Errors with vehicle table with sql

mickiefinn · October 29, 2017, 9:56pm

I am trying to set up my own server, and i have got round all the issues so far but this one i have been struggling with for neally 2 weeks now, i am trying to set up a garage & licence system with esx, and i keep getting the same error no matter what scripts i use, https://pastebin.com/rC3ZP9k9 [ 390003] [ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM vehicles {=}”: Table ‘essentialmode.vehicles’ doesn’t exist
[ 391126] Error running call reference function for resource dmvschool: server.lua:53: attempt to index a nil value (local ‘xPlayer’)
any idea where im going wrong?
i am running all the sqls etc right and everything in the server.cfg is set up right to

304bl · October 29, 2017, 10:20pm

have you the table create in your database ?

mickiefinn · October 30, 2017, 7:04am

No none of the scripts I’m using provide it in their sql’s that’s why i posted this in hoping that I’ve missed something

304bl · October 30, 2017, 12:10pm

normaly if your script using mysql they should provide a file *.sql somewhere

mickiefinn · October 30, 2017, 8:23pm

i got all of the sqls, but none of them provide the vehicles table when i run them

Baguette_man_bruno · October 30, 2017, 9:44pm

mickiefinn · October 30, 2017, 11:27pm

thats a link to a mod shop and bennys is it not? im after a garage i can save cars in, and the problem is with the missing vehicle table in my sql database, thanks anyway man

dexslab · October 31, 2017, 5:16am

here is the SQL you need this one is in FR but you can modify it how you need but it provides the vehicle table you need

github.com

esx-framework/esx_vehicleshop/blob/master/esx_vehicleshop.sql

USE `es_extended`;

INSERT INTO `addon_account` (name, label, shared) VALUES
	('society_cardealer','Concessionnaire',1)
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
	('society_cardealer','Concesionnaire',1)
;

INSERT INTO `jobs` (name, label) VALUES
	('cardealer','Concessionnaire')
;

INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
	('cardealer',0,'recruit','Recrue',10,'{}','{}'),
	('cardealer',1,'novice','Novice',25,'{}','{}'),
	('cardealer',2,'experienced','Experimente',40,'{}','{}'),
	('cardealer',3,'boss','Patron',0,'{}','{}')
;

This file has been truncated. show original

mickiefinn · November 1, 2017, 1:14pm

you my friend are brilliant! thank you!

Papy_Gamer · February 25, 2019, 10:47pm

fr:
salut j’ai le même problème mise à part que c’est pour vendre les véhicules il me dit que la table vendre n’existe pas dans le garage je ne trouve pas cette commande… une idée peut-être?

en:
hi I have the same problem except that it is to sell the vehicles he told me that the table sell does not exist in the garage: / I can not find this order … an idea maybe?

OwbyTV · May 31, 2019, 12:27pm

You have to install esx_vehicleshop if you want owned vehicles.

The police job requires this, didn’t stay in the ReadMe

snakemer · March 19, 2021, 4:28pm

esto como se hace? se copia y se importa ?