Database (MySQL) error, how to fix??

[Akuma2000]

I'm recently installed the Arcade.

GREAT MOD!

But it is giving me MySQL errors when somebody in the tournament makes a new record:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM vb_tournament WHERE tid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Error Number : 1064
Date : Saturday, January 5th 2008 @ 05:54:13 PM
Script : http://www.iwsclan.com/forums/index.php?act=Arcade&do=newscore
Referrer : http://www.iwsclan.com/forums/arcade.php?&do=playtourney&gameid=4&tid=11&rung=1&faceoff=1
IP Address : XX.XX.XX.XXX
Username : XXX
Classname : XXX


Can somebody tell me how to fix this?

Thnx in advance!

[MrZeropage]

it should be "tournaments" I guess there is a problem in some file-edit you did ?

[Akuma2000]

Do you have an idea wich file-edit that should be?

I can't remember doing a file edit with "vb_tournament".
And I copy-pasted everthing, so there should be no error made.

I've installed vbcredits with the ibproarcade addon

[MrZeropage]

Try to deactivate it - I am SURE that the typo is there...

[Akuma2000]

It's the addon for vbcredits.
There was a bug in there, but the coder made a patch.
See here:
http://www.vbcredits.com/forum/tracker.php?itemid=87

Might come in handy for fellow vbcredits users :)

[MrZeropage]

I was sure it was not a problem of my code ;) :D

[Akuma2000]

Hi all,

I got another error again:

Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT * FROM vb_tournament WHERE tid = 5;
MySQL Error : Table 'xxx.vb_tournament' doesn't exist Error Number : 1146
Date : Monday, January 7th 2008 @ 07:35:40 PM
Script : http://www.iwsclan.com/forums/index.php?act=Arcade&do=newscore
Referrer : http://www.iwsclan.com/forums/arcade/snake.swf
IP Address : xx.xxx.xx.xxx
Username : xxx
Classname : vb_database

As you can see, the database doesn't exist.
Just as MrZeropage said before.

Because now it calles the table 'vb_tournament' instead of 'vb_tournaments'
I guess that's the problem.

But I don't know in which file this code is used.
Do you got any idea wich file it could be?

Thnx in advance!

[MrZeropage]

I guess it's vbCredit or something like this again - any addon related to ibProArcade...

[Akuma2000]

Yes!
And it's fixed again :D

See it here:
http://www.vbcredits.com/forum/showthread.php?p=5929#post5929