AlliedModders - View Single Post - [Solved] Run time error 10: native error (native "SQL_ThreadQuery"

Infamanious · **Author**

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)
}