Probleme mit MySQL

CreepyFreaky · 30. Oktober 2016

Hey Leute,

ich habe Probleme, und zwar habe ich im Script die Daten von MySQL alle eingetragen und die existieren auch so und sind richtig eingegeben.
Nun, hier einmal die Log:

Code: server_log

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


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


[13:47:05] 
[13:47:05] Server Plugins
[13:47:05] --------------
[13:47:05]  Loading plugin: crashdetect.so
[13:47:05]   CrashDetect v4.17 is OK.
[13:47:05]   Loaded.
[13:47:05]  Loading plugin: mysql_static.so
[13:47:05]  >> plugin.mysql: R34 successfully loaded.
[13:47:05]   Loaded.
[13:47:05]  Loading plugin: streamer.so
[13:47:05] 


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


[13:47:05]   Loaded.
[13:47:05]  Loading plugin: sscanf.so
[13:47:05] 


[13:47:05]  ===============================


[13:47:05]       sscanf plugin loaded.     


[13:47:05]          Version:  2.8.2        


[13:47:05]    (c) 2012 Alex "Y_Less" Cole  


[13:47:05]  ===============================


[13:47:05]   Loaded.
[13:47:05]  Loading plugin: MapAndreas.so
[13:47:05]   Loaded.
[13:47:05]  Loaded 5 plugins.


[13:47:05] 
[13:47:05] Filterscripts
[13:47:05] ---------------
[13:47:05]   Loading filterscript 'TD.amx'...
[13:47:05] 
--------------------------------------
[13:47:05]  Text Draw Editor 1.0RC2 by Zamaroht for SA-MP 0.3 Loaded.
[13:47:05] --------------------------------------


[13:47:05]   Loading filterscript 'cameditor.amx'...
[13:47:05] 
--------------------------------------
[13:47:05]  CamEditor by Drebin
[13:47:05] --------------------------------------


[13:47:05]   Loading filterscript 'material.amx'...
[13:47:05]        ____________________________
[13:47:05]       |-Text Object Editor Loaded- |
[13:47:05]       |   Scripted by irinel1996   |
[13:47:05]       |    Copyright © 2012-2013   |
[13:47:05]       |      Keep the credits!     |
[13:47:05]       |____________________________|
[13:47:05]   Loading filterscript 'ls_elevator.amx'...
[13:47:05]   Loaded 4 filterscripts.


[13:47:06] [MYSQL]: Verbindung zur Datenbank samp fehlgeschlagen!
[13:47:07] [ - SCRIPT - ] Objekte werden geladen...
[13:47:07] [ - SCRIPT - ] 4924 Objecte wurden erfolgreich in 8 Millisekunden geladen!
[13:47:07] ----------------------------------
[13:47:07]  Voltage Reallife by Shanon
[13:47:07]  Scripting by Shanon & Blacktaro
[13:47:07] 
Heapspace: 65900 | 16364
[13:47:07] ----------------------------------
[13:47:07] ====================================================
[13:47:07] Number of vehicle models: 0
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `frakinfo`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `tanken`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `fahrzeugmodelinfo`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `autohauser`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `kaufautos`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `parks`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `feuerstellen`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `flammen`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `fraktionscars`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `hausinterior`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `hausinfo`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `haustoplayer` JOIN `accounts` WHERE `haustoplayer`.`Status` = 2 AND `haustoplayer`.`spielerid` = `accounts`.`userID`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `gangwarinfo`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `angelgebiete`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `orgainfo`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `pfandflaschen`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `wbschilder`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `blitzer`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `elektrikinfo`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `drogeninfo`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `pickups`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `pickups_enterexit`
[13:47:07] [MYSQL-ERROR] 2006 - MySQL server has gone away in Callback OnQueryFinish on connection 1
[13:47:07] [MYSQL-ERROR] SELECT * FROM `serverinfo` LIMIT 1;

Alles anzeigen

Mysql_Log:

PHP: mysql_log.txt

[13:47:06] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:06] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:06] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:06] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:06] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:06] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:06] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:06] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [WARNING] cache_get_row_count - no active cache
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[13:47:07] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[13:47:07] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[13:47:07] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Alles anzeigen

Ich hab schon alles versucht, geht aber nichts.

Jeffry · 30. Oktober 2016

Versuche anstatt "localhost" in den Verbindungsdaten "127.0.0.1" zu nutzen, oder andersherum.

Probleme mit MySQL

breadfish.de 12. März 2022

Ähnliche Themen

Neuer PC und der Server funktioniert nicht

samp server. exe Systemfehler

Server Startet nicht

Probleme mit mysql

Spieler wird nicht gespeichert

Probleme mit den Plugins habe eig soweit alle drinne !???