mySQL query error. Resolved

[ogameclub]

Hi,
Mysql error suddenly in arcade.php.

mySQL query error: SELECT s.userid, s.location, s.in_game, u.username, g.opentag, g.closetag, u.options
FROM session as s
LEFT JOIN user as u ON (u.userid = s.userid)
LEFT JOIN usergroup as g ON (u.usergroupid = g.usergroupid)
WHERE s.lastactivity > 1219334845 AND s.location LIKE '%rcade%' AND s.location NOT LIKE '%admin%'
GROUP BY s.userid
ORDER BY u.username ASC


Vbulletin and ibProArcade are last version. PHP Version 5.1.6

I rapaired Database tables with phpMyadmin and admincp (No problem)
Arcade game list, categories show normally.
Update User Names, Update Highscores, Update the Best Results and Update League are performed.
I re-installed ibProArcade.

But problems contiune...:(

Any idea?

[stangger5]

Did you install or edit anything in the arcade ??

That error is looking for (in_game) table..
Try uninstalling and then reinstall...

The product-ibproarcade.XML should write your arcade tables again..

[Infopro]

Start disabling other plugins and testing the arcade. Might be something conflicting with it.

[ogameclub]

Start disabling other plugins and testing the arcade. Might be something conflicting with it.
I disasbled other plugins step by step. Not conflicting.

Did you install or edit anything in the arcade ??

That error is looking for (in_game) table..
Try uninstalling and then reinstall...

The product-ibproarcade.XML should write your arcade tables again..

No, but new games another day.
Uninstaling and reinstalling. Last alternative.... Yes This works, :)

Thanks
http://www.grafikyukle.com/images/n9dbl5bzthfqa66il71x.gif