[JasonRiggs]

Hi, is there any method to show the exact part/line of error from mysql_log.txt?

[JasonRiggs]

Bump

[StrikerZ]

MySQL's latest version does that using log-core, update your script with that

[Sew_Sumi]

Depending on what you're wanting, clearing the log file, then forcing the error, then rechecking the log file could be a simple thing to mess with.


What's going on?

[JasonRiggs]

Quote:

Originally Posted by Sew_Sumi Depending on what you're wanting, clearing the log file, then forcing the error, then rechecking the log file could be a simple thing to mess with. What's going on?

The mysql_log shows me errors but without giving me lines, example:

Quote:

[16:44:39] [ERROR] cache_get_field_content_int - invalid datatype [16:44:39] [ERROR] cache_get_field_content_int - invalid datatype

Is there any method to show me the exact line?

[Sew_Sumi]

You may have to compare by manual checking.

It's saying that one of the integers it's trying to pull from the database, isn't an integer. So whichever value it's pulling should come out as a zero by theory.

You could try make each query print out what it got back to see if that could also help out, especially as it should come back with an empty result.


Something else to look at could be the level of log that it's showing... https://sampwiki.blast.hk/wiki/MySQL/R33#mysql_log


Try get all or debug maybe working.