Help me Mysql - 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: Help me Mysql (/showthread.php?tid=615850)

---

Help me Mysql - meranti1995 - 28.08.2016

Help me to fix this

[15:16:00] Error: Function not registered: 'mysql_real_escape_string'
[15:16:00] Error: Function not registered: 'mysql_insert_id'
[15:16:00] Error: Function not registered: 'mysql_free_result'
[15:16:00] Error: Function not registered: 'mysql_store_result'
[15:16:00] Error: Function not registered: 'mysql_num_rows'
[15:16:00] Error: Function not registered: 'mysql_retrieve_row'
[15:16:00] Error: Function not registered: 'mysql_fetch_int'
[15:16:00] Error: Function not registered: 'mysql_fetch_row_format'
[15:16:00] Error: Function not registered: 'mysql_fetch_field_row'
[15:16:00] Error: Function not registered: 'GetCountryName'
[15:16:00] Error: Function not registered: 'mysql_ping'
[15:16:00] [debug] Run time error 19: "File or function is not found"
[15:16:00] [debug] mysql_real_escape_string
[15:16:00] [debug] mysql_insert_id
[15:16:00] [debug] mysql_free_result
[15:16:00] [debug] mysql_store_result
[15:16:00] [debug] mysql_num_rows
[15:16:00] [debug] mysql_retrieve_row
[15:16:00] [debug] mysql_fetch_int
[15:16:00] [debug] mysql_fetch_row_format
[15:16:00] [debug] mysql_fetch_field_row
[15:16:00] [debug] mysql_ping
[15:16:00] [debug] Run time error 19: "File or function is not found"
[15:16:00] [debug] mysql_real_escape_string
[15:16:00] [debug] mysql_insert_id
[15:16:00] [debug] mysql_free_result
[15:16:00] [debug] mysql_store_result
[15:16:00] [debug] mysql_num_rows
[15:16:00] [debug] mysql_retrieve_row
[15:16:00] [debug] mysql_fetch_int
[15:16:00] [debug] mysql_fetch_row_format
[15:16:00] [debug] mysql_fetch_field_row
[15:16:00] [debug] mysql_ping
[15:16:00] Script[gamemodes/GGRP.amx]: Run time error 19: "File or function is not found"
[15:16:00] Number of vehicle models: 0

---

Re: Help me Mysql - Konstantinos - 28.08.2016

Can you also post the server log because we don't know if the mysql plugin:

- was added in plugins line (in server.cfg).
- was loaded but wrong version.
- was loaded but wrong mysql plugin (not BlueG's).
- wasn't loaded due to libmysqlclient_r.so.x could not be found.

---

Re: Help me Mysql - meranti1995 - 28.08.2016

SA-MP Dedicated Server
----------------------
v0.3x, ©2005-2013 SA-MP Team

[15:16:00] filterscripts = "" (string)
[15:16:00]
[15:16:00] Server Plugins
[15:16:00] --------------
[15:16:00] Loading plugin: sscanf
[15:16:00]

[15:16:00] ===============================

[15:16:00] sscanf plugin loaded.

[15:16:00] Version: 2.8.1

[15:16:00] © 2012 Alex "******" Cole

[15:16:00] ===============================

[15:16:00] Loaded.
[15:16:00] Loading plugin: crashdetect
[15:16:00] CrashDetect v4.15.1 is OK.
[15:16:00] Loaded.
[15:16:00] Loading plugin: streamer
[15:16:00]

*** Streamer Plugin v2.8.2 by Incognito loaded ***

[15:16:00] Loaded.
[15:16:00] Loading plugin: mysql
[15:16:00] >> plugin.mysql: R39-2 successfully loaded.
[15:16:00] Loaded.
[15:16:00] Loading plugin: whirlpool
[15:16:00]
[15:16:00] ==================
[15:16:00]
[15:16:00] Whirlpool loaded
[15:16:00]
[15:16:00] ==================
[15:16:00]
[15:16:00] Loaded.
[15:16:00] Loading plugin: nativechecker
[15:16:00] Loaded.
[15:16:00] Loading plugin: wp
[15:16:00]
[15:16:00] ==================
[15:16:00]
[15:16:00] Whirlpool loaded
[15:16:00]
[15:16:00] ==================
[15:16:00]
[15:16:00] Loaded.
[15:16:00] Loading plugin: GeoIP_Plugin
[15:16:00] GeoIP_Plugin got loaded.
[15:16:00] Loaded.
[15:16:00] Loading plugin: irc
[15:16:00]

*** IRC Plugin v1.4.2 by Incognito loaded ***

[15:16:00] Loaded.
[15:16:00] Loaded 9 plugins.

[15:16:00]
[15:16:00] Filterscripts
[15:16:00] ---------------
[15:16:00] Loaded 0 filterscripts.

[15:16:00] Error: Function not registered: 'mysql_real_escape_string'
[15:16:00] Error: Function not registered: 'mysql_insert_id'
[15:16:00] Error: Function not registered: 'mysql_free_result'
[15:16:00] Error: Function not registered: 'mysql_store_result'
[15:16:00] Error: Function not registered: 'mysql_num_rows'
[15:16:00] Error: Function not registered: 'mysql_retrieve_row'
[15:16:00] Error: Function not registered: 'mysql_fetch_int'
[15:16:00] Error: Function not registered: 'mysql_fetch_row_format'
[15:16:00] Error: Function not registered: 'mysql_fetch_field_row'
[15:16:00] Error: Function not registered: 'GetCountryName'
[15:16:00] Error: Function not registered: 'mysql_ping'
[15:16:00] [debug] Run time error 19: "File or function is not found"
[15:16:00] [debug] mysql_real_escape_string
[15:16:00] [debug] mysql_insert_id
[15:16:00] [debug] mysql_free_result
[15:16:00] [debug] mysql_store_result
[15:16:00] [debug] mysql_num_rows
[15:16:00] [debug] mysql_retrieve_row
[15:16:00] [debug] mysql_fetch_int
[15:16:00] [debug] mysql_fetch_row_format
[15:16:00] [debug] mysql_fetch_field_row
[15:16:00] [debug] mysql_ping
[15:16:00] [debug] Run time error 19: "File or function is not found"
[15:16:00] [debug] mysql_real_escape_string
[15:16:00] [debug] mysql_insert_id
[15:16:00] [debug] mysql_free_result
[15:16:00] [debug] mysql_store_result
[15:16:00] [debug] mysql_num_rows
[15:16:00] [debug] mysql_retrieve_row
[15:16:00] [debug] mysql_fetch_int
[15:16:00] [debug] mysql_fetch_row_format
[15:16:00] [debug] mysql_fetch_field_row
[15:16:00] [debug] mysql_ping
[15:16:00] Script[gamemodes/GGRP.amx]: Run time error 19: "File or function is not found"
[15:16:00] Number of vehicle models: 0

This.

---

Re: Help me Mysql - Konstantinos - 28.08.2016

You have loaded BlueG's R39-2 but the script is using BlueG's R6 (a very old version). You can load the correct version for now to fix your problem but consider updating the script to the latest version (with threaded queries) eventually.

---

Re: Help me Mysql - meranti1995 - 28.08.2016

can you give me link new version ?

---

Re: Help me Mysql - meranti1995 - 28.08.2016

or can you tell me to update this script ?

---

Re: Help me Mysql - Konstantinos - 28.08.2016

You mean the old version which can be found at the bottom of the first post: http://forum.sa-mp.com/showpost.php?...95&postcount=1

It will take some time to convert it but it's worth it. I can link you to some useful links:

How to use threaded queries: https://sampforum.blast.hk/showthread.php?tid=337810
All the functions (description, their parameters, how they are used): https://sampwiki.blast.hk/wiki/MySQL/R33
An example script for register/login system: https://raw.githubusercontent.com/pB...stem-cache.pwn

---

Re: Help me Mysql - meranti1995 - 28.08.2016

if i use BlueG's R6, its okey ? and if i use it, is that problem ?

---

Re: Help me Mysql - Konstantinos - 28.08.2016

Well, loading R6 will fix the run time error 19 and start the server but honestly there is no support whatsoever for older versions (especially crashes from mysql functions which I've seen lately).

---

Re: Help me Mysql - meranti1995 - 28.08.2016

men when i join server theres nothing register table, how to fix that ?

---