Getting a strange error at ARCADE

[veenuisthebest]

hiii.. I'm getting an error on opening the arcade right after a full database restore. It was working perfect before that.

After restoration, I had to rebuild forum cache as my forum was unable to find any vb tables. I simply did this with tools.php and everything worked fine after that.

But now I notice that its unable to find just arcade tables, i think I need to rebuild some sort of arcade's cache as well. Is there an option to do so. However, I can view my games list from the admincp.

This is the error I get on visiting arcade:-

mySQL query error: SELECT p.mid, p.tid, t.nbtries, p.timesplayed, p.rungscore, p.rung, p.faceoff, p.notified, t.creat FROM tournament_players AS p LEFT JOIN tournaments AS t ON (p.tid=t.tid) LEFT JOIN tournament_players_statut AS s ON (p.tid=s.tid AND p.mid=s.mid) WHERE p.timesplayed<t.nbtries AND t.demare=1 AND s.statut=0 AND p.timeplayed<1215638945

mySQL error: Table 'mydb.tournament_players' doesn't exist
mySQL error code:
Date: Wednesday 16th 2008f July 2008 09:29:05 PM

I notice the table tournament_players is not in my db. On importing the product again, it is not getting created !!

Any help plz.

[MrZeropage]

all other ibProArcade-tables are existing ?

you did not change any tableprefix ?


CREATE TABLE IF NOT EXISTS tournament_players (mid int(11) NOT NULL default '0', tid int(11) NOT NULL default '0', rung int(11) NOT NULL default '0', rungscore int(11) NOT NULL default '0', faceoff int(11) NOT NULL default '0', timeplayed int(10) NOT NULL default '0', timesplayed int(11) NOT NULL default '0')