AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   Solved Run time error 10: native error (native "SQL_ThreadQuery" (https://forums.alliedmods.net/showthread.php?t=340682)

Infamanious 12-03-2022 04:59

Run time error 10: native error (native "SQL_ThreadQuery"
 
Code:

12/03/2022 - 03:47:57: [MySQL] Invalid info tuple handle: 0
L 12/03/2022 - 03:47:57: [AMXX] Displaying debug trace (plugin "KZ_Engine.amxx", version "1.01")
L 12/03/2022 - 03:47:57: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 12/03/2022 - 03:47:57: [AMXX]    [0] kz_sql.inc::SQL_Config (line 641)
L 12/03/2022 - 03:47:57: [AMXX]    [1] KZ_Engine.sma::kz_connect (line 965)
L 12/03/2022 - 03:47:57: [AMXX]    [2] KZ_Engine.sma::client_putinserver (line 1051)

updated geoip country mmdb to latest, displayed sql.cfg, and appropirate code lines from error. nothing else is displayed in console w/ debug. Also is it possible this is happening because i havent setup mysql yet? (edit: setup a sql database and its still outputting those errors) also added a database and it works
https://github.com/MichaelKheel/ProKreedz

Code:

[ 1] AMX Mod X    RUN  -    amxmodx_mm_i386.so        v1.9.0.5294  ini  Start ANY 
 [ 2] MySQL        RUN  -    mysql_amxx_i386.so        v1.9.0.5294  pl1  ANY  ANY 
 [ 3] SQLite        RUN  -    sqlite_amxx_i386.so      v1.9.0.5294  pl1  ANY  ANY 
 [ 4] Fun          RUN  -    fun_amxx_i386.so          v1.9.0.5294  pl1  ANY  ANY 
 [ 5] Engine        RUN  -    engine_amxx_i386.so      v1.9.0.5294  pl1  ANY  ANY 
 [ 6] FakeMeta      RUN  -    fakemeta_amxx_i386.so    v1.9.0.5294  pl1  ANY  ANY 
 [ 7] GeoIP        RUN  -    geoip_amxx_i386.so        v1.9.0.5294  pl1  ANY  ANY 
 [ 8] CStrike      RUN  -    cstrike_amxx_i386.so      v1.9.0.5294  pl1  ANY  ANY 
 [ 9] CSX          RUN  -    csx_amxx_i386.so          v1.9.0.5294  pl1  ANY  ANY 
 [10] Ham Sandwich  RUN  -    hamsandwich_amxx_i386.so  v1.9.0.5294  pl1  ANY  ANY


Code:

amx_sql_host    "127.0.0.1"
amx_sql_user    "root"
amx_sql_pass    ""
amx_sql_db      "amx"
amx_sql_table  "admins"
amx_sql_type    "mysql"
amx_sql_timeout "60"

Code:

public SQL_Config(id)
{
        new createinto[128], cData[1]
        cData[0] = id
        formatex(createinto, sizeof createinto - 1, "SELECT * FROM kz_config WHERE authid='%s'", kz_authid[id])
        SQL_ThreadQuery(g_SqlTuple, "SQL_ConfigHandle", createinto, cData, 1)
}

public SQL_ConfigHandle(failstate, Handle:hQuery, error[], errcode, cData[], iSize, Float:fQueueTime)
{
        new id = cData[0]

        if( failstate == TQUERY_CONNECT_FAILED )
        {
                set_fail_state("Could not connect to database.");
        }
        else if( failstate == TQUERY_QUERY_FAILED )
        {
                set_fail_state("Query failed.");
        }
        else if( errcode )
        {
                log_amx("Error on query: %s", error);
        }
        else


Code:

public kz_connect(id)
{
        if (is_user_connected(id) && !is_user_bot(id))
        {
                if(gIsUserConnected[id])
                {
                        SQL_Config(id)
                        SQL_profile(id)
                        SQL_Check_Savepos(id)
                }

                new cszName[32], country[46]
                get_user_name(id, cszName, 31);
            geoip_country ( kz_ip[id], country, 45 )

                if( !(get_user_flags(id) & ACCESS_0)) {
                        ColorChat( 0, RED, "^x01[^x03%s^x01]^x03 %s^x01 %s [Country:^x03%s^x01]^x01.", VIP_ACCESS(id), cszName, (gIsUserConnected[id] ? "Connect" : "Disconnect"), country );
                } else {
                        ColorChat( 0, BLUE, "^x03 %s^x01 %s [Country:^x03%s^x01]^x01.", cszName, (gIsUserConnected[id] ? "Connect" : "Disconnect"), country );
                }
        }
}


Code:

public client_putinserver(id)
{
        if(is_user_bot(id)) return;

        gIsUserConnected[id] = true
        Savepos_activated[id] = false;
        Savepos_exploit[id] = false;
        checknumbers[id] = 0
        gochecknumbers[id] = 0
        antihookcheat[id] = 0.0
        chatorhud[id] = -1
        timer_started[id] = false
        NightVisionUse[id] = false
        firstspawn[id] = true
        IsPaused[id] = false
        WasPaused[id] = false
        show_speed[id] = false;
        Screen_fade[id] = false;
        remove_hook(id)
        //canusenoclip[id] = false
        g_bShowBeams[id] = true;
        g_bReturnFloat[id] = true;
        g_bDetailedResults[id] = false;
        g_bAutoSetting[id] = false;

        // Режим бессмертия
        if(mapIsSlide || g_bHealsOnMap)
                GodModeOn[id] = 1
        else
                GodModeOn[id] = 0

        // Connect сообщение
        kz_connect(id)
        // Обнуление фонаря
        flashlight_reset(id)
        set_task(0.5, "ct_resp", id)

        // SQL функция, Для Menu top15 time на карте
        mytime(id, PRO_TOP)
        mytime(id, NUB_TOP)
}


lexzor 12-03-2022 10:06

Re: Run time error 10: native error (native "SQL_ThreadQuery"
 
you sent a query before the connection initialized


All times are GMT -4. The time now is 10:15.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.