MySQL Syntax Error
#1

Can anyone seem to find what's wrong in this syntax?

Код:
mysql_format(mysql, query, sizeof(query), "UPDATE `accs` SET `pName` = %e, `pSecKey` = %d, `pLevel` = %d, `pRespect` = %d, `pSkin` = %d, `pIP` = %e, `pAdmin` = %d, `pVIP` = %d, `pMoney` = %d, `pGender` = %d, `pAge` = %d, `pBank` = %d, `pBanned` = %d, `pBans` = %d, `pBannedBy` = %e, `pBanReason` = %e, `pBanDate` = %e, `pBanTime` = %e, `pBanAppealable` = %d, `pFaction` = %d, `pRank` = %d, `pFacSkin` = %d, `pTester` = %d, `pTutStep` = %d, `pFinishedTut` = %d, `pMuted` = %d, `pPosX` = %f, `pPosY` = %f, `pPosZ` = %f, `pPosA` = %f WHERE `pID` = %d"
Код:
[05:13:41] [part] Jason_Vienna has left the server (0:1)
[05:13:41] [SQL-ERR][] EID:1064 >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.255.255, `pAdmin` = 0, `pVIP` = 0, `pMoney` = 0, `pGender` = 0, `pAge` = 0, `pB' at line 1
[05:13:41] UPDATE `accs` SET `pName` = Test_Account, `pSecKey` = 0, `pLevel` = 0, `pRespect` = 0, `pSkin` = 0, `pIP` = 255.255.255.255, `pAdmin` = 0, `pVIP` = 0, `pMoney` = 0, `pGender` = 0, `pAge` = 0, `pBank` = 0, `pBanned` = 0, `pBans` = 0, `pBannedBy` = , `pBanReason` = , `pBanDate` = , `pBanTime` = , `pBanAppealable` = 0, `pFaction` = 0, `pRank` = 0, `pFacSkin` = 0, `pTester` = 0, `pTutStep` = 0, `pFinishedTut` = 0, `pMuted` = 1125808864, `pPosX` = -80.625, `pPosY` = 1.578, `pPosZ` = 132.06, `pPosA` = 7.006e-45 WHERE `pID` =
Reply


Messages In This Thread
MySQL Syntax Error - by JaydenJason - 04.07.2015, 12:14
Re: MySQL Syntax Error - by rymax99 - 04.07.2015, 12:25
Re: MySQL Syntax Error - by prineside - 04.07.2015, 12:26
Re: MySQL Syntax Error - by Prokill911 - 04.07.2015, 12:30
Re: MySQL Syntax Error - by JaydenJason - 04.07.2015, 12:32
Re: MySQL Syntax Error - by Prokill911 - 04.07.2015, 12:34
Re: MySQL Syntax Error - by rymax99 - 04.07.2015, 12:34
Re: MySQL Syntax Error - by Prokill911 - 04.07.2015, 12:37
Re: MySQL Syntax Error - by rymax99 - 04.07.2015, 12:38
Re: MySQL Syntax Error - by JaydenJason - 04.07.2015, 12:45

Forum Jump:


Users browsing this thread: 1 Guest(s)