[RE-RELEASE] esx_eden garage

garage
esx

#148

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


#149

Also confused…Where? forgive me


#150

[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?


#151

Yes read other peoples comment that had same issue as you


#152

Got it thanks,


#153

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?


#154

Look at what other asked and you ll find solution


#155

Ah? What do you mean?


#156

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!


#158

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


#159

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


#160

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


#161

50 previous messages were about your problem


#162

nope il y a rien d’écris


#164

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


#165

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` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `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`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

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:


#166

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

exports.ft_libs:EnableArea(“esx_eden_garage_area_police_mecanodeletepoint”)
exports.ft_libs:EnableArea(“esx_eden_garage_area_police_mecanospawnpoint”)
exports.ft_libs:EnableArea(“esx_eden_garage_area_Bennys_mecanodeletepoint”)
exports.ft_libs:EnableArea(“esx_eden_garage_area_Bennys_mecanospawnpoint”)


#167

client sided where you take you duty


#168

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




#170

In client.lua line 179

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

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
						menu.close()
						menu2.close()

Great script!!