[SERVER][ LINUX ] Msql Problem

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 liebe Braedfish User ,
    Ich hab lange gerabeitet für ein Selfmade , 2 Moante ca. Als alles fkt hat schaute ich kurz in Server_log Datei rein und sah das


    [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:27] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:27] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:27] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:41] Playerid: 0, Dialogid: 1, Response: 1 Listitem: -1 Inputtext:
    [20:39:43] Playerid: 0, Dialogid: 2, Response: 1 Listitem: -1 Inputtext: yawar123
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:43] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] Playerid: 0, Dialogid: 0, Response: 1 Listitem: -1 Inputtext: yawar123
    [20:39:44] [MySQL] Error (0): Function: mysql_real_escape_string called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] Spieler Yawar wird geladen
    [20:39:44] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:44] Spieler Yawar geladen
    [20:39:44] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:39:47] Playerid: 0, Dialogid: 3, Response: 1 Listitem: -1 Inputtext:
    [20:39:50] Playerid: 0, Dialogid: 89, Response: 0 Listitem: -1 Inputtext:
    [20:40:26] Incoming connection: 91.20.7.225:55901
    [20:40:27] [join] Mr.Chair has joined the server (1:91.20.7.225)
    [20:40:27] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:27] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:27] [MySQL] Error (0): Function: mysql_fetch_int called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:27] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:38] Playerid: 1, Dialogid: 1, Response: 1 Listitem: -1 Inputtext:
    [20:40:40] Playerid: 1, Dialogid: 2, Response: 1 Listitem: -1 Inputtext: david
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:40] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] Playerid: 1, Dialogid: 0, Response: 1 Listitem: -1 Inputtext: david
    [20:40:41] [MySQL] Error (0): Function: mysql_real_escape_string called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] [MySQL] Error (0): Function: mysql_fetch_row called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] Spieler Mr.Chair wird geladen
    [20:40:41] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:41] Spieler Mr.Chair geladen
    [20:40:41] [MySQL] Error (0): Function: mysql_query called when not connected to any database. Can't connect to MySQL server on 'CHANGEME.de' (110).
    [20:40:43] Playerid: 1, Dialogid: 3, Response: 1 Listitem: -1 Inputtext:
    [20:40:45] Playerid: 1, Dialogid: 89, Response: 0 Listitem: -1 Inputtext:
    [20:40:51] [chat] [Mr.Chair]: Yawar
    [20:41:01] [chat] [Mr.Chair]: Du bleibsch mal on
    [20:41:11] Playerid: 0, Dialogid: 80, Response: 1 Listitem: 1 Inputtext: 10000$ Startgeld
    [20:41:14] [chat] [Yawar]: xD
    [20:41:18] [chat] [Mr.Chair]: Yawar
    [20:41:19] /serverinfp
    [20:41:20] /serverinfo
    [20:41:25] [chat] [Mr.Chair]: wilsch du mich verarschen
    [20:41:29] Playerid: 0, Dialogid: 14, Response: 1 Listitem: -1 Inputtext:
    [20:41:34] [chat] [Mr.Chair]: Yawar[pwn]


    Es speichert auch keine Daten halt es speichert nix ?


    Könnt ihr mir bitte Helfen ? Facebook Kontakt Name : Malik Yawar Awan


    Eure 10 Minuten mit mir auf Teamviewer könnten meine 2 Monate retten :) !
    Gegenleistung ist ich mach für euch was ich kann :< Ich will nicht das ich 2 Moante um sonst gesessen bin :>


    Danke Liebe Grüße Yawar

  • Code
    Can't connect to MySQL server on 'CHANGEME.de'


    Da hat wohl wer nicht die richtigen MySQL-Daten drinstehen. ;)
    Das einfach durch die richtigen Daten ersetzen, Nutzername und Kennwort stimmen dann voraussichtlich auch nicht, das ist dann auch anzupassen.

    Ich bin Dittis Signatur.

  • Danke Ditti aber wie meinst du das xD ? Ich versteh dich irgendwie nicht hast du kurz zeit ?
    Könntest kurz in Teamviewer vorbei schauen wär nett von dir :>
    ID : 395 836 432 Kennwort :4564

  • Wir kaufen uns einen neuen mit Samp4you aber das hat eigentlich Super funktoniert vorhin mit Mysql ich mach sicher was falsch :<
    Jetzt kom*** Streamer Plugin v2.6.1 by Incognito unloaded ***


    [21:33:58]


    [21:33:58] ===============================


    [21:33:58] sscanf plugin unloaded.


    [21:33:58] ===============================


    [21:33:58]


    [21:33:58] ______________________________________


    [21:33:58] Encrypt Plugin v0.1 unloaded
    [21:33:58] ______________________________________


    [21:33:58] SA:MP MySQL Plugin v2.1.1 Unloaded.


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


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


    [21:34:01]
    [21:34:01] Server Plugins
    [21:34:01] --------------
    [21:34:01] Loading plugin: streamer.so
    [21:34:01]


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


    [21:34:01] Loaded.
    [21:34:01] Loading plugin: sscanf.so
    [21:34:01]


    [21:34:01] ===============================


    [21:34:01] sscanf plugin loaded.


    [21:34:01] (c) 2009 Alex "Y_Less" Cole


    [21:34:01] ===============================


    [21:34:01] Loaded.
    [21:34:01] Loading plugin: nativechecker.so
    [21:34:01] Loaded.
    [21:34:01] Loading plugin: Encrypt.so
    [21:34:01]


    [21:34:01] ______________________________________


    [21:34:01] Encrypt Plugin v0.1 loaded
    [21:34:01] ______________________________________


    [21:34:01] By: Fro (c) Copyright <TBG> 2009-2010
    [21:34:01] ______________________________________


    [21:34:01] Loaded.
    [21:34:01] Loading plugin: mysql.so
    [21:34:01] SA:MP MySQL Plugin v2.1.1 Loaded.
    [21:34:01] Loaded.
    [21:34:01] [MySQL] Thread running. Threadsafe: Yes.
    [21:34:01] Loaded 5 plugins.


    [21:34:01]
    [21:34:01] Ban list
    [21:34:01] --------
    [21:34:01] Loaded: samp.ban
    [21:34:01]
    [21:34:01]
    [21:34:01] Filterscripts
    [21:34:01] ---------------
    [21:34:01] Loading filterscript 'Autohaus.amx'...
    [21:34:01]
    Copyright (c) by Kaliber


    [21:34:01] Loaded 1 filterscripts.


    [21:34:01] Error: Function not registered: 'mysql_real_escape_string'
    [21:34:01] Error: Function not registered: 'mysql_query'
    [21:34:01] Error: Function not registered: 'mysql_store_result'
    [21:34:01] Error: Function not registered: 'mysql_fetch_row'
    [21:34:01] Error: Function not registered: 'mysql_free_result'
    [21:34:01] Error: Function not registered: 'mysql_fetch_int'
    [21:34:01] Error: Function not registered: 'mysql_num_rows'
    [21:34:01] Error: Function not registered: 'mysql_fetch_field'
    [21:34:01] Error: Function not registered: 'mysql_init'
    [21:34:01] Error: Function not registered: 'mysql_connect'