[help] SQL error

Results 1 to 3 of 3
  1. #1
    Apprentice kenbigpig is offline
    MemberRank
    Dec 2006 Join Date
    16Posts

    [help] SQL error

    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 'thpor_2209531'@'%' to database 'thpor_2209531_Ogame'
    LOCK TABLE ugml_errors' at line 5

    i don't know if i did anything wrong or not.............
    Attached Files Attached Files


  2. #2
    Novice Jackkk is offline
    MemberRank
    Aug 2008 Join Date
    2Posts

    Re: [help] SQL error

    i have a mysql error in Rageonline 0.9 when i trying to build x(2 etc) amount some buildings or fleet in defense and shipyard

    Unknown column '' in 'field list'
    UPDATE game_planets SET `metal` = '153583.327781', `crystal` = '81987.8791669', `deuterium` = '18265.9749997', `last_update` = '1218699300', `b_hangar_id` = '', `metal_perhour` = '3890', `crystal_perhour` = '2122', `deuterium_perhour` = '631', `energy_used` = '-3954', `energy_max` = '4487', `` = '2', `b_hangar` = '6' WHERE `id` = '10';

    missing column(should be b_building_plus?) it's number of buildings/fleet
    where in php/tpl files i can fix it?
    and other one, when player trying send colonizator
    Incorrect integer value: '' for column 'fleet_target_owner' at row 1
    INSERT INTO game_fleets SET `fleet_owner` = '13', `fleet_mission` = '7', `fleet_amount` = '1', `fleet_array` = '208,1;', `fleet_start_time` = '1218726459', `fleet_start_galaxy` = '1', `fleet_start_system` = '50', `fleet_start_planet` = '7', `fleet_start_type` = '1', `fleet_end_time` = '1218727852', `fleet_end_stay` = '0', `fleet_end_galaxy` = '1', `fleet_end_system` = '50', `fleet_end_planet` = '5', `fleet_end_type` = '1', `fleet_resource_metal` = '0', `fleet_resource_crystal` = '0', `fleet_resource_deuterium` = '0', `fleet_target_owner` = '', `start_time` = '1218725066';
    Last edited by Jackkk; 14-08-08 at 04:32 PM.

  3. #3
    Novice Mausz is offline
    MemberRank
    Aug 2008 Join Date
    2Posts

    Re: [help] SQL error

    Quote Originally Posted by kenbigpig View Post
    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 'thpor_2209531'@'%' to database 'thpor_2209531_Ogame'
    LOCK TABLE ugml_errors' at line 5

    i don't know if i did anything wrong or not.............
    I have the same problem as the topic starter, does anybody know a solution ? Big Thanks if anyone does :biggrinth

    The problem is:

    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 'XXX'@'%' to database 'ogame'
    LOCK TABLE ugml_errorslunas WRITE, ugml_er' at line 5
    where XXX = database username. I have the ogame SQL database installed and everything, i really don`t know what to do.



    edit:

    I fixed it: Problem is the 'lock table'-privilege, the database-user has to have that privilege, if he doesn`t, you get the message above.
    Last edited by Mausz; 18-08-08 at 09:37 PM.



Advertisement