Posts: 183
Threads: 16
Joined: Mar 2012
I've come across some mysql error's,
Код:
[00:12:31] Error: Function not registered: 'cache_get_row_count'
[00:12:31] Error: Function not registered: 'cache_get_field_content'
[00:12:31] Error: Function not registered: 'cache_get_field_count'
[00:12:31] Error: Function not registered: 'cache_get_row'
[00:12:31] Error: Function not registered: 'mysql_escape_string'
I know it has something to do with the includes but I have them all and it says I don't.
Posts: 252
Threads: 16
Joined: Jun 2012
Post the server logs for when you start up the server. The MySQL plugin might not be loading upon server-startup, which will indeed cause these errors!
Posts: 889
Threads: 4
Joined: Mar 2013
Reputation:
0
You are missing an updated include or plugin. Make sure to update, recompile and then test.
Posts: 50
Threads: 11
Joined: Mar 2014
Reputation:
0
Try updating your plugins.
Posts: 183
Threads: 16
Joined: Mar 2012
Код:
SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team
[00:54:09]
[00:54:09] Server Plugins
[00:54:09] --------------
[00:54:09] Loading plugin: streamer.dll
[00:54:09]
*** Streamer Plugin v2.7 by Incognito loaded ***
[00:54:09] Loaded.
[00:54:09] Loading plugin: irc.dll
[00:54:09] Failed.
[00:54:09] Loading plugin: sscanf.dll
[00:54:09]
[00:54:09] ===============================
[00:54:09] sscanf plugin loaded.
[00:54:09] Version: 2.8.1
[00:54:09] © 2012 Alex "******" Cole
[00:54:09] ===============================
[00:54:09] Loaded.
[00:54:09] Loading plugin: mysql.dll
[00:54:09] SA:MP MySQL Plugin v2.1.1 Loaded.
[00:54:09] Loaded.
[00:54:09] Loading plugin: nativechecker.dll
[00:54:09] [MySQL] Thread running. Threadsafe: Yes.
[00:54:09] Loaded.
[00:54:09] Loaded 4 plugins.
[00:54:09]
[00:54:09] Filterscripts
[00:54:09] ---------------
[00:54:09] Loading filterscript 'adminfsmysql.amx'...
[00:54:09] Error: Function not registered: 'cache_get_row_count'
[00:54:09] Error: Function not registered: 'cache_get_field_content'
[00:54:09] Error: Function not registered: 'cache_get_field_count'
[00:54:09] Error: Function not registered: 'cache_get_row'
[00:54:09] Error: Function not registered: 'mysql_escape_string'
[00:54:09] Loading filterscript 'maps.amx'...
[00:54:09] Loading maps
[00:54:09] United Force Base Loaded
[00:54:09] UGHT Loaded
[00:54:09] Slayers drop map loaded
[00:54:09] Slayers ship jump loaded
[00:54:09] Quad Parkour Loaded
[00:54:09] Stunt road loaded
[00:54:09] Pipe loaded
[00:54:09] farm biking loaded
[00:54:09] loaded LS Beach stunts
[00:54:09] Loaded 2 filterscripts.
[00:54:09] Error: Function not registered: 'cache_get_row_count'
[00:54:09] Error: Function not registered: 'cache_get_field_content'
[00:54:09] Error: Function not registered: 'cache_get_field_count'
[00:54:09] Error: Function not registered: 'cache_get_row'
[00:54:09] Script[gamemodes/ultimate-gamers03z.amx]: Run time error 19: "File or function is not found"
[00:54:09] Number of vehicle models: 6
I have updated all of the plugins and they all match the includes. Still errored.
Posts: 183
Threads: 16
Joined: Mar 2012
Iv'e installed BlueG's Plugin & Include now when I try to re-compile the gamemode I get this;
Код:
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8124) : error 017: undefined symbol "mysql_store_result"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8125) : error 017: undefined symbol "mysql_fetch_row_format"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8131) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8132) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8133) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8134) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8139) : error 017: undefined symbol "mysql_free_result"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8153) : error 017: undefined symbol "mysql_store_result"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8154) : error 017: undefined symbol "mysql_fetch_row_format"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8160) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8161) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8162) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8163) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8169) : error 017: undefined symbol "mysql_free_result"
C:\Users\Tom\Desktop\UF Server\gamemodes\ultimate-gamers03z.pwn(8204) : warning 203: symbol is never used: "params"
Pawn compiler 3.2.3664 Copyright (coffee) 1997-2006, ITB CompuPhase
14 Errors.
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation:
0
And the plugin + include versions are?
In the logs appeared that cache_get_row_count is not a registered function which is added in R33.
In the script you're trying to compile above, it gives about undefined symbol "mysql_store_result" which doesn't exist in R33 and higher versions.
Also keep in mind that you cannot use a filterscript (adminfsmysql that uses MySQL) and a gamemode with different versions. Actually you can do it by loading both the old and the new mysql plugin (different names) but it would be really bad. So use the same version for all the scripts that use MySQL and make sure that the scripts are updated for that version too otherwise it will give the 'Function not registered' messages.
