vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Problem Uploading Products (https://vborg.vbsupport.ru/showthread.php?t=286115)

Gator Bite 07-30-2012 04:34 PM
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:

Quote:
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

nhawk 07-30-2012 07:23 PM
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 07-30-2012 07:31 PM
This issue is down to your mysql version where as nhawk points out TYPE has been deprocated.


All times are GMT. The time now is 12:18 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01416 seconds
  • Memory Usage 1,711KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete