Problem Uploading Products

[Gator Bite]

After a recent server move, I am unable to upload any products to our vBulletin installations. I hold several licenses and am having this problem on all of them.

For example, if I try to upload the XML file that comes with EasyForms, I get this:

Database error in vBulletin 3.8.7:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `forms` (
`fid` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`displayorder` int(10) NOT NULL,
`action` int(3) NOT NULL,
PRIMARY KEY (`fid`)
) TYPE=MyISAM;

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 'TYPE=MyISAM' at line 8
Error Number : 1064
Request Date : Monday, July 30th 2012 @ 02:29:00 PM
Error Date : Monday, July 30th 2012 @ 02:29:00 PM
Script : http://912register.pca.org/admincp/plugin.php?do=productimport
Referrer : http://912register.pca.org/admincp/plugin.php?do=productadd
IP Address : 76.23.204.75
Username : Gator Bite
Classname : vB_Database
MySQL Version : 5.5.23

Anyone have any idea how I can correct this?

Site URL: http://912register.pca.org/index.php

[nhawk]

The 'Type =' part of the query is obsolete and no longer supported by newer MySQL installations.

Either delete that part of the query to use the default storage engine or replace it with 'Engine ='

[Simon Lloyd]

This issue is down to your mysql version where as nhawk points out TYPE has been deprocated.