mysql error exact line - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql error exact line (/showthread.php?tid=654165)

---

mysql error exact line - JasonRiggs - 22.05.2018

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

---

Re: mysql error exact line - JasonRiggs - 23.05.2018

Bump

---

Re: mysql error exact line - StrikerZ - 23.05.2018

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

---

Re: mysql error exact line - Sew_Sumi - 23.05.2018

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?

---

Re: mysql error exact line - JasonRiggs - 26.05.2018

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

Is there any method to show me the exact line?

---

Re: mysql error exact line - Sew_Sumi - 26.05.2018

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.

---