Author
|
Message
|
Senior Member
|
12-03-2022
, 04:59
Run time error 10: native error (native "SQL_ThreadQuery"
|
#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.
|
|
|
|