[ERROR] [MySQL] owned_vehicles

FiveM Resource Development Discussion
1

[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM owned_vehicles WHERE @plate = plate {@plate=OSC 811}”: Unknown column ‘plate’ in ‘where clause’

3

What? )20 characters

4

Hello,

The colum “plate” does not exist in your table “Owned_vehicle”.

5 
[ERROR] [MySQL] [esplugin_mysql] An error happens on MySQL for query "UPDATE users SET `money`=4234324234,`bank`=16100 WHERE `identifier`='steam:110000138d71734'": ER_WARN_DATA_OUT_OF_RANGE: Out of range value for column 'money' at row 2
[ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query "INSERT INTO owned_vehicles (owner, plate, vehicle, x, y, z, h, health) VALUES ('steam:110000138d71734', 'RHS 817', '{\"modBrakes\":-1,\"modFender\":-1,\"modHood\":-1,\"wheelColor\":156,\"modStruts\":-1,\"model\":-134949878,\"tyreSmokeColor\":[255,255,255],\"plate\":\"RHS 817\",\"modSpoilers\":-1,\"modSideSkirt\":-1,\"extras\":{\"2\":false,\"1\":true},\"modSuspension\":-1,\"modHydrolic\":-1,\"modTrimA\":-1,\"modTurbo\":false,\"modXenon\":false,\"plateIndex\":0,\"modBackWheels\":-1,\"modFrontWheels\":-1,\"modArmor\":-1,\"neonEnabled\":[false,false,false,false],\"modTrunk\":-1,\"modLivery\":3,\"color2\":63,\"modRearBumper\":-1,\"neonColor\":[255,0,255],\"modAerials\":-1,\"modSpeakers\":-1,\"modDial\":-1,\"modAirFilter\":-1,\"modGrille\":-1,\"dirtLevel\":1.0000042915344239,\"modTrimB\":-1,\"color1\":63,\"modPlateHolder\":-1,\"modSeats\":-1,\"modRightFender\":-1,\"modHorns\":-1,\"modSteeringWheel\":-1,\"modFrontBumper\":-1,\"modEngineBlock\":-1,\"health\":1000,\"modShifterLeavers\":-1,\"modDoorSpeaker\":-1,\"modWindows\":-1,\"modTransmission\":-1,\"wheels\":7,\"modOrnaments\":-1,\"modTank\":-1,\"modDashboard\":-1,\"modVanityPlate\":-1,\"modAPlate\":-1,\"modSmokeEnabled\":false,\"modExhaust\":-1,\"pearlescentColor\":5,\"modRoof\":-1,\"windowTint\":-1,\"modFrame\":-1,\"modEngine\":-1,\"modArchCover\":-1}', -245.85999999998603, 6257.199999999255, 31.089999999996508, 223.96999999997206, 1000)": ER_BAD_FIELD_ERROR: Unknown column 'x' in 'field list'

Could you help me? When i buy a vehicle it doesnt save to owned_vehicles data base

6

Try to set it as a varchar 255 or a long text

7

did you ever find a fix for the 2nd line in this?