Raised This Month: $12 Target: $400
 3% 

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


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Infamanious
Senior Member
Join Date: Dec 2005
Old 12-03-2022 , 04:59   Run time error 10: native error (native "SQL_ThreadQuery"
Reply With Quote #1

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

Last edited by Infamanious; 12-03-2022 at 07:20.
Infamanious is offline
lexzor
Veteran Member
Join Date: Nov 2020
Old 12-03-2022 , 10:06   Re: Run time error 10: native error (native "SQL_ThreadQuery"
Reply With Quote #2

you sent a query before the connection initialized
lexzor is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 21:23.


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