[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM owned_vehicles WHERE owner = @owner AND type = @type AND job = @job {@type=car;@owner=steam:1100001361a8398;@job=ambulance}”: Unknown column ‘type’ in ‘where clause’
he puts that on me and in ambulance job he doesn’t let me take the ambulance
The garage script you are using has modified the table to have a type. The type is Car.
Make sure the type column is in the owned_vehicles table in your database. It may not be there.
Just delete the And type=@type. See if that works
excuse me so noob. What do you mean by And type = @ type
thanks
From your OP.
The error is a misconfigured SQL request, probably because of the two AND statements inside it.
Becauae you don’t really need to doulbe check if you are pulling a car out from your database if you’re an ambulance worker, removing the requirement for the type to be car is the easiest solution.
Basically, inside the scriptthat is giving you an issue. Please find the SQL string that should be the error that is listed, and modify it inside the script.
it works thank you. I have another problem in ambulancejob and if boi to revive a dead player that player is transported to the hospital and does not stay where he died. Thanks
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
