View Single Post
  #2658  
Old 08-22-2004, 06:01 PM
Cocytus Cocytus is offline
 
Join Date: Jun 2004
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE gamechallenges (
challengeid int(10) unsigned NOT NULL auto_increment,
type tinyint(1) unsigned NOT NULL default '0',
challengerid int(10) unsigned NOT NULL default '0',
challengedid int(10) unsigned NOT NULL default '0',
game varchar(30) NOT NULL default '',
status tinyint(1) unsigned NOT NULL default '0',
datestamp int(13) unsigned NOT NULL default '0',
challengersession int(20) unsigned NOT NULL default '0',
challengedsession int(20) unsigned NOT NULL default '0',
PRIMARY KEY (challengeid)
) TYPE=MyISAM

mysql error: Table 'gamechallenges' already exists

mysql error number: 1050

HELP!!!! Someone, anyone!

I have lastest verstion of arcade and VB 3.0.3. I just recently upgraded the site and had to reinstall the arcade.....

Seems that some of the left over databases are messing things up.

I tried to wipe all the databases but then get this error:

Invalid SQL:
INSERT INTO datastore VALUES('arcadesettings', 845)

mysql error: Duplicate entry 'arcadesettings' for key 1

mysql error number: 1062
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01103 seconds
  • Memory Usage 1,761KB
  • 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)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