1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support

Threaded Mode
Console closes when I join.
Stefand
Gangsta
*****
Posts: 772
Threads: 223
Joined: Sep 2011
Reputation: 0
#1

10.05.2013, 08:47
Hey,

I wanted to test my script and when I join it takes really long so I thought there must be something wrong.
Then after a few minutes it sais Server Lost Connection and then I noticed that my console closed...

The LOG doesn't show anything.

Код:
SA-MP Dedicated Server
----------------------
v0.3x, ©2005-2013 SA-MP Team

[10:45:33] filterscripts = ""  (string)
[10:45:33] 
[10:45:33] Server Plugins
[10:45:33] --------------
[10:45:33]  Loading plugin: mysql
[10:45:33] 

  > MySQL plugin R7 successfully loaded.

[10:45:33]   Loaded.
[10:45:33]  Loading plugin: Whirlpool
[10:45:33]  
[10:45:33]  ==================
[10:45:33]  
[10:45:33]   Whirlpool loaded
[10:45:33]  
[10:45:33]  ==================
[10:45:33]  
[10:45:33]   Loaded.
[10:45:33]  Loading plugin: streamer
[10:45:33] 

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

[10:45:33]   Loaded.
[10:45:33]  Loaded 3 plugins.

[10:45:34] 
[10:45:34] Filterscripts
[10:45:34] ---------------
[10:45:34]   Loaded 0 filterscripts.

[10:45:34]  
[10:45:34]  
[10:45:34]  
[10:45:34]  ======================================= 
[10:45:34]  |                                     | 
[10:45:34]  |        YSI version 1.06.0002        | 
[10:45:34]  |        By Alex "******" Cole        | 
[10:45:34]  |                                     | 
[10:45:34]  ======================================= 
[10:45:34]  
[10:45:34]  
[10:45:34]  
[10:45:34]  * Connecting to MySQL: Success
[10:45:35]  
[10:45:35]  
[10:45:35] -----------------------GAMEMODE LOADING-----------------------
[10:45:35] ------------- Gamemode created by: Stefantjuh97 --------------
[10:45:35] --------------- Email: Stefantjuh97@gmail.com ----------------
[10:45:35] -----------------------GAMEMODE  LOADED-----------------------
[10:45:35]  
[10:45:35]  
[10:45:35] Number of vehicle models: 0
[10:45:35] [System] Faction 1 with faction name: Los Santos Police Department spawned.
[10:45:35] [System] Faction 2 with faction name: Los Santos Emergency Services spawned.
[10:45:35] [System] Faction 3 with faction name: Federal Bureau of Investigations spawned.
[10:45:35] [System] Faction 4 with faction name: Cable News Network spawned.
[10:45:35] [System] Faction 5 with faction name: Taxi Company spawned.
[10:45:37] Incoming connection: 25.137.80.58:53059
[10:45:37] [join] Danny_Williams has joined the server (0:25.137.80.58)
What could be the problem?
I tried re-compiling etc...

EDIT:

Now I joined and quickly alt tabbed, It says on the console: SA-MP DEDICATED SERVER HAS STOPPED WORKING
Find
Reply
Stefand
Gangsta
*****
Posts: 772
Threads: 223
Joined: Sep 2011
Reputation: 0
#2

10.05.2013, 08:57
pawn Код:
stock InitFactions()
{
    new query[400];
    for(new id; id < MAX_FACTIONS; id++) // Goes through all the slots, looking for the data
    {
        format(query, sizeof(query), "SELECT * FROM `Factions` WHERE `FactionID` = %d", id); // Selects all the information from the table
        mysql_function_query(connectionHandle, query, true, "LoadFactionsCallback", "d", id);
    }
    return 1;
}

stock InitVehicles()
{
    new query[400];
    for(new id; id < MAX_VEHICLES; id++) // Goes through all the slots, looking for the data
    {
        format(query, sizeof(query), "SELECT * FROM `Vehicles` WHERE `CarFileID` = %d", id); // Selects all the information from the table
        mysql_function_query(connectionHandle, query, true, "LoadVehiclesCallback", "d", id);
    }
    return 1;
}

stock InitHouses()
{
    new query[400];
    for(new id; id < MAX_HOUSES; id++) // Goes through all the slots, looking for the data
    {
        format(query, sizeof(query), "SELECT * FROM `Houses` WHERE `HouseID` = %d", id); // Selects all the information from the table
        mysql_function_query(connectionHandle, query, true, "LoadHousesCallback", "d", id);
    }
    return 1;
}
I think it is that because when I check MYSQL log it is FULL of Spam of these things.

Look at this:

Код:
[10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 0 | d
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 0)
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled.
[10:51:42] CMySQLHandler::StoreResult() - Result was stored.
[10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:51:42] LoadVehiclesCallback(d) - Threaded function called.
[10:51:42] >> cache_get_data( Connection handle: 1 )
[10:51:42] ProcessTick() - The cache has been cleared.
[10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 1 | d
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 1)
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled.
[10:51:42] CMySQLHandler::StoreResult() - Result was stored.
[10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:51:42] LoadVehiclesCallback(d) - Threaded function called.
[10:51:42] >> cache_get_data( Connection handle: 1 )
[10:51:42] ProcessTick() - The cache has been cleared.
[10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 2 | d
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 2)
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled.
[10:51:42] CMySQLHandler::StoreResult() - Result was stored.
[10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:51:42] LoadVehiclesCallback(d) - Threaded function called.
[10:51:42] >> cache_get_data( Connection handle: 1 )
[10:51:42] ProcessTick() - The cache has been cleared.
[10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 3 | d
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 3)
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled.
[10:51:42] CMySQLHandler::StoreResult() - Result was stored.
[10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:51:42] LoadVehiclesCallback(d) - Threaded function called.
[10:51:42] >> cache_get_data( Connection handle: 1 )
[10:51:42] ProcessTick() - The cache has been cleared.
[10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 4 | d
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 4)
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled.
[10:51:42] CMySQLHandler::StoreResult() - Result was stored.
[10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:51:42] LoadVehiclesCallback(d) - Threaded function called.
[10:51:42] >> cache_get_data( Connection handle: 1 )
[10:51:42] ProcessTick() - The cache has been cleared.
[10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 5 | d
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 5)
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled.
[10:51:42] CMySQLHandler::StoreResult() - Result was stored.
[10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:51:42] LoadVehiclesCallback(d) - Threaded function called.
[10:51:42] >> cache_get_data( Connection handle: 1 )
[10:51:42] ProcessTick() - The cache has been cleared.
[10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 6 | d
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 6)
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled.
[10:51:42] CMySQLHandler::StoreResult() - Result was stored.
[10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:51:42] LoadVehiclesCallback(d) - Threaded function called.
[10:51:42] >> cache_get_data( Connection handle: 1 )
[10:51:42] ProcessTick() - The cache has been cleared.
[10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 7 | d
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 7)
[10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled.
[10:51:42] CMySQLHandler::StoreResult() - Result was stored.
[10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:51:42] LoadVehiclesCallback(d) - Threaded function called.
[10:51:42] >> cache_get_data( Connection handle: 1 )
[10:51:42] ProcessTick() - The cache has been cleared.
up to the 2000...

and

Код:
[10:52:04] ProcessTick() - The cache has been cleared.
[10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 1 | d
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 1)
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled.
[10:52:04] CMySQLHandler::StoreResult() - Result was stored.
[10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:52:04] LoadHousesCallback(d) - Threaded function called.
[10:52:04] >> cache_get_data( Connection handle: 1 )
[10:52:04] ProcessTick() - The cache has been cleared.
[10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 2 | d
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 2)
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled.
[10:52:04] CMySQLHandler::StoreResult() - Result was stored.
[10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:52:04] LoadHousesCallback(d) - Threaded function called.
[10:52:04] >> cache_get_data( Connection handle: 1 )
[10:52:04] ProcessTick() - The cache has been cleared.
[10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 3 | d
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 3)
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled.
[10:52:04] CMySQLHandler::StoreResult() - Result was stored.
[10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:52:04] LoadHousesCallback(d) - Threaded function called.
[10:52:04] >> cache_get_data( Connection handle: 1 )
[10:52:04] ProcessTick() - The cache has been cleared.
[10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 4 | d
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 4)
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled.
[10:52:04] CMySQLHandler::StoreResult() - Result was stored.
[10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:52:04] LoadHousesCallback(d) - Threaded function called.
[10:52:04] >> cache_get_data( Connection handle: 1 )
[10:52:04] ProcessTick() - The cache has been cleared.
[10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 5 | d
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 5)
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled.
[10:52:04] CMySQLHandler::StoreResult() - Result was stored.
[10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:52:04] LoadHousesCallback(d) - Threaded function called.
[10:52:04] >> cache_get_data( Connection handle: 1 )
[10:52:04] ProcessTick() - The cache has been cleared.
[10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 6 | d
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 6)
[10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled.
[10:52:04] CMySQLHandler::StoreResult() - Result was stored.
[10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd.
[10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[10:52:04] LoadHousesCallback(d) - Threaded function called.
[10:52:04] >> cache_get_data( Conne
up to the 1000...

and maybe like a thousand times

Код:
[10:51:41] >> mysql_query_callback( Connection handle: 1 )
at the beginning
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support