[Blademaster680]

I have this problem when I am trying to login on my server.
Could someone please help?

Thanks

Error:

Код:

[23:47:21] Number of vehicle models: 0
[23:47:40] Incoming connection: 127.0.0.1:59823
[23:47:40] [join] Dylan_Forster has joined the server (0:127.0.0.1)
[23:47:43] Debug 1:SELECT * FROM playerdata WHERE Name = 'Dylan Forster'
[23:47:43] [debug] Server crashed while executing LLA.amx
[23:47:43] [debug] AMX backtrace:
[23:47:43] [debug] #0 native mysql_fetch_field_row () [002b6700] from mysql.DLL
[23:47:43] [debug] #1 000077b4 in ?? (0x00000000) from LLA.amx
[23:47:43] [debug] #2 00007298 in public OnDialogResponse (0x00000000, 0x00000001, 0x00000001, 0xffffffff, 0x00083058) from LLA.amx
[23:47:43] [debug] Native backtrace:
[23:47:43] [debug] #0 7116b9f0 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4940_none_50916076bcb9a742\MSVCR90.dll
[23:47:43] [debug] #1 002b952e in ?? () from plugins\mysql.DLL
[23:47:43] [debug] #2 002b67d3 in ?? () from plugins\mysql.DLL
[23:47:43] [debug] #3 004010b6 in ?? () from samp-server.exe
[23:47:43] [debug] #4 692358ca in ?? () from plugins\crashdetect.DLL
[23:47:43] [debug] #5 6923774f in ?? () from plugins\crashdetect.DLL
[23:47:43] [debug] #6 69230834 in ?? () from plugins\crashdetect.DLL
[23:47:43] [debug] #7 6923591a in ?? () from plugins\crashdetect.DLL
[23:47:43] [debug] #8 0046de11 in ?? () from samp-server.exe
[23:47:43] [debug] #9 00452970 in ?? () from samp-server.exe
[23:47:43] [debug] #10 7795e023 in ?? () from C:\Windows\SysWOW64\ntdll.dll
[23:47:43] [debug] #11 756314ad in ?? () from C:\Windows\syswow64\kernel32.dll
[23:47:43] [debug] #12 004a50fe in ?? () from samp-server.exe
[23:47:43] [debug] #13 68106ac3 in ?? () from samp-server.exe
[23:47:43] [debug] #14 004b3328 in ?? () from samp-server.exe

Login code:

Код:

stock LoginPlayer(playerid)
{
    new query[126];
    format(query, sizeof(query), "SELECT * FROM playerdata WHERE Name = '%s'", GetName(playerid));
    mysql_query(query);
   	printf("Debug 1:%s", query); // Like this
    mysql_store_result();

    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(query, "ID"); PlayerInfo[playerid][ID] = strval(query);
        mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name");
        mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password");
        mysql_fetch_field_row(query, "AdminLevel"); PlayerInfo[playerid][AdminLevel] = strval(query);
        mysql_fetch_field_row(query, "PlayerPos");
        sscanf(query, "fff", PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2]);
        mysql_fetch_field_row(query, "Cash"); PlayerInfo[playerid][Cash] = strval(query);
    }
    mysql_free_result();
    GivePlayerMoney(playerid, PlayerInfo[playerid][Cash]);
    SetSpawnInfo(playerid, 0, 299, PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2], 0, 0, 0, 0, 0, 0, 0);
    SpawnPlayer(playerid);
    SetPlayerPos(playerid, PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2]);
}

[Blademaster680]

Anyone?

[rickisme]

Change :

Quote:

format(query, sizeof(query), "SELECT * FROM playerdata WHERE Name = '%s'", GetName(playerid));

to :

Quote:

format(query, sizeof(query), "SELECT `ID`,`Name`,`Password`,`AdminLevel`,`PlayerPos`,`C ash` FROM playerdata WHERE Name = '%s'", GetName(playerid));

[Blademaster680]

Nope still the same...
And the format(query, sizeof(query), "SELECT * FROM playerdata WHERE Name = '%s'", GetName(playerid));
The '*' means everything...

[rickisme]

hmm, compile your script with -d2 mode then you will get error line

[Blademaster680]

-d2 mode?

[iZN]

Quote:

Originally Posted by rickisme hmm, compile your script with -d2 mode then you will get error line

It's not -d2, it's -d3.


@OP: https://github.com/Zeex/samp-plugin-...ith-debug-info

The crash I can see is related to mysql_fetch_field_row, I guess there is an issue while getting the field row?