Problem mit MYSQL ( ERRORS)

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
  • Hey Leute ich habe ein Problem mit MYSQL.
    hier der Serverlog !

    Spoiler anzeigen

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

    Spoiler anzeigen
    SA-MP Dedicated Server
    ----------------------
    v0.3z, (C)2005-2014 SA-MP Team

    Spoiler anzeigen
    [13:55:02]
    [13:55:02] Server Plugins
    [13:55:02] --------------
    [13:55:02] Loading plugin: nativechecker
    [13:55:02] Loaded.
    [13:55:02] Loading plugin: sscanf
    [13:55:02]

    Spoiler anzeigen
    [13:55:02] ===============================

    Spoiler anzeigen
    [13:55:02] sscanf plugin loaded.

    Spoiler anzeigen
    [13:55:02] (c) 2009 Alex "Y_Less" Cole

    Spoiler anzeigen
    [13:55:02] ===============================

    Spoiler anzeigen
    [13:55:02] Loaded.
    [13:55:02] Loading plugin: streamer
    [13:55:02]

    Spoiler anzeigen
    *** Streamer Plugin v2.5.2 by Incognito loaded ***

    Spoiler anzeigen
    [13:55:02] Loaded.
    [13:55:02] Loading plugin: chrashdetect
    [13:55:02] Failed.
    [13:55:02] Loading plugin: mysql
    [13:55:02]

    Spoiler anzeigen
    > MySQL plugin R5 successfully loaded.

    Spoiler anzeigen
    [13:55:02] Loaded.
    [13:55:02] Loaded 4 plugins.

    Spoiler anzeigen
    [13:55:02]
    [13:55:02] Ban list
    [13:55:02] --------
    [13:55:02] Loaded: samp.ban
    [13:55:02]
    [13:55:02]
    [13:55:02] Filterscripts
    [13:55:02] ---------------
    [13:55:02] Loading filterscript 'Antibug.amx'...
    [13:55:02] Loading filterscript 'HelpSystem.amx'...
    [13:55:02]
    --------------------------------------
    [13:55:02] Help System Loadet.
    [13:55:02] --------------------------------------

    Spoiler anzeigen
    [13:55:02] Loading filterscript 'Races.amx'...
    [13:55:02] Loaded 3 filterscripts.

    Spoiler anzeigen
    [13:55:02] Error: Function not registered: 'mysql_store_result'
    [13:55:02] Error: Function not registered: 'mysql_num_rows'
    [13:55:02] Error: Function not registered: 'mysql_fetch_row_format'
    [13:55:02] Error: Function not registered: 'mysql_free_result'
    [13:55:02] Error: Function not registered: 'mysql_debug'
    [13:55:02] Error: Function not registered: 'mysql_connect'
    [13:55:02] Error: Function not registered: 'mysql_close'
    [13:55:02] Error: Function not registered: 'mysql_ping'
    [13:55:02] Error: Function not registered: 'mysql_query'
    [13:55:02] Error: Function not registered: 'dir_exists'
    [13:55:02] Error: Function not registered: 'dir_create'
    [13:55:02] Error: Function not registered: 'file_write'
    [13:55:02] Error: Function not registered: 'mysql_fetch_field_row'
    [13:55:02] Error: Function not registered: 'mysql_real_escape_string'
    [13:55:02] Error: Function not registered: 'mysql_fetch_int'
    [13:55:02] Script[gamemodes/samp.amx]: Run time error 19: "File or function is not found"
    [13:55:02] Number of vehicle models: 0



    ich habe schon alles versucht meine Plugins erneuert und script neu Comp....
    so wie auch die includes aber geht nich ...?


    danke im vorraus :thumbup:

  • ich hab hab den Filemanager eingebaut.
    das andere Problem


    er ladet bis objects und bricht ab ich weiß nur das hat bei mir mit den scriptfiles zu tun wenn ich mich net teusche
    und dir mysql errors kommen immer noch

    Spoiler anzeigen

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

    Spoiler anzeigen
    SA-MP Dedicated Server
    ----------------------
    v0.3z, (C)2005-2014 SA-MP Team

    Spoiler anzeigen
    [14:17:54]
    [14:17:54] Server Plugins
    [14:17:54] --------------
    [14:17:54] Loading plugin: nativechecker
    [14:17:54] Loaded.
    [14:17:54] Loading plugin: mysql
    [14:17:54]

    Spoiler anzeigen
    > MySQL plugin R5 successfully loaded.

    Spoiler anzeigen
    [14:17:54] Loaded.
    [14:17:54] Loading plugin: sscanf
    [14:17:54]

    Spoiler anzeigen
    [14:17:54] ===============================

    Spoiler anzeigen
    [14:17:54] sscanf plugin loaded.

    Spoiler anzeigen
    [14:17:54] (c) 2009 Alex "Y_Less" Cole

    Spoiler anzeigen
    [14:17:54] ===============================

    Spoiler anzeigen
    [14:17:54] Loaded.
    [14:17:54] Loading plugin: streamer
    [14:17:54]

    Spoiler anzeigen
    *** Streamer Plugin v2.5.2 by Incognito loaded ***

    Spoiler anzeigen
    [14:17:54] Loaded.
    [14:17:54] Loading plugin: Filemanager
    [14:17:54] ******************
    [14:17:54] ** FILE MANAGER **
    [14:17:54] ** Loaded **
    [14:17:54] ** Version 1.1 **
    [14:17:54] ******************
    [14:17:54] Loaded.
    [14:17:54] Loaded 5 plugins.

    Spoiler anzeigen
    [14:17:54]
    [14:17:54] Ban list
    [14:17:54] --------
    [14:17:54] Loaded: samp.ban
    [14:17:54]
    [14:17:54]
    [14:17:54] Filterscripts
    [14:17:54] ---------------
    [14:17:54] Loading filterscript 'Antibug.amx'...
    [14:17:54] Loading filterscript 'HelpSystem.amx'...
    [14:17:54]
    --------------------------------------
    [14:17:54] Help System Loadet.
    [14:17:54] --------------------------------------

    Spoiler anzeigen
    [14:17:54] Loading filterscript 'Races.amx'...
    [14:17:54] Loaded 3 filterscripts.

    Spoiler anzeigen
    [14:17:54] Error: Function not registered: 'mysql_store_result'
    [14:17:54] Error: Function not registered: 'mysql_num_rows'
    [14:17:54] Error: Function not registered: 'mysql_fetch_row_format'
    [14:17:54] Error: Function not registered: 'mysql_free_result'
    [14:17:54] Error: Function not registered: 'mysql_debug'
    [14:17:54] Error: Function not registered: 'mysql_connect'
    [14:17:54] Error: Function not registered: 'mysql_close'
    [14:17:54] Error: Function not registered: 'mysql_ping'
    [14:17:54] Error: Function not registered: 'mysql_query'
    [14:17:54] Error: Function not registered: 'dir_exists'
    [14:17:54] Error: Function not registered: 'dir_create'
    [14:17:54] Error: Function not registered: 'file_write'
    [14:17:54] Error: Function not registered: 'mysql_fetch_field_row'
    [14:17:54] Error: Function not registered: 'mysql_real_escape_string'
    [14:17:54] Error: Function not registered: 'mysql_fetch_int'
    [14:17:54] Starte den server
    [14:17:55] MSQL --> hat die Verbindung zur Datenbank aufgebaut
    [14:17:55] OnGamemodeInt: LoadProperty
    [14:17:55] OnGamemodeInt: LoadBiz
    [14:17:55] OnGamemodeInt: LoadSBiz
    [14:17:55] OnGamemodeInt: LoadTankenBiz
    [14:17:55] OnGamemodeInt: LoadGangAutos
    [14:17:55] OnGamemodeInt: LoadStuff
    [14:17:55] OnGamemodeInt: LoadKassenInfo
    [14:17:55] OnGamemodeInt: LoadGangfightZones
    [14:17:55] Gangwars geladen
    [14:17:55] OnGamemodeInt: LoadGangWarInfos
    [14:17:55] OnGamemodeInt: LoadGangMotds
    [14:17:55] OnGamemodeInt: LoadGangBNDInfos
    [14:17:55] Beginne Gangzonen zu erstellen
    [14:17:55] Textdraws erstelt
    [14:17:55] AntiDeAMX aufgerufen
    [14:17:55] SetGamemodeText RealToleplay4You v.1.6
    [14:17:55] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
    [14:17:55] Beginne Autos zu spawnen
    [14:17:55] >>>>> Autos wurden Gespawnt <<<<<
    [14:17:55] >>>>> Objecte Spawned <<<<<

  • Wegen den Errors: Setzte in deiner server.cfg das crashdetect Plugin an die letzte Stelle.


    Wenn der Server wegen den scriptfiles abstürzt, dann liegt es wohl daran, dass ein Ordner bzw. eine Datei aufgerufen wird, der/die nicht existiert. Prüfe deine Pfade.

  • ok hat sich geklert mit MSVCP100.dll


    jetz sind noch die errors da und dann habe ich debugs bekommen ;( 8|


    Spoiler anzeigen

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

    Spoiler anzeigen
    SA-MP Dedicated Server
    ----------------------
    v0.3z, (C)2005-2014 SA-MP Team

    Spoiler anzeigen
    [14:45:16]
    [14:45:16] Server Plugins
    [14:45:16] --------------
    [14:45:16] Loading plugin: nativechecker
    [14:45:16] Loaded.
    [14:45:16] Loading plugin: mysql
    [14:45:16]

    Spoiler anzeigen
    > MySQL plugin R5 successfully loaded.

    Spoiler anzeigen
    [14:45:16] Loaded.
    [14:45:16] Loading plugin: sscanf
    [14:45:16]

    Spoiler anzeigen
    [14:45:16] ===============================

    Spoiler anzeigen
    [14:45:16] sscanf plugin loaded.

    Spoiler anzeigen
    [14:45:16] (c) 2009 Alex "Y_Less" Cole

    Spoiler anzeigen
    [14:45:16] ===============================

    Spoiler anzeigen
    [14:45:16] Loaded.
    [14:45:16] Loading plugin: streamer
    [14:45:16]

    Spoiler anzeigen
    *** Streamer Plugin v2.5.2 by Incognito loaded ***

    Spoiler anzeigen
    [14:45:16] Loaded.
    [14:45:16] Loading plugin: Filemanager
    [14:45:16] ******************
    [14:45:16] ** FILE MANAGER **
    [14:45:16] ** Loaded **
    [14:45:16] ** Version 1.1 **
    [14:45:16] ******************
    [14:45:16] Loaded.
    [14:45:16] Loading plugin: crashdetect
    [14:45:16] crashdetect v4.8.5 is OK.
    [14:45:16] Loaded.
    [14:45:16] Loaded 6 plugins.

    Spoiler anzeigen
    [14:45:16]
    [14:45:16] Ban list
    [14:45:16] --------
    [14:45:16] Loaded: samp.ban
    [14:45:16]
    [14:45:16]
    [14:45:16] Filterscripts
    [14:45:16] ---------------
    [14:45:16] Loading filterscript 'Antibug.amx'...
    [14:45:16] Loading filterscript 'HelpSystem.amx'...
    [14:45:16]
    --------------------------------------
    [14:45:16] Help System Loadet.
    [14:45:16] --------------------------------------

    Spoiler anzeigen
    [14:45:16] Loading filterscript 'Races.amx'...
    [14:45:17] Loaded 3 filterscripts.

    Spoiler anzeigen
    [14:45:17] Error: Function not registered: 'mysql_store_result'
    [14:45:17] Error: Function not registered: 'mysql_num_rows'
    [14:45:17] Error: Function not registered: 'mysql_fetch_row_format'
    [14:45:17] Error: Function not registered: 'mysql_free_result'
    [14:45:17] Error: Function not registered: 'mysql_debug'
    [14:45:17] Error: Function not registered: 'mysql_connect'
    [14:45:17] Error: Function not registered: 'mysql_close'
    [14:45:17] Error: Function not registered: 'mysql_ping'
    [14:45:17] Error: Function not registered: 'mysql_query'
    [14:45:17] Error: Function not registered: 'dir_exists'
    [14:45:17] Error: Function not registered: 'dir_create'
    [14:45:17] Error: Function not registered: 'file_write'
    [14:45:17] Error: Function not registered: 'mysql_fetch_field_row'
    [14:45:17] Error: Function not registered: 'mysql_real_escape_string'
    [14:45:17] Error: Function not registered: 'mysql_fetch_int'
    [14:45:17] Starte den server
    [14:45:18] MSQL --> hat die Verbindung zur Datenbank aufgebaut
    [14:45:18] OnGamemodeInt: LoadProperty
    [14:45:18] OnGamemodeInt: LoadBiz
    [14:45:18] OnGamemodeInt: LoadSBiz
    [14:45:18] OnGamemodeInt: LoadTankenBiz
    [14:45:18] OnGamemodeInt: LoadGangAutos
    [14:45:18] OnGamemodeInt: LoadStuff
    [14:45:18] OnGamemodeInt: LoadKassenInfo
    [14:45:18] OnGamemodeInt: LoadGangfightZones
    [14:45:18] Gangwars geladen
    [14:45:18] OnGamemodeInt: LoadGangWarInfos
    [14:45:18] OnGamemodeInt: LoadGangMotds
    [14:45:18] OnGamemodeInt: LoadGangBNDInfos
    [14:45:18] Beginne Gangzonen zu erstellen
    [14:45:18] Textdraws erstelt
    [14:45:18] AntiDeAMX aufgerufen
    [14:45:18] SetGamemodeText RealToleplay4You v.1.6
    [14:45:18] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
    [14:45:18] Beginne Autos zu spawnen
    [14:45:18] >>>>> Autos wurden Gespawnt <<<<<
    [14:45:18] >>>>> Objecte Spawned <<<<<
    [14:45:18] [debug] Server crashed while executing samp.amx
    [14:45:18] [debug] AMX backtrace:
    [14:45:18] [debug] #0 native fwrite () [004056e0] from samp-server.exe
    [14:45:18] [debug] #1 00070e38 in ?? () from samp.amx
    [14:45:18] [debug] #2 000a697c in ?? () from samp.amx
    [14:45:18] [debug] #3 0022d99c in ?? () from samp.amx
    [14:45:18] [debug] #4 0009fa58 in public OnGameModeInit () from samp.amx
    [14:45:18] [debug] System backtrace:
    [14:45:18] [debug] #0 00493990 in ?? () from C:\Users\Robert\Desktop\Original\Roleplay 4 you\samp-server.exe
    [14:45:18] [debug] #1 0040531e in ?? () from C:\Users\Robert\Desktop\Original\Roleplay 4 you\samp-server.exe

  • Ich nehme mal an das es auf einem Root läuft


    Wenn ja haste bei der Server.cfg bei den plugins .so geschrieben ?