MYSQL register fehler

Fabi.StaR · 25. Juni 2013

Guten Abend,

Ich habe grade ein mysql Login/Register system geschrieben un mein Problem ist jetzt ich kann mich registrieren aber andere user werden nich in der mysql daten bank gespeichert

Bitte um hilfe schreibt mir einfach was ihr sehen wollt und ich zeige es euch

.Kevin · 25. Juni 2013

Einmal Code posten.

& im Gamemode einmal bitte unter Ongamemodeinit mysql_debu(1);

Greetz

Fabi.StaR · 25. Juni 2013

hir der debug:

SQL

[19:35:51] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:51] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:51] >> mysql_query( Connection handle: 1 )


[19:35:51] CMySQLHandler::Query(SELECT * FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:51] >> mysql_store_result( Connection handle: 1 )


[19:35:51] CMySQLHandler::StoreResult() - Result was stored.


[19:35:51] >> mysql_num_rows( Connection handle: 1 )


[19:35:51] CMySQLHandler::NumRows() - Returned 1 row(s)


[19:35:51] >> mysql_free_result( Connection handle: 1 )


[19:35:51] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:51] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:51] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:51] >> mysql_query( Connection handle: 1 )


[19:35:51] CMySQLHandler::Query(SELECT * FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:51] >> mysql_store_result( Connection handle: 1 )


[19:35:51] CMySQLHandler::StoreResult() - Result was stored.


[19:35:51] >> mysql_num_rows( Connection handle: 1 )


[19:35:51] CMySQLHandler::NumRows() - Returned 1 row(s)


[19:35:51] >> mysql_free_result( Connection handle: 1 )


[19:35:51] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:56] >> mysql_query( Connection handle: 1 )


[19:35:56] CMySQLHandler::Query(SELECT `passwort` FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - An error has occured. (Error ID: 1054, Unknown column 'passwort' in 'field list')


[19:35:56] >> mysql_store_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::StoreResult() - No data to store.


[19:35:56] >> mysql_fetch_row_format( Connection handle: 1 )


[19:35:56] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)


[19:35:56] >> mysql_free_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::FreeResult() - The result is already empty.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Money); - Escaped 5 characters to Money.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:56] >> mysql_query( Connection handle: 1 )


[19:35:56] CMySQLHandler::Query(SELECT `Money` FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:56] >> mysql_store_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::StoreResult() - Result was stored.


[19:35:56] >> mysql_fetch_int( Connection handle: 1 )


[19:35:56] CMySQLHandler::FetchRow() - Return: NULL


[19:35:56] >> mysql_free_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Score); - Escaped 5 characters to Score.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:56] >> mysql_query( Connection handle: 1 )


[19:35:56] CMySQLHandler::Query(SELECT `Score` FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:56] >> mysql_store_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::StoreResult() - Result was stored.


[19:35:56] >> mysql_fetch_int( Connection handle: 1 )


[19:35:56] CMySQLHandler::FetchRow() - Return: NULL


[19:35:56] >> mysql_free_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Kills); - Escaped 5 characters to Kills.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:56] >> mysql_query( Connection handle: 1 )


[19:35:56] CMySQLHandler::Query(SELECT `Kills` FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:56] >> mysql_store_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::StoreResult() - Result was stored.


[19:35:56] >> mysql_fetch_int( Connection handle: 1 )


[19:35:56] CMySQLHandler::FetchRow() - Return: NULL


[19:35:56] >> mysql_free_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Tode); - Escaped 4 characters to Tode.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:56] >> mysql_query( Connection handle: 1 )


[19:35:56] CMySQLHandler::Query(SELECT `Tode` FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:56] >> mysql_store_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::StoreResult() - Result was stored.


[19:35:56] >> mysql_fetch_int( Connection handle: 1 )


[19:35:56] CMySQLHandler::FetchRow() - Return: NULL


[19:35:56] >> mysql_free_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(AdminLevel); - Escaped 10 characters to AdminLevel.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:56] >> mysql_query( Connection handle: 1 )


[19:35:56] CMySQLHandler::Query(SELECT `AdminLevel` FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:56] >> mysql_store_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::StoreResult() - Result was stored.


[19:35:56] >> mysql_fetch_int( Connection handle: 1 )


[19:35:56] CMySQLHandler::FetchRow() - Return: NULL


[19:35:56] >> mysql_free_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(FTeam); - Escaped 5 characters to FTeam.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:56] >> mysql_query( Connection handle: 1 )


[19:35:56] CMySQLHandler::Query(SELECT `FTeam` FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:56] >> mysql_store_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::StoreResult() - Result was stored.


[19:35:56] >> mysql_fetch_int( Connection handle: 1 )


[19:35:56] CMySQLHandler::FetchRow() - Return: NULL


[19:35:56] >> mysql_free_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(FLeader); - Escaped 7 characters to FLeader.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:56] >> mysql_query( Connection handle: 1 )


[19:35:56] CMySQLHandler::Query(SELECT `FLeader` FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:56] >> mysql_store_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::StoreResult() - Result was stored.


[19:35:56] >> mysql_fetch_int( Connection handle: 1 )


[19:35:56] CMySQLHandler::FetchRow() - Return: NULL


[19:35:56] >> mysql_free_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(FRank); - Escaped 5 characters to FRank.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.


[19:35:56] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:56] CMySQLHandler::EscapeString([CoR]Fabi.StaR); - Escaped 14 characters to [CoR]Fabi.StaR.


[19:35:56] >> mysql_query( Connection handle: 1 )


[19:35:56] CMySQLHandler::Query(SELECT `FRank` FROM `Accounts` WHERE `Name` = '[CoR]Fabi.StaR') - Successfully executed.


[19:35:56] >> mysql_store_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::StoreResult() - Result was stored.


[19:35:56] >> mysql_fetch_int( Connection handle: 1 )


[19:35:56] CMySQLHandler::FetchRow() - Return: NULL


[19:35:56] >> mysql_free_result( Connection handle: 1 )


[19:35:56] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:35:59] >> mysql_real_escape_string( Connection handle: 1 )


[19:35:59] CMySQLHandler::EscapeString([CoR]Flo.StaR); - Escaped 13 characters to [CoR]Flo.StaR.


[19:35:59] >> mysql_query( Connection handle: 1 )


[19:35:59] CMySQLHandler::Query(SELECT * FROM `Accounts` WHERE `Name` = '[CoR]Flo.StaR') - Successfully executed.


[19:35:59] >> mysql_store_result( Connection handle: 1 )


[19:35:59] CMySQLHandler::StoreResult() - Result was stored.


[19:35:59] >> mysql_num_rows( Connection handle: 1 )


[19:35:59] CMySQLHandler::NumRows() - Returned 0 row(s)


[19:35:59] >> mysql_free_result( Connection handle: 1 )


[19:35:59] CMySQLHandler::FreeResult() - Result was successfully free'd.


[19:36:03] >> mysql_real_escape_string( Connection handle: 1 )


[19:36:03] CMySQLHandler::EscapeString([CoR]Flo.StaR); - Escaped 13 characters to [CoR]Flo.StaR.


[19:36:03] >> mysql_real_escape_string( Connection handle: 1 )


[19:36:03] CMySQLHandler::EscapeString(e2a70be0da01d80cb652b90d3a40004f); - Escaped 32 characters to e2a70be0da01d80cb652b90d3a40004f.


[19:36:03] >> mysql_query( Connection handle: 1 )


[19:36:03] CMySQLHandler::Query(INSERT INTO `Accounts` (`Name`, `Password`) VALUES ('[CoR]Flo.StaR', 'e2a70be0da01d80cb652b90d3a40004f')) - An error has occured. (Error ID: 1062, Duplicate entry '0' for key 'PRIMARY')

Alles anzeigen

Sharpadox · 25. Juni 2013

SQL

[19:36:03] CMySQLHandler::Query(INSERT INTO `Accounts` (`Name`, `Password`) VALUES ('[CoR]Flo.StaR', 'e2a70be0da01d80cb652b90d3a40004f')) - An error has occured. (Error ID: 1062, Duplicate entry '0' for key 'PRIMARY')

Anscheinend hast du die Primary (wahrscheinlich UserID in der DB) "0" doppelt, was neue Accounts verhindert.
Schaue mal nach und ändere es so, dass nichts doppelt ist.

breadfish.de 12. März 2022