SA-MP Forums Archive
mysql error 1064 - 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 1064 (/showthread.php?tid=355346)


mysql error 1064 - marquezsanchez - 29.06.2012

hi guys i have a mysql error 1064 , it an syntax error but i didnt found any error :

Error + query

Quote:

errorid = 1064,
error = 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 '`hEnterPosX` = '1958.378295', `hEnterPosY` = '1343.157226', `hEnterPosZ` = '15.3' at line 1,
callback =
query = UPDATE `housedata` SET `hOwner` = 'Etat', `hToSell` = '1', `hOriginalPrice` = '20000' `hEnterPosX` = '1958.378295', `hEnterPosY` = '1343.157226', `hEnterPosZ` = '15.374607', `hExitPosX` = '123.123001', `hExitPosY` = '456.455993', `hExitPosZ` = '789.789001' `hStoredWeapon0` = '0', `hStoredWeapon1` = '0', `hStoredWeapon2` = '0', `hStoredWeapon3` = '0', `hStoredMoney` = '0' `hLocked` = '0', `hSecurityLevel` = '0', `hHasAlarm` = '0'
the code :

Quote:
PHP код:
MysqlSaveHouse(houseId)
{
    new escapedQuery[512];
    format(escapedQuery, sizeof(escapedQuery), "UPDATE `housedata` SET `hOwner` = '%s', `hToSell` = '%i', `hOriginalPrice` = '%i' \
    `hEnterPosX` = '%s', `hEnterPosY` = '%s', `hEnterPosZ` = '%s', `hExitPosX` = '%s', `hExitPosY` = '%s', `hExitPosZ` = '%s' \
    `hStoredWeapon0` = '%i', `hStoredWeapon1` = '%i', `hStoredWeapon2` = '%i', `hStoredWeapon3` = '%i', `hStoredMoney` = '%i' \
    `hLocked` = '%i', `hSecurityLevel` = '%i', `hHasAlarm` = '%i'",
    gHouseVar[houseId][hOwner], gHouseVar[houseId][hToSell], gHouseVar[houseId][hOriginalPrice], strfloat(gHouseVar[houseId][hEnterPos][0]), strfloat(gHouseVar[houseId][hEnterPos][1]),
    strfloat(gHouseVar[houseId][hEnterPos][2]), strfloat(gHouseVar[houseId][hExitPos][0]), strfloat(gHouseVar[houseId][hExitPos][1]), strfloat(gHouseVar[houseId][hExitPos][2]),
    gHouseVar[houseId][hStoredWeapon][0], gHouseVar[houseId][hStoredWeapon][1],gHouseVar[houseId][hStoredWeapon][2],gHouseVar[houseId][hStoredWeapon][3],
    gHouseVar[houseId][hStoredMoney], gHouseVar[houseId][hLocked], gHouseVar[houseId][hSecurityLevel], gHouseVar[houseId][hHasAlarm]);
    
    mysql_function_query(gConnection, escapedQuery, false, "", "");
} 


Re: mysql error 1064 - iGetty - 29.06.2012

You haven't set to update WHAT house ID..

Re: mysql error 1064 - marquezsanchez - 29.06.2012

OMFG !! thx you

Re: mysql error 1064 - iGetty - 29.06.2012

Is it fixed? I hope so.

Re: mysql error 1064 - marquezsanchez - 29.06.2012

yes ^^.