SA-MP Forums Archive
A Critical Issue with MySQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: A Critical Issue with MySQL (/showthread.php?tid=429302)


A Critical Issue with MySQL - Goldilox - 09.04.2013

Hey there, so I am experiencing an unpredictable issue with MySQL on my server. It is kinda not believable but that is it. So, I have a database with volt host. When I play my server form my localhost with the same database (one which is in volt host) it works fine and updates everything changes in game but when I upload the script and try playing on my server, it doesn't updates the server changes into the database. Yes I have the right MySQL plugin, and if I didn't had, it should had worked in localhost. Seeking for someone's help immediately! I have to fix my server as soon as possible.

Re: A Critical Issue with MySQL - ReneG - 09.04.2013

You aren't really clear when you say you have the right plugin. Volthost servers are linux-based, since you say it worked on localhost then I assume you're on windows, which I then assume it was a .dll plugin. Linux plugins are .so files.

Re: A Critical Issue with MySQL - Goldilox - 09.04.2013

I have both of em for all the plugins.

Here is a nice little screenshot explaining my statement there. (attached in bottom)

I just realized an error in the server console, it might help recognizing the issue too.

Код:
[20:01:00] RCON (In-Game): Player [[SkR]Gold] sent command: gmx
[19:59:38] RCON (In-Game): Player #0 ([SkR]Gold) has logged in.
[19:59:36] RCON (In-Game): Player #0 ([SkR]Gold) failed login.
[19:59:35] RCON (In-Game): Player #0 ([SkR]Gold) failed login.
[19:59:35] RCON (In-Game): Player #0 ([SkR]Gold) failed login.
[19:59:34] RCON (In-Game): Player #0 ([SkR]Gold) failed login.
[19:59:32] RCON (In-Game): Player #0 ([SkR]Gold) failed login.
[19:59:27] RCON (In-Game): Player #0 ([SkR]Gold) failed login.
[19:59:15] sscanf error: System not initialised.
[19:59:12] [join] [SkR]Gold has joined the server (0:70.76.50.65)
[19:59:11] Incoming connection: 70.76.50.65:59461
[19:58:41] Number of vehicle models: 10

[19:58:41] =====================================================================
[19:58:41] ** 0	<->	MapIcons Loaded From	<->	MySQL		   **
[19:58:41] ** 3	<->	Labels Loaded From	<->	MySQL		   **
[19:58:41] sscanf error: System not initialised.
[19:58:41] sscanf error: System not initialised.
[19:58:41] sscanf error: System not initialised.
[19:58:41] ** 1	<->	Pickups Loaded From	<->	MySQL		   **
[19:58:41] sscanf error: System not initialised.
[19:58:41] ** 8	<->	Vehicles Loaded From	<->	MySQL		   **
[19:58:41] sscanf error: System not initialised.
[19:58:41] sscanf error: System not initialised.
[19:58:41] sscanf error: System not initialised.
[19:58:41] sscanf error: System not initialised.
[19:58:41] sscanf error: System not initialised.
[19:58:41] sscanf error: System not initialised.
[19:58:41] sscanf error: System not initialised.
[19:58:41] sscanf error: System not initialised.
[19:58:41] =====================================================================
[19:58:41] *** Streamer Plugin: Include file version (unknown version) does not match plugin version (0x26105) (script needs to be recompiled with the latest include file)
[19:58:41] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyCheckpoint" found (script needs to be recompiled with the latest include file)
[19:58:41] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyPickup" found (script needs to be recompiled with the latest include file)
[19:58:41] *** Streamer Plugin: Obsolete or invalid native "Streamer_RemovePlayer" found (script needs to be recompiled with the latest include file)
[19:58:41] *** Streamer Plugin: Obsolete or invalid native "Streamer_AddPlayer" found (script needs to be recompiled with the latest include file)
[19:58:41] *** Streamer Plugin: Obsolete or invalid native "Streamer_RegisterInterface" found (script needs to be recompiled with the latest include file)

[19:58:41]   Loaded 1 filterscripts.
[19:58:41]   Loading filterscript 's-admin.amx'...
[19:58:41] ---------------
[19:58:41] Filterscripts
[19:58:41] 

[19:58:41]  Loaded 3 plugins.
[19:58:41]   Loaded.

  > MySQL plugin R6 successfully loaded.

[19:58:41] 
[19:58:41]  Loading plugin: mysql.so
[19:58:41]   Loaded.

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

[19:58:41] 
[19:58:41]  Loading plugin: streamer.so
[19:58:41]   Loaded.

[19:58:41]  ===============================

[19:58:41]    0.3d-R2 500 Players "dnee"

[19:58:41]    © 2009 Alex "******" Cole

[19:58:41]       sscanf plugin loaded.     

[19:58:41]  ===============================

[19:58:41] 
[19:58:41]  Loading plugin: sscanf.so
[19:58:41] --------------
[19:58:41] Server Plugins
[19:58:41] 

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

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

[19:58:06] [part] [SkR]Gold has left the server (0:1)
[19:57:31] sscanf error: System not initialised.
[19:57:28] [join] [SkR]Gold has joined the server (0:70.76.50.65)
[19:57:27] Incoming connection: 70.76.50.65:56597
[19:56:49] Number of vehicle models: 10

[19:56:49] =====================================================================
[19:56:49] ** 0	<->	MapIcons Loaded From	<->	MySQL		   **
[19:56:49] ** 3	<->	Labels Loaded From	<->	MySQL		   **
[19:56:49] sscanf error: System not initialised.
[19:56:49] sscanf error: System not initialised.
[19:56:49] sscanf error: System not initialised.
[19:56:49] ** 1	<->	Pickups Loaded From	<->	MySQL		   **
[19:56:49] sscanf error: System not initialised.
[19:56:49] ** 8	<->	Vehicles Loaded From	<->	MySQL		   **
[19:56:49] sscanf error: System not initialised.
[19:56:49] sscanf error: System not initialised.
[19:56:49] sscanf error: System not initialised.
[19:56:49] sscanf error: System not initialised.
[19:56:49] sscanf error: System not initialised.
[19:56:49] sscanf error: System not initialised.
[19:56:49] sscanf error: System not initialised.
[19:56:49] sscanf error: System not initialised.
[19:56:49] =====================================================================
[19:56:49] *** Streamer Plugin: Include file version (unknown version) does not match plugin version (0x26105) (script needs to be recompiled with the latest include file)
[19:56:49] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyCheckpoint" found (script needs to be recompiled with the latest include file)
[19:56:49] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyPickup" found (script needs to be recompiled with the latest include file)
[19:56:49] *** Streamer Plugin: Obsolete or invalid native "Streamer_RemovePlayer" found (script needs to be recompiled with the latest include file)
[19:56:49] *** Streamer Plugin: Obsolete or invalid native "Streamer_AddPlayer" found (script needs to be recompiled with the latest include file)
[19:56:49] *** Streamer Plugin: Obsolete or invalid native "Streamer_RegisterInterface" found (script needs to be recompiled with the latest include file)

[19:56:49]   Loaded 1 filterscripts.
[19:56:49]   Loading filterscript 's-admin.amx'...
[19:56:49] ---------------
[19:56:49] Filterscripts
[19:56:49] 

[19:56:49]  Loaded 3 plugins.
[19:56:49]   Loaded.

  > MySQL plugin R6 successfully loaded.

[19:56:49] 
[19:56:49]  Loading plugin: mysql.so
[19:56:49]   Loaded.

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

[19:56:49] 
[19:56:49]  Loading plugin: streamer.so
[19:56:49]   Loaded.

[19:56:49]  ===============================

[19:56:49]    0.3d-R2 500 Players "dnee"

[19:56:49]    © 2009 Alex "******" Cole

[19:56:49]       sscanf plugin loaded.     

[19:56:49]  ===============================

[19:56:49] 
[19:56:49]  Loading plugin: sscanf.so
[19:56:49] --------------
[19:56:49] Server Plugins
[19:56:49] 

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

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

[19:34:31] Number of vehicle models: 10

[19:34:31] =====================================================================
[19:34:31] ** 0	<->	MapIcons Loaded From	<->	MySQL		   **
[19:34:31] ** 3	<->	Labels Loaded From	<->	MySQL		   **
[19:34:31] sscanf error: System not initialised.
[19:34:31] sscanf error: System not initialised.
[19:34:31] sscanf error: System not initialised.
[19:34:31] ** 1	<->	Pickups Loaded From	<->	MySQL		   **
[19:34:31] sscanf error: System not initialised.
[19:34:31] ** 8	<->	Vehicles Loaded From	<->	MySQL		   **
[19:34:31] sscanf error: System not initialised.
[19:34:31] sscanf error: System not initialised.
[19:34:31] sscanf error: System not initialised.
[19:34:31] sscanf error: System not initialised.
[19:34:31] sscanf error: System not initialised.
[19:34:31] sscanf error: System not initialised.
[19:34:31] sscanf error: System not initialised.
[19:34:31] sscanf error: System not initialised.
[19:34:31] =====================================================================
[19:34:31] *** Streamer Plugin: Include file version (unknown version) does not match plugin version (0x26105) (script needs to be recompiled with the latest include file)
[19:34:31] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyCheckpoint" found (script needs to be recompiled with the latest include file)
[19:34:31] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyPickup" found (script needs to be recompiled with the latest include file)
[19:34:31] *** Streamer Plugin: Obsolete or invalid native "Streamer_RemovePlayer" found (script needs to be recompiled with the latest include file)
[19:34:31] *** Streamer Plugin: Obsolete or invalid native "Streamer_AddPlayer" found (script needs to be recompiled with the latest include file)
[19:34:31] *** Streamer Plugin: Obsolete or invalid native "Streamer_RegisterInterface" found (script needs to be recompiled with the latest include file)

[19:34:31]   Loaded 1 filterscripts.
[19:34:31]   Loading filterscript 's-admin.amx'...
[19:34:31] ---------------
[19:34:31] Filterscripts
[19:34:31] 

[19:34:31]  Loaded 3 plugins.
[19:34:31]   Loaded.

  > MySQL plugin R6 successfully loaded.

[19:34:31] 
[19:34:31]  Loading plugin: mysql.so
[19:34:31]   Loaded.


Re: A Critical Issue with MySQL - Goldilox - 09.04.2013

Can someone fix this issue real quick if they know, by skyping me at "soomrotayab"

Re: A Critical Issue with MySQL - Scenario - 09.04.2013

You have to use .so plugins at Volt since they run Linux servers. So, in your server.cfg file, you have to add .so to the end of each plugin you've named. And, considering you have uploaded the .so plugins to the Volt server, it should be working fine.

Re: A Critical Issue with MySQL - Goldilox - 09.04.2013

My cfg already has .so files, it did work before. I have vehicles, playerinfo, 3dlebels in database so I added a 3d label it did updated but suddenly I dont know what is wrong.

Код:
echo Executing Server Config...
lanmode 0
rcon_password ...
maxplayers 1
port 7779
hostname ST Freeroam
gamemode0 st
filterscripts s-admin
plugins sscanf.so streamer.so mysql.so
announce 1
query 1
weburl www.sa-mp.com
maxnpc 1
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
bind 66.85.141.89


Re: A Critical Issue with MySQL - Goldilox - 09.04.2013

By the way just realized that it saves the new entries of the users but just doesn't updates the vehicles and if I change the level from mysql it doesn't works.

EDIT: I also have this error, what does that mean?
Код:
[07:22:17] sscanf error: System not initialised.


Re: A Critical Issue with MySQL - Threshold - 09.04.2013

This means you need to update your sscanf... which is all mentioned in the original sscanf thread by ******... Also, judging by the obvious errors in your server log, I'd say you need to update your streamer plugin and include as well...

Re: A Critical Issue with MySQL - DobbysGamertag - 09.04.2013

Use the "One Click Mod Installer" i use it for sscanf streamer etc. Even if i have the .so extension's. Works without fail for me

Re: A Critical Issue with MySQL - Goldilox - 10.04.2013

I already have tried updating all the stuff. I heard from someone that the volt host is linux based so I updated all the plugins with .so format and all the things inside the server files are now in lowercase. Yet it doesn't work.

Quote:

I have a windows server, made by my own. It is in MySQL, vehicles, playerinfo, 3dlabel, pickups and the icon are all in MySQL. Thing is, when I play that server in my localhost with the database of volt host it works perfectly fine, I can add cars, change player level to admin and all are good. But when I upload my server to my volt host it the game mode runs perfectly fine and the account I created with localhost in the server is updated on the volt host database. But when I give him admin level 5 and when I reload my phpmyadmin it removes the changes I had made and it doesn't work in my server. I hope you got my issue, I am seeking help so badly. I am having hard time making the script work in volt host. It will be appreciated if you help and you will get reputation obviously.
I have also uploaded the server files. If someone has time, can someone fix it so it will be up and running for volt host?

http://www.soomrotayab.com/server1.zip