View Single Post
  #13  
Old 06-19-2009, 03:42 PM
twitch's Avatar
twitch twitch is offline
 
Join Date: Apr 2005
Posts: 260
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

uploaded files then tried to import the xml file and got this error

Code:
Database error in vBulletin 3.8.3:

Invalid SQL:

CREATE TABLE IF NOT EXISTS vb3_ DTO_garage_vehicle (
  vehicle_id int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  year int(4) unsigned NOT NULL default '0',
  make varchar(50) NOT NULL default '',
  model varchar(50) NOT NULL default '',
  color varchar(50) NOT NULL default '',
  packages text NOT NULL,
  history text NOT NULL,
  exteriormods text NOT NULL,
  interiormods text NOT NULL,
  icemods text NOT NULL,
  drivetrainmods text NOT NULL,
  suspensionmods text NOT NULL,
  wheelsandtires text NOT NULL,
  time_modified timestamp NOT NULL default CURRENT_TIMESTAMP,
  time_added timestamp NOT NULL default '0000-00-00 00:00:00',
  allowcomments tinyint(1) NOT NULL default '1',
  display tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (vehicle_id)
) ENGINE=MyISAM auto_increment=1000;

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 'DTO_garage_vehicle (
  vehicle_id int(10) unsigned NOT NULL auto_increment,
  ' at line 1
Error Number  : 1064
Request Date  : Friday, June 19th 2009 @ 09:38:14 AM
Error Date    : Friday, June 19th 2009 @ 09:38:14 AM
Script        : http://www.mysite.com/forum/admincp/plugin.php?do=productimport
Referrer      : http://www.mysite.com/forum/admincp/plugin.php?do=productadd
IP Address    : 11.111.111.111
Username      : myusername
Classname     : vb_database
MySQL Version : 5.0.67-community
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01235 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete