Help me Mysql
#1

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
Reply
#2

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.
Reply
#3

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.
Reply
#4

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.
Reply
#5

can you give me link new version ?
Reply
#6

or can you tell me to update this script ?
Reply
#7

Quote:
Originally Posted by meranti1995
Посмотреть сообщение
can you give me link new version ?
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

Quote:
Originally Posted by meranti1995
Посмотреть сообщение
or can you tell me to update this script ?
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
Reply
#8

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

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).
Reply
#10

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


Forum Jump:


Users browsing this thread: 1 Guest(s)