SA-MP Forums Archive
[MYSQL] Error can't save data again! PLZ HELP! - 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 can't save data again! PLZ HELP! (/showthread.php?tid=579568)


[MYSQL] Error can't save data again! PLZ HELP![FIXED] - kloning1 - 28.06.2015

top
pawn Код:
enum plyrinfo
{
    // some data
    pBanned,
    pABanned[MAX_PLAYER_NAME],
    pBanReason[128]
};
public OnPlayerUpdate(playerid)
{
    // some system and data
    format(pInfo[playerid][pBanReason],128, "tidak");
    format(pInfo[playerid][pABanned], MAX_PLAYER_NAME, "none");
    // blabla bla
    return 1;
}
function save player
pawn Код:
stock SaveStats(playerid)
{
    new query[512], asu[24+MAX_PLAYER_NAME], benreson[128];
    format(asu,sizeof(asu),"%s",pInfo[playerid][pABanned]);
    format(benreson,sizeof(benreson),"%s",pInfo[playerid][pBanReason]);
    format(query, sizeof(query), "UPDATE `zmusers` SET `pEXP`=%d, `pKills`=%d, `pDeaths`=%d, `pRank`=%d, `pEvac`=%d, `pAdminLevel`=%d, `pAdminMapping`=%d, `pDonateLevel`=%d, `pZmc`=%d, `pHour`=%d, `pMin`=%d, `pSec`=%d,",
    pInfo[playerid][pEXP], pInfo[playerid][pKills], pInfo[playerid][pDeaths], pInfo[playerid][pRank], pInfo[playerid][pEvac], pInfo[playerid][pAdminLevel], pInfo[playerid][pAdminMapping], pInfo[playerid][pDonateLevel],  pInfo[playerid][pZmc], pInfo[playerid][pHour], pInfo[playerid][pMin], pInfo[playerid][pSec]);
    mysql_format(mysql, query, sizeof(query), "%s `pMapsPlayed`=%d, `pMoney`=%d, `gLeader`=%d, `gMember`=%d, `pWarnings`=%d, `pBanned`=%d, `pABanned`=`%s`, `pBanReason`=`%s` WHERE `Username`='%e'",
    query, pInfo[playerid][pMapsPlayed], pInfo[playerid][pMoney], pInfo[playerid][gLeader], pInfo[playerid][gMember], pInfo[playerid][pWarnings], pInfo[playerid][pBanned], asu, benreson, PlayerName(playerid));
    mysql_tquery(mysql, query);
    return 1;
}
ERROR!
Код:
[14:07:58] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column '' in 'field list'
In My DB


so? what wrong? I am very confused on this issue
I've been there 4 hours looking for a solution
any can help me?

Re: [MYSQL] Error can't save data again! PLZ HELP! - AlonzoTorres - 28.06.2015

pawn Код:
stock SaveStats(playerid)
{
    new query[512], asu[24+MAX_PLAYER_NAME], benreson[128];
    format(asu,sizeof(asu),"%s",pInfo[playerid][pABanned]);
    format(benreson,sizeof(benreson),"%s",pInfo[playerid][pBanReason]);
    format(query, sizeof(query), "UPDATE `zmusers` SET `pEXP`=%d, `pKills`=%d, `pDeaths`=%d, `pRank`=%d, `pEvac`=%d, `pAdminLevel`=%d, `pAdminMapping`=%d, `pDonateLevel`=%d, `pZmc`=%d, `pHour`=%d, `pMin`=%d, `pSec`=%d ->,<-", // Remove the last comma (,)
    pInfo[playerid][pEXP], pInfo[playerid][pKills], pInfo[playerid][pDeaths], pInfo[playerid][pRank], pInfo[playerid][pEvac], pInfo[playerid][pAdminLevel], pInfo[playerid][pAdminMapping], pInfo[playerid][pDonateLevel],  pInfo[playerid][pZmc], pInfo[playerid][pHour], pInfo[playerid][pMin], pInfo[playerid][pSec]);
    mysql_format(mysql, query, sizeof(query), "%s `pMapsPlayed`=%d, `pMoney`=%d, `gLeader`=%d, `gMember`=%d, `pWarnings`=%d, `pBanned`=%d, `pABanned`=`%s`, `pBanReason`=`%s` WHERE `Username`='%e'",
    query, pInfo[playerid][pMapsPlayed], pInfo[playerid][pMoney], pInfo[playerid][gLeader], pInfo[playerid][gMember], pInfo[playerid][pWarnings], pInfo[playerid][pBanned], asu, benreson, PlayerName(playerid));
    mysql_tquery(mysql, query);
    return 1;
}


Re: [MYSQL] Error can't save data again! PLZ HELP! - kloning1 - 28.06.2015

Quote:
Originally Posted by AlonzoTorres
Посмотреть сообщение
pawn Код:
stock SaveStats(playerid)
{
    new query[512], asu[24+MAX_PLAYER_NAME], benreson[128];
    format(asu,sizeof(asu),"%s",pInfo[playerid][pABanned]);
    format(benreson,sizeof(benreson),"%s",pInfo[playerid][pBanReason]);
    format(query, sizeof(query), "UPDATE `zmusers` SET `pEXP`=%d, `pKills`=%d, `pDeaths`=%d, `pRank`=%d, `pEvac`=%d, `pAdminLevel`=%d, `pAdminMapping`=%d, `pDonateLevel`=%d, `pZmc`=%d, `pHour`=%d, `pMin`=%d, `pSec`=%d ->,<-", // Remove the last comma (,)
    pInfo[playerid][pEXP], pInfo[playerid][pKills], pInfo[playerid][pDeaths], pInfo[playerid][pRank], pInfo[playerid][pEvac], pInfo[playerid][pAdminLevel], pInfo[playerid][pAdminMapping], pInfo[playerid][pDonateLevel],  pInfo[playerid][pZmc], pInfo[playerid][pHour], pInfo[playerid][pMin], pInfo[playerid][pSec]);
    mysql_format(mysql, query, sizeof(query), "%s `pMapsPlayed`=%d, `pMoney`=%d, `gLeader`=%d, `gMember`=%d, `pWarnings`=%d, `pBanned`=%d, `pABanned`=`%s`, `pBanReason`=`%s` WHERE `Username`='%e'",
    query, pInfo[playerid][pMapsPlayed], pInfo[playerid][pMoney], pInfo[playerid][gLeader], pInfo[playerid][gMember], pInfo[playerid][pWarnings], pInfo[playerid][pBanned], asu, benreson, PlayerName(playerid));
    mysql_tquery(mysql, query);
    return 1;
}
Код:
[16:44:41] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:44:41] [ERROR] CMySQLQuery::Execute[] - (error #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 '`pMapsPlayed`=1, `pMoney`=0, `gLeader`=0, `gMember`=0, `pWarnings`=0, `pBanned`=' at line 1
[16:44:41] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[16:44:41] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:44:41] [ERROR] CMySQLQuery::Execute[] - (error #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 '`pMapsPlayed`=1, `pMoney`=0, `gLeader`=0, `gMember`=0, `pWarnings`=0, `pBanned`=' at line 1
[16:44:41] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError


Re: [MYSQL] Error can't save data again! PLZ HELP! - kloning1 - 28.06.2015

BUMP!

Re: [MYSQL] Error can't save data again! PLZ HELP! - AlonzoTorres - 29.06.2015

Remove the "query," part next to pInfo[playerid][pMapsPlayed]