Need help with esx_vehicleshop {SOLVED}

FiveM Server Development ES/ESX
1

So i downloaded the following

And when i go to the dealership and go into the circle and press “E” the shop menu comes up but there is no categories or vehicles. i noticed my server gave me this error but am unsure how to fix this issue

Error:

[ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query “SELECT * FROM vehicle_categories”: ER_NO_SUCH_TABLE: Table ‘essentialmode.vehicle_categories’ doesn’t exist

Can someone help me out? thank you

2

Hello MRHYUING,
the error says : you don’t have table name vehicle_categories in database essentialmode

try to delete the database & reinstall it again.

3

Is there no .sql i could possibly download and just make it super simple? instead of deleting my entire database…? i just fixed my server after two days and finally got it up again. i noticed you can right click a table in the essentialmode database and export it as an .sql file.

4

Try :

CREATE TABLE `vehicle_categories` (
	`name` varchar(60) NOT NULL,
	`label` varchar(60) NOT NULL,

	PRIMARY KEY (`name`)
);

than :

INSERT INTO `vehicle_categories` (name, label) VALUES
	('compacts','Compacts'),
	('coupes','Coupés'),
	('sedans','Sedans'),
	('sports','Sports'),
	('sportsclassics','Sports Classics'),
	('super','Super'),
	('muscle','Muscle'),
	('offroad','Off Road'),
	('suvs','SUVs'),
	('vans','Vans'),
	('motorcycles','Motos')
;

this is the .esx_vehicleshop.sql (11.9 KB)
SQL

5

okay i can try this. where do i place this in? i’m so sorry for all the questions. i’m new and trying to learn this stuff best i can

6

i just edit my post and upload for you the SQL file under your request.

so if you don’t want manually add those codes just upload the SQL database what i added into the same database but make sure that when you upload this database it will overwrite on you database.

7

First thanks for the help lol…

how can i overwrite things with the new .sql because i’m getting “Duplicated” errors

again i’m sorry i’m new to heidiSQL and all this

8

Fine, just delete the hole database and install the uploaded above.

9

Fixed. Thanks

10

You welcome :slight_smile:.

11

Thanks

12

Hi guys, need help for other than cardealer job, player can only view the car.

13

I can use my dealership one time with E put when i want to open the menu again i cant press E ?? PLS help