Script läuft nicht! //edit

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Hallo Breadfish Community,
    Ich habe das Problem dass ich unser Selfmade nicht zum laufen bekomme!


    Ich habe bereits versucht einen localhost Server (auf dem PC) zu errichten, dort hat alles funktioniert!
    Auch als ich im localhost die Datenbank auf die von meinem Server geleitet hatte (via IP) ging der localhost trotzdem reibungslos...



    Sobald ich das Script aber auf unseren Linux Server lege springt der Server nicht mehr an...


    Hier ist die Serverlog:



    Hier ist die MySQL Verbindung definiert:
    new MySQLConnection; //MySQL_Host, MySQL_User, MySQL_DB, MySQL_Passwort#define MySQL_Host "127.0.0.1"#define MySQL_User "server2"#define MySQL_DB "server2"#define MySQL_Passwort "sstYu4722bXs9DHZ"#endif



    Und das steht im public OnGameModeInit():


    public OnGameModeInit(){//GeschenkeSpawnen();//GStimer = SetTimer("GeschenkeSpawnen", GESCHENK_ZEIT*60*1000,1);printf("Starte den server"); //<--- Nach diesem Satz Crasht der Server "Siehe Serverlog"mysql_debug(0);//um alles MySQL zu debuggen 0 = Aus -> 1 = Annew string[MAX_PLAYER_NAME],string1[MAX_PLAYER_NAME],string2[256];#if defined MySQLMySQLConnection = mysql_connect(MySQL_Host, MySQL_User, MySQL_DB, MySQL_Passwort);printf("MSQL --> hat die Verbindung zur Datenbank aufgebaut");#endif

    Einmal editiert, zuletzt von NcDeluxe ()

  • Die Plugins werden alle ordnungsgemäß geladen...

    Das spielt keine Rolle, die Informationen über die Version sind ebenfalls wichtig.



    Das Problem ist wie ich vermute der Verbindungsaufbau zu MySQL

    Nein, das ist nicht das Problem.
    Die Fehlermeldung kommt, weil das Plugin entweder nicht geladen wird, nicht geladen werden kann, oder eine falsche Version ist.

  • //edit
    Das ist die Server Log:


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


    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team


    [17:24:16] filterscripts = "" (string)
    [17:24:16]
    [17:24:16] Server Plugins
    [17:24:16] --------------
    [17:24:16] Loading plugin: mysql.so
    [17:24:16] >> plugin.mysql: R41-4 successfully loaded.
    [17:24:16] Loaded.
    [17:24:16] Loading plugin: crashdetect.so
    [17:24:16] CrashDetect v4.17 is OK.
    [17:24:16] Loaded.
    [17:24:16] Loading plugin: Filemanager.so
    [17:24:16] ******************
    [17:24:16] ** FILE MANAGER **
    [17:24:16] ** Loaded **
    [17:24:16] ** Version 1.1 **
    [17:24:16] ******************
    [17:24:16] Loaded.
    [17:24:16] Loading plugin: streamer.so
    [17:24:16]


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


    [17:24:16] Loaded.
    [17:24:16] Loaded 4 plugins.


    [17:24:16]
    [17:24:16] Ban list
    [17:24:16] --------
    [17:24:16] Loaded: samp.ban
    [17:24:16]
    [17:24:16]
    [17:24:16] Filterscripts
    [17:24:16] ---------------
    [17:24:16] Loaded 0 filterscripts.


    [17:24:16] [debug] Run time error 19: "File or function is not found"
    [17:24:16] [debug] mysql_store_result
    [17:24:16] [debug] mysql_num_rows
    [17:24:16] [debug] mysql_fetch_row_format
    [17:24:16] [debug] mysql_free_result
    [17:24:16] [debug] mysql_debug
    [17:24:16] [debug] mysql_ping
    [17:24:16] [debug] mysql_fetch_field_row
    [17:24:16] [debug] mysql_real_escape_string
    [17:24:16] [debug] mysql_fetch_int
    [17:24:16] [debug] Run time error 19: "File or function is not found"
    [17:24:16] [debug] mysql_store_result
    [17:24:16] [debug] mysql_num_rows
    [17:24:16] [debug] mysql_fetch_row_format
    [17:24:16] [debug] mysql_free_result
    [17:24:16] [debug] mysql_debug
    [17:24:16] [debug] mysql_ping
    [17:24:16] [debug] mysql_fetch_field_row
    [17:24:16] [debug] mysql_real_escape_string
    [17:24:16] [debug] mysql_fetch_int
    [17:24:16] Script[gamemodes/richtig.amx]: Run time error 19: "File or function is not found"
    [17:24:16] Number of vehicle models: 0

    Einmal editiert, zuletzt von NcDeluxe ()

  • Du benutzt die falsche Include Version.
    Lad dir hier: Klick
    Das win32 Paket runter, da ist auch eine Include dabei, die ziehst du dann in deinen Pawno Include Ordner, und compilest das Script einmal neu.

  • Dann kommt dieser Fehler mit der MySQL R5:



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


    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team


    [17:12:36] filterscripts = "" (string)
    [17:12:36]
    [17:12:36] Server Plugins
    [17:12:36] --------------
    [17:12:36] Loading plugin: mysql.so
    [17:12:36]


    > MySQL plugin R5 successfully loaded.


    [17:12:36] Loaded.
    [17:12:36] Loading plugin: crashdetect.so
    [17:12:36] CrashDetect v4.17 is OK.
    [17:12:36] Loaded.
    [17:12:36] Loading plugin: Filemanager.so
    [17:12:36] ******************
    [17:12:36] ** FILE MANAGER **
    [17:12:36] ** Loaded **
    [17:12:36] ** Version 1.1 **
    [17:12:36] ******************
    [17:12:36] Loaded.
    [17:12:36] Loading plugin: streamer.so
    [17:12:36]


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


    [17:12:36] Loaded.
    [17:12:36] Loaded 4 plugins.


    [17:12:36]
    [17:12:36] Ban list
    [17:12:36] --------
    [17:12:36] Loaded: samp.ban
    [17:12:36]
    [17:12:36]
    [17:12:36] Filterscripts
    [17:12:36] ---------------
    [17:12:36] Loaded 0 filterscripts.


    [17:12:37] Starte den server
    [17:12:37] [debug] Server crashed while executing richtig.amx
    [17:12:37] [debug] AMX backtrace:
    [17:12:37] [debug] #0 native mysql_connect () from mysql.so
    [17:12:37] [debug] #1 0007e0c8 in public OnGameModeInit () from richtig.amx
    [17:12:37] [debug] Native backtrace:
    [17:12:37] [debug] #0 f6a2eca0 in _Z13GetStackTraceRSt6vectorI10StackFrameSaIS0_EEPv () from plugins/crashdetect.so
    [17:12:37] [debug] #1 f6a27d22 in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
    [17:12:37] [debug] #2 f6a28314 in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
    [17:12:37] [debug] #3 f6a2a964 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
    [17:12:37] [debug] #4 f6a2e5cd in ?? () from plugins/crashdetect.so
    [17:12:37] [debug] #5 f773fc90 in __kernel_rt_sigreturn () from linux-gate.so.1
    [17:12:37] [debug] #6 f72ac35b in ?? () from plugins/mysql.so
    [17:12:37] [debug] #7 f72af377 in ?? () from plugins/mysql.so
    [17:12:37] [debug] #8 f72bf116 in ?? () from plugins/mysql.so
    [17:12:37] [debug] #9 f72bf7c0 in my_xml_parse () from plugins/mysql.so
    [17:12:37] [debug] #10 f72af28a in my_parse_charset_xml () from plugins/mysql.so
    [17:12:37] [debug] #11 f72ac283 in ?? () from plugins/mysql.so
    [17:12:37] [debug] #12 f72acac5 in ?? () from plugins/mysql.so
    [17:12:37] [debug] #13 f72acd00 in get_charset_by_csname () from plugins/mysql.so
    [17:12:37] [debug] #14 f72c0e73 in mysql_init_character_set () from plugins/mysql.so
    [17:12:37] [debug] #15 f72c2e12 in mysql_real_connect () from plugins/mysql.so
    [17:12:37] [debug] #16 f7299508 in _ZN13CMySQLHandler7ConnectEv () from plugins/mysql.so
    [17:12:37] [debug] #17 f729aae0 in _ZN13CMySQLHandlerC1ESsSsSsSs () from plugins/mysql.so
    [17:12:37] [debug] #18 f729f8cc in _ZN15NativeFunctions15n_mysql_connectEP6tagAMXPi () from plugins/mysql.so
    [17:12:37] [debug] #19 080950e4 in ?? () from ./samp03svr
    [17:12:37] [debug] #20 f6a297b3 in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
    [17:12:37] [debug] #21 08b56308 in ?? () from ·o÷Hµo÷¤›Ð¤›Ð¥ŸÐ¤›Ð ¡Ð¤£ÐDp÷

  • #include <a_samp>
    #include <streamer>
    #include <mysql>
    #include <a_mysql>
    #include <ocmd>
    #include <float>
    #include <time>
    #include <file>
    #include <dutils>
    #include <Dini>
    #include <ocmd>
    #include <wbb_connect>
    //#include <Waffenhack>
    //#include <Junkbuster>

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


    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team


    [17:48:25] filterscripts = "" (string)
    [17:48:25]
    [17:48:25] Server Plugins
    [17:48:25] --------------
    [17:48:25] Loading plugin: mysql.so
    [17:48:25]


    > MySQL plugin R5 successfully loaded.


    [17:48:25] Loaded.
    [17:48:25] Loading plugin: crashdetect.so
    [17:48:25] CrashDetect v4.17 is OK.
    [17:48:25] Loaded.
    [17:48:25] Loading plugin: Filemanager.so
    [17:48:25] ******************
    [17:48:25] ** FILE MANAGER **
    [17:48:25] ** Loaded **
    [17:48:25] ** Version 1.1 **
    [17:48:25] ******************
    [17:48:25] Loaded.
    [17:48:25] Loading plugin: streamer.so
    [17:48:25]


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


    [17:48:25] Loaded.
    [17:48:25] Loaded 4 plugins.


    [17:48:25]
    [17:48:25] Ban list
    [17:48:25] --------
    [17:48:25] Loaded: samp.ban
    [17:48:25]
    [17:48:26]
    [17:48:26] Filterscripts
    [17:48:26] ---------------
    [17:48:26] Loaded 0 filterscripts.


    [17:48:26] Starte den server
    [17:48:26] [debug] Server crashed while executing richtig.amx
    [17:48:26] [debug] AMX backtrace:
    [17:48:26] [debug] #0 native mysql_connect () from mysql.so
    [17:48:26] [debug] #1 0007e0c8 in public OnGameModeInit () from richtig.amx
    [17:48:26] [debug] Native backtrace:
    [17:48:26] [debug] #0 f6a87ca0 in _Z13GetStackTraceRSt6vectorI10StackFrameSaIS0_EEPv () from plugins/crashdetect.so
    [17:48:26] [debug] #1 f6a80d22 in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
    [17:48:26] [debug] #2 f6a81314 in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
    [17:48:26] [debug] #3 f6a83964 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
    [17:48:26] [debug] #4 f6a875cd in ?? () from plugins/crashdetect.so
    [17:48:26] [debug] #5 f7798c90 in __kernel_rt_sigreturn () from linux-gate.so.1
    [17:48:26] [debug] #6 f730535b in ?? () from plugins/mysql.so
    [17:48:26] [debug] #7 f7308377 in ?? () from plugins/mysql.so
    [17:48:26] [debug] #8 f7318116 in ?? () from plugins/mysql.so
    [17:48:26] [debug] #9 f73187c0 in my_xml_parse () from plugins/mysql.so
    [17:48:26] [debug] #10 f730828a in my_parse_charset_xml () from plugins/mysql.so
    [17:48:26] [debug] #11 f7305283 in ?? () from plugins/mysql.so
    [17:48:26] [debug] #12 f7305ac5 in ?? () from plugins/mysql.so
    [17:48:26] [debug] #13 f7305d00 in get_charset_by_csname () from plugins/mysql.so
    [17:48:26] [debug] #14 f7319e73 in mysql_init_character_set () from plugins/mysql.so
    [17:48:26] [debug] #15 f731be12 in mysql_real_connect () from plugins/mysql.so
    [17:48:26] [debug] #16 f72f2508 in _ZN13CMySQLHandler7ConnectEv () from plugins/mysql.so
    [17:48:26] [debug] #17 f72f3ae0 in _ZN13CMySQLHandlerC1ESsSsSsSs () from plugins/mysql.so
    [17:48:26] [debug] #18 f72f88cc in _ZN15NativeFunctions15n_mysql_connectEP6tagAMXPi () from plugins/mysql.so
    [17:48:26] [debug] #19 080950e4 in ?? () from ./samp03svr
    [17:48:26] [debug] #20 f6a827b3 in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
    [17:48:26] [debug] #21 09c0c308 in ?? () from Gu÷HEu÷¤ûÛ ¤ûÛ ¥ÿÛ ¤ûÛÜ ¤Ü Ôu÷






    //includes



    #pragma dynamic 100000
    #pragma tabsize 0



    #include <a_samp>
    #include <streamer>
    //#include <mysql>
    #include <a_mysql>
    #include <ocmd>
    #include <float>
    #include <time>
    #include <file>
    #include <dutils>
    #include <Dini>
    #include <ocmd>
    #include <wbb_connect>
    //#include <Waffenhack>
    //#include <Junkbuster>