Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 30 Jul 2012, 18:34
Gator Bite Gator Bite is offline
 
Join Date: Dec 2009
Problem Uploading Products

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/p...=productimport
Referrer : http://912register.pca.org/admincp/p...?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
Reply With Quote
  #2  
Old 30 Jul 2012, 21:23
nhawk nhawk is offline
 
Join Date: Jan 2011
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 ='
Reply With Quote
  #3  
Old 30 Jul 2012, 21:31
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
This issue is down to your mysql version where as nhawk points out TYPE has been deprocated.
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 15:09.

Layout Options | Width: Wide Color: