Mysql wont load
#1

Hello Scripters.

Im getting this error on my VPS > Windows Server 2008 R2
when i run the exact same on my Windows 7 NO error. it will start

please help me





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

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

[23:02:23]
[23:02:23] Server Plugins
[23:02:23] --------------
[23:02:23] Loading plugin: mysql
[23:02:23] Failed.
[23:02:23] Loading plugin: Whirlpool
[23:02:23]
[23:02:23] ==================
[23:02:23]
[23:02:23] Whirlpool loaded
[23:02:23]
[23:02:23] ==================
[23:02:23]
[23:02:23] Loaded.
[23:02:23] Loading plugin: streamer.dll
[23:02:23]

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

[23:02:23] Loaded.
[23:02:23] Loading plugin: sscanf
[23:02:23]

[23:02:23] ===============================

[23:02:23] sscanf plugin loaded.

[23:02:23] Version: 2.8.1

[23:02:23] © 2012 Alex "******" Cole

[23:02:23] ===============================

[23:02:23] Loaded.
[23:02:23] Loading plugin: nativechecker
[23:02:23] Loaded.
[23:02:23] Loading plugin: FileManager
[23:02:23] Failed.
[23:02:23] Loaded 4 plugins.

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

[23:02:24] Loaded 6 filterscripts.

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

what OS ?
Reply
#3

You no read??
Reply
#4

That will be a plugin issue, Either update your plugin and make sure its in the plugins folder and is correctly written in your server.cfg
Reply
#5

If i Load the gamemode on my Windows 7 PC it will work
But if i start the gamemode on my Windows Server 2008 R2 im getting that errors and mysql wont load.
Do i miss anything in the VPS ?
Reply
#6

Your version of mysql plugin is not equal with your mysql include.
Reply
#7

But why does it start on my windows 7 OS with the same mysql version
Reply
#8

This is if i run it on my Windows 7 OS

Код:
----------
Loaded log file: "server_log.txt".
----------

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

[22:42:33] 
[22:42:33] Server Plugins
[22:42:33] --------------
[22:42:33]  Loading plugin: mysql
[22:42:33]  >> plugin.mysql: R33 successfully loaded.
[22:42:33]   Loaded.
[22:42:33]  Loading plugin: Whirlpool
[22:42:33]  
[22:42:33]  ==================
[22:42:33]  
[22:42:33]   Whirlpool loaded
[22:42:33]  
[22:42:33]  ==================
[22:42:33]  
[22:42:33]   Loaded.
[22:42:33]  Loading plugin: streamer
[22:42:33] 

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

[22:42:33]   Loaded.
[22:42:33]  Loading plugin: sscanf
[22:42:33] 

[22:42:33]  ===============================

[22:42:33]       sscanf plugin loaded.     

[22:42:33]          Version:  2.8.1        

[22:42:33]    © 2012 Alex "******" Cole  

[22:42:33]  ===============================

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

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

[22:42:33]   Loaded 6 filterscripts.

[22:42:33]  
[22:42:33]  
[22:42:33]  
[22:42:33]  ======================================= 
[22:42:33]  |                                     | 
[22:42:33]  |        YSI version 3.09.0684        | 
[22:42:33]  |        By Alex "******" Cole        | 
[22:42:33]  |                                     | 
[22:42:33]  ======================================= 
[22:42:33]  
[22:42:33]  
[22:42:33]  
[22:42:33] Preparing the gamemode, please wait...
[22:42:35] [MySQL] (Main Pipelines) Connecting to 127.0.0.1...
[22:42:35] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host 127.0.0.1 - DB: cgrp_sql - User: root
[22:42:35] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[22:42:35] [MySQL] Error number: 2003
[22:42:35] [Dynamic Giftbox] Loading the Dynamic Giftbox...
[22:42:35] [LoadCrates] Load Query Sent
[22:42:35] [LoadHouses] Loading data from database...
[22:42:35] [LoadDynamicDoors] Loading data from database...
[22:42:35] [LoadDynamicMapIcons] Loading data from database...
[22:42:35] [LoadMailboxes] Loading data from database...
[22:42:35] [LoadBusinesses] Loading data from database...
[22:42:35] [LoadAuctions] Loading data from database...
[22:42:35] [LoadTxtLabels] Loading data from database...
[22:42:35] [LoadPlants] Loading data from database...
[22:42:35] [SpeedCameras] Loading data from database...
[22:42:35] [LoadPayNSprays] Loading data from database...
[22:42:35] [LoadArrestPoints] Loading data from database...
[22:42:35] [LoadImpoundPoints] Loading data from database...
[22:42:35] [LoadRelayForLifeTeams] Loading data from database...
[22:42:35] [LoadBusinessSales] Loading data from database...
[22:42:35] [LoadTurfWars] 65 turfs loaded.
[22:42:35] [LoadPaintballArenas] 10 paintball arenas loaded.
[22:42:35] [LoadEventPoints] 0 event points loaded.
[22:42:35] [LoadGates] Loading data from database...
[22:42:35] [LoadElevatorStuff] 20 floors loaded.
[22:42:35] [LoadFamilies] Loading data from database...
[22:42:35] [LoadFamilyPoints] Loading Family Points from the database, please wait...
[22:42:35] [MiscLoad] Misc Loaded
[22:42:35] Resetting news...
[22:42:35] Resetting default server variables..
[22:42:35] Adjusted the server time...
[22:42:35] [Streamer] Loading Dynamic Static Vehicles...
[22:42:35] [Streamer] Dynamic Static Vehicles has been loaded.
[22:42:35] [Streamer] Loading Dynamic Pickups...
[22:42:35] [Streamer] Dynamic Pickups has been loaded.
[22:42:35] [Streamer] Loading 3D Text Labels...
[22:42:35] [Streamer] Dynamic 3D Text Labels has been loaded.
[22:42:35] [Streamer] Loading Dynamic Buttons...
[22:42:35] [Streamer] Dynamic Buttons has been loaded.
[22:42:35] [Streamer] Loading Dynamic Objects...
[22:42:35] [Streamer] Dynamic Objects has been loaded.
[22:42:35] [Textdraws] Loading Textdraws...
[22:42:35] [Textdraws] Loaded textdraws.
[22:42:35] [Dynamic Groups] Loading Dynamic Groups...
[22:42:35] [Dynamic Groups] Loading Dynamic Groups Vehicles...
[22:42:35] 
-------------------------------------------
[22:42:35] Crystal Generation Gaming

[22:42:35] Copyright © Crystal Generation Gaming (2012-2013)
[22:42:35] All Rights Reserved
[22:42:35] -------------------------------------------

[22:42:35] Successfully initiated the gamemode...
[22:42:35] Number of vehicle models: 33
[22:42:35] --- Server Shutting Down.
and im getting this if i run it on my Windows Server 2008 R2

Код:
----------
Loaded log file: "server_log.txt".
----------

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

[23:02:23] 
[23:02:23] Server Plugins
[23:02:23] --------------
[23:02:23] Loading plugin: mysql
[23:02:23] Failed.
[23:02:23] Loading plugin: Whirlpool
[23:02:23] 
[23:02:23] ==================
[23:02:23] 
[23:02:23] Whirlpool loaded
[23:02:23] 
[23:02:23] ==================
[23:02:23] 
[23:02:23] Loaded.
[23:02:23] Loading plugin: streamer.dll
[23:02:23] 

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

[23:02:23] Loaded.
[23:02:23] Loading plugin: sscanf
[23:02:23] 

[23:02:23] ===============================

[23:02:23] sscanf plugin loaded. 

[23:02:23] Version: 2.8.1 

[23:02:23] © 2012 Alex "******" Cole 

[23:02:23] ===============================

[23:02:23] Loaded.
[23:02:23] Loading plugin: nativechecker
[23:02:23] Loaded.
[23:02:23] Loading plugin: FileManager
[23:02:23] Failed.
[23:02:23] Loaded 4 plugins.

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

[23:02:24] Loaded 6 filterscripts.

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

Does the VPS have the latest Visual C runtime libraries (vcredist_x86 and vcredist_x64) installed?
Reply
#10

Goto the search function on this forum search for "BlueG" look for mysql then click on the GITHUB link, goto github and then downloaded either the newest version or the one before, personally I prefer R36. But you can choose one if your gamemode is made to use threaded queries.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)