problem with the cops and mecano job

[ptNegorath]

i'm getting this error. Can you help please:

[ERROR] [MySQL] An critical error happens on MySQL for query "select * from owned_vehicles inner join characters on owned_vehicles.owner = characters.identifier where fourrieremecano=@fourrieremecano {@fourrieremecano=True}": An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException (System.ExceptionResource resource) [0x0000b] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Collections.Generic.Dictionary2[TKey,TValue].Insert (TKey key, TValue value, System.Boolean add) [0x0007c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Collections.Generic.Dictionary2[TKey,TValue].Add (TKey key, TValue value) [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at MySQLAsync.FetchAll+d2.MoveNext () [0x000e9] in <6f835765886c4fada3e5ffb1ffcd6998>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Runtime.CompilerServices.TaskAwaiter1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at MySQLAsync.Operation1+d7[TResult].MoveNext () [0x00169] in <6f835765886c4fada3e5ffb1ffcd6998>:0

[TanguyOrtegat]

yes the error is clearly written: An item with the same key has already been added

so means you id column is not a primary key or yuo have double identifiers in users table or character table

[TanguyOrtegat]

no more answers, closing the tread

[Abdou741]

Hi, I have a same problem for latest relase : I have a problem with esx_policejob & esx_vehicleshop A issue for that ? Don't try for the moment for another jobs. Sorry if my english is bad.

[ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query "SELECT * FROM owned_vehicles WHERE owner = 'steam:00000' AND type = 'car' AND job = 'police'": ER_BAD_FIELD_ERROR: Unknown column 'type' in 'where clause' [ERROR] [MySQL] [esx_policejob] An error happens on MySQL for query "SELECT plate FROM owned_vehicles WHERE owner = 'steam:00000' AND plate = '82FOJ548' AND job = 'police'": ER_BAD_FIELD_ERROR: Unknown column 'job' in 'where clause' [ERROR] [MySQL] [esx_policejob] An error happens on MySQL for query "INSERT INTO owned_vehicles (owner, vehicle, plate, type, job, stored) VALUES ('steam:00000', '{\"modFender\":-1,\"modXenon\":false,\"modEngineBlock\":-1,\"modFrame\":-1,\"modPlateHolder\":-1,\"pearlescentColor\":0,\"modSideSkirt\":-1,\"modSteeringWheel\":-1,\"model\":2046537925,\"modHydrolic\":-1,\"modTrimB\":-1,\"modStruts\":-1,\"modHood\":-1,\"modSpeakers\":-1,\"plateIndex\":4,\"dirtLevel\":5.0,\"modVanityPlate\":-1,\"modTank\":-1,\"color1\":134,\"modLivery\":3,\"modWindows\":-1,\"modAerials\":-1,\"wheels\":1,\"plate\":\"ZQH 092\",\"wheelColor\":156,\"modExhaust\":-1,\"fuelLevel\":65.0,\"modTransmission\":-1,\"modRoof\":-1,\"modDoorSpeaker\":-1,\"modAirFilter\":-1,\"modRearBumper\":-1,\"modGrille\":-1,\"modHorns\":-1,\"modTrimA\":-1,\"modSuspension\":-1,\"neonColor\":[255,0,255],\"modFrontBumper\":-1,\"modTurbo\":false,\"modShifterLeavers\":-1,\"modAPlate\":-1,\"modFrontWheels\":-1,\"extras\":{\"2\":false,\"1\":true},\"engineHealth\":1000.0,\"windowTint\":-1,\"modBackWheels\":-1,\"modSmokeEnabled\":false,\"modBrakes\":-1,\"tyreSmokeColor\":[255,255,255],\"color2\":134,\"modSeats\":-1,\"modArchCover\":-1,\"modDashboard\":-1,\"modOrnaments\":-1,\"bodyHealth\":1000.0,\"modDial\":-1,\"modTrunk\":-1,\"modArmor\":-1,\"modRightFender\":-1,\"modEngine\":-1,\"neonEnabled\":[false,false,false,false],\"modSpoilers\":-1}', 'ZQH 092', 'car', 'police', true)": ER_BAD_FIELD_ERROR: Unknown column 'type' in 'field list'

[TanguyOrtegat]

that is your error: : Unknown column 'type' in 'field list' lat sentences. you just need to update boat and airplane shop otherwise everything works fine. That error comes from your job and not the script so cannot help. contact the owner of that script to make it compatible (but policejob should be compatible)