1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
refreshed Mysql but script gives me run time error
Acres
Huge Clucker
****
Posts: 285
Threads: 104
Joined: Dec 2013
Reputation: 0
#1

02.05.2014, 13:03
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
i updated my mysql to latest R7.
Find
Reply
Eth
Gangsta
*****
Posts: 791
Threads: 20
Joined: Sep 2013
Reputation: 0
#2

02.05.2014, 13:14
show me your server include
Find
Reply
Acres
Huge Clucker
****
Posts: 285
Threads: 104
Joined: Dec 2013
Reputation: 0
#3

02.05.2014, 13:30
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.
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#4

02.05.2014, 13:34
R7 uses mysql_function_query instead of mysql_query and it's threaded queries.
Find
Reply
Acres
Huge Clucker
****
Posts: 285
Threads: 104
Joined: Dec 2013
Reputation: 0
#5

02.05.2014, 13:38
do i have to change the Function only or anything more??
Find
Reply
Acres
Huge Clucker
****
Posts: 285
Threads: 104
Joined: Dec 2013
Reputation: 0
#6

02.05.2014, 13:42
Код:
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.
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#7

02.05.2014, 13:43
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);
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help