Server fails to - Printable Version

Server fails to - 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: Server fails to (/showthread.php?tid=412753)

PLEASE help really important - Geeboi_Mehdi - 03.02.2013

this is from Server_log

pawn Code:

> MySQL plugin unloaded.

[22:06:46] 

*** Streamer Plugin v2.5 by Incognito unloaded ***

[22:06:46] 

[22:06:46]  ===============================

[22:06:46]      sscanf plugin unloaded.    

[22:06:46]  ===============================


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

SA-MP Dedicated Server
----------------------
v0.3e, (C)2005-2012 SA-MP Team

[20:24:34] filterscripts = ""  (string)
[20:24:34] 
[20:24:34] Server Plugins
[20:24:34] --------------
[20:24:34]  Loading plugin: mysql
[20:24:34] 

  > MySQL plugin R5 successfully loaded.

[20:24:34]   Loaded.
[20:24:34]  Loading plugin: streamer
[20:24:34] 

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

[20:24:34]   Loaded.
[20:24:34]  Loading plugin: sscanf
[20:24:34] 

[20:24:34]  ===============================

[20:24:34]       sscanf plugin loaded.     

[20:24:34]    (c) 2009 Alex "Y_Less" Cole

[20:24:34]  ===============================

[20:24:34]   Loaded.
[20:24:34]  Loaded 3 plugins.

[20:24:34] 
[20:24:34] Filterscripts
[20:24:34] ---------------
[20:24:34]   Loaded 0 filterscripts.

[20:24:35] [MYSQL]: [ERROR]: Connection to `lof` failed!
[20:24:35] Failed to load airline.
[20:24:35] Failed to load airline.
[20:24:35] Failed to load airline.
[20:24:35] Failed to load airline.
[20:24:35] Failed to load airline.
[20:24:35] ** -1    <-> Airline Vehicles loaded from    <-> MySQL          **
[20:24:35] ** -1    <-> Vehicles loaded from    <-> MySQL          **
[20:24:35] 
----------------------------------
[20:24:35]  Life of Flying | By Mehdi
[20:24:35] ----------------------------------

[20:24:35] Number of vehicle models: 0
[20:24:46] --- Server Shutting Down.
[20:24:46] 

  > MySQL plugin unloaded.

[20:24:46] 

*** Streamer Plugin v2.5 by Incognito unloaded ***

[20:24:46] 

[20:24:46]  ===============================

[20:24:46]      sscanf plugin unloaded.    

[20:24:46]  ===============================

as you see its Server fails to load.
i don't host this server or using any program i just open server and try to connect my friend told me to use this program xampp i have no idea how to use it can you please help me?

this is really important to me i been trying to fix this server for months if you do help me i will be so greatful

Re: Server fails to - T0pAz - 03.02.2013

Show the line where you are connecting with the MYSQL server and also make sure that XAMPP is running.

Re: Server fails to - Geeboi_Mehdi - 03.02.2013

pawn Code:

#include <a_samp>
#include <a_mysql>
#include <streamer>
#include <utils>

stock SetPlayerPosOb(playerid, Float:x, Float:y, Float:z){
    Streamer_UpdateEx(playerid,x,y,z);
    return SetTimerEx("SetPlayerPosPublic",0,0,"ifff",playerid,x,y,z);
}
forward SetPlayerPosPublic(playerid,Float:x,Float:y,Float:z);
public SetPlayerPosPublic(playerid,Float:x,Float:y,Float:z)
{
    SetPlayerPos(playerid,x,y,z);
    return 1;
}
#define SetPlayerPos SetPlayerPosOb

main()
{
    print("\n----------------------------------");
    print(" Life of Flying | By Mehdi");
    print("----------------------------------\n");
}

AntiDeAMX()
{
    new a[][] =
    {
        "Unarmed (Fist)",
        "Brass K"
    };
    #pragma unused a
}
#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_PASS "...."
#define SQL_DB "lof"
#define TABLENAME "users"

#undef MAX_PLAYERS
#define MAX_PLAYERS (51) // 50 - amount of max slots

Here
btw i bought this server

Re: Server fails to - T0pAz - 03.02.2013

Quote:

Originally Posted by Geeboi_Mehdi

pawn Code:

#include <a_samp>
#include <a_mysql>
#include <streamer>
#include <utils>

stock SetPlayerPosOb(playerid, Float:x, Float:y, Float:z){
    Streamer_UpdateEx(playerid,x,y,z);
    return SetTimerEx("SetPlayerPosPublic",0,0,"ifff",playerid,x,y,z);
}
forward SetPlayerPosPublic(playerid,Float:x,Float:y,Float:z);
public SetPlayerPosPublic(playerid,Float:x,Float:y,Float:z)
{
    SetPlayerPos(playerid,x,y,z);
    return 1;
}
#define SetPlayerPos SetPlayerPosOb

main()
{
    print("\n----------------------------------");
    print(" Life of Flying | By Mehdi");
    print("----------------------------------\n");
}

AntiDeAMX()
{
    new a[][] =
    {
        "Unarmed (Fist)",
        "Brass K"
    };
    #pragma unused a
}
#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_PASS "Nicolay90"
#define SQL_DB "lof"
#define TABLENAME "users"

#undef MAX_PLAYERS
#define MAX_PLAYERS (51) // 50 - amount of max slots

Here
btw i bought this server

Mate, you just showed your password. I only wanted to see how you are connecting it.

Re: Server fails to - Djean - 03.02.2013

What did the MYSQL return and say? Are you connected or not?

Re: Server fails to - Geeboi_Mehdi - 03.02.2013

i asked this person to fix it he did and got banned from samp forums before he told me how to fix it here is what he said was:

Quote:

Originally Posted by MyNinja

Guess what? GUESS WHAT? I fixed the script.

Here are the images as to my proof.

Clicky, or click me!

If you already have a host, i can do all the server set-up for you

The problem is relating with the MySQL. You did something wrong, so the MySQL server wasn't connected. I've now fixed it, default server slots in the script is set to 51, and the max. slots in server.cfg also set to 51.

There has been some errors while launching the samp-server.exe, maybe you can recognize this?

Code:

sscanf warning: Strings without a length are deprecated, please add a destination size.

Also, do you want me to clear all the data present in the database? Like, clean up everything? When I'm done with everything, i will send you back the file, with instructions on how to connect to the MySQL DB

Re: Server fails to - T0pAz - 03.02.2013

Quote:

Originally Posted by Geeboi_Mehdi

i asked this person to fix it he did and got banned from samp forums before he told me how to fix it here is what he said was:

You are not connected to the Mysql server. You need to start your XAMPP server.

Re: Server fails to - Geeboi_Mehdi - 03.02.2013

okay i run it and i clicked mysql and start pics:

what now?

Re: Server fails to - T0pAz - 03.02.2013

Change the port number to 7577 by going to the config.

Re: Server fails to - Geeboi_Mehdi - 03.02.2013

i did it its just say its
11:24:49 PM [main] All prerequisites found
11:24:49 PM [main] Initializing Modules
11:24:50 PM [main] Starting Check-Timer
11:24:50 PM [main] Control Panel Ready
11:24:54 PM [mysql] Attempting to start MySQL service...
11:24:56 PM [mysql] Status change detected: running
11:25:00 PM [main] Executing "c:\xampp\mysql"
11:25:36 PM [mysql] Status change detected: stopped
11:25:36 PM [mysql] Error: MySQL shutdown unexpectedly.
11:25:36 PM [mysql] This may be due to a blocked port, missing dependencies,
11:25:36 PM [mysql] improper privileges, a crash, or a shutdown by another method.
11:25:36 PM [mysql] Check the "/xampp/mysql/data/mysql_error.log" file
11:25:36 PM [mysql] and the Windows Event Viewer for more clues
11:25:47 PM [mysql] Attempting to start MySQL service...
11:25:55 PM [mysql] Attempting to start MySQL service...
11:25:55 PM [mysql] Attempting to start MySQL service...
11:25:57 PM [mysql] Attempting to start MySQL service...