[reQ]

[echo_unlimited]

I will give some one all my points if they can fix my arcade, the problem I am having is this:
I did go to the support center provided by this forum. But Il post my problem.
I get this error below trying to view the arcade (blue-inc.org/arcade.php)

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM arcade_challenges AS arcade_challenges
LEFT JOIN user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 10;
MySQL Error : Table 'blueinc_vb.arcade_challenges' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 11:49:26 AM
Script : http://www.blue-inc.org/arcade.php
http://www.blue-inc.org/index.php
IP Address : xxxxx :tear: not telling you this.
Username : echo_unlimited
Classname : vb_database

Also I get these errors while veiwing a thread:

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT title,highscorerid,highscore,miniimage,gameid FROM arcade_games WHERE highscorerid IS NOT NULL AND (gamepermissions & 2);
MySQL Error : Table 'blueinc_vb.arcade_games' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 03:39:27 PM
Script : http://www.blue-inc.org/showthread.php?p=519#post519
Referrer : http://www.blue-inc.org/index.php
IP Address : ---------
Username : echo_unlimited
Classname : vb_database

And while when I go into ACP>>Arcade>> Catagorys:

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT * FROM arcade_categories AS arcade_categories ORDER BY displayorder ASC;
MySQL Error : Table 'blueinc_vb.arcade_categories' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 03:40:41 PM
Script : http://www.blue-inc.org/admincp/arcadeadmin.php?do=categories
Referrer : http://www.blue-inc.org/admincp/index.php?do=nav
IP Address :-------------
Username : echo_unlimited
Classname : vb_database

ACP>>Arcade>>Games:

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT COUNT(*) AS total
FROM arcade_games AS arcade_games;
MySQL Error : Table 'blueinc_vb.arcade_games' doesn't exist
Error Number : 1146
Date : Monday, April 3rd 2006 @ 03:41:23 PM
Script : http://www.blue-inc.org/admincp/arcadeadmin.php?do=games
Referrer : http://www.blue-inc.org/admincp/index.php
IP Address : -------------
Username : echo_unlimited
Classname : vb_database

Thats all the errors I get, plus its affecting my forum

Currently I have my arcade disabled as it caused some errors while posting on my site. At the moment I am quite pissed with this, but if any one can direct me on how to fix this then please do say so and if it works Il hand the points over.

 

[swirly]

yeah well your prolly not gonna want to hear this but try reinstalling it! lol save everything u got and then reinstall!

 

[deaddevil]

well the errors you are facing are due to the sql language. you will have to contact the development forum for that. I think you may have to re install the mod.

 

[echo_unlimited]

I can't reinstall it, every time I try to reinstall, it I get another sql error. if some one can do this for me il give you ALL my points.

 

[James]

Lol, well thats not all that much, but if you still need help i can manage to help you out, probally thursday night or fri.
cya

 

[echo_unlimited]

Lol, well thats not all that much, but if you still need help i can manage to help you out, probally thursday night or fri.
cya

Ok then dude, thanks. Could you unistall the v3arcade and install ibproarcade which is located: http://www.vbulletin.org/forum/showthread.php?t=101554&highlight=v3arcade


I can do the template edits, but if you could uninstall v3arcade and install ibproarcade then that'd be great, but I can do page edits..

Cheers dude.

 

[echo_unlimited]

Please, some one fix this for me.

 

[Jake]

there is something like this: "MySQL Error : Table 'blueinc_vb.arcade_challenges' doesn't exist" in each one of those errors

sooo, obviously you didnt run the SQL query to create the arcades tables, if you did, it didnt work so try again.

 

[James]

there is something like this: "MySQL Error : Table 'blueinc_vb.arcade_challenges' doesn't exist" in each one of those errors

sooo, obviously you didnt run the SQL query to create the arcades tables, if you did, it didnt work so try again.

Yes thats the probelm, im helping him do it tomorow it mustnt of created the tables.

 

[echo_unlimited]

Corey fixed it for me. Thnx.