0.3e Convertion problem - 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: 0.3e Convertion problem (/showthread.php?tid=380543)
+- 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: 0.3e Convertion problem (/showthread.php?tid=380543)
0.3e Convertion problem(Mysql+Streamer) - rt-2 - 25.09.2012
Hi,
I wasn't available for a moment recently and I just came back...
So I started updating my server from 0.3d to 0.3e.
I downloaded the new MySQL R7 and Streamer v2.6.1
I also tried to update my code to the new Mysql way of doing...
The problem is that when I start my server it crashes after only 5 seconds..
I'm just wondering if there's a way to use MySQL R7 and the streamer plugin in the same time.
I've read that the problem with MySQL and the streamer is about cache, but I don't even think we're talking about the same problem because I've read that it happens after 2-8h and I don't even need to connect any players to the server to make it crash within 5 seconds.
I have tried to remove one or the other from my server.cfg but my script does an runtime error anyway and I haven't really tested it but the server stay up in that way because I would have to rewrite my entire code for the test...
Here is my server.cfg
Quote:
|
echo Executing Server Config... lanmode 0 rcon_password XXXX maxplayers 100 port 7777 hostname SA Advanced Roleplay [ENG] gamemode0 SAarp 1 filterscripts announce 0 query 1 weburl www.rt-2.net onfoot_rate 40 incar_rate 40 weapon_rate 40 stream_distance 300.0 stream_rate 1000 maxnpc 10 logtimeformat [%c] plugins mysql streamer |
Quote:
|
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3e-R2, ©2005-2012 SA-MP Team [18:25:44] filterscripts = "" (string) [09/25/12 18:25:44] [09/25/12 18:25:44] Server Plugins [09/25/12 18:25:44] -------------- [09/25/12 18:25:44] Loading plugin: mysql [09/25/12 18:25:44] > MySQL plugin R7 successfully loaded. [09/25/12 18:25:44] Loaded. [09/25/12 18:25:44] Loading plugin: streamer [09/25/12 18:25:44] *** Streamer Plugin v2.6.1 by Incognito loaded *** [09/25/12 18:25:44] Loaded. [09/25/12 18:25:44] Loaded 2 plugins. [09/25/12 18:25:44] [09/25/12 18:25:44] Filterscripts [09/25/12 18:25:44] --------------- [09/25/12 18:25:44] Loaded 0 filterscripts. [09/25/12 18:25:45] -Initializing principal game mode. [09/25/12 18:25:45] -Setting Variables. [09/25/12 18:25:45] -Connecting to MYSQL database. [09/25/12 18:25:45] -Connection to `saarp` succesful! [09/25/12 18:25:45] -Spawning map icons... [09/25/12 18:25:45] -Objects initializations... [09/25/12 18:25:45] -Acquiring object types [09/25/12 18:25:45] -Acquiring weapon types [09/25/12 18:25:45] -Spawning ground objects models [09/25/12 18:25:45] -Planes initializations... [09/25/12 18:25:45] -Acquiring plane ids [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -Factions initializations... [09/25/12 18:25:45] -Loading City Planning faction. [09/25/12 18:25:45] -Spawning pickups and labels. [09/25/12 18:25:45] -Loading Police Forces faction [09/25/12 18:25:45] -Loading objects [09/25/12 18:25:45] -Loading pickups [09/25/12 18:25:45] -Taxi faction initializing [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Loading LS Military Police faction. [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -Mush faction initializing [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -SASD faction initializing [09/25/12 18:25:45] -Setting routes [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -SAVA faction initializing (SADA/SAAA/SABA) [09/25/12 18:25:45] -Spawning objects [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Xoomer faction initializing [09/25/12 18:25:45] -Spawning pickups [09/25/12 18:25:45] -Principal game mode initializing completed. [09/25/12 18:25:45] Game mode ready! [09/25/12 18:25:45] Number of vehicle models: 0 |
Quote:
|
[18:25:45] >> mysql_connect(127.0.0.1, saarp, saarp, ******) on port 3306 [18:25:45] CMySQLHandler::CMySQLHandler() - constructor called. [18:25:45] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "saarp" | Username: "saarp" [18:25:45] CMySQLHandler::Connect() - Connection was successful. [18:25:45] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [18:25:45] >> mysql_ping( Connection handle: 1 ) [18:25:45] CMySQLHandler::Ping() - Connection is still alive. [18:25:45] [18:25:45] ** MySQL Debugging enabled (09/25/12) [18:25:45] [18:25:45] >> mysql_query_callback( Connection handle: 1 ) [18:25:45] >> mysql_query_callback( Connection handle: 1 ) [18:25:45] Passing query SELECT * FROM objects_types | [18:25:45] ProcessQueryThread(ReceiveObjectTypes) - Query was successful. (SELECT * FROM objects_types) [18:25:45] ProcessQueryThread(ReceiveObjectTypes) - Data caching enabled. [18:25:45] CMySQLHandler::StoreResult() - Result was stored. [18:25:45] CMySQLHandler::FreeResult() - Result was successfully free'd. [18:25:45] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [18:25:45] Passing query SELECT * FROM objects_list WHERE p_type = 'ground' | [18:25:45] ProcessQueryThread(SpawnGroundObjects) - Query was successful. (SELECT * FROM objects_list WHERE p_type = 'ground') [18:25:45] ProcessQueryThread(SpawnGroundObjects) - Data caching enabled. [18:25:45] CMySQLHandler::StoreResult() - Result was stored. [18:25:45] CMySQLHandler::FreeResult() - Result was successfully free'd. [18:25:45] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [18:25:45] SpawnGroundObjects() - Threaded function called. [18:25:45] >> cache_get_data( Connection handle: 1 ) |
Yanick Coulombe
Re: 0.3e Convertion problem - rt-2 - 26.09.2012
Bump, I'm sure there's a way to use both in the same time, a lot of servers that need Mysql and Streamer are updated already, I'm sure it has been found by now....
Re: 0.3e Convertion problem - rt-2 - 28.09.2012
Bump
Re: 0.3e Convertion problem - Red_Dragon. - 28.09.2012
Buddy, do not spam and bump your thread many times on a short time also average time for thread bumping is 48 hours and thanks
Re: 0.3e Convertion problem - MrPlatinum - 29.09.2012
He bumped his thread once in 24 hours then again in 48 :P
Re: 0.3e Convertion problem - rt-2 - 30.09.2012
Thanks for bumping guys, but what more information do you think I should add?
Re: 0.3e Convertion problem - XtremeR - 30.09.2012
get ur old version script, download a 0.3e 's fresh server, and from the 0.3e, take these files and replace the old version:
Quote:
|
samp-server.exe samp-npc.exe announce.exe samp-license.txt |
Re: 0.3e Convertion problem - M3mPHi$_S3 - 30.09.2012
recompile too !!!
Re: 0.3e Convertion problem - XtremeR - 30.09.2012
no need to recompile if using my trick..
Re: 0.3e Convertion problem - M3mPHi$_S3 - 30.09.2012
Quote:
|
Originally Posted by XtremeR
 no need to recompile if using my trick..
|