[randomkid88]

I keep getting a MySQL syntax error and I can't seem to find it. Below is the query and the error details:

pawn Код:

format(Query, sizeof(Query), "INSERT INTO `pinfo` (`Name`, `Key`, `Level`, `Admin`, `Reg`, `Sex`, `Age`, `Origin`, `Muted`, `Frozen`, `Cuffed`, `Jailed`, `JailTime`, `Leader`, `Member`, `Rank`, `Cash`, `Bank`, `House`, `Crimes`, `Wanted`,`Phone`, `Mats`, `Skin`,\
        `Model`, `License`, `Warns`, `VirWorld`, `Int`, `Inv`, `Suspend`, `NameChange`, `CK`, `Crashed`, `CrashX`, `CrashY`, `CrashZ`, `IP`, `LastSeen`, `RegisteredDate`)");
    format(Query, sizeof(Query), "%s VALUES ('%s','%s','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%s','%d','%d','%s','%d','%d','%s','%d','%d','%d','%d','%d','%d','%d','%d','%f','%f','%f','%s','%s','%s'",
        Query,
        escName,
        escKey,
        PlayerInfo[playerid][pLevel],
        PlayerInfo[playerid][pAdmin],
        PlayerInfo[playerid][pReg],
        PlayerInfo[playerid][pSex],
        PlayerInfo[playerid][pAge],
        PlayerInfo[playerid][pOrigin],
        PlayerInfo[playerid][pMuted],
        PlayerInfo[playerid][pFrozen],
        PlayerInfo[playerid][pCuffed],
        PlayerInfo[playerid][pJailed],
        PlayerInfo[playerid][pJailTime],
        PlayerInfo[playerid][pLeader],
        PlayerInfo[playerid][pMember],
        PlayerInfo[playerid][pRank],
        PlayerInfo[playerid][pCash],
        PlayerInfo[playerid][pBank],
        PlayerInfo[playerid][pHouse],
        PlayerInfo[playerid][pCrimes],
        PlayerInfo[playerid][pWanted],
        PlayerInfo[playerid][pPhone],
        PlayerInfo[playerid][pMats],
        PlayerInfo[playerid][pSkin],
        PlayerInfo[playerid][pModel],
        PlayerInfo[playerid][pLicense],
        PlayerInfo[playerid][pWarns],
        PlayerInfo[playerid][pVirWorld],
        PlayerInfo[playerid][pInt],
        PlayerInfo[playerid][pInv],
        PlayerInfo[playerid][pSuspend],
        PlayerInfo[playerid][pNameChange],
        PlayerInfo[playerid][pCK],
        PlayerInfo[playerid][pCrashed],
        PlayerInfo[playerid][pCrashX],
        PlayerInfo[playerid][pCrashY],
        PlayerInfo[playerid][pCrashZ],
        PlayerInfo[playerid][pIP],
        PlayerInfo[playerid][pLastSeen],
        PlayerInfo[playerid][pRegisteredDate]);
    mysql_query(Query);

And the error:

Код:

INSERT INTO `pinfo` (`Name`, `Key`, `Level`, `Admin`, `Reg`, `Sex`, `Age`, `Origin`, 
`Muted`, `Frozen`, `Cuffed`, `Jailed`, `JailTime`, `Leader`, `Member`, `Rank`, `Cash`, `Bank`, 
`House`, `Crimes`, `Wanted`,`Phone`, `Mats`, `Skin`,`Model`, `License`, `Warns`, `VirWorld`, `Int`, `Inv`, 
`Suspend`, `NameChange`, `CK`, `Crashed`, `CrashX`, `CrashY`, `CrashZ`, `IP`, `LastSeen`, `RegisteredDate`) VALUES 
('James_Wilson','2B76AFDB08F68079AFA06F093FE08F065765667BE41D407E66689437C2049CE1730CD2376D3C3220) 
- An error has occured. (Error ID: 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 ''2B76AFDB08F68079AFA06F093FE08F065765667BE41D407E66689437C2049CE1730CD2376D3C322' at line 1)

The password is Whirlpooled, and the error above stops after 80 (it should be 128 ). Its real_escaped on entry and before the query is executed.

[Lorrden]

I'm not sure, but You're formating "Query" twice without using the first.

edit: noticed that you included the first query in the other..

Perhaps Your "Query" isn't large enough?

[randomkid88]

Yep, that was the issue. Thanks