Hi I’m looking for a way to debug MYSQL errors or add more verbosity/debug into the console. Currently experiencing a bug with jobs - the job is not displayed in the game and when freshly loaded in i get the following error.
Isn’t this enough info?
Looks like you are trying to get a column called name which doesnt exists
Well obviously it isn’t enough information as i do not know what query/function actually procs the error. Its easy to point fingers at the easy solution but how can i trace back to the source of the problem.
The source of the problem is that the field doesnt exist. The help that @TheIndra provided is more than sufficient.
Read your serverside code, find the part of it that looks for a ‘name’ column, and add the column to the appropriate table in your database.
1 Like
My issue isnt actually looking at ta specific error like the one provided. I want to figure out a way to track down the errors and how/where do they come from. A lot of the time the errors seem very vague compared to OOPL like C#, Python, GO. That’s why i’m just looking for a way to trace a root of the problem. And grepping 200+ lua files to search for a ‘name’ can be a bit daunting.
In the end i’m just sick of constantly restoring my database to its working state when it gets broken, i want to figure out a way to troubleshoot and thats why i have posted this.
MySQL errors here are always going to be vague, a field name is as specific as its ever going to get