1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support

Threaded Mode
MySQL Error
Tingesport
Big Clucker
***
Posts: 103
Threads: 9
Joined: Dec 2012
Reputation: 0
#1

14.11.2013, 08:46
When I try to start up my server it says..

Код:
[10:45:04]  

[10:45:04] ---------------------------

[10:45:04] MySQL Debugging activated (11/14/13)

[10:45:04] ---------------------------

[10:45:04]  

[10:45:04] >> mysql_connect( )

[10:45:04] CMySQLHandler::CMySQLHandler() - constructor called.

[10:45:04] CMySQLHandler::CMySQLHandler() - Connecting to "BLURRED" | DB: "BLURRED" | Username: "BLURRED" ...

[10:45:04] CMySQLHandler::Connect() - Connection was successful.

[10:45:04] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[10:45:04] >> mysql_query( Connection handle: 1 )

[10:45:04] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1)

[10:45:04] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
And yes, I blurred out the hostname, database and username, I'm aware of that.
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#2

14.11.2013, 09:40
Add (if not exists already) OnQueryError to your script and print the parameters (debugging).
Find
Reply
Tingesport
Big Clucker
***
Posts: 103
Threads: 9
Joined: Dec 2012
Reputation: 0
#3

14.11.2013, 09:52
Код:
[11:51:15] [debug] Server crashed while executing BLURRED.amx
[11:51:15] [debug] AMX backtrace:
[11:51:15] [debug] #0 native fclose () [004056c0] from samp-server.exe
[11:51:15] [debug] #1 0002af04 in public LoadRefundCars () from BLURRED.amx
[11:51:15] [debug] #2 0002ecd0 in public zcmd_OnGameModeInit () from BLURRED.amx
[11:51:15] [debug] #3 native CallLocalFunction () [00471ef0] from samp-server.exe
[11:51:15] [debug] #4 000081b8 in public SSCANF_OnGameModeInit () from BLURRED.amx
[11:51:15] [debug] #5 000021d8 in public Itter_OnGameModeInit () from BLURRED.amx
[11:51:15] [debug] #6 native CallLocalFunction () [00471ef0] from samp-server.exe
[11:51:15] [debug] #7 000019c4 in public ScriptInit_OnGameModeInit () from BLURRED.amx
[11:51:15] [debug] #8 00000bb8 in public OnGameModeInit () from BLURRED.amx
[11:51:15] [debug] Native backtrace:
[11:51:15] [debug] #0 0049316b in ?? () from BLURRED
[11:51:15] [debug] #1 004056cd in ?? () from BLURRED
[11:51:15] [debug] #2 6b7560ba in ?? () from BLURRED
[11:51:15] [debug] #3 6b757fee in ?? () from BLURRED
[11:51:15] [debug] #4 6b750091 in ?? () from BLURRED
[11:51:15] [debug] #5 6b75610a in ?? () from BLURRED
[11:51:15] [debug] #6 004721fe in ?? () from BLURRED
[11:51:15] [debug] #7 004010b6 in ?? () from BLURRED
[11:51:15] [debug] #8 6b7560ba in ?? () from BLURRED
[11:51:15] [debug] #9 6b757fee in ?? () from BLURRED
[11:51:15] [debug] #10 6b750091 in ?? () from BLURRED
[11:51:15] [debug] #11 6b75610a in ?? () from BLURRED
[11:51:15] [debug] #12 004721fe in ?? () from BLURRED
[11:51:15] [debug] #13 004010b6 in ?? () from BLURRED
[11:51:15] [debug] #14 6b7560ba in ?? () from BLURRED
[11:51:15] [debug] #15 6b757fee in ?? () from BLURRED
[11:51:15] [debug] #16 6b750091 in ?? () from BLURRED
[11:51:15] [debug] #17 6b75610a in ?? () from BLURRED
[11:51:15] [debug] #18 0046e1f4 in ?? () from BLURRED
[11:51:15] [debug] #19 65646f6d in ?? () from BLURRED
[11:51:15] [debug] #20 414c2f73 in ?? () from BLURRED
[11:51:15] [debug] #21 2e50522d in ?? () from BLURRED
[11:51:15] [debug] #22 00786d61 in ?? ()
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#4

14.11.2013, 09:54
Post LoadRefundCars function, fclose that was used in it crashed the server (probably not checking if the file opened successfully).
Find
Reply
Tingesport
Big Clucker
***
Posts: 103
Threads: 9
Joined: Dec 2012
Reputation: 0
#5

14.11.2013, 09:58
pawn Код:
public LoadRefundCars()
{
    new arrCoords[42][64];
    new strFromFile2[256];
    new File: file = fopen("cars2.cfg", io_read);
    if (file)
    {
        new idx;
        while (idx < sizeof(RefundcInfo))
        {
            fread(file, strFromFile2);
            split(strFromFile2, arrCoords, ',');
            RefundcInfo[idx][rcModel] = strval(arrCoords[0]);
            RefundcInfo[idx][rcLocationx] = floatstr(arrCoords[1]);
            RefundcInfo[idx][rcLocationy] = floatstr(arrCoords[2]);
            RefundcInfo[idx][rcLocationz] = floatstr(arrCoords[3]);
            RefundcInfo[idx][rcAngle] = floatstr(arrCoords[4]);
            RefundcInfo[idx][rcColorOne] = strval(arrCoords[5]);
            RefundcInfo[idx][rcColorTwo] = strval(arrCoords[6]);
            strmid(RefundcInfo[idx][rcOwner], arrCoords[7], 0, strlen(arrCoords[7]), 255);
            strmid(RefundcInfo[idx][rcDescription], arrCoords[8], 0, strlen(arrCoords[8]), 255);
            RefundcInfo[idx][rcValue] = strval(arrCoords[9]);
            RefundcInfo[idx][rcLicense] = strval(arrCoords[10]);
            RefundcInfo[idx][rcOwned] = strval(arrCoords[11]);
            RefundcInfo[idx][rcLock] = strval(arrCoords[12]);
            RefundcInfo[idx][rcMod][0] = strval(arrCoords[13]);
            RefundcInfo[idx][rcMod][1] = strval(arrCoords[14]);
            RefundcInfo[idx][rcMod][2] = strval(arrCoords[15]);
            RefundcInfo[idx][rcMod][3] = strval(arrCoords[16]);
            RefundcInfo[idx][rcMod][4] = strval(arrCoords[17]);
            RefundcInfo[idx][rcMod][5] = strval(arrCoords[18]);
            RefundcInfo[idx][rcMod][6] = strval(arrCoords[19]);
            RefundcInfo[idx][rcMod][7] = strval(arrCoords[20]);
            RefundcInfo[idx][rcMod][8] = strval(arrCoords[21]);
            RefundcInfo[idx][rcMod][9] = strval(arrCoords[22]);
            RefundcInfo[idx][rcDonate] = strval(arrCoords[23]);
            RefundcInfo[idx][rcFuel] = strval(arrCoords[24]);
            RefundcInfo[idx][rcTrunkWep][1] = strval(arrCoords[25]);
            RefundcInfo[idx][rcTrunkAmmo][1] = strval(arrCoords[26]);
            RefundcInfo[idx][rcTrunkWep][2] = strval(arrCoords[27]);
            RefundcInfo[idx][rcTrunkAmmo][2] = strval(arrCoords[28]);
            RefundcInfo[idx][rcTrunkWep][3] = strval(arrCoords[29]);
            RefundcInfo[idx][rcTrunkAmmo][3] = strval(arrCoords[30]);
            RefundcInfo[idx][rcTrunkWep][4] = strval(arrCoords[31]);
            RefundcInfo[idx][rcTrunkAmmo][4] = strval(arrCoords[32]);
            RefundcInfo[idx][rcTrunkArmour] = floatstr(arrCoords[33]);
            RefundcInfo[idx][rcTrunkCounter] = strval(arrCoords[34]);
            RefundcInfo[idx][rcAlarm] = strval(arrCoords[35]);
            RefundcInfo[idx][rcTrunkDrugs] = strval(arrCoords[36]);
            RefundcInfo[idx][rcTrunkMats] = strval(arrCoords[37]);
            RefundcInfo[idx][rcImpounded] = strval(arrCoords[38]);
            RefundcInfo[idx][rcImpoundedPrice] = strval(arrCoords[39]);
            RefundcInfo[idx][rcInsur] = strval(arrCoords[40]);
            RefundcInfo[idx][rcHealth] = floatstr(arrCoords[41]);
            idx++;
        }
    }
    fclose(file);
    return 1;
}
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#6

14.11.2013, 10:10
The fclose function must be inside the "if (file)" statement (so it can know that it opened the file successully so it can close it ) and outside of the while loop. If the file failed to open for any reason and it tries to close an already closed file, the result will be crash.

So change to:
pawn Код:
public LoadRefundCars()
{
    new arrCoords[42][64];
    new strFromFile2[256];
    new File: file = fopen("cars2.cfg", io_read);
    if (file)
    {
        new idx;
        while (idx < sizeof(RefundcInfo))
        {
            fread(file, strFromFile2);
            split(strFromFile2, arrCoords, ',');
            RefundcInfo[idx][rcModel] = strval(arrCoords[0]);
            RefundcInfo[idx][rcLocationx] = floatstr(arrCoords[1]);
            RefundcInfo[idx][rcLocationy] = floatstr(arrCoords[2]);
            RefundcInfo[idx][rcLocationz] = floatstr(arrCoords[3]);
            RefundcInfo[idx][rcAngle] = floatstr(arrCoords[4]);
            RefundcInfo[idx][rcColorOne] = strval(arrCoords[5]);
            RefundcInfo[idx][rcColorTwo] = strval(arrCoords[6]);
            strmid(RefundcInfo[idx][rcOwner], arrCoords[7], 0, strlen(arrCoords[7]), 255);
            strmid(RefundcInfo[idx][rcDescription], arrCoords[8], 0, strlen(arrCoords[8]), 255);
            RefundcInfo[idx][rcValue] = strval(arrCoords[9]);
            RefundcInfo[idx][rcLicense] = strval(arrCoords[10]);
            RefundcInfo[idx][rcOwned] = strval(arrCoords[11]);
            RefundcInfo[idx][rcLock] = strval(arrCoords[12]);
            RefundcInfo[idx][rcMod][0] = strval(arrCoords[13]);
            RefundcInfo[idx][rcMod][1] = strval(arrCoords[14]);
            RefundcInfo[idx][rcMod][2] = strval(arrCoords[15]);
            RefundcInfo[idx][rcMod][3] = strval(arrCoords[16]);
            RefundcInfo[idx][rcMod][4] = strval(arrCoords[17]);
            RefundcInfo[idx][rcMod][5] = strval(arrCoords[18]);
            RefundcInfo[idx][rcMod][6] = strval(arrCoords[19]);
            RefundcInfo[idx][rcMod][7] = strval(arrCoords[20]);
            RefundcInfo[idx][rcMod][8] = strval(arrCoords[21]);
            RefundcInfo[idx][rcMod][9] = strval(arrCoords[22]);
            RefundcInfo[idx][rcDonate] = strval(arrCoords[23]);
            RefundcInfo[idx][rcFuel] = strval(arrCoords[24]);
            RefundcInfo[idx][rcTrunkWep][1] = strval(arrCoords[25]);
            RefundcInfo[idx][rcTrunkAmmo][1] = strval(arrCoords[26]);
            RefundcInfo[idx][rcTrunkWep][2] = strval(arrCoords[27]);
            RefundcInfo[idx][rcTrunkAmmo][2] = strval(arrCoords[28]);
            RefundcInfo[idx][rcTrunkWep][3] = strval(arrCoords[29]);
            RefundcInfo[idx][rcTrunkAmmo][3] = strval(arrCoords[30]);
            RefundcInfo[idx][rcTrunkWep][4] = strval(arrCoords[31]);
            RefundcInfo[idx][rcTrunkAmmo][4] = strval(arrCoords[32]);
            RefundcInfo[idx][rcTrunkArmour] = floatstr(arrCoords[33]);
            RefundcInfo[idx][rcTrunkCounter] = strval(arrCoords[34]);
            RefundcInfo[idx][rcAlarm] = strval(arrCoords[35]);
            RefundcInfo[idx][rcTrunkDrugs] = strval(arrCoords[36]);
            RefundcInfo[idx][rcTrunkMats] = strval(arrCoords[37]);
            RefundcInfo[idx][rcImpounded] = strval(arrCoords[38]);
            RefundcInfo[idx][rcImpoundedPrice] = strval(arrCoords[39]);
            RefundcInfo[idx][rcInsur] = strval(arrCoords[40]);
            RefundcInfo[idx][rcHealth] = floatstr(arrCoords[41]);
            idx++;
        }
        fclose(file);
    }
    return 1;
}
Find
Reply
Tingesport
Big Clucker
***
Posts: 103
Threads: 9
Joined: Dec 2012
Reputation: 0
#7

14.11.2013, 10:17
It worked, thank you! Got another problem, the server starts but it connects to grand larceny and the server.cfg is configured correctly?
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#8

14.11.2013, 10:44
Post the server.cfg (hide the RCON password).
Find
Reply
Tingesport
Big Clucker
***
Posts: 103
Threads: 9
Joined: Dec 2012
Reputation: 0
#9

14.11.2013, 10:57
GOT IT WORKING
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support