Thread: Profile Enhancements - iTrader 2.1.0 (Interim Release)
View Single Post
  #51  
Old 06-26-2008, 03:12 PM
Watson's Avatar
Watson Watson is offline
 
Join Date: May 2004
Location: Scotland
Posts: 220
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,

I did have it previously running, but when I uninstalled it looks like its left the tables. This is good as I have my data still, however when I run the XML file I get the below error.

Code:
Database error in vBulletin 3.7.1:

Invalid SQL:
CREATE TABLE itrader (
		  rateid int(10) unsigned NOT NULL auto_increment,
		  userid int(10) unsigned NOT NULL default '0',
		  rateduserid int(10) unsigned NOT NULL default '0',
		  rating tinyint(3) NOT NULL default '0',
		  buyselltrade tinyint(3) unsigned NOT NULL default '0',
		  subject varchar(80) NOT NULL default '',
		  dealurl varchar(255) NOT NULL default '',
		  dateline int(10) unsigned NOT NULL default '0',
		  ipaddress varchar(15) NOT NULL default '',
		  PRIMARY KEY  (userid,rateid),
		  UNIQUE KEY rateduserid (rateduserid,rateid),
		  KEY rateid (rateid)
		) TYPE=MyISAM AUTO_INCREMENT=1;

MySQL Error   : Table 'itrader' already exists
Also when I try and do it via the upgrade file, I get an error telling me tables don't exist. Any help is appreciated.

Cheers

Watson
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01133 seconds
  • Memory Usage 1,764KB
  • 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