#Qb-Vehicleshop & Qb-Garages
1 messages · Page 1 of 1 (latest)
Please fill out the following fields with maximum effort. Low-effort posts will receive low-effort responses.
Provide the name of the script you're having trouble with.
Paste the exact error message you received. Ignore this if no error. (Check client (F8) and server (Tx) console)
Describe the issue you're experiencing in detail.
List the last changes you made before this issue occurred.
Explain what steps you've already taken to try and fix this.
Include any relevant screenshots or recordings.
yeah cause the index you're trying to add already exists
Ive deleted it and re run it but still getting the same error
Delete your entire player_vehicles table and run the whole sql file again
Ive done that already like 5 times and still the same thing
And you keep getting this same error?
Yep
I'll redo it for you right now and I'll send you another screenshot
Maybe send a video of how youre dropping the table
2 mins
There you go mate
Ok so you are getting a different error not the same error
Yeh I dont understand why though
Click on details and please send a photo of what it says
Also on a completely different and unrelated note, I would recommend changing your tag from "advanced" to probably "intermediate"
When it comes to this sort of stuff its complicated anything else Im an expert 😂
run this in phpmyadmin
DROP TABLE IF EXISTS player_vehicles;
CREATE TABLE player_vehicles (
id int(11) NOT NULL AUTO_INCREMENT,
license varchar(50) DEFAULT NULL,
citizenid varchar(50) DEFAULT NULL,
vehicle varchar(50) DEFAULT NULL,
hash varchar(50) DEFAULT NULL,
mods text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
plate varchar(15) NOT NULL,
fakeplate varchar(50) DEFAULT NULL,
garage varchar(50) DEFAULT 'pillboxgarage',
fuel int(11) DEFAULT 100,
engine float DEFAULT 1000,
body float DEFAULT 1000,
state int(11) DEFAULT 1,
depotprice int(11) NOT NULL DEFAULT 0,
drivingdistance int(50) DEFAULT NULL,
status text DEFAULT NULL,
balance int(11) NOT NULL DEFAULT 0,
paymentamount int(11) NOT NULL DEFAULT 0,
paymentsleft int(11) NOT NULL DEFAULT 0,
financetime int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (id),
UNIQUE KEY UK_playervehicles_plate (plate),
KEY citizenid (citizenid),
KEY license (license)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Where am I putting that exactly
yep
ok so now restart your server
If you have fixed this problem now Im gonna be over the moon
and then try again 🙂
Right so I can buy it fine but when it comes to storing the vehicle it just says 'the vehicle is not yours'
any f8 errors or console errors?
is this a fresh install?
One of your issues that may not be present atm is using zap. I would avoid using them as they're quality of service is poor.
the only errors are for other scripts
What are the errors?
wasabi scripts thats all but I can fix those
When did u do this install of qb?
Well we reinstalled the server this morning
Ok so I've just tested on my install that I did 2 days ago and it's working perfectly.
You must have installed this incorrectly.
Ive done it a million times and its worked perfectly fine
It's obvious that something is wrong on your end. I would try a fresh install first before doing anything else
Test then without any other scripts etc
Ok I will do that now and let you know when Ive done
Which one would you recommend because Ive been using the top one
So it took me a while to get the server reinstalled but the garages work now so do you think it could be one of my scripts in the server
Probably the errors you were saying before conflicting. Or you installed it incorrectly
But without looking and seeing what the errors were or what scripts you had it’s impossible for me to confirm
So remove your scripts and go one by one