[rt-2]

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

And here is my server_log

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

And here is my mysql_log

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 )

Thank you very much in advance for your help,
Yanick Coulombe