View Single Post
  #2607  
Old 07-29-2004, 03:50 AM
flstreetscene flstreetscene is offline
 
Join Date: Sep 2003
Posts: 68
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Arcade still not working...

Could you double check if I'm doing everything right?

I've deleted all my template additions, and reverted all documents to original 3.0.3 settings. As the instruction on v3arcade.com say I've deleted the following tables from my database (zeno_forums):

==========================================
gamechallenges
gamenews
games
gamesessions

the database table "datastore", browse it and find the titles "arcadesettings" and "scoresettings" - delete them both.
==========================================

I've also updated my install_arcade.php document where it asks me to change the '$styleid=' value to the proper style id (in this case $styleid=10

I then proceed to the 'http://www.floridastreetscene.com/forums/admincp/install_arcade.php' page to start installing the arcade. When I get to the 'Database Modifications' step I get the following...

==========================================
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

Date: Thursday 29th of July 2004 04:40:45 AM
Script: http://www.floridastreetscene.com/fo...all_arcade.php
Referer:
Username: zeno
IP Address: 64.8.219.569
==========================================

...but I am certain that those table were dropped. It seems they are restored or not deleted properly?

Once I figure this out I guess I've fixed my arcade.

Thanks!

EDIT: Ok it seems eventhough the installation didn't seem to go through completly my arcade (http://www.floridastreetscene.com/forums/arcade.php?) is still up and functioning... however as you can see the image path's are screwed as they are pointing to my forums root. I am pretty sure why this is happening; I've skipped the modification to my i'ncludes/functions.php' as that caused my forums stop responding. Is there any way to get around this conflict?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01197 seconds
  • Memory Usage 1,768KB
  • 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