vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Incorrect key file for table usercss (https://vborg.vbsupport.ru/showthread.php?t=266332)

RedDevil 07-05-2011 07:25 PM
Incorrect key file for table usercss
 
Updated mysql and rebuilding database I am receiving this error message

Incorrect key file for table 'usercss'

I have tried repair in admincp under maintenance (didnt work)

I have tried to access and repair using phpmyadmin (wont show the table)

Is there a way to repair or delete this using a query?

Thanks in advance

kh99 07-05-2011 07:42 PM
You might try the mysql_upgrade command: http://dev.mysql.com/doc/refman/5.0/...l-upgrade.html (which I believe has to be done from a command line).

RedDevil 07-05-2011 08:39 PM
mysql has just been upgraded thats whats caused the table error i think, 2 running sites and a test site all affected with the same error.

kh99 07-05-2011 08:49 PM
Right. I don't know if that will fix your problem or not, but even though mysql_upgrade sounds like it would upgrade your mysql version, what it actually does (according to the docs I linked above) is "examines all tables in all databases for incompatibilities with the current version of MySQL Server." and it also says "mysql_upgrade should be executed each time you upgrade MySQL." I found out about it when I searched for that error you got and found where someone said running mysql_upgrade fixed it.

RedDevil 07-06-2011 09:00 AM
Thanks for the info i did read through, its supposed to repair all databases on upgrade, but for some reason, all 3 VB4 databases have the same corrupt error all on same table, which is weird.

I can create a new DB and export and import the offending tables but on a site with 18,000 members im reluctant to just do it without making sure its not going to do any major harm, seems this covers custom profiles so wont be a biggy, was hoping maybe someone encountered tis and knew best cure.

The error is also preventing a database backup as it wont go past the corrupt table.

Badshah93 07-06-2011 09:10 AM
see this thread

Code:
https://www.vbulletin.com/forum/showthread.php/44909-3-ways-to-repair-a-database
if it works for you then its fine or drop all the values in usercss table.

RedDevil 07-06-2011 09:20 AM
Ok fixed it.

First I created a new VB4 database (basically a new testsite)

Second I exported the usercss tables

Third I dropped the damaged usercss table in main database

I then readded using the query below. If your tables have a prefix then change name in red.

Code:
CREATE TABLE `usercss` (
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `selector` varchar(30) NOT NULL DEFAULT '',
  `property` varchar(30) NOT NULL DEFAULT '',
  `value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`userid`,`selector`,`property`),
  KEY `property` (`property`,`userid`,`value`(20))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

brihan 03-29-2013 08:44 PM
Hi, Sorry to open up an old thread but I need some help with this.

I also have the same issue with the usercss table being corrupt and not being able to backup my database.

I see you have fixed it and posted the directions however I need a little more hand holding to walk me through this.

Where/how do you do this?
Quote:
CREATE TABLE `usercss` (
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`selector` varchar(30) NOT NULL DEFAULT '',
`property` varchar(30) NOT NULL DEFAULT '',
`value` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`userid`,`selector`,`property`),
KEY `property` (`property`,`userid`,`value`(20))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
One question I have is "What is in the usercss table"? I looked at the good one in my 4.2.0 test site and it was blank. Is there anything important in there?

I just checked the table status and it's create and update date/time are the same so it looks like nothing has ever been done with this table.

Create: 2013-03-01 12:06:53
Update: 2013-03-01 12:06:53
Check: 2013-03-29 16:19:11

From PHPmyadmin can I just drop the corrupt usercss table or can I try to import the blank one from my test site?

Thank for any help you can provide.

Brian


All times are GMT. The time now is 06:53 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00989 seconds
  • Memory Usage 1,731KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete