MySQL bug at some variables..
#9

Looking at that line:
pawn Код:
format(query, sizeof(query), "UPDATE utilisateurs SET BiggestFish=%d, Job=%d, PayCheck=%d, HeadValue=%d, Jailed=%d, JailTime=%d, Materials=%d WHERE Pseudo='%s'", PlayerInfo[playerid][pBiggestFish], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pMats], PlayerInfo[playerid][pMatsf], pName);
The error is easy to spot. You're missing the variable for HeadValue (after PlayerInfo[playerid][pPayCheck] and before PlayerInfo[playerid][pJailed]). That's why the query is invalid.

A good way to keep track of query errors (and this query _will_ produce one) is through the debug files both MySQL plugins have the option for.

Also, even if just for testing - why something as pointless as that? And 19 queries? Are you kidding me...
Reply


Messages In This Thread
MySQL bug at some variables.. - by Sreadon - 08.10.2011, 11:57
AW: MySQL bug at some variables.. - by Tigerkiller - 08.10.2011, 12:29
Re : MySQL bug at some variables.. - by Sreadon - 08.10.2011, 12:35
AW: MySQL bug at some variables.. - by Tigerkiller - 08.10.2011, 12:38
Re : MySQL bug at some variables.. - by Sreadon - 08.10.2011, 12:42
Re: MySQL bug at some variables.. - by Sergei - 08.10.2011, 15:54
Re: AW: MySQL bug at some variables.. - by AndreT - 08.10.2011, 16:00
Re : MySQL bug at some variables.. - by Sreadon - 08.10.2011, 16:01
Re: MySQL bug at some variables.. - by AndreT - 08.10.2011, 16:03
Re : MySQL bug at some variables.. - by Sreadon - 08.10.2011, 16:12

Forum Jump:


Users browsing this thread: 1 Guest(s)