I'm trying to run the arcade installer but I get this error:
mySQL query error: CREATE TABLE mybb_games_scores (
s_id int(11) NOT NULL auto_increment,
mid int(11) NOT NULL default '0',
gid int(11) NOT NULL default '0',
name text NOT NULL,
score FLOAT(11) NOT NULL default '0',
ip text NOT NULL,
comment text NOT NULL,
datescored int(10) NOT NULL,
PRIMARY KEY (s_id)) TYPE=MyISAM
mySQL error: Table 'mybb_games_scores' already exists
mySQL error code:
Date: Monday 21st of August 2006 11:21:19 PM
To view:
http://locahhb.lo.funpic.org/board/installer.php
I got this plugin from:
http://www.emulation64.com/files/category/32/74/
How would I fix this?
If that table exists you will need to log into your phpMyAdmin and delete the table before running the installer.
So I should delete the whole
mybb_games_scores table?
~~
Didn't work. I get this:
mySQL query error: CREATE TABLE mybb_games_list (
gid int(11) NOT NULL auto_increment,
gname varchar(40) NOT NULL default '',
gwords text NOT NULL,
gcount int(11) NOT NULL default '0',
gtitle varchar(40) NOT NULL default '',
bgcolor varchar(6) NOT NULL default '000',
active tinyint(1) NOT NULL default '1',
gwidth int(11) NOT NULL default '400',
gheight int(11) NOT NULL default '400',
position mediumint(8) NOT NULL default '1',
gcat int(2) NOT NULL default '1',
object text NOT NULL,
gkeys text NOT NULL,
added INT( 10 ) DEFAULT '0' NOT NULL,
g_rating TINYINT( 1 ) DEFAULT '0' NOT NULL,
g_raters TEXT NOT NULL,
highscore_type VARCHAR ( 4 ) DEFAULT 'high' NOT NULL,
UNIQUE KEY gid (gid)) TYPE=MyISAM COMMENT='Game List'
mySQL error: Table 'mybb_games_list' already exists
mySQL error code:
Date: Wednesday 23rd of August 2006 06:22:53 AM
Edited thread subject - don't choose thread subjects like "need help".
Sorry,
Can anyone help me on this?
LocaJony Wrote:mySQL error: Table 'mybb_games_scores' already exists
LocaJony Wrote:So I should delete the whole
mybb_games_scores table?
~~
Didn't work. I get this:
mySQL error: Table 'mybb_games_list' already exists
Thats a different table. I dont know anything about the arcade mod, but if all its tables are prefixed "mybb_games" then you could just drop all tables prefixed "mybb_games" and run the installer.
I'd back up your database first tho.
Ok, I'm not going to lie.
I have no idea how to do some of that.
This assumes you have phpMyAdmin.
Backup Database -
Source
marcgo15 Wrote:1. Login to phpMyAdmin and select the database you wish to dump
2. Click on the "Export" tab at the top of the page
3. Click "Select All" below the list of tables
4. Make the format is SQL
5. Click "Save as File" to download the result, or leave this box unticked to view it on-screen
6. Ensure that both "Structure" and "Data" are ticked
7. Choose a compression type, if any, from the bottom of the form
8. Click "Go"
Dropping "mybb_games" tables
1. Login to phpMyAdmin and select your MyBB database.
2. Check the box next to any tables prefixed with "mybb_games"
NOT JUST "mybb_"
3. Using the drop down box at the bottom of the tables list, select "Drop"
Install Arcade
Run the install script like you were trying to do before.