[RE-RELEASE] esx_eden garage



No matter what we set primary key as even with everything unchecked as allow null in vehicle shop this happens


Also confused…Where? forgive me


[ERROR] [MySQL] [esx_jb_eden_garage2] An error happens on MySQL for query “[obje
ct Object]”: ER_BAD_FIELD_ERROR: Unknown column ‘id’ in ‘where clause’

Interesting any ideas?


Yes read other peoples comment that had same issue as you


Got it thanks,


I have this 3 errors when I try to store a car in a garage.

This is how my “owned_vehicles” table looks like:

Can someone please help me fix this?


Look at what other asked and you ll find solution


Ah? What do you mean?


Does anyone have an issue with the car’s being impounded the minute you enter them into the garage? Then when you pay the impound fee, re-enter the car into the garage, it get’s impounded AGAIN? Help please!


ERROR] [MySQL] An error happens on MySQL for query “UPDATE owned_vehicles SET state =@state WHERE id=@id {@state=False}”: Unknown column ‘id’ in ‘where clause’

toujours le meme problemes lorsque je sort le vehicules et lorsque je tente de rentrer le vehicules rien ne se produit


Même erreur que les autres. La sollu à déjà été donné plus haut


serieux ? je l’ai meme aps vu… pourrais tu me la donner ?


50 previous messages were about your problem


nope il y a rien d’écris


Hello ,
Pour tous simplement enlever tous ces erreur MySQL !
Changer tous simplement tous Les " id " en " plate " coté server (server.lua) du script au lieu d’ajouter une Colonne Id et ne plus avoir la totalité de script fonctionnel !
Voila tous je partage ce que pour moi cela reste le plus facile et le plus complet !
Cordialement Sky ^^


Hello, for those peoples who has the latest version of es_extended and esx_jb_eden_garage2 and who are not able to make it work. First of all here is the error :

(Thanks x1mart for the screen, go check his post to be sure that it’s the same error)

I’ve found a fix(temporary), just before this, be sure to save your db (export a sql file), the owned_vehicles table must be like this :

If you are too lazy, here is the sql request :

CREATE TABLE IF NOT EXISTS `owned_vehicles` (
  `owner` varchar(30) NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Etat de la voiture',
  `plate` varchar(12) NOT NULL,
  `vehicle` longtext,
  `fourrieremecano` tinyint(1) NOT NULL DEFAULT '0',
  `vehiclename` varchar(50) NOT NULL DEFAULT 'voiture',
  PRIMARY KEY (`id`),
  KEY `vehsowned` (`owner`)

Then go in [essential]/es_extended/client/functions.lua at line 644 change this :

		plate             = ESX.Math.Trim(GetVehicleNumberPlateText(vehicle)),

to this :

		plate             = GetVehicleNumberPlateText(vehicle),	

Then restart, delete cache folder … My vehicle shop work correctly with this btw no probem with eden_garage2 !
Hope it helps you :wink:


am i just really stupid atm i cant find where to put these lines anywhere



client sided where you take you duty


I’m having this problem on the console someone else having and can pass as I can solve.


In client.lua line 179

		function(data2, menu2)
				if data2.current.value == "get_vehicle_out" then
					if (data.current.value.state) then

Should add menu.close() so first menu closes after spawning a vehicle. Preventing the player from spawning multiple vehicles intentionally or accidentally.

		function(data2, menu2)
				if data2.current.value == "get_vehicle_out" then
					if (data.current.value.state) then

Great script!!