MySQL Error

Programmmagic · 14. Mai 2016

Guten Tag,
ich wollte gerade meinen Server starten doch dann kommt dieser Error mit MySQL. Ich weiß nicht woran es liegt wenn ich die Datei öffne also "samp-Server" läd es etwas und dann wird es auch gleich wieder geschlossen.
weiß jmd darüber genauer bescheid?

Spoiler anzeigen

LG
Programmmagic

shoxinat0r · 14. Mai 2016

Ist der MySQL Server an? Es kann anscheinend keine Verbindung aufgebaut werden.
Zeig uns mal bitte die MySQL Log.

Programmmagic · 14. Mai 2016

Spoiler anzeigen

[14:43:51] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:51] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:52] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:53] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[14:43:53] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'FrakMembers' in 'field list'
[16:42:40] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[16:42:40] [WARNING] CMySQLHandle::Create - connection already exists
[16:42:41] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[16:42:41] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[16:42:41] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[16:42:41] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[16:42:41] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[16:42:41] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[16:42:41] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
reconnecting..
[17:20:40] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:20:40] [WARNING] CMySQLHandle::Create - connection already exists
[17:20:41] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:20:41] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[17:20:41] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:20:41] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:20:41] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:20:41] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:20:41] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:20:41] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:22:17] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:22:17] [WARNING] CMySQLHandle::Create - connection already exists
[17:22:18] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:22:18] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[17:22:18] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:22:18] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:22:18] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:22:18] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:22:18] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:22:18] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:22:18] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:22:22] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:22:22] [WARNING] CMySQLHandle::Create - connection already exists
[17:22:23] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:22:23] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[17:22:23] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:22:23] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:22:23] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:22:23] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:22:23] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:22:23] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:22:23] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
reconnecting..
[17:23:02] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:23:02] [WARNING] CMySQLHandle::Create - connection already exists
[17:23:03] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:23:03] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[17:23:03] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:23:03] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:23:03] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:23:03] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:23:03] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
reconnecting..
[17:23:34] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:23:34] [WARNING] CMySQLHandle::Create - connection already exists
[17:23:35] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:23:35] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[17:23:35] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:23:35] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:23:35] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:23:35] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
reconnecting..
[17:23:40] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:23:40] [WARNING] CMySQLHandle::Create - connection already exists
[17:23:41] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:23:41] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[17:23:41] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:23:41] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:23:41] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:23:41] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:23:41] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:23:41] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:24:27] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:24:27] [WARNING] CMySQLHandle::Create - connection already exists
[17:24:28] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:24:28] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[17:24:28] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:24:28] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:24:28] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #2006) MySQL server has gone away
[17:24:28] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:24:28] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:24:28] [WARNING] CMySQLQuery::Execute[OnQueryFinish(siii)] - lost connection, reconnecting..
[17:24:28] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..

shoxinat0r · 14. Mai 2016

Code

[16:42:41] [ERROR] CMySQLHandle::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)

Passen die Zugangsdaten vom MySQL Server? Er kann nämlich nicht verbinden.

Programmmagic · 14. Mai 2016

Wie kann ich die ändern? wollte mir nähmlich ein Script anschaun

shoxinat0r · 14. Mai 2016

Das müsstest du im Script sehen können. Eventuell ist das direkt oben definiert.

Programmmagic · 14. Mai 2016

bei den includes steht:

Code

#include </MySQL_Verbindungen/MySQL_Localhost>

shoxinat0r · 14. Mai 2016

Kannst du den Inhalt der Include mal posten?

Programmmagic · 14. Mai 2016

weiß meinst du was soll ich dir schicken?

seegras · 14. Mai 2016

Zensier einfach das Passwort und poste den Rest der include hier rein

shoxinat0r · 14. Mai 2016

Zitat von Programmmagic

weiß meinst du was soll ich dir schicken?

Den Inhalt dieser Include, die du oben angegeben hast. Das Passwort kannst du, wie @seegras sagte, zensieren.

Programmmagic · 14. Mai 2016

Code

#define MySQL_Host "localhost"
#define MySQL_User "root"
#define MySQL_Datenbank "circle_of_life_db"
#define MySQL_Passwort ""

Code

#define MySQL_Host "localhost"
#define MySQL_User "root"
#define MySQL_Datenbank "Script"
#define MySQL_Passwort "kevin123"

shoxinat0r · 14. Mai 2016

Okay, super! Passen die Daten von "localhost"?

Programmmagic · 14. Mai 2016

wie meinst du daten wo kann ich das nachschauen?

shoxinat0r · 14. Mai 2016

Zitat von Programmmagic

wie meinst du daten wo kann ich das nachschauen?

Du musst, um das Script auf dem localhost (eigener PC) verwenden zu können, mit dem Programm xampp eine Datenbank erstellen. Hast du das gemacht?

Programmmagic · 14. Mai 2016

nee hab ich nicht es ist jedoch eine Datenbank im Ordner

shoxinat0r · 14. Mai 2016

Dann schau dir mal bitte dieses Tutorial an.

Programmmagic · 14. Mai 2016

Zitat von shoxinat0r

Dann schau dir mal bitte dieses Tutorial an.

bei mir funktioniert dort die Webseite localhost/xampp/ nicht why?

Bilder

shoxinat0r · 14. Mai 2016

Hast du im xampp Controlpanel Apache und MySQL gestartet?

Programmmagic · 14. Mai 2016

ich hab nur das normale Programm gestartet sonst nichts

MySQL Error

Ähnliche Themen

SAMP Server verbindet mit MySQL nicht mehr

Mysql Frage

MYSQL Datenbank verbindung verloren bei GMX

Gamemode Unknown

MySQL Fehler

MySql Connected nicht...