Helpful Information
 
 
Category: vBulletin 4 Discussion
please help

i am using 3.8.4 and was trying to upgrade to 4.0 beta but when i run upgrade script i get the following error.
please please help me in this regards and answer me in details so i can fix it. My usres are killing me and my forums are not working.
------------------------------------------------------------------------------
Database error in vBulletin 3.8.4:

Invalid SQL:
SHOW ENGINES;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINES' at line 1
Error Number : 1064
Request Date : Saturday, November 14th 2009 @ 08:51:19 AM
Error Date : Saturday, November 14th 2009 @ 08:51:19 AM
Script : http://www.humpaki.com/forums/instal...0a1.php?step=1
Referrer : http://www.humpaki.com/forums/install/upgrade_400a1.php
IP Address : 92.234.82.117
Username :
Classname : vB_Database
MySQL Version : 4.0.27-max-log

It's your MySQL version ;)

See here for more info and Lynne from here caught that in the similar message posted just like yours.

http://www.vbulletin.com/forum/showthread.php?325423-upgrade-error&highlight=invalid+SQL+show+engines

You can contact your host and see if they have other servers that run a higher version of MySQL and if so see if they have PHP5 on it too. Read the rquirements that were stickied either last night or this morning... http://www.vbulletin.com/forum/showthread.php?325521-vBulletin-4-Minimum-System-Requirements

Mike

You're having an old version of MySQL.

Minimum required MySQL version: 4.1 (Recommended is 5.0.19)
See this thread: vBulletin 4: Minimum System Requirements (http://www.vbulletin.com/forum/showthread.php?325521-vBulletin-4-Minimum-System-Requirements)

Questions regarding the upgrade script should be posted at vBulletin.com forums or in a support ticket.










privacy (GDPR)