search

kasuganosoras / esx_realparking

🅿️ A real car parking script for FiveM
GNU General Public License v3.0
51 stars 31 forks source link

mysql error #15

Open R0bbieJ opened 4 years ago

R0bbieJ commented 4 years ago

after server restart

[ERROR] [MySQL] [esx_realparking] An error happens on MySQL for query "SELECT identifier, name FROM users": ER_BAD_FIELD_ERROR: Unknown column 'name' in 'field list'

[ERROR] [MySQL] [esx_realparking] An error happens on MySQL for query "UPDATE owned_vehicles SET stored = 0 WHERE plate = 'ORU 601' AND owner = '038ec16e2c249675dd3f610207558adcf833b577'": ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stored = 0 WHERE plate = 'ORU 601' AND owner = '038ec16e2c249675dd3f610207558adc' at line 1

Danielfivem1 commented 4 years ago

Same

ghost commented 4 years ago

Same

kasuganosoras commented 4 years ago

you are using the new version of ESX, please change Config.UsingOldESX to false in config.lua

N3URoO commented 4 years ago

Your db dont find column "name" create this column in your "owned_vehicle"

dark13elemental commented 4 years ago

The problem was in "stored" column. It's MySQL reserved keyword. You need to change in ../server/main.lua: ALL MySQL.Async.execute('UPDATE owned_vehicles SET stored TO MySQL.Async.execute('UPDATE owned_vehicles SET stored Place word "stored" in the middle of ``

kasuganosoras commented 2 years ago

Fixed in 9feee08