Problem Installation SQL

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Problem Installation SQL

    When arrive at last step ( after admin insert ) show me this error

    Message: SQLSTATE[42000]: Syntax error or access violation: 1064
    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 'system =
    AND planet = '2'
    AND planet_type = '1'' at line 5

    Query-Code:SELECT COUNT(*) as record
    FROM uni1_planets
    WHERE universe = 1
    AND galaxy = 1
    AND system = 1
    AND planet = 2
    AND planet_type = 1;
    File: /includes/classes/Database.class.php
    Line: 126
    PHP-Version: 8.1.28
    PHP-API: litespeed
    2Moons Version: 2.0.0 (FILE)
    Debug Backtrace:
    #0 /includes/classes/Database.class.php(202): Database->_query('SELECT COUNT(*)...', Array, 'select')
    #1 /includes/classes/PlayerUtil.class.php(50): Database->selectSingle('SELECT COUNT(*)...', Array, 'record')
    #2 /includes/classes/PlayerUtil.class.php(96): PlayerUtil::isPositionFree(1, 1, 1, 2)
    #3 /install/index.php(574): PlayerUtil::createPlayer(1, 'mariottide88',
    '$2a$09$pHZPE509...', 'mario89@gmail.c...', 'en', 1, 1, 2, NULL, 3)
    #4 {main}
  • Hello, what version of the game are you using? For me it doesn't come from your php version which is too high and the system in the sql is reserved you must add `` around