[JasperH]

Hello everyone,

Recently my friend has started up a new community and he has been having this error on his SAMP server. I decided to try and help him out and figure it out. The script works perfectly fine on our computers but as soon as it is put onto the VDS (Virtual Dedicated Server) it fails to load all the required plugins and gives a bunch of errors.


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

[14:27:36]
[14:27:36] Server Plugins
[14:27:36] --------------
[14:27:36] Loading plugin: mysql
[14:27:36] Failed.
[14:27:36] Loading plugin: Whirlpool
[14:27:36]
[14:27:36] ==================
[14:27:36]
[14:27:36] Whirlpool loaded
[14:27:36]
[14:27:36] ==================
[14:27:36]
[14:27:36] Loaded.
[14:27:36] Loading plugin: streamer
[14:27:36] Failed.
[14:27:36] Loading plugin: sscanf
[14:27:36] Failed.
[14:27:36] Loading plugin: nativechecker
[14:27:36] Loaded.
[14:27:36] Loaded 2 plugins.

[14:27:36]
[14:27:36] Filterscripts
[14:27:36] ---------------
[14:27:36] Loading filterscript 'yom_buttons.amx'...
[14:27:36] Error: Function not registered: 'Streamer_CallbackHook'
[14:27:36] Error: Function not registered: 'CreateDynamicObject'
[14:27:36] Error: Function not registered: 'DestroyDynamicObject'
[14:27:36] Error: Function not registered: 'SetDynamicObjectPos'
[14:27:36] Error: Function not registered: 'SetDynamicObjectRot'
[14:27:36] Error: Function not registered: 'MoveDynamicObject'
[14:27:36] Error: Function not registered: 'StopDynamicObject'
[14:27:36] Loading filterscript 'vactions.amx'...
[14:27:36] Loading filterscript 'Server.amx'...
[14:27:36] Error: Function not registered: 'Streamer_CallbackHook'
[14:27:36] Error: Function not registered: 'CreateDynamicObject'
[14:27:36] Error: Function not registered: 'SetDynamicObjectMaterial'
[14:27:36] Error: Function not registered: 'SetDynamicObjectMaterialText'
[14:27:36] Error: Function not registered: 'CreateDynamic3DTextLabel'
[14:27:36] Error: Function not registered: 'CreateDynamicPickup'
[14:27:36] Error: Function not registered: 'Streamer_UpdateEx'
[14:27:36] Error: Function not registered: 'Streamer_VisibleItems'
[14:27:36] Loading filterscript 'PlayerInteriors.amx'...
[14:27:36] Error: Function not registered: 'Streamer_CallbackHook'
[14:27:36] Error: Function not registered: 'CreateDynamicObject'
[14:27:36] Error: Function not registered: 'CreateDynamicPickup'
[14:27:36] Error: Function not registered: 'CreateDynamic3DTextLabel'
[14:27:36] Error: Function not registered: 'SetDynamicObjectMaterialText'
[14:27:36] Error: Function not registered: 'Streamer_UpdateEx'
[14:27:36] Error: Function not registered: 'Streamer_VisibleItems'
[14:27:36] Loading filterscript 'PlayerExteriors.amx'...
[14:27:36] Error: Function not registered: 'Streamer_CallbackHook'
[14:27:36] Error: Function not registered: 'CreateDynamicObject'
[14:27:36] Error: Function not registered: 'SetDynamicObjectMaterial'
[14:27:36] Error: Function not registered: 'SetDynamicObjectMaterialText'
[14:27:36] Error: Function not registered: 'CreateDynamic3DTextLabel'
[14:27:36] Error: Function not registered: 'Streamer_UpdateEx'
[14:27:36] Error: Function not registered: 'Streamer_VisibleItems'
[14:27:36] Loaded 5 filterscripts.

[14:27:37] Error: Function not registered: 'Streamer_CallbackHook'
[14:27:37] Error: Function not registered: 'SSCANF_Init'
[14:27:37] Error: Function not registered: 'SSCANF_Join'
[14:27:37] Error: Function not registered: 'SSCANF_Leave'
[14:27:37] Error: Function not registered: 'IsValidDynamicObject'
[14:27:37] Error: Function not registered: 'DestroyDynamicObject'
[14:27:37] Error: Function not registered: 'CreateDynamicObject'
[14:27:37] Error: Function not registered: 'mysql_tquery'
[14:27:37] Error: Function not registered: 'IsValidDynamic3DTextLabel'
[14:27:37] Error: Function not registered: 'DestroyDynamic3DTextLabel'
[14:27:37] Error: Function not registered: 'IsPlayerInDynamicArea'
[14:27:37] Error: Function not registered: 'GetDynamicObjectPos'
[14:27:37] Error: Function not registered: 'GetDynamicObjectRot'
[14:27:37] Error: Function not registered: 'CreateDynamic3DTextLabel'
[14:27:37] Error: Function not registered: 'mysql_escape_string'
[14:27:37] Error: Function not registered: 'CreateDynamicPolygon'
[14:27:37] Error: Function not registered: 'Streamer_TickRate'
[14:27:37] Error: Function not registered: 'MoveDynamicObject'
[14:27:37] Error: Function not registered: 'UpdateDynamic3DTextLabelText'
[14:27:37] Error: Function not registered: 'cache_get_data'
[14:27:37] Error: Function not registered: 'cache_get_field_content'
[14:27:37] Error: Function not registered: 'Streamer_UpdateEx'
[14:27:37] Error: Function not registered: 'AttachDynamicObjectToVehicle'
[14:27:37] Error: Function not registered: 'Streamer_Update'
[14:27:37] Error: Function not registered: 'Streamer_SetArrayData'
[14:27:37] Error: Function not registered: 'DestroyDynamicPickup'
[14:27:37] Error: Function not registered: 'CreateDynamicPickup'
[14:27:37] Error: Function not registered: 'DestroyAllDynamicObjects'
[14:27:37] Error: Function not registered: 'DestroyAllDynamic3DTextLabels'
[14:27:37] Error: Function not registered: 'DestroyAllDynamicCPs'
[14:27:37] Error: Function not registered: 'DestroyAllDynamicMapIcons'
[14:27:37] Error: Function not registered: 'DestroyAllDynamicRaceCPs'
[14:27:37] Error: Function not registered: 'DestroyAllDynamicAreas'
[14:27:37] Error: Function not registered: 'CreateDynamicSphere'
[14:27:37] Error: Function not registered: 'IsValidDynamicPickup'
[14:27:37] Error: Function not registered: 'sscanf'
[14:27:37] Error: Function not registered: 'IsValidDynamicMapIcon'
[14:27:37] Error: Function not registered: 'DestroyDynamicMapIcon'
[14:27:37] Error: Function not registered: 'CreateDynamicRectangle'
[14:27:37] Error: Function not registered: 'DestroyDynamicArea'
[14:27:37] Error: Function not registered: 'SetDynamicObjectMaterialText'
[14:27:37] Error: Function not registered: 'Streamer_IsItemVisible'
[14:27:37] Error: Function not registered: 'IsValidDynamicArea'
[14:27:37] Error: Function not registered: 'mysql_stat'
[14:27:37] Error: Function not registered: 'CreateDynamicMapIcon'
[14:27:37] Error: Function not registered: 'Streamer_SetIntData'
[14:27:37] Error: Function not registered: 'SetDynamicObjectPos'
[14:27:37] Error: Function not registered: 'SetDynamicObjectRot'
[14:27:37] Error: Function not registered: 'EditDynamicObject'
[14:27:37] Error: Function not registered: 'mysql_log'
[14:27:37] Error: Function not registered: 'mysql_connect'
[14:27:37] Error: Function not registered: 'mysql_errno'
[14:27:37] Error: Function not registered: 'mysql_close'
[14:27:37] Error: Function not registered: 'cache_get_row'
[14:27:37] Error: Function not registered: 'cache_insert_id'
[14:27:37] Error: Function not registered: 'cache_affected_rows'
[14:27:37] Script[gamemodes/SCG.amx]: Run time error 19: "File or function is not found"
[14:27:37] Number of vehicle models: 0

Anybody know the solution to this problem?

[TakeiT]

make sure you have net framework 3.5 and Visual C++ 2010. it MUST be the 2010. If you got an error saying missing DLL before, and you downloaded the following DLLs: MSVCR100, MSVCR110, MSVCF110 or any varient, delete them and re install the packages above.

[JasperH]

Quote:

Originally Posted by TakeiT make sure you have net framework 3.5 and Visual C++ 2010. it MUST be the 2010. If you got an error saying missing DLL before, and you downloaded the following DLLs: MSVCR100, MSVCR110, MSVCF110 or any varient, delete them and re install the packages above.

Already have .net framework 3.5, I did indeed get the DLL errors and will try to download Visual C++ 2010.

[JasperH]

Quote:

Originally Posted by TakeiT make sure you have net framework 3.5 and Visual C++ 2010. it MUST be the 2010. If you got an error saying missing DLL before, and you downloaded the following DLLs: MSVCR100, MSVCR110, MSVCF110 or any varient, delete them and re install the packages above.

I installed it and it fixed all of the plugins except for mysql.

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

[14:47:01]
[14:47:01] Server Plugins
[14:47:01] --------------
[14:47:01] Loading plugin: mysql
[14:47:01] Failed.
[14:47:01] Loading plugin: Whirlpool
[14:47:01]
[14:47:01] ==================
[14:47:01]
[14:47:01] Whirlpool loaded
[14:47:01]
[14:47:01] ==================
[14:47:01]
[14:47:01] Loaded.
[14:47:01] Loading plugin: streamer
[14:47:01]

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

[14:47:01] Loaded.
[14:47:01] Loading plugin: sscanf
[14:47:01]

[14:47:01] ===============================

[14:47:01] sscanf plugin loaded.

[14:47:01] © 2009 Alex "Y_Less" Cole

[14:47:01] 0.3d-R2 500 Players "dnee"

[14:47:01] ===============================

[14:47:01] Loaded.
[14:47:01] Loading plugin: nativechecker
[14:47:01] Loaded.
[14:47:01] Loaded 4 plugins.

[14:47:01]
[14:47:01] Filterscripts
[14:47:01] ---------------
[14:47:01] Loading filterscript 'yom_buttons.amx'...
[14:47:01] Loading filterscript 'vactions.amx'...
[14:47:01] Loading filterscript 'Server.amx'...
[14:47:01] Loading filterscript 'PlayerInteriors.amx'...
[14:47:01] Loading filterscript 'PlayerExteriors.amx'...
[14:47:01] Loaded 5 filterscripts.

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

I'm pretty sure there is a specific version of mysql I need, but do you know the version?

[SaintMikey]

Go to the script, search for "mysql_ping, or errno" and either change it to mysql_ping, or change all _ping(s) to errno, then you need to get a static version of MySQL, and a better include version, and recompile the script!

[JasperH]

Quote:

Originally Posted by SaintMikey Go to the script, search for "mysql_ping, or errno" and either change it to mysql_ping, or change all _ping(s) to errno, then you need to get a static version of MySQL, and a better include version, and recompile the script!

I installed version r20 and then it changed to this..

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

[15:13:21]
[15:13:21] Server Plugins
[15:13:21] --------------
[15:13:21] Loading plugin: mysql
[15:13:21] plugin.mysql: R20 successfully loaded.
[15:13:21] Loaded.
[15:13:21] Loading plugin: Whirlpool
[15:13:21]
[15:13:21] ==================
[15:13:21]
[15:13:21] Whirlpool loaded
[15:13:21]
[15:13:21] ==================
[15:13:21]
[15:13:21] Loaded.
[15:13:21] Loading plugin: streamer
[15:13:21]

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

[15:13:21] Loaded.
[15:13:21] Loading plugin: sscanf
[15:13:21]

[15:13:21] ===============================

[15:13:21] sscanf plugin loaded.

[15:13:21] © 2009 Alex "Y_Less" Cole

[15:13:21] 0.3d-R2 500 Players "dnee"

[15:13:21] ===============================

[15:13:21] Loaded.
[15:13:21] Loading plugin: nativechecker
[15:13:21] Loaded.
[15:13:21] Loaded 5 plugins.

[15:13:21]
[15:13:21] Filterscripts
[15:13:21] ---------------
[15:13:21] Loading filterscript 'yom_buttons.amx'...
[15:13:21] Loading filterscript 'vactions.amx'...
[15:13:21] Loading filterscript 'Server.amx'...
[15:13:21] Loading filterscript 'PlayerInteriors.amx'...
[15:13:21] Loading filterscript 'PlayerExteriors.amx'...
[15:13:21] Loaded 5 filterscripts.

[15:13:22] Error: Function not registered: 'mysql_tquery'
[15:13:22] Error: Function not registered: 'mysql_escape_string'
[15:13:22] Error: Function not registered: 'cache_insert_id'
[15:13:22] Error: Function not registered: 'cache_affected_rows'
[15:13:22] Script[gamemodes/SCG.amx]: Run time error 19: "File or function is not found"
[15:13:22] Number of vehicle models: 0

It loaded mysql but is now down to 4 errors. Any ideas?

[TakeiT]

Chances are, you forgot to remove one of the DLLs that you downloaded. Double check and recompile C++2010. Also download C++2013, it may help too, though i cant remember

[JasperH]

Quote:

Originally Posted by TakeiT Chances are, you forgot to remove one of the DLLs that you downloaded. Double check and recompile C++2010. Also download C++2013, it may help too, though i cant remember

I have all the DLLs from before because whenever I delete them and try to start the server it gives the same errors and tells me to install them.

[SaintMikey]

I believe you should be able to remove the plugins, and re-install them, into the once you are required to have, and make sure your include file is in the same version as all the other plugins as well.