MYSQL Fehler (no PRP) !

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
  • [17:15:33] *** Streamer Plugin: Include file version (0) does not match plugin version (0x26104) (script needs to be recompiled with the latest include file)
    [17:15:33] *** Streamer Plugin: Obsolete or invalid native found (script needs to be recompiled with the latest include file)
    [17:15:33] OnGameo
    [17:15:33] [MySQL] Connected (0) to 'samp'@'localhost via TCP/IP'.
    [17:15:33] [MySQL] Server Version 5.5.16-log.
    [17:15:33] MySQL-Verbindung wurde erfolgreich hergestellt
    [17:15:33] Wetter ID: 5
    [17:15:33] [MySQL] Error (0): Failed to exeute query. Table 'dsz.wetter' doesn't exist.
    [17:15:33] [MySQL] Error (0): Failed to exeute query. Table 'dsz.drogen' doesn't exist.
    [17:15:33] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'dsz.drogen' doesn't exist.
    [17:15:33] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Table 'dsz.drogen' doesn't exist.
    [17:15:33] [debug] Server crashed while executing D.S.Z224.amx
    [17:15:33] [debug] Backtrace (most recent call first):
    [17:15:33] [debug] #0 fb68a3d4 in ?? () from D.S.Z224.amx
    [17:15:33] [debug] #1 000a21f0 in SSCANF_OnGameModeInit () from D.S.Z224.amx
    [17:15:33] [debug] #2 ???????? in native CallLocalFunction () from samp-server.exe
    [17:15:33] [debug] #3 000031ec in Streamer_OnGameModeInit () from D.S.Z224.amx
    [17:15:33] [debug] #4 ???????? in native CallLocalFunction () from samp-server.exe
    [17:15:33] [debug] #5 00001f6c in Itter_OnGameModeInit () from D.S.Z224.amx
    [17:15:33] [debug] #6 ???????? in native CallLocalFunction () from samp-server.exe
    [17:15:33] [debug] #7 00000824 in OnGameModeInit () from D.S.Z224.amx



    welchen fehler hab ich hier ich habe keine ahnung was das bedeutet


    bitte helfen danke


  • [17:15:33] [MySQL] Error (0): Failed to exeute query. Table 'dsz.wetter' doesn't exist.
    [17:15:33] [MySQL] Error (0): Failed to exeute query. Table 'dsz.drogen' doesn't exist.
    [17:15:33] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'dsz.drogen' doesn't exist.
    [17:15:33] [MySQL] Error (0): Function: mysql_fetch_field called when no result stored. Table 'dsz.drogen' doesn't exist.
    Das sagt dir, dass die Tabellen nicht existieren, du musst sie erstellen.

  • bin gerade dabei die sql datenbank zu erstellen scriptfiles hab ich ale erstellt hast du zufällig die db?


    Hier nochmal die erstellte db + log



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


    SA-MP Dedicated Server
    ----------------------
    v0.3x, (C)2005-2013 SA-MP Team


    [17:20:20] filterscripts = "" (string)
    [17:20:20]
    [17:20:20] Server Plugins
    [17:20:20] --------------
    [17:20:20] Loading plugin: mysql
    [17:20:20] SA:MP MySQL Plugin v2.1.1 Loaded.
    [17:20:20] Loaded.
    [17:20:20] Loading plugin: streamer
    [17:20:20] [MySQL] Thread running. Threadsafe: Yes.
    [17:20:20]


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


    [17:20:20] Loaded.
    [17:20:20] Loading plugin: sscanf
    [17:20:20]


    [17:20:20] ===============================


    [17:20:20] sscanf plugin loaded.


    [17:20:20] Version: 2.8.1


    [17:20:20] (c) 2012 Alex "Y_Less" Cole


    [17:20:20] ===============================


    [17:20:20] Loaded.
    [17:20:20] Loading plugin: crashdetect
    [17:20:20] crashdetect v4.5.1 is OK.
    [17:20:20] Loaded.
    [17:20:20] Loaded 4 plugins.


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


    [17:20:20] *** Streamer Plugin: Include file version (0) does not match plugin version (0x26104) (script needs to be recompiled with the latest include file)
    [17:20:20] *** Streamer Plugin: Obsolete or invalid native found (script needs to be recompiled with the latest include file)
    [17:20:20] OnGameo
    [17:20:20] [MySQL] Connected (0) to 'samp'@'localhost via TCP/IP'.
    [17:20:20] [MySQL] Server Version 5.5.16-log.
    [17:20:20] MySQL-Verbindung wurde erfolgreich hergestellt
    [17:20:20] Wetter ID: 9
    [17:20:20] [debug] Server crashed while executing D.S.Z224.amx
    [17:20:20] [debug] Backtrace (most recent call first):
    [17:20:20] [debug] #0 ???????? in native mysql_fetch_field () from mysql.DLL
    [17:20:20] [debug] #1 0000ca40 in ?? () from D.S.Z224.amx
    [17:20:20] [debug] #2 000a0538 in ?? () from D.S.Z224.amx
    [17:20:20] [debug] #3 000a21ec in SSCANF_OnGameModeInit () from D.S.Z224.amx
    [17:20:20] [debug] #4 ???????? in native CallLocalFunction () from samp-server.exe
    [17:20:20] [debug] #5 000031ec in Streamer_OnGameModeInit () from D.S.Z224.amx
    [17:20:20] [debug] #6 ???????? in native CallLocalFunction () from samp-server.exe
    [17:20:20] [debug] #7 00001f6c in Itter_OnGameModeInit () from D.S.Z224.amx
    [17:20:20] [debug] #8 ???????? in native CallLocalFunction () from samp-server.exe
    [17:20:20] [debug] #9 00000824 in OnGameModeInit () from D.S.Z224.amx


    geladene db

  • Kommen wir vonder halbstarken Rechtsberatung vom Gebrauch fremdkreiierter Produkte wieder zurück zu seinem mySQL-Problem. Das fänd ich Klasse.


    Mein CS:GO Server: 62.75.168.39:27016


    Ich bin so hungrig, dass ich vor lauter Durst nicht weiß, was ich rauchen soll - so müde bin ich!
    Freedom is just another word for 'Nothing left to lose'

  • Also ich habe streamer + mysql + sscanf upgedatet danach kommt nurnoch dieser kleine error



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


    SA-MP Dedicated Server
    ----------------------
    v0.3x, (C)2005-2013 SA-MP Team


    [18:04:46] filterscripts = "" (string)
    [18:04:46]
    [18:04:46] Server Plugins
    [18:04:46] --------------
    [18:04:46] Loading plugin: mysql
    [18:04:46] SA:MP MySQL Plugin v2.1.1 Loaded.
    [18:04:46] Loaded.
    [18:04:46] Loading plugin: streamer
    [18:04:46] [MySQL] Thread running. Threadsafe: Yes.
    [18:04:46]


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


    [18:04:46] Loaded.
    [18:04:46] Loading plugin: sscanf
    [18:04:46]


    [18:04:46] ===============================


    [18:04:46] sscanf plugin loaded.


    [18:04:46] Version: 2.8.1


    [18:04:46] (c) 2012 Alex "Y_Less" Cole


    [18:04:46] ===============================


    [18:04:46] Loaded.
    [18:04:46] Loading plugin: crashdetect
    [18:04:46] crashdetect v4.5.1 is OK.
    [18:04:46] Loaded.
    [18:04:46] Loaded 4 plugins.


    [18:04:46]
    [18:04:46] Ban list
    [18:04:46] --------
    [18:04:46] Loaded: samp.ban
    [18:04:46]
    [18:04:46]
    [18:04:46] Filterscripts
    [18:04:46] ---------------
    [18:04:46] Loaded 0 filterscripts.


    [18:04:46] [MySQL] Connected (0) to 'samp'@'localhost via TCP/IP'.
    [18:04:46] [MySQL] Server Version 5.5.16-log.
    [18:04:46] MySQL-Verbindung wurde erfolgreich hergestellt
    [18:04:46] Wetter ID: 3
    [18:04:46] [debug] Run time error 6: "Invalid instruction"
    [18:04:46] [debug] Unknown opcode 0x232c at address 0x00001A54
    [18:04:46] [debug] Backtrace (most recent call first):
    [18:04:46] [debug] #0 00001a54 in ?? () from D.S.Z224.amx
    [18:04:46] [debug] #1 000a13f4 in ?? () from D.S.Z224.amx
    [18:04:46] [debug] #2 000023d4 in Itter_OnGameModeInit () from D.S.Z224.amx
    [18:04:46] [debug] #3 ???????? in native CallLocalFunction () from samp-server.exe
    [18:04:46] [debug] #4 00000824 in OnGameModeInit () from D.S.Z224.amx
    [18:04:46] _______________________________________
    [18:04:46] Das Script wurde Vollständig geladen!
    [18:04:46] editet by [D.S.Z]M4rciii
    [18:04:46] _______________________________________
    [18:04:46]
    [18:04:46] Number of vehicle models: 0