[+REP - SQLite] - Printable Version

[+REP - SQLite] - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: [+REP - SQLite] (/showthread.php?tid=534398)

[+REP - SQLite] - JordanDoughty - 29.08.2014

Ok, I do /editfamily

select one and edit the name for example,

then I get this error in the console from CrashDetect.

pawn Код:

stock LoadFamilies()
{
    new DBResult:query = db_query(Database, "SELECT * FROM Families"), szValue[64];
    for(new i=0; i < db_num_rows(query); i++)
    {
        db_get_field_assoc(query, "FamilyID", szValue, sizeof(szValue));
        FamilyInfo[i][fFamilyID] = strval(szValue);
        db_get_field_assoc(query, "Active", szValue, sizeof(szValue));
        FamilyInfo[i][fActive] = strval(szValue);
        db_get_field_assoc(query, "Name", szValue, sizeof(szValue));
        format(FamilyInfo[i][fName], sizeof(szValue), "%s", szValue);
        db_get_field_assoc(query, "Type", szValue, sizeof(szValue));
        FamilyInfo[i][fType] = strval(szValue);
        db_get_field_assoc(query, "Rank0", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank0], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank1", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank1], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank2", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank2], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank3", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank3], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank4", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank4], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank5", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank5], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank6", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank6], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank7", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank7], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank8", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank8], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank9", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank9], 64, "%s", szValue);
        db_get_field_assoc(query, "Rank10", szValue, sizeof(szValue));
        format(FamilyInfo[i][fRank10], 64, "%s", szValue);
        db_next_row(query);
    }
}

This is my loading function.

Код:

[17:50:12] [debug] Server crashed while executing rp.amx
[17:50:12] [debug] AMX backtrace:
[17:50:12] [debug] #0 native db_get_field_assoc () [0044de40] from samp-server.exe
[17:50:12] [debug] #1 0003cfb4 in ?? () from rp.amx
[17:50:12] [debug] #2 0003a53c in ?? () from rp.amx
[17:50:12] [debug] #3 0001beec in ?? (0x00000000, 0x00000028, 0x00000001, 0xffffffff, 0x0017ae5c) from rp.amx
[17:50:12] [debug] #4 0000f618 in public OnDialogResponse (0x00000000, 0x00000028, 0x00000001, 0xffffffff, 0x0017ae5c) from rp.amx
[17:50:12] [debug] Native backtrace:
[17:50:12] [debug] #0 0044dae1 in ?? () from samp-server.exe
[17:50:12] [debug] #1 004010b6 in ?? () from samp-server.exe
[17:50:12] [debug] #2 593258ca in ?? () from plugins\crashdetect.DLL
[17:50:12] [debug] #3 5932774f in ?? () from plugins\crashdetect.DLL
[17:50:12] [debug] #4 59320834 in ?? () from plugins\crashdetect.DLL
[17:50:12] [debug] #5 5932591a in ?? () from plugins\crashdetect.DLL
[17:50:12] [debug] #6 0046de11 in ?? () from samp-server.exe
[17:50:12] [debug] #7 00452970 in ?? () from samp-server.exe
[17:50:12] [debug] #8 5932591a in ?? () from plugins\crashdetect.DLL
[17:50:12] [debug] #9 0046db90 in ?? () from samp-server.exe
[17:50:12] [debug] #10 00499cd9 in ?? () from samp-server.exe
[17:50:12] [debug] #11 0045b39a in ?? () from samp-server.exe
[17:50:12] [debug] #12 76fe6a64 in ?? () from C:\Windows\SYSTEM32\ntdll.dll

Thats the error.

But it gives the this error but yet still changes the database, as if it changes it then just crashes.

Re: [+REP - SQLite] - Sledgehammer - 29.08.2014

Its probably something with OnDilaogResponse according to that log.

You tried dubbing your script yet? If so, I suggest you try it and it may help to find where this crash exactly happens. Print it in the console with print("1"); etc.

Re: [+REP - SQLite] - JordanDoughty - 29.08.2014

Quote:

Originally Posted by Death1300

Its probably something with OnDilaogResponse according to that log.

You tried dubbing your script yet? If so, I suggest you try it and it may help to find where this crash exactly happens. Print it in the console with print("1"); etc.

I added loading to when the server loads, I got this.

Код:

[18:34:21] 1
[18:34:21] 2
[18:34:21] 1
[18:34:21] 3
[18:34:21] [debug] Server crashed while executing rp.amx
[18:34:21] [debug] AMX backtrace:
[18:34:21] [debug] #0 native db_get_field_assoc () [0044de40] from samp-server.exe
[18:34:21] [debug] #1 0003d514 in ?? () from rp.amx
[18:34:21] [debug] #2 00013a60 in ?? () from rp.amx
[18:34:21] [debug] #3 0000bfb4 in public Itter_OnGameModeInit () from rp.amx
[18:34:21] [debug] #4 native CallLocalFunction () [00472ad0] from samp-server.exe
[18:34:21] [debug] #5 00008bec in public ScriptInit_OnGameModeInit () from rp.amx
[18:34:21] [debug] #6 00006848 in public zcmd_OnGameModeInit () from rp.amx
[18:34:21] [debug] #7 native CallLocalFunction () [00472ad0] from samp-server.exe
[18:34:21] [debug] #8 0000633c in public SSCANF_OnGameModeInit () from rp.amx
[18:34:21] [debug] #9 00000294 in public OnGameModeInit () from rp.amx
[18:34:22] [debug] Native backtrace:
[18:34:22] [debug] #0 0044dae1 in ?? () from samp-server.exe
[18:34:22] [debug] #1 004010b6 in ?? () from samp-server.exe
[18:34:22] [debug] #2 614258ca in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #3 6142774f in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #4 61420834 in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #5 6142591a in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #6 00472dde in ?? () from samp-server.exe
[18:34:22] [debug] #7 004010b6 in ?? () from samp-server.exe
[18:34:22] [debug] #8 614258ca in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #9 6142774f in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #10 61420834 in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #11 6142591a in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #12 00472dde in ?? () from samp-server.exe
[18:34:22] [debug] #13 004010b6 in ?? () from samp-server.exe
[18:34:22] [debug] #14 614258ca in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #15 6142774f in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #16 61420834 in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #17 6142591a in ?? () from plugins\crashdetect.DLL
[18:34:22] [debug] #18 0046e624 in ?? () from samp-server.exe
[18:34:22] [debug] #19 65646f6d in ?? () from samp-server.exe
[18:34:22] [debug] #20 70722f73 in ?? () from samp-server.exe
[18:34:22] [debug] #21 786d612e in ?? () from samp-server.exe

here is dubbed code.

pawn Код:

stock LoadFamilies()
{
    new DBResult:query = db_query(Database, "SELECT * FROM Families"), szValue[248];
    for(new i=0; i < db_num_rows(query); i++)
    {
        db_get_field_assoc(query, "FamilyID", szValue, sizeof(szValue)); print("1");
        FamilyInfo[i][fFamilyID] = strval(szValue); print("2");
        db_get_field_assoc(query, "Active", szValue, sizeof(szValue)); print("1");
        FamilyInfo[i][fActive] = strval(szValue); print("3");
        db_get_field_assoc(query, "Name", szValue, sizeof(szValue)); print("4");
        format(FamilyInfo[i][fName], sizeof(szValue), "%s", szValue); print("5");
        db_get_field_assoc(query, "Type", szValue, sizeof(szValue)); print("6");
        FamilyInfo[i][fType] = strval(szValue); print("7");
        db_get_field_assoc(query, "Rank0", szValue, sizeof(szValue)); print("8");
        format(FamilyInfo[i][fRank0], 64, "%s", szValue); print("9");
        db_get_field_assoc(query, "Rank1", szValue, sizeof(szValue)); print("10");
        format(FamilyInfo[i][fRank1], 64, "%s", szValue); print("11");
        db_get_field_assoc(query, "Rank2", szValue, sizeof(szValue)); print("12");
        format(FamilyInfo[i][fRank2], 64, "%s", szValue); print("13");
        db_get_field_assoc(query, "Rank3", szValue, sizeof(szValue)); print("14");
        format(FamilyInfo[i][fRank3], 64, "%s", szValue); print("15");
        db_get_field_assoc(query, "Rank4", szValue, sizeof(szValue)); print("16");
        format(FamilyInfo[i][fRank4], 64, "%s", szValue); print("17");
        db_get_field_assoc(query, "Rank5", szValue, sizeof(szValue)); print("18");
        format(FamilyInfo[i][fRank5], 64, "%s", szValue); print("19");
        db_get_field_assoc(query, "Rank6", szValue, sizeof(szValue)); print("20");
        format(FamilyInfo[i][fRank6], 64, "%s", szValue); print("21");
        db_get_field_assoc(query, "Rank7", szValue, sizeof(szValue)); print("22");
        format(FamilyInfo[i][fRank7], 64, "%s", szValue); print("23");
        db_get_field_assoc(query, "Rank8", szValue, sizeof(szValue)); print("24");
        format(FamilyInfo[i][fRank8], 64, "%s", szValue); print("25");
        db_get_field_assoc(query, "Rank9", szValue, sizeof(szValue)); print("26");
        format(FamilyInfo[i][fRank9], 64, "%s", szValue); print("27");
        db_get_field_assoc(query, "Rank10", szValue, sizeof(szValue)); print("28");
        format(FamilyInfo[i][fRank10], 64, "%s", szValue); print("29");
        db_next_row(query); print("30");
    }
}

Re: [+REP - SQLite] - JordanDoughty - 29.08.2014

FIXED

Re: [+REP - SQLite] - Sledgehammer - 29.08.2014

What did you do to fix it? (I just got back and viewed the thread) I would have made the string a bit more bigger.

Re: [+REP - SQLite] - JordanDoughty - 30.08.2014

Quote:

Originally Posted by Death1300

What did you do to fix it? (I just got back and viewed the thread) I would have made the string a bit more bigger.

Exactly that,