[Plugin] [REL] MySQL Plugin (Now on github!)

am getting this error what do i change it to
error 017: undefined symbol "mysql_format"

am using R6.
Reply

Quote:
Originally Posted by Yves
Посмотреть сообщение
am getting this error what do i change it to
error 017: undefined symbol "mysql_format"

am using R6.
See the first page. It says mysql_format is only for R7 and R6-2.
Reply

Can I use R6 in ubuntu !
i want run mysql in ubuntu on samp 0.3z
help me plz
Reply

NICE!!!
Reply

Quote:
Originally Posted by khalildz
Посмотреть сообщение
Can I use R6 in ubuntu !
i want run mysql in ubuntu on samp 0.3z
help me plz
You really should use the latest R38 version.
If you have problems running the plugin, try the static version.
My dedicated server runs on Ubuntu, and I use the latest version, so there shouldn't be any problems for you.
Reply

I wonder if anyone has any answers for me.

So I believe I am using R37 of the plugin and I am experiencing some issues that occur randomly.

I converted the script from R5 to the current version and all seemed well but recently after a period of the server being up for some reason all queries or threaded fuctions just seem to stop working.

Nothing is outputted to the log as an error, just stop working and yet the server stays live.

Your help will be muchly appreciated.
Reply

Quote:
Originally Posted by Boooth
Посмотреть сообщение
I wonder if anyone has any answers for me.

So I believe I am using R37 of the plugin and I am experiencing some issues that occur randomly.

I converted the script from R5 to the current version and all seemed well but recently after a period of the server being up for some reason all queries or threaded fuctions just seem to stop working.

Nothing is outputted to the log as an error, just stop working and yet the server stays live.

Your help will be muchly appreciated.
Do you have mysql logging enabled? You can find issues with it and you can use OnQueryError callback for checking any errors related to MySQL. Also, the latest release is R38.
Reply

I have MYSQl R8 and it working perfect
Reply

Quote:
Originally Posted by iZN
Посмотреть сообщение
Do you have mysql logging enabled? You can find issues with it and you can use OnQueryError callback for checking any errors related to MySQL. Also, the latest release is R38.
I do indeed have logging on LOG_ALL but it's hard to maintain as the log easily get over 5GB very quickly.

I also have already put in a file write in OnQueryError and yet nothing is printed, it is a strange issue. Any other ideas?
Reply

Set logging to LOG_ERROR | LOG_WARNING
Also does something happen to the mysql server? Does it go off or something ?
Reply

i have problem mysql_query

i want fix
Reply

my problem in compiled
Reply

Hello Guys, i really need your Help
i have a MySQL probleme...
when i
Uploaded R33 and Failed to Load too and gives
Quote:

[16:56:15]----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[16:56:15]
[16:56:15] Server Plugins
[16:56:15] --------------
[16:56:15] Loading plugin: mysql
[16:56:15] Failed.
[16:56:15] Loading plugin: Whirlpool
[16:56:15]
[16:56:15] ==================
[16:56:15]
[16:56:15] Whirlpool loaded
[16:56:15]
[16:56:15] ==================
[16:56:15]
[16:56:15] Loaded.
[16:56:15] Loading plugin: streamer
[16:56:15]

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

[16:56:15] Loaded.
[16:56:15] Loading plugin: sscanf
[16:56:15]

[16:56:15] ===============================

[16:56:15] sscanf plugin loaded.

[16:56:15] Version: 2.8.1

[16:56:15] © 2012 Alex "Y_Less" Cole

[16:56:15] ===============================

[16:56:15] Loaded.
[16:56:15] Loading plugin: nativechecker
[16:56:15] Loaded.
[16:56:15] Loading plugin: FileManager
[16:56:15] Failed.
[16:56:15] Loaded 4 plugins.

[16:56:16]
[16:56:16] Filterscripts
[16:56:16] ---------------
[16:56:16] Loading filterscript 'yom_buttons.amx'...
[16:56:16] Loading filterscript 'vactions.amx'...
[16:56:16] Loading filterscript 'Server.amx'...
[16:56:16] Loading filterscript 'PlayerInteriors.amx'...
[16:56:16] Loading filterscript 'PlayerExteriors.amx'...
[16:56:16] Loading filterscript 'RealDamage.amx'...
[16:56:16]
--------------------------------------
[16:56:16] New 0.3z Weapon DMG System by FeRRum (aka RenSoprano)
[16:56:16] --------------------------------------

[16:56:16] Loaded 6 filterscripts.

[16:56:16] Error: Function not registered: 'mysql_tquery'
[16:56:16] Error: Function not registered: 'mysql_escape_string'
[16:56:16] Error: Function not registered: 'cache_get_data'
[16:56:16] Error: Function not registered: 'cache_get_field_content'
[16:56:16] Error: Function not registered: 'mysql_stat'
[16:56:16] Error: Function not registered: 'mysql_log'
[16:56:16] Error: Function not registered: 'mysql_connect'
[16:56:16] Error: Function not registered: 'mysql_errno'
[16:56:16] Error: Function not registered: 'mysql_close'
[16:56:16] Error: Function not registered: 'cache_get_row'
[16:56:16] Error: Function not registered: 'cache_insert_id'
[16:56:16] Error: Function not registered: 'cache_affected_rows'
[16:56:16] Script[gamemodes/NXRP.amx]: Run time error 19: "File or function is not found"
[16:56:16] Number of vehicle models: 0

Uploaded R34 and Failed to Load too and Gives too :
Quote:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[16:56:15]
[16:56:15] Server Plugins
[16:56:15] --------------
[16:56:15] Loading plugin: mysql
[16:56:15] Failed.
[16:56:15] Loading plugin: Whirlpool
[16:56:15]
[16:56:15] ==================
[16:56:15]
[16:56:15] Whirlpool loaded
[16:56:15]
[16:56:15] ==================
[16:56:15]
[16:56:15] Loaded.
[16:56:15] Loading plugin: streamer
[16:56:15]

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

[16:56:15] Loaded.
[16:56:15] Loading plugin: sscanf
[16:56:15]

[16:56:15] ===============================

[16:56:15] sscanf plugin loaded.

[16:56:15] Version: 2.8.1

[16:56:15] © 2012 Alex "Y_Less" Cole

[16:56:15] ===============================

[16:56:15] Loaded.
[16:56:15] Loading plugin: nativechecker
[16:56:15] Loaded.
[16:56:15] Loading plugin: FileManager
[16:56:15] Failed.
[16:56:15] Loaded 4 plugins.

[16:56:16]
[16:56:16] Filterscripts
[16:56:16] ---------------
[16:56:16] Loading filterscript 'yom_buttons.amx'...
[16:56:16] Loading filterscript 'vactions.amx'...
[16:56:16] Loading filterscript 'Server.amx'...
[16:56:16] Loading filterscript 'PlayerInteriors.amx'...
[16:56:16] Loading filterscript 'PlayerExteriors.amx'...
[16:56:16] Loading filterscript 'RealDamage.amx'...
[16:56:16]
--------------------------------------
[16:56:16] New 0.3z Weapon DMG System by FeRRum (aka RenSoprano)
[16:56:16] --------------------------------------

[16:56:16] Loaded 6 filterscripts.

[16:56:16] Error: Function not registered: 'mysql_tquery'
[16:56:16] Error: Function not registered: 'mysql_escape_string'
[16:56:16] Error: Function not registered: 'cache_get_data'
[16:56:16] Error: Function not registered: 'cache_get_field_content'
[16:56:16] Error: Function not registered: 'mysql_stat'
[16:56:16] Error: Function not registered: 'mysql_log'
[16:56:16] Error: Function not registered: 'mysql_connect'
[16:56:16] Error: Function not registered: 'mysql_errno'
[16:56:16] Error: Function not registered: 'mysql_close'
[16:56:16] Error: Function not registered: 'cache_get_row'
[16:56:16] Error: Function not registered: 'cache_insert_id'
[16:56:16] Error: Function not registered: 'cache_affected_rows'
[16:56:16] Script[gamemodes/NXRP.amx]: Run time error 19: "File or function is not found"
[16:56:16] Number of vehicle models: 0

MySQL R5 and gives:
Quote:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[16:47:35]
[16:47:35] Server Plugins
[16:47:35] --------------
[16:47:35] Loading plugin: mysql
[16:47:35]

> MySQL plugin R5 successfully loaded.

[16:47:35] Loaded.
[16:47:35] Loading plugin: Whirlpool
[16:47:35]
[16:47:35] ==================
[16:47:35]
[16:47:35] Whirlpool loaded
[16:47:35]
[16:47:35] ==================
[16:47:35]
[16:47:35] Loaded.
[16:47:35] Loading plugin: streamer
[16:47:35]

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

[16:47:35] Loaded.
[16:47:35] Loading plugin: sscanf
[16:47:35]

[16:47:35] ===============================

[16:47:35] sscanf plugin loaded.

[16:47:35] Version: 2.8.1

[16:47:35] © 2012 Alex "Y_Less" Cole

[16:47:35] ===============================

[16:47:35] Loaded.
[16:47:35] Loading plugin: nativechecker
[16:47:35] Loaded.
[16:47:35] Loading plugin: FileManager
[16:47:35] Failed.
[16:47:35] Loaded 5 plugins.

[16:47:35]
[16:47:35] Filterscripts
[16:47:35] ---------------
[16:47:35] Loading filterscript 'yom_buttons.amx'...
[16:47:35] Loading filterscript 'vactions.amx'...
[16:47:35] Loading filterscript 'Server.amx'...
[16:47:35] Loading filterscript 'PlayerInteriors.amx'...
[16:47:35] Loading filterscript 'PlayerExteriors.amx'...
[16:47:35] Loading filterscript 'RealDamage.amx'...
[16:47:35]
--------------------------------------
[16:47:35] New 0.3z Weapon DMG System by FeRRum (aka RenSoprano)
[16:47:35] --------------------------------------

[16:47:35] Loaded 6 filterscripts.

[16:47:35] Error: Function not registered: 'mysql_tquery'
[16:47:35] Error: Function not registered: 'mysql_escape_string'
[16:47:35] Error: Function not registered: 'cache_get_data'
[16:47:35] Error: Function not registered: 'cache_get_field_content'
[16:47:35] Error: Function not registered: 'mysql_log'
[16:47:35] Error: Function not registered: 'cache_get_row'
[16:47:35] Error: Function not registered: 'cache_insert_id'
[16:47:35] Error: Function not registered: 'cache_affected_rows'
[16:47:35] Script[gamemodes/NXRP.amx]: Run time error 19: "File or function is not found"
[16:47:35] Number of vehicle models: 0

Uploaded R6 and gives
Quote:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[16:47:35]
[16:47:35] Server Plugins
[16:47:35] --------------
[16:47:35] Loading plugin: mysql
[16:47:35]

> MySQL plugin R5 successfully loaded.

[16:47:35] Loaded.
[16:47:35] Loading plugin: Whirlpool
[16:47:35]
[16:47:35] ==================
[16:47:35]
[16:47:35] Whirlpool loaded
[16:47:35]
[16:47:35] ==================
[16:47:35]
[16:47:35] Loaded.
[16:47:35] Loading plugin: streamer
[16:47:35]

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

[16:47:35] Loaded.
[16:47:35] Loading plugin: sscanf
[16:47:35]

[16:47:35] ===============================

[16:47:35] sscanf plugin loaded.

[16:47:35] Version: 2.8.1

[16:47:35] © 2012 Alex "Y_Less" Cole

[16:47:35] ===============================

[16:47:35] Loaded.
[16:47:35] Loading plugin: nativechecker
[16:47:35] Loaded.
[16:47:35] Loading plugin: FileManager
[16:47:35] Failed.
[16:47:35] Loaded 5 plugins.

[16:47:35]
[16:47:35] Filterscripts
[16:47:35] ---------------
[16:47:35] Loading filterscript 'yom_buttons.amx'...
[16:47:35] Loading filterscript 'vactions.amx'...
[16:47:35] Loading filterscript 'Server.amx'...
[16:47:35] Loading filterscript 'PlayerInteriors.amx'...
[16:47:35] Loading filterscript 'PlayerExteriors.amx'...
[16:47:35] Loading filterscript 'RealDamage.amx'...
[16:47:35]
--------------------------------------
[16:47:35] New 0.3z Weapon DMG System by FeRRum (aka RenSoprano)
[16:47:35] --------------------------------------

[16:47:35] Loaded 6 filterscripts.

[16:47:35] Error: Function not registered: 'mysql_tquery'
[16:47:35] Error: Function not registered: 'mysql_escape_string'
[16:47:35] Error: Function not registered: 'cache_get_data'
[16:47:35] Error: Function not registered: 'cache_get_field_content'
[16:47:35] Error: Function not registered: 'mysql_log'
[16:47:35] Error: Function not registered: 'cache_get_row'
[16:47:35] Error: Function not registered: 'cache_insert_id'
[16:47:35] Error: Function not registered: 'cache_affected_rows'
[16:47:35] Script[gamemodes/NXRP.amx]: Run time error 19: "File or function is not found"
[16:47:35] Number of vehicle models: 0

Reply

Did you updated plugin and include folder?
Reply

Read the FAQ and check back here if your problem is still not solved.
Reply

yes i did, i downloaded the R38 and Put all of it in my Gamemode Folder...
:-/
Reply

Just Downloadd the 2012 (x86)
but after start my server it show this and then the black box disappear
and got this :
Quote:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[22:21:03]
[22:21:03] Server Plugins
[22:21:03] --------------
[22:21:03] Loading plugin: mysql
[22:21:03] >> plugin.mysql: R38 successfully loaded.
[22:21:03] Loaded.
[22:21:03] Loading plugin: Whirlpool
[22:21:03]
[22:21:03] ==================
[22:21:03]
[22:21:03] Whirlpool loaded
[22:21:03]
[22:21:03] ==================
[22:21:03]
[22:21:03] Loaded.
[22:21:03] Loading plugin: streamer
[22:21:03]

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

[22:21:03] Loaded.
[22:21:03] Loading plugin: sscanf
[22:21:03]

[22:21:03] ===============================

[22:21:03] sscanf plugin loaded.

[22:21:03] Version: 2.8.1

[22:21:03] © 2012 Alex "******" Cole

[22:21:03] ===============================

[22:21:03] Loaded.
[22:21:03] Loading plugin: nativechecker
[22:21:03] Loaded.
[22:21:03] Loading plugin: FileManager
[22:21:03] ******************
[22:21:03] ** FILE MANAGER **
[22:21:03] ** Loaded **
[22:21:03] ** Version 1.5 **
[22:21:03] ******************
[22:21:03] Loaded.
[22:21:03] Loaded 6 plugins.

[22:21:03]
[22:21:03] Filterscripts
[22:21:03] ---------------
[22:21:03] Loading filterscript 'yom_buttons.amx'...
[22:21:03] Loading filterscript 'vactions.amx'...
[22:21:03] Loading filterscript 'Server.amx'...
[22:21:03] Loading filterscript 'PlayerInteriors.amx'...
[22:21:03] Loading filterscript 'PlayerExteriors.amx'...
[22:21:03] Loading filterscript 'RealDamage.amx'...
[22:21:03]
--------------------------------------
[22:21:03] New 0.3z Weapon DMG System by FeRRum (aka RenSoprano)
[22:21:03] --------------------------------------

[22:21:03] Loaded 6 filterscripts.

[22:21:04]
[22:21:04]
[22:21:04]
[22:21:04] =======================================
[22:21:04] | |
[22:21:04] | YSI version 3.09.0684 |
[22:21:04] | By Alex "******" Cole |
[22:21:04] | |
[22:21:04] =======================================
[22:21:04]
[22:21:04]
[22:21:04]
[22:21:04] Preparing the gamemode, please wait...

Reply

any help please ?
Reply

Okay, you got R38 working!

About your problem, it seems the server just crashed on start. Load crashdetect plugin: https://sampforum.blast.hk/showthread.php?tid=262796
Reply

this what give :

Quote:

EAX: 0x0018F0C4 EBX: 0x55A3DD99 ECX: 0x00000003 EDX: 0x00000000

ESI: 0x4FF82080 EDI: 0x78C224F0 EBP: 0x0018F114 ESP: 0x0018F0C4

EFLAGS: 0x00000212



Stack:

+0000: 0xE06D7363 0x00000001 0x00000000 0x7744C42D

+0010: 0x00000003 0x19930520 0x0018F160 0x663A2C64

+0020: 0x0018F160 0x55A3DD99 0x0018F11C 0x663782BE

+0030: 0x0018F1C4 0xD208C0D4 0x0018F1B0 0x0018F160

+0040: 0x55A3DD99 0x00000000 0x0018F138 0x66397830

+0050: 0x0018F14C 0x55A49863 0xE06D7363 0x00000001

+0060: 0x00000003 0x0018F140 0xE06D7363 0x00000001

+0070: 0x00000000 0x00000000 0x00000003 0x19930520

+0080: 0x0018F160 0x663A2C64 0x0018F200 0x66377615

+0090: 0x0018F160 0x663A2C64 0xD208C0AC 0x6639C974

+00A0: 0x7897C970 0x02D80001 0x0000000B 0x663A8628

+00B0: 0x0018EF00 0x66395000 0x78B74FD8 0x00000001

+00C0: 0x00000000 0x0000000F 0x6639C980 0x00000000

+00D0: 0x00000000 0x00000000 0xFFFFFFFF 0x6639CEA8

+00E0: 0x00000000 0x6639C988 0x0018F220 0x6639C960

+00F0: 0x7897C948 0x7897C901 0x0000000B 0x663A8628

+0100: 0x663A8600 0x0018F220 0x0018F1DC 0x55AC9246

+0110: 0x00000000 0x0000000F 0x6639C96C 0x00000000

+0120: 0x00000000 0x00000000 0xFFFFFFFF 0x55A3DD99

+0130: 0x0018F250 0x66397AE8 0x00000000 0x0018F25C



--------------------------



Loaded Modules:

-FailedCreate-
Reply


Forum Jump:


Users browsing this thread: 5 Guest(s)