[help] SQL error

[kenbigpig]

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.............

 

[Jackkk]

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';

 

[Mausz]

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.