Results 1 to 5 of 5

Thread: Invalid SQL when I try a play

  1. #1

    Default Invalid SQL when I try a play

    I've upgrade from 1.1.1 to 2.0.0.
    When I try a play:
    Code:
    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.

  2. #2

    Default Re: Invalid SQL when I try a play

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

  3. #3
    Senior Member Mario's Avatar
    Join Date
    Sep 2005
    Posts
    145

    Default Re: Invalid SQL when I try a play

    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.

  4. #4

    Default Re: Invalid SQL when I try a play

    Fixed. Thank You

  5. #5
    Super Moderator KW802's Avatar
    Join Date
    Mar 2004
    Location
    A galaxy far, far away...
    Posts
    6,606

    Default Re: Invalid SQL when I try a play

    Quote Originally Posted by Mario View Post
    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"

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •