PDA

View Full Version : Error when on step 4


dellow
Sat 11th Nov '06, 3:14am
Hello,

when upgrading from 3.5.4 to 3.6.3 i recive this error
http://domain/363/install/finalupgrade.php?step=4




Database error in vBulletin 3.6.3:
Invalid SQL:
UPDATE template SET styleid = -10 WHERE styleid = -1 AND (product = 'vbulletin' OR product = '');
MySQL Error : Incorrect key file for table 'template'; try to repair it
Error Number : 1034
Date : Friday, November 10th 2006 @ 06:46:01 PM
Script : http://domain/363/install/finalupgrade.php?step=4
Referrer : http://domain/363/install/finalupgrade.php?step=3
IP Address : 212.24.224.16
Username :
Classname : vb_database

Marco van Herwaarden
Sat 11th Nov '06, 11:18am
To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all
errors:
Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

Once the table is repaired, re-run upgrade.php.

dellow
Sat 11th Nov '06, 12:40pm
Thank you

problem resolved and upgrading completed.

actualy i try to repair the DB using ssh with this command :

myisamchk -r /var/lib/mysql/DBname/*.MYI

and reparing completed but problem not resolved.


Thank you