SA-MP Forums Archive
An error has occured - 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: An error has occured (/showthread.php?tid=551753)


An error has occured - OMonger - 20.12.2014

Reopened, found another bug which I need help with. This is the server's log:
http://pastebin.com/qnwYSQ2R

This is the line where the MYSQL saves of which creates the bug:
Код:
format(query, sizeof(query), "UPDATE `Accounts` SET `PrisonSelect` = %d, `PrisonTime` = %d, `AdminPrisonCount` = %d, `SecondsLoggedIn` = %d, `PlayingHours` = %d, `AdminCode` = %d, `PhoneN` = %d, `PhoneCredit` = %d, `PhoneBook` = %d, `House` = %d, `Hotel` = %d, `Hospitalized` = %d, WHERE `UserID` = '%d'",
It does save, just it doesn't save them. Thanks in advance

Re: An error has occured - Jefff - 20.12.2014

Remove ',' before WHERE

Re: An error has occured - JeaSon - 20.12.2014

mistake is " , " before WHERE
pawn Код:
format(query, sizeof(query), "UPDATE `Accounts` SET `PrisonSelect` = %d, `PrisonTime` = %d, `AdminPrisonCount` = %d, `SecondsLoggedIn` = %d, `PlayingHours` = %d, `AdminCode` = %d, `PhoneN` = %d, `PhoneCredit` = %d, `PhoneBook` = %d, `House` = %d, `Hotel` = %d, `Hospitalized` = %d WHERE `UserID` = '%d'",
EDIT:late

Re: An error has occured - OMonger - 20.12.2014

Thanks! Took me a while to fix the others too, thanks again!