SA-MP Forums Archive
Mysql error! help +rep - 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! help +rep (/showthread.php?tid=540484)


Mysql error! help +rep - Ryz - 05.10.2014

....

Re: Mysql error! help +rep - yanir3 - 05.10.2014

`id` is not set to Auto-Increment. Click on 'change' on the id row and mark the A_I option, then confirm the change.

It should show up like this:


Re: Mysql error! help +rep - Ryz - 05.10.2014

ohh let me try it

Re: Mysql error! help +rep - Ryz - 05.10.2014

not fixed!

Re: Mysql error! help +rep - MacT - 05.10.2014

Are you sure you db code in samp is correct way. Maybe something wrong in sql dump file

Re: Mysql error! help +rep - Vince - 05.10.2014

Read the error closely:
Код:
in 'order clause'
That means you're looking for a query that has ORDER BY in it.

Re: Mysql error! help +rep - Ryz - 05.10.2014

Quote:
Originally Posted by Vince
Посмотреть сообщение
Read the error closely:
Код:
in 'order clause'
That means you're looking for a query that has ORDER BY in it.
I have already ordered him complete.

here is all quarry list

pawn Код:
Query("INSERT INTO `playerinfo` (`user`,`password`,`IP`,`date`) VALUES ('%s',%d,'%s',%d)",

SaveStats(playerid)
{
    if (!gPlayerInfo[playerid][pLogged]) return 1;
    new query[300];
    Query("UPDATE `playerinfo` SET `score`='%d',`money`='%d',`kills`='%d',`deaths`='%d',`level`='%d',`operator`='%d',`donor`='%d',`pilot`='%d',`isnavy`='%d',`hourson`='%d', `tag`='%d' WHERE `id`='%i'",
    gPlayerInfo[playerid][pScore],gPlayerInfo[playerid][pMoney],gPlayerInfo[playerid][pKills],gPlayerInfo[playerid][pDeaths],
    gPlayerInfo[playerid][pAlevel],gPlayerInfo[playerid][pOp],gPlayerInfo[playerid][pDonor],gPlayerInfo[playerid][pPilot],gPlayerInfo[playerid][pNavy], gPlayerInfo[ playerid ][ Hours ], gPlayerInfo[playerid][pTAG],
    gPlayerInfo[playerid][pDBID]);
    mysql_query(query); //queries
    SendClientMessage(playerid,YELLOW,"Stats saved!");
    return 1;
}