Kennt sich jemand mit MYSQL aus ?

Blacksonny · 22. Februar 2013

Wir haben das RGR Script entbuggt nun haben wir den Server gestartet und das kommt jetzt.

Wir wissen nicht wo der Fehler liegt, aber falls jemand sich auskennt und uns helfen könnte wäre das sehr nett.
Ich könnt auch im Gegenzug für euch was tun. Z.b bin ich Forum-/Teamspeak Techniker. (außer dafür bezahlen).

Mit freundlichen Grüßen,
[VIP]Scarface[VIP]

Kevin1 · 22. Februar 2013

Tach.
Verbindet der anfangs mit MySQL?
Guck mal in die Serverlog ob er die Verbindung dort aufbaut.
Ist der MySQL-Server denn gestartet?
Wurden die Daten richtig in die .pwn eingetragen?

ps. Würde das Script nicht benutzen, da die Veröffentlichung ja nicht gerade gewollt war (soweit ich das jetzt mitbekommen habe).

Blacksonny · 22. Februar 2013

Verbindet der Anfangs mit MYSQL ?
Nein.

Ist der MYSQL-Server denn gestartet ?
Ja müsste es eig. weiß ich aber ehrlich gesagt nicht genau haben phpadmin control panel.

Wurden die Daten richtig in die .pwn eingetragen ?
Ja wurden sie.

Kevin1 · 22. Februar 2013

Geh in die .pwn und kopiere dir die MySQL-Zugangsdaten raus.
Dann versuch dich über phpmyadmin einzuloggen und guck ob die Datenbank existiert.

Blacksonny · 22. Februar 2013

Ja die existieren.

Kevin1 · 22. Februar 2013

"mysql_debug(1);" bei OnGameModeInit einfügen (aber erstmal nachgucken ob "mysql_debug(0);" nicht irgendwo danach steht).
Dann compilen und Server starten.
Dann wird eine Datei namens "mysql_log.txt" erstellt.
Dort werden alle Queries dokumentiert und geschrieben ob die erfolgreich waren.
Einfach dann mal dort gucken.

Blacksonny · 22. Februar 2013

Kevin1 debug ist auch drinnen.

Kann mir keiner per Teamviewer helfen ?

Beavis · 22. Februar 2013

mysql Debug einschalten und dann den Log hier posten von den debug

Blacksonny · 22. Februar 2013

MYSQL_log ist 144 MB groß O.o

Könnt ne Weile dauern ...

Zitat

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_free_result( Connection handle: 0 )

[17:00:16] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_store_result( Connection handle: 0 )

[17:00:16] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_num_rows( Connection handle: 0 )

[17:00:16] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_free_result( Connection handle: 0 )

[17:00:16] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_store_result( Connection handle: 0 )

[17:00:16] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_num_rows( Connection handle: 0 )

[17:00:16] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_free_result( Connection handle: 0 )

[17:00:16] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_store_result( Connection handle: 0 )

[17:00:16] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_num_rows( Connection handle: 0 )

[17:00:16] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_free_result( Connection handle: 0 )

[17:00:16] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_store_result( Connection handle: 0 )

[17:00:16] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_num_rows( Connection handle: 0 )

[17:00:16] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_free_result( Connection handle: 0 )

[17:00:16] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_store_result( Connection handle: 0 )

[17:00:16] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_num_rows( Connection handle: 0 )

[17:00:16] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_free_result( Connection handle: 0 )

[17:00:16] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_store_result( Connection handle: 0 )

[17:00:16] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_num_rows( Connection handle: 0 )

[17:00:16] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_free_result( Connection handle: 0 )

[17:00:16] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_store_result( Connection handle: 0 )

[17:00:16] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_num_rows( Connection handle: 0 )

[17:00:16] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_free_result( Connection handle: 0 )

[17:00:16] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_store_result( Connection handle: 0 )

[17:00:16] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_num_rows( Connection handle: 0 )

[17:00:16] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:00:16] >> mysql_free_result( Connection handle: 0 )

[17:00:16] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:00:16] >> mysql_query( Connection handle: 1 )

[17:00:16] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[17:01:21] >> mysql_ping( Connection handle: 0 )

[17:01:21] >> mysql_ping() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:01:21] >> mysql_connect( )

[17:01:22] CMySQLHandler::Connect() - Can't connect to MySQL server on '85.214.94.65' (10061) (Error ID: 2003)

[17:02:26] >> mysql_ping( Connection handle: 0 )

[17:02:26] >> mysql_ping() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:02:26] >> mysql_connect( )

[17:02:27] CMySQLHandler::Connect() - Can't connect to MySQL server on '85.214.94.65' (10061) (Error ID: 2003)

[17:03:32] >> mysql_ping( Connection handle: 0 )

[17:03:32] >> mysql_ping() - Invalid connection handle. (You set: 0, Highest connection handle ID is 2).

[17:03:32] >> mysql_connect( )

[17:03:32] CMySQLHandler::Connect() - Can't connect to MySQL server on '85.214.94.65' (10061) (Error ID: 2003)

Alles anzeigen

Kleiner Auszug davon ist sehr viel drinnen, falls ihr mehr sehen müsst bitte Bescheid Sagen.

/edit.

Beavis · 22. Februar 2013

Zitat von [VIP]Scarface[VIP]

[17:03:32] >> mysql_connect( )

[17:03:32] CMySQLHandler::Connect() - Can't connect to MySQL server on '85.214.94.65' (10061) (Error ID: 2003)

Tja du hast keine Verbindung zum Server aufgebaut das sagt der Log
Also stimmen die zugangsdaten nicht

Blacksonny · 22. Februar 2013

doch die stimmen ganz sicher

Beavis · 22. Februar 2013

Dann ist der Zugriff nicht möglich
Frag mal dein hoster ob er externe zugriffe erlaubt

Blacksonny · 22. Februar 2013

Ja erlauben sie ...

breadfish.de 11. März 2022