refreshed Mysql but script gives me run time error - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: refreshed Mysql but script gives me run time error (/showthread.php?tid=510766)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: refreshed Mysql but script gives me run time error (/showthread.php?tid=510766)
refreshed Mysql but script gives me run time error - Acres - 02.05.2014
hey guys i need help with this..
Код:
SA-MP Dedicated Server ---------------------- v0.3z, ©2005-2014 SA-MP Team [16:15:51] filterscripts = "" (string) [16:15:51] [16:15:51] Server Plugins [16:15:51] -------------- [16:15:51] Loading plugin: sscanf.dll [16:15:51] [16:15:51] =============================== [16:15:51] sscanf plugin loaded. [16:15:51] Version: 2.8.1 [16:15:51] © 2012 Alex "******" Cole [16:15:51] =============================== [16:15:51] Loaded. [16:15:51] Loading plugin: streamer.dll [16:15:51] *** Streamer Plugin v2.7 by Incognito loaded *** [16:15:51] Loaded. [16:15:51] Loading plugin: Whirlpool.dll [16:15:51] [16:15:51] ================== [16:15:51] [16:15:51] Whirlpool loaded [16:15:51] [16:15:51] ================== [16:15:51] [16:15:51] Loaded. [16:15:51] Loading plugin: crashdetect.dll [16:15:51] CrashDetect v4.13 is OK. [16:15:51] Loaded. [16:15:51] Loading plugin: socket.dll [16:15:51] Socket plugin v0.1b loaded. [16:15:51] Loaded. [16:15:51] Loading plugin: mysql.dll [16:15:51] > MySQL plugin R7 successfully loaded. [16:15:51] Loaded. [16:15:51] Loading plugin: nativechecker.dll [16:15:51] Failed. [16:15:51] Loaded 6 plugins. [16:15:51] [16:15:51] Filterscripts [16:15:51] --------------- [16:15:51] Loaded 0 filterscripts. [16:15:52] [debug] Run time error 19: "File or function is not found" [16:15:52] [debug] mysql_query [16:15:52] [debug] Run time error 19: "File or function is not found" [16:15:52] [debug] mysql_query [16:15:52] Script[gamemodes/test.amx]: Run time error 19: "File or function is not found" [16:15:52] Number of vehicle models: 0
Re: refreshed Mysql but script gives me run time error - Eth - 02.05.2014
show me your server include
Re: refreshed Mysql but script gives me run time error - Acres - 02.05.2014
erm i tried to compile and that i got
Код:
C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(9833) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(9838) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(19340) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(19348) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(19356) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(19364) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(26861) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(26897) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(26918) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(26945) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(87138) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(87177) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91271) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91398) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91421) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91549) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91579) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91604) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91641) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91663) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91701) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91745) : error 017: undefined symbol "mysql_query" C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(121749) : warning 235: public function lacks forward declaration (symbol "OnQueryFinish") Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 22 Errors.
Re: refreshed Mysql but script gives me run time error - Konstantinos - 02.05.2014
R7 uses mysql_function_query instead of mysql_query and it's threaded queries.
Re: refreshed Mysql but script gives me run time error - Acres - 02.05.2014
do i have to change the Function only or anything more??
Re: refreshed Mysql but script gives me run time error - Acres - 02.05.2014
Код:
C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(9833) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(9838) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(19340) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(19348) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(19356) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(19364) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(26861) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(26897) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(26918) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(26945) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(87138) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(87177) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91271) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91398) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91421) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91549) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91579) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91604) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91641) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91663) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91701) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(91745) : error 035: argument type mismatch (argument 1) C:\Users\Erik\Desktop\SAMP\PLA Script\gamemodes\vpsPLA_nomysql.pwn(121749) : warning 235: public function lacks forward declaration (symbol "OnQueryFinish") Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 22 Errors.
Re: refreshed Mysql but script gives me run time error - Konstantinos - 02.05.2014
Almost everything because R7 doesn't support non-threaded queries.
Tutorial about threaded queries: https://sampforum.blast.hk/showthread.php?tid=337810
You can use non-threaded queries though in R33+ versions but it's not recommended.
About the above warnings which are from R33+, the first argument is the connection handle* and the second argument is the query.
Connection handle is stored to a variable in mysql_connect.
pawn Код:
// global:
new MySQL = -1;
// OnGameModeInit:
MySQL = mysql_connect(...);
// somewhere you want to execute a query:
mysql_query(MySQL, query);