[Original Sysop]

Originally Posted by Original Sysop

Error when trying to install... please help!

Installing on vbulletin 4.1.3
Mod version 4.0.2 PL1
MySQL version 5.5

BE ADVISED I REPLACED TEXT BELOW THAT I WANT PRIVATE WITH "######"

Error -------------------------------------------------------------------------------------------------------
Database error in vBulletin 4.1.3:

Invalid SQL:
ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Table '#####.award' doesn't exist
Error Number : 1146
Request Date : Wednesday, May 4th 2011 @ 01:33:29 PM
Error Date : Wednesday, May 4th 2011 @ 01:33:29 PM
Script : http://www.#######.com/admincp/plugi...=productimport
Referrer : http://www.#######.com/admincp/plugin.php?do=productadd
IP Address : ##.#.#.###
Username : #########
Classname : vB_Database
MySQL Version : 5.5.10

End of error ----------------------------------------------------------------------------------------------------

Fixed it, change TYPE=MyISAM to ENGINE=MyISAM in the XML file.