Invalid SQL when I try a play

[morris2003]

I've upgrade from 1.1.1 to 2.0.0.
When I try a play:

Invalid SQL:
SELECT MAX(score) AS personalbest, MIN(score) AS personalbestr, gameid FROM v_arcade_sessions AS arcade_sessions WHERE gameid=100 AND userid=1 AND valid=1 GROUP BY gameid;

MySQL Error   : Table 'forum.v_arcade_sessions' doesn't exist
Error Number  : 1146

but everything work fine.

[morris2003]

I tried uninstalling and then reinstalling the Arcade, but this error always appears. How I can fix it?

[Mario]

The error are from a mod you have installed in the old arcade.
Disable the old mods one by one to find out wich one it is.

[morris2003]

Fixed. Thank You

[KW802]

Originally Posted by Mario

The error are from a mod you have installed in the old arcade.
Disable the old mods one by one to find out wich one it is.

Yep.

As part of the upgrade to v3A 2.0.0 the various tables, phrases, and just about everything, has been added to have a prefix.

For the sessions table...

Old Name: TABLE_PREFIX . "arcade_sessions"
New Name: TABLE_PREFIX . "v3arcade_sessions"