[FunnyBear]

Hey guys,

It started again... I tested my script and MySQL would not make a new account. I get this error in the debug:

pawn Код:

- 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 '' at line 1)

On this line:

pawn Код:

format(query, sizeof(query), "INSERT INTO playerdata (user, password, Adminlevel, Warnings, score, money, IP, Seconds, Minutes, Hours, register_date, Deaths, Kills) VALUES('%s', SHA1('%s'), 0, 0, 0, 0, '%s', 0, 0, 0, NOW(), 0, 0)", pname, passwordstring, IP);

I don't see anything wrong in the script, I hope you can help me!

Thanks

[dusk]

You should use MySQL default values,instead of inserting 0s

[FunnyBear]

Quote:

Originally Posted by dusk You should use MySQL default values,instead of inserting 0s

It worked fine before, just as I added Kills and Deaths it started?

[dusk]

Just delete them,MySQL will set 0 by deffault anyway.No point of setting it manually

[Smally]

How big is your query string?

[FunnyBear]

But can you find an error? I don't see anything wrong?

EDIT: Query string is 200

[Smally]

Quote:

Originally Posted by FunnyBear But can you find an error? I don't see anything wrong? EDIT: Query string is 200

So your define looks like this?

PHP код:

new query[200]; 


[FunnyBear]

Quote:

Originally Posted by Smally So your define looks like this? PHP код: new query[200];

pawn Код:

stock MySQL_Register(playerid, passwordstring[])
{
    new query[200], pname[24], IP[16];
    GetPlayerName(playerid, pname, 24);
    GetPlayerIp(playerid, IP, 16);
    format(query, sizeof(query), "INSERT INTO playerdata (user, password, Adminlevel, Warnings, score, money, IP, Seconds, Minutes, Hours, register_date, Deaths, Kills) VALUES('%s', SHA1('%s'), 0, 0, 0, 0, '%s', 0, 0, 0, NOW(), 0, 0)", pname, passwordstring, IP);
    mysql_query(query);
    SendClientMessage(playerid, INFO, ">> You have sucesfully registered a new account!");
    Logged[playerid] = 1;
    return 1;
}

[Smally]

Try increasing it slightly.

[Vince]

That query, without the specifiers, is already 194 characters long.