[RE-RELEASE] esx_eden garage2: 3 in 1 garage

MercFury · November 26, 2018, 12:55pm

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

Luggz · November 29, 2018, 2:03am

Also confused…Where? forgive me

Luggz · November 29, 2018, 3:39am

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

Jager_Bom · November 29, 2018, 8:38am

Yes read other peoples comment that had same issue as you

Luggz · November 29, 2018, 8:56am

Got it thanks,

x1mart · November 29, 2018, 7:37pm

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?

Jager_Bom · November 29, 2018, 11:22pm

Look at what other asked and you ll find solution

ColoradoRP · November 30, 2018, 7:14am

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!

Jonathanfletcher · December 5, 2018, 12:16am

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

Jager_Bom · December 5, 2018, 8:00am

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

Jonathanfletcher · December 5, 2018, 10:06pm

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

Jager_Bom · December 6, 2018, 12:01am

50 previous messages were about your problem

Jonathanfletcher · December 6, 2018, 12:12am

nope il y a rien d’écris

skytrix · December 6, 2018, 4:59pm

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

AODeltaB · December 8, 2018, 11:29am

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

RyuuTheKitsune · December 13, 2018, 1:50am

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”)

Jager_Bom · December 13, 2018, 10:37am

client sided where you take you duty

Shyricaus · December 14, 2018, 5:42am

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

Shyricaus · December 14, 2018, 6:01am

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

Jager_Bom · December 14, 2018, 8:41am

One of my players reported me a dupe bug I ll fix it on GitHub