problem ships

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

    • problem ships

      my database
      base 1
      based2
      base 3base4

      my problem


      Source Code

      1. USER ERROR
      2. Message: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'fleet_count' at row 1
      3. File: /includes/classes/Database.class.php
      4. Line: 259
      5. URL: http://starwar.5v.pl/2/admin.php?page=statsupdate
      6. PHP-Version: 5.6.30-0+deb8u1
      7. PHP-API: fpm-fcgi
      8. 2Moons Version: 1.9.git
      9. Debug Backtrace:
      10. #0 /includes/classes/Database.class.php(259): PDO->query('INSERT INTO un...')
      11. #1 /includes/classes/class.statbuilder.php(158): Database->nativeQuery('INSERT INTO %%...')
      12. #2 /includes/classes/class.statbuilder.php(410): statbuilder->SaveDataIntoDB('TRUNCATE TABLE ...')
      13. #3 /includes/pages/adm/ShowStatUpdatePage.php(24): statbuilder->MakeStats()
      14. #4 /admin.php(143): ShowStatUpdatePage()
      15. #5 {main}
      Display All
      please help
    • Is this serious ? Will this question be asked daily ? please use search function.
    • hint for the future:
      Display Spoiler
      SELECT DISTINCT TABLE_NAME
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE COLUMN_NAME IN ('y')
      AND TABLE_SCHEMA=xxx';
      xxx is the name of your 2moonsdb
      y is the colum you search
      send this as mysql order. result will be the tables you find the colums in.


      ps:alternativliy you can search the sql file from the install folder of 2moons
      after found scoll a bit up, and you will see the tablename.


      levelcolums are in uni1_planets and uni1_users
      (officers and researches in users
      buildings are on planets)

      the names of the filds are the names you find in uni1_vars
      filds with this names in uni1_planets and uni1_users have the value of its level