SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 23/03/2014, 12:49 AM   #1
PinEvil
Banned
 
Join Date: Mar 2012
Location: United Kingdom ********************* Pr@gr4mm4r
Posts: 182
Reputation: 20
Default MySQL Errors

I've come across some mysql error's,

Code:
[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.
PinEvil is offline   Reply With Quote
Old 23/03/2014, 01:38 AM   #2
Sgt.TheDarkness
Banned
 
Join Date: Jun 2012
Location: Moscow, Russia.
Posts: 252
Reputation: 50
Default Re: MySQL Errors

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!
Sgt.TheDarkness is offline   Reply With Quote
Old 23/03/2014, 10:08 AM   #3
Sithis
Gangsta
 
Join Date: Mar 2013
Location: the Netherlands
Posts: 887
Reputation: 79
Default Re: MySQL Errors

You are missing an updated include or plugin. Make sure to update, recompile and then test.
__________________
Developer and owner of https://trinityrpg.com
Sithis is offline   Reply With Quote
Old 23/03/2014, 02:30 PM   #4
KilotD
Big Clucker
 
Join Date: Mar 2014
Posts: 50
Reputation: 2
Default Re: MySQL Errors

Try updating your plugins.
__________________
If I helped you, kindly +rep me please!
Thanks!
KilotD is offline   Reply With Quote
Old 23/03/2014, 06:31 PM   #5
PinEvil
Banned
 
Join Date: Mar 2012
Location: United Kingdom ********************* Pr@gr4mm4r
Posts: 182
Reputation: 20
Default Re: MySQL Errors

Code:
SA-MP Dedicated Server
----------------------
v0.3z, (C)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]    (c) 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.
PinEvil is offline   Reply With Quote
Old 23/03/2014, 06:40 PM   #6
Konstantinos
Spam Machine
 
Konstantinos's Avatar
 
Join Date: Dec 2011
Posts: 11,827
Reputation: 1401
Default Re: MySQL Errors

Wrong MySQL plugin. Your scripts use the plugin by BlueG and you've loaded the plugin by StrickenKid.

Use R33+ version: https://github.com/pBlueG/SA-MP-MySQL/releases
__________________
Life is like riding a bicycle. To keep your balance, you must keep moving.

[Tutorial] How to use SQLite
[FilterScript] Tune System
Konstantinos is offline   Reply With Quote
Old 23/03/2014, 07:43 PM   #7
PinEvil
Banned
 
Join Date: Mar 2012
Location: United Kingdom ********************* Pr@gr4mm4r
Posts: 182
Reputation: 20
Default Re: MySQL Errors

Iv'e installed BlueG's Plugin & Include now when I try to re-compile the gamemode I get this;

Code:
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.
PinEvil is offline   Reply With Quote
Old 23/03/2014, 08:47 PM   #8
Konstantinos
Spam Machine
 
Konstantinos's Avatar
 
Join Date: Dec 2011
Posts: 11,827
Reputation: 1401
Default Re: MySQL Errors

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.
__________________
Life is like riding a bicycle. To keep your balance, you must keep moving.

[Tutorial] How to use SQLite
[FilterScript] Tune System
Konstantinos is offline   Reply With Quote
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL R34 Errors EmilLykke Scripting Help 7 13/03/2014 09:57 PM
MYSql Errors KaliKs Scripting Help 5 20/02/2014 07:42 AM
errors MYSQL Yves Scripting Help 6 02/02/2014 04:28 PM
MySQL errors in log. Creax Scripting Help 3 14/11/2013 05:47 PM
Need help with some MySQL errors johannetje2 Help Archive 2 16/04/2011 09:46 PM


All times are GMT. The time now is 02:26 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.