fleet error

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

  • I have a problem sending a fleet when I send out such error



    1.111.118.446.744.099.958.554.624


    my database
    jpg

    Source Code

    1. Message: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'fleet_amount' at row 1
    2. Query-Code:INSERT INTO uni1_log_fleets SET fleet_id = 8863, fleet_owner = 1, fleet_target_owner = 3, fleet_mission = 1, fleet_amount = 1.1111184467441E+24, fleet_array = 202,1111118446744099958554624, fleet_universe = 1, fleet_start_time = 1508055018.8103, fleet_end_stay = 1508055018.8103, fleet_end_time = 1508055040.6206, fleet_start_id = 1, fleet_start_galaxy = 1, fleet_start_system = 1, fleet_start_planet = 2, fleet_start_type = 1, fleet_end_id = 3, fleet_end_galaxy = 1, fleet_end_system = 1, fleet_end_planet = 3, fleet_end_type = 1, fleet_resource_metal = 0, fleet_resource_crystal = 0, fleet_resource_deuterium = 0, fleet_group = 0, fleet_target_obj = 0, start_time = 1508054997;
    3. File: /includes/classes/Database.class.php
    4. Line: 126
    5. URL: http://starwar.5v.pl/2/game.php?page=fleetStep3
    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(185): Database->_query('INSERT INTO %%L...', Array, 'insert')
    11. #1 /includes/classes/class.FleetFunctions.php(624): Database->insert('INSERT INTO %%L...', Array)
    12. #2 /includes/pages/game/ShowFleetStep3Page.class.php(404): FleetFunctions::sendFleet(Array, 1, '1', '1', '1', '1', '2', '1', '3', '3', 1, 1, 3, 1, Array, 1508055018.8103, 1508055018.8103, 1508055040.6206, 0)
    13. #3 /game.php(57): ShowFleetStep3Page->show()
    14. #4 {main}
    Display All

  • Ограничение надо ставить в админ панель а то нарисуете кучу нулей и mysqli не может прочитать. Не понимаю зачем столько нулей лепить когда можно настроить намного поменьше.
  • You are editing the wrong table.
    uni1_log_fleets not uni_fleet

    olszak wrote:

    I have a problem sending a fleet when I send out such error



    1.111.118.446.744.099.958.554.624


    my database
    jpg

    Source Code

    1. Message: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'fleet_amount' at row 1
    2. Query-Code:INSERT INTO uni1_log_fleets SET fleet_id = 8863, fleet_owner = 1, fleet_target_owner = 3, fleet_mission = 1, fleet_amount = 1.1111184467441E+24, fleet_array = 202,1111118446744099958554624, fleet_universe = 1, fleet_start_time = 1508055018.8103, fleet_end_stay = 1508055018.8103, fleet_end_time = 1508055040.6206, fleet_start_id = 1, fleet_start_galaxy = 1, fleet_start_system = 1, fleet_start_planet = 2, fleet_start_type = 1, fleet_end_id = 3, fleet_end_galaxy = 1, fleet_end_system = 1, fleet_end_planet = 3, fleet_end_type = 1, fleet_resource_metal = 0, fleet_resource_crystal = 0, fleet_resource_deuterium = 0, fleet_group = 0, fleet_target_obj = 0, start_time = 1508054997;
    3. File: /includes/classes/Database.class.php
    4. Line: 126
    5. URL: http://starwar.5v.pl/2/game.php?page=fleetStep3
    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(185): Database->_query('INSERT INTO %%L...', Array, 'insert')
    11. #1 /includes/classes/class.FleetFunctions.php(624): Database->insert('INSERT INTO %%L...', Array)
    12. #2 /includes/pages/game/ShowFleetStep3Page.class.php(404): FleetFunctions::sendFleet(Array, 1, '1', '1', '1', '1', '2', '1', '3', '3', 1, 1, 3, 1, Array, 1508055018.8103, 1508055018.8103, 1508055040.6206, 0)
    13. #3 /game.php(57): ShowFleetStep3Page->show()
    14. #4 {main}
    Display All


  • --'

    jona wrote:

    You are editing the wrong table.
    uni1_log_fleets not uni_fleet

    olszak wrote:

    I have a problem sending a fleet when I send out such error



    1.111.118.446.744.099.958.554.624


    my database
    jpg

    Source Code

    1. Message: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'fleet_amount' at row 1
    2. Query-Code:INSERT INTO uni1_log_fleets SET fleet_id = 8863, fleet_owner = 1, fleet_target_owner = 3, fleet_mission = 1, fleet_amount = 1.1111184467441E+24, fleet_array = 202,1111118446744099958554624, fleet_universe = 1, fleet_start_time = 1508055018.8103, fleet_end_stay = 1508055018.8103, fleet_end_time = 1508055040.6206, fleet_start_id = 1, fleet_start_galaxy = 1, fleet_start_system = 1, fleet_start_planet = 2, fleet_start_type = 1, fleet_end_id = 3, fleet_end_galaxy = 1, fleet_end_system = 1, fleet_end_planet = 3, fleet_end_type = 1, fleet_resource_metal = 0, fleet_resource_crystal = 0, fleet_resource_deuterium = 0, fleet_group = 0, fleet_target_obj = 0, start_time = 1508054997;
    3. File: /includes/classes/Database.class.php
    4. Line: 126
    5. URL: http://starwar.5v.pl/2/game.php?page=fleetStep3
    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(185): Database->_query('INSERT INTO %%L...', Array, 'insert')
    11. #1 /includes/classes/class.FleetFunctions.php(624): Database->insert('INSERT INTO %%L...', Array)
    12. #2 /includes/pages/game/ShowFleetStep3Page.class.php(404): FleetFunctions::sendFleet(Array, 1, '1', '1', '1', '1', '2', '1', '3', '3', 1, 1, 3, 1, Array, 1508055018.8103, 1508055018.8103, 1508055040.6206, 0)
    13. #3 /game.php(57): ShowFleetStep3Page->show()
    14. #4 {main}
    Display All



  • You probably right, its simply the creator of the tread not giving attention to the error
    and as usual, a question already asked 100 times in the last 2 weeks and for wich the anwser will never change