[scott1]

Hello all,

i got an problem sometime,

i use an system when players crash and save it into sql db,

Код:

GetPlayerPos(playerid, JoueurInfos[playerid][jCPosX], JoueurInfos[playerid][jCPosY], JoueurInfos[playerid][jCPosZ]);

and sometime i got error like this

Quote:

ErreurID: 1054 , Erreur Unknown column 'NaN' in 'field list' , thread ID: -1 , Extraid: яИЬ , Callback NULL , Query UPDATE `DBCrash` SET CrashPosX=NaN,CrashPosY=NaN,CrashPosZ=NaN,CrashVW= 0,CrashInt=0 WHERE ID = 4631 ErreurID: 1064 , Erreur 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 '/,),(-*,(.((((((,CrashPosY=-11.730871,CrashPosZ=5199.609375,CrashVW=0,CrashInt =0' at line 1 , thread ID: -1 , Extraid: яŒH , Callback NULL , Query UPDATE `DBCrash` SET CrashPosX=-./,),(-*,(.((((((,CrashPosY=-11.730871,CrashPosZ=5199.609375,CrashVW=0,CrashInt =0 WHERE ID = 40129

Thank you

Max

[Skribblez]

Post the part where you update the database.

[doreto]

Quote:

ErreurID: 1054 , Erreur Unknown column 'NaN' in 'field list' , thread ID: -1 , Extraid: яИЬ , Callback NULL , Query UPDATE `DBCrash` SET CrashPosX=NaN,CrashPosY=NaN,CrashPosZ=NaN,CrashVW= 0,CrashInt=0 WHERE ID = 4631

4char

[scott1]

Quote:

Originally Posted by Skribblez Post the part where you update the database.

It is in ma save player,

Quote:

Originally Posted by doreto 4char

what do you mean?



I don't bug every time, at each save

Thank you

Max

[Skribblez]

Could you post "ya" save player then?

[doreto]

Quote:

Originally Posted by scott1 what do you mean?

Quote:

ErreurID: 1054 , Erreur Unknown column 'NaN' in 'field list' , thread ID: -1 , Extraid: яИЬ , Callback NULL , Query UPDATE `DBCrash` SET

Here is your problem and mean you don't have that column you try to update data.
Solution: add column with NaN name.

[scott1]

Look at the request,

Quote:

CrashPosX=NaN,CrashPosY=NaN,CrashPosZ=NaN,

CrashPosX is the X from GetPlayerPos
CrashPosY is the Y from GetPlayerPos
CrashPosZ is the Z from GetPlayerPos

Hard to explain into english, but my float returned by getplayerpos, became Nan,

why?

Max

[-Prodigy-]

Can you show when you format the query? Also, when are you getting the player's pos?

Here's info on "NaN": http://en.wikipedia.org/wiki/NaN

[scott1]

i format the query when i save account, on disconnect,

i get the pos into onplayerdisconnect

Код:

switch(reason)
    {
        case 0:
		{
			format(string, sizeof(string), "* %s quitte le serveur (Crash).", nom);
		    JoueurInfos[playerid][jCInt] = GetPlayerInterior(playerid);
			JoueurInfos[playerid][jCVw]= GetPlayerVirtualWorld(playerid);
		    new Float:x, Float:y, Float:z;
			GetPlayerPos(playerid, x, y, z);
			JoueurInfos[playerid][jCrash] = 1;
			JoueurInfos[playerid][jCPosX] = x;
			JoueurInfos[playerid][jCPosY] = y;
			JoueurInfos[playerid][jCPosZ] = z;

Thank you for the time you spend to help me

Max