SA-MP Forums Archive
MySQL Failing to load. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL Failing to load. (/showthread.php?tid=515371)



MySQL Failing to load. - MikkaVanBuuren - 25.05.2014

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

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

[11:40:40] password = ""  (string)
[11:40:40] 
[11:40:40] Server Plugins
[11:40:40] --------------
[11:40:40]  Loading plugin: mysql
[11:40:42]   Failed.
[11:40:42]  Loading plugin: Whirlpool
[11:40:42]  
[11:40:42]  ==================
[11:40:42]  
[11:40:42]   Whirlpool loaded
[11:40:42]  
[11:40:42]  ==================
[11:40:42]  
[11:40:42]   Loaded.
[11:40:42]  Loading plugin: streamer
[11:40:42] 

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

[11:40:42]   Loaded.
[11:40:42]  Loading plugin: sscanf
[11:40:42] 

[11:40:42]  ===============================

[11:40:42]       sscanf plugin loaded.     

[11:40:42]    © 2009 Alex "******" Cole

[11:40:42]    0.3d-R2 500 Players "dnee"

[11:40:42]  ===============================

[11:40:42]   Loaded.
[11:40:42]  Loading plugin: nativechecker
[11:40:42]   Loaded.
[11:40:42]  Loaded 4 plugins.

[11:40:43] 
[11:40:43] Ban list
[11:40:43] --------
[11:40:43]  Loaded: samp.ban
[11:40:43] 
[11:40:43] 
[11:40:43] Filterscripts
[11:40:43] ---------------
[11:40:43]   Loading filterscript 'yom_buttons.amx'...
[11:40:43]   Loading filterscript 'vactions.amx'...
[11:40:43]   Loading filterscript 'Server.amx'...
[11:40:43]   Loading filterscript 'PlayerInteriors.amx'...
[11:40:43]   Loading filterscript 'PlayerExteriors.amx'...
[11:40:43]   Loading filterscript 'ints.amx'...
[11:40:43] 
---------------------------------
[11:40:43]  Interiors
[11:40:43] ---------------------------------

[11:40:43]   Loading filterscript 'gcustom03e.amx'...
[11:40:43]   Loading filterscript 'valkyrie.amx'...
[11:40:43] 
----------------------------------
[11:40:43]  :)
[11:40:43] ----------------------------------

[11:40:43]   Loaded 8 filterscripts.

[11:40:44]    Error: Function not registered: 'mysql_tquery'
[11:40:44]    Error: Function not registered: 'mysql_escape_string'
[11:40:44]    Error: Function not registered: 'cache_get_data'
[11:40:44]    Error: Function not registered: 'cache_get_field_content'
[11:40:44]    Error: Function not registered: 'mysql_stat'
[11:40:44]    Error: Function not registered: 'mysql_log'
[11:40:44]    Error: Function not registered: 'mysql_connect'
[11:40:44]    Error: Function not registered: 'mysql_errno'
[11:40:44]    Error: Function not registered: 'mysql_close'
[11:40:44]    Error: Function not registered: 'cache_get_row'
[11:40:44]    Error: Function not registered: 'cache_insert_id'
[11:40:44]    Error: Function not registered: 'cache_affected_rows'
[11:40:44] Script[gamemodes/V-RP.amx]: Run time error 19: "File or function is not found"
[11:40:44] Number of vehicle models: 0
[11:40:52] --- Server Shutting Down.
[11:40:56]  
[11:40:56]  ====================
[11:40:56]  
[11:40:56]   Whirlpool unloaded
[11:40:56]  
[11:40:56]  ====================
[11:40:56]  
[11:40:56] 

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

[11:40:56] 

[11:40:56]  ===============================

[11:40:56]      sscanf plugin unloaded.    

[11:40:56]  ===============================
I've been having recent problems with c++ redistributables earlier, but windows update seem to have fixed half of them.

It was giving me these
msvcp100.dll
msvcr100.dll
msvcr110.dll

Basically it could not find those or whatever.

SSCANF/Streamer/Whirlpool were looking for those DLL's and they failed to start.

Now the others are loading except the MySQL one.

What do I do?


Re: MySQL Failing to load. - Excarius - 25.05.2014

Are you running Windows Server 2008?


Re: MySQL Failing to load. - MikkaVanBuuren - 25.05.2014

Quote:
Originally Posted by Excarius
Посмотреть сообщение
Are you running Windows Server 2008?
No, that was on my old RDP, this RDP runs Windows Server 2003.


Re: MySQL Failing to load. - Excarius - 25.05.2014

Okay, i know a proper fix for it, i am running windows 2012 server 64bit so, the UI may look very different than what u got, if so, tell me. Here we go with images instruction. and STEP by STEP. I hope everyone will use it as a solution!

1)


2)


3)


4)
After done, restart the machine, and go get ALL c++ Redistributable packages.
BUT, before you go, make sure you install ALL the available .NET Frameworks, try all no matter if its old/new, you loose NOTHING, so do it.

5)
When done, try to get ALL c++ Redistributable. Try 2008 and 2010 c++ Redistributable, x86 and x64 (x86 for 32bit, x64 for 64bit). Don't care about bits, download both and apply both of them.)

6) After you're done, restart the machine and make sure you get "libmysql.dll" to your root of your SA:MP Server folder. (I don't know if it may helps with anything, but you loose nothing, so do it )

You can get libmysql.dll from mySQL plugin creator that you are using, BlueG's plugin also has it, so install and put it. Like i said, it may don't change anything but try it, you lose nothing with it.


If this worked, please inform us!


Re: MySQL Failing to load. - MikkaVanBuuren - 25.05.2014

Quote:
Originally Posted by Excarius
Посмотреть сообщение
Okay, i know a proper fix for it, i am running windows 2012 server 64bit so, the UI may look very different than what u got, if so, tell me. Here we go with images instruction. and STEP by STEP. I hope everyone will use it as a solution!

1)


2)


3)


4)
After done, restart the machine, and go get ALL c++ Redistributable packages.
BUT, before you go, make sure you install ALL the available .NET Frameworks, try all no matter if its old/new, you loose NOTHING, so do it.

5)
When done, try to get ALL c++ Redistributable. Try 2008 and 2010 c++ Redistributable, x86 and x64 (x86 for 32bit, x64 for 64bit). Don't care about bits, download both and apply both of them.)

6) After you're done, restart the machine and make sure you get "libmysql.dll" to your root of your SA:MP Server folder. (I don't know if it may helps with anything, but you loose nothing, so do it )

You can get libmysql.dll from mySQL plugin creator that you are using, BlueG's plugin also has it, so install and put it. Like i said, it may don't change anything but try it, you lose nothing with it.


If this worked, please inform us!
I don't see the feature part.