search

HumanTree92 / esx_advancedvehicleshop

Advanced Vehicle Shops for FiveM ESX Legacy
http://velocitientertainment.com/
27 stars 15 forks source link

mysql error for owning bought vehicles #76

Closed Ardentrayne closed 3 years ago

Ardentrayne commented 3 years ago

Hi I've been getting an error basically that says: [esx_advancedvehicleshop] An error happens for query "INSERT INTO owned_vehicles. I've tried alot of solutions for this but still can't get it to work, this happens basically when i buy the vehicle, in game it says I own it but I get this error. This also stops me from being able to pull it out from my garage once i store it because its technically not mine due to the error. Any advice would be great~

also here's an image of the full thing (hopefully it shows): image

Questions Have you made changes to anything besides the config.lua?: Have you looked through the Closed Topics?: Have you looked through the Wiki?: Are you using a Pre-Installed ESX? If Yes who?: Are you using ESX Legacy?: Are you using OneSync?: Linux or Windows?:

HumanTree92 commented 3 years ago

Post an image of your owned_vehicles structure

Ardentrayne commented 3 years ago

This should be the one: image

HumanTree92 commented 3 years ago

Judging from the screenshot it looks like your using the Release Version. But just as a heads up the Job Column shouldn't be NULL as you can see here https://github.com/HumanTree92/esx_advancedvehicleshop/blob/V1/esx_advancedvehicleshop.sql#L13

Ardentrayne commented 3 years ago

Okay that makes sense but also How would I go about changing that exactly?

HumanTree92 commented 3 years ago

Delete ur current owned_vehicles and upload mine. Or click the change button in structure

Ardentrayne commented 3 years ago

And to upload I'd just basically be putting in the SQL right? when i go to change the structure i see a few things does it matter which one of these I choose? image

Ardentrayne commented 3 years ago

I've tried to reinput the SQL as well as create my own table and that didn't end up working I got the same error. I've attached an image of the structure: image

Ardentrayne commented 3 years ago

Okay so update I got it to work, I understood what you said and tried it that way with editing the sql to what was missing which was basically the creation table! Thank you for your help!