V3Arcade installation problem with V3Gold

[flstreetscene]

I get the following error when I run /forums/admincp/install_arcade.php

Database error in vBulletin 3.0.0:

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: Friday 26th of March 2004 04:20:55 PM

This is a clean install of the arcade. I've deleted all traces after the upgrade to Gold even the database tables but it seems they are still there?? :ermm:

Solutions?

[13th_Disciple]

can you get to a prompt on the server or phpmyadmin? if so, go have a look in there and delete all tables relating to v3arcade.. if you have already done this and can't find the answer int he v3arcade thread, then have a look at v3arcade.com.. the answer may be over there..

[Zachery]

You didnt need to delete the arcade after the upgrade, nothing of the database of hacks are touched apon an upgrade.

[flstreetscene]

Well I've reinstalled everything for a clean install, deleted the database tables in mysql but I still get this

Database error in vBulletin 3.0.0:

Invalid SQL: 
		INSERT INTO datastore VALUES('arcadesettings', 845)
	
mysql error: Duplicate entry 'arcadesettings' for key 1

mysql error number: 1062

Date: Saturday 27th of March 2004 03:16:28 PM

[13th_Disciple]

since you have gone this far and are still getting errors.. what about just creating a new database with a new name.. at this point, it seems just as simple..

[flstreetscene]

Ok I've seem to have fixed my arcade by deleting the arcadesettings columns from all the database tables but something is still wrong as none of the images show up and checking their properties they're all liked from my site root.

ex) http://www.floridastreetscene.com/snake1.gif

[13th_Disciple]

wasn't there something about having to change the images path in one of the templates? or one of the files.. not sure.. but i seem to remember having that problem when i first installed it..

have you looked int he v3arcade thread to see if there are similar issues or on v3arcade.com?

[flstreetscene]

I've posted in the v3 arcade twice already and still did not receive a response to this.. Does anyone know?

Thanks.