[Spunky]

L 02/12/2010 - 12:06:22: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4)

PHP Code:

fnCreateTables()
{
    if (!GetConVarBool(g_pEnableSaving))
    {
        LogMessage("Saving is disabled")

        return
    }

    decl String:szError[64]
    g_hConnection = SQL_Connect("crp", false, szError, 64)

    decl String:szMode[6]
    SQL_ReadDriver(g_hConnection, szMode, 6)

    if (StrEqual(szMode, "mysql", false))
        g_hMode = Mode_MySQL
    else
        g_hMode = Mode_SQLite

    decl String:szQuery[128]

    FormatEx(szQuery, 128, "CREATE TABLE IF NOT EXISTS crp_users (SteamID VARCHAR(40), Wallet INT(12), Bank INT(12), JobName VARCHAR(40), Hunger INT(12), Access INT(12), JobRights INT(12), UNIQUE %s(SteamID))", g_hMode == Mode_MySQL ? "KEY " : "")
    SQL_TQuery(g_hConnection, fnGenericHandler, szQuery, 0, DBPrio_Normal)

    FormatEx(szQuery, 128, "CREATE TABLE IF NOT EXISTS crp_jobs (Name VARCHAR(40), Wage INT(12), Access INT(12), UNIQUE %s(Name))", g_hMode == Mode_MySQL ? "KEY " : "")
    SQL_TQuery(g_hConnection, fnGenericHandler, szQuery, 0, DBPrio_Normal)

    FormatEx(szQuery, 128, "CREATE TABLE IF NOT EXISTS crp_items (SteamID VARCHAR(40), Item INT(12), Amount INT(12), UNIQUE %s(SteamID))", g_hMode == Mode_MySQL ? "KEY " : "")
    SQL_TQuery(g_hConnection, fnGenericHandler, szQuery, 0, DBPrio_Normal)

    CreateTimer(GetConVarFloat(g_pSaveInterval), fnSaveData, INVALID_HANDLE, TIMER_REPEAT)
} 


PHP Code:

public OnClientAuthorized(id, const String:szSteam[])
{
    decl String:szQuery[96]
    FormatEx(szQuery, 96, "SELECT * FROM crp_users WHERE SteamID = \"%s\"", szSteam)

    SQL_TQuery(g_hConnection, fnLoadData, szQuery, id, DBPrio_Normal)
} 


PHP Code:

public fnLoadData(Handle:hOwner, Handle:hQuery, String:szError[], any:_Data)
{
    if (hQuery == INVALID_HANDLE)
        LogMessage("Query failed")

    else if (!IsClientConnected(_Data))
        LogMessage("User disconnected while query was running")

    else if (szError[0])
        LogMessage(szError)

    decl String:szQuery[96]

    if (!SQL_FetchRow(hQuery))
    {
        LogMessage("Failed to load data for \"%N\", creating new account...", _Data)

        decl String:szSteam[40]
        GetClientAuthString(_Data, szSteam, 40)

        FormatEx(szQuery, 96, "INSERT INTO crp_users VALUES (\"%s\", 0, 0, \"Unemployed\", 0, 0, 0)", szSteam)
        SQL_TQuery(g_hConnection, fnGenericHandler, szQuery, 0, DBPrio_High)

        g_iWallet[_Data] = 0
        g_iBank[_Data] = 0
        g_szJobName[_Data] = "Unemployed"
        g_iHunger[_Data] = 0
        g_iAccess[_Data] = 0
        g_iJobRights[_Data] = 0

        SQL_TQuery(g_hConnection, fnLoadWage, "SELECT * FROM crp_jobs WHERE JobName = \"Unemployed\"", _Data, DBPrio_High)
    }
    else
    {
        g_iWallet[_Data] = SQL_FetchInt(hQuery, 1)
        g_iBank[_Data] = SQL_FetchInt(hQuery, 2)
        SQL_FetchString(hQuery, 3, g_szJobName[_Data], 40)
        g_iHunger[_Data] = SQL_FetchInt(hQuery, 4)
        g_iAccess[_Data] = SQL_FetchInt(hQuery, 5)
        g_iJobRights[_Data] = SQL_FetchInt(hQuery, 6)

        FormatEx(szQuery, 96, "SELECT * FROM crp_jobs WHERE JobName = \"%s\"", g_szJobName[_Data])
        SQL_TQuery(g_hConnection, fnLoadWage, szQuery, _Data, DBPrio_High)
    }
} 


[berni]

When hQuery is invalid you shouldn't continue the function, but return;

[Spunky]

It's not invalid though. If it were invalid, it would have logged it like you see in the code. There was no log entry stating the query had failed. So it's not invalid.

Edit: I figured it out. It was a problem with a timer.