Mysql error. - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql error. (/showthread.php?tid=216118)

---

Mysql error. - Haydz - 24.01.2011

,aallalla

---

Respuesta: Mysql error. - anonymousx - 25.01.2011

Delete ; at the end of every query.

---

Re: Mysql error. - Haydz - 25.01.2011

No luck ;/, any other ideas?

---

Re: Mysql error. - Blacklite - 25.01.2011

The ; is fine. You didn't have to remove that. Here is your problem:

UPDATE users SET money = %d, score = %d, Shamal = '%d', Cargo = '%d', Helicopter = '%d', ban = %d, ban_reason = '%s', WHERE username = '%s'

Remove that comma at the end - it's not supposed to be there. It should be:

UPDATE users SET money = %d, score = %d, Shamal = '%d', Cargo = '%d', Helicopter = '%d', ban = %d, ban_reason = '%s' WHERE username = '%s'

---

Re: Mysql error. - Haydz - 25.01.2011

Cheers blacklite, that works perfectly.

---