Accounts werden nicht gespeichert

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
  • Beitrag von linux_ ()

    Dieser Beitrag wurde von shoxinat0r gelöscht ().

  • public ShowLoginOrRegisterDialog(playerid)
    {
    new query[128];
    TextDrawHideForPlayer(playerid,Introdraw[2]);
    TextDrawHideForPlayer(playerid,Introdraw[3]);
    SpamChat(playerid,0);// 0 = nur für einen spieler wird der chat kontrolliert 100 zeilen voll gespamt,bei 1 = für alle spieler
    format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,query,true,"OnQueryFinish","siii",query,_SQL_ACCOUNT_CHECK,playerid,MySqlConnection);
    return 1;
    }


    Datenbank

  • Hier ist der MYSQL Log:


    Habe einen Ubuntu Root.


    [18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Friedhof'[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'pMarried'[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1[18:00:20] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_races' doesn't exist[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GangWarZoneAttacker' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'id' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:00:20] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'GFFID' doesn't have a default value[18:04:22] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Online' doesn't have a default value[18:04:22] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Waffen0' doesn't have a default value[18:04:22] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'FishID0' doesn't have a default value[18:04:22] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Slot0' doesn't have a default value[18:04:22] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'blacklist0' doesn't have a default value[18:04:22] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'c4' doesn't have a default value[18:04:22] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'car' doesn't have a default value[18:04:22] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'safetresor' doesn't have a default value[18:04:25] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Online' doesn't have a default value[18:04:25] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Waffen0' doesn't have a default value[18:04:25] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'FishID0' doesn't have a default value[18:04:25] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Slot0' doesn't have a default value[18:04:25] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'blacklist0' doesn't have a default value[18:04:25] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'c4' doesn't have a default value[18:04:25] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'car' doesn't have a default value[18:04:25] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'safetresor' doesn't have a default value[18:05:42] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Online' doesn't have a default value[18:05:42] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Waffen0' doesn't have a default value[18:05:42] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'FishID0' doesn't have a default value[18:05:42] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Slot0' doesn't have a default value[18:05:42] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'blacklist0' doesn't have a default value[18:05:42] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'c4' doesn't have a default value[18:05:42] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'car' doesn't have a default value[18:05:42] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'safetresor' doesn't have a default value[18:08:13] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:14] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:14] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:15] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:17] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:17] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:18] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:18] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:19] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:20] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:20] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:21] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:21] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:22] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:23] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:23] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_stuff' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist[18:09:36] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Friedhof'[18:09:36] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'pMarried'[18:09:36] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1[18:09:36] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1[18:09:36] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'HyperLink.pRP_races' doesn't exist[18:09:36] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'HyperLink.pRP_gutscheine' doesn't exist[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43')[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("NextFreeHousekey")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GSKILLS")[18:09:36] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1[18:09:36] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1[18:10:54] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Online' doesn't have a default value[18:10:54] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Waffen0' doesn't have a default value[18:10:54] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'FishID0' doesn't have a default value[18:10:54] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'Slot0' doesn't have a default value[18:10:54] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'blacklist0' doesn't have a default value[18:10:54] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'c4' doesn't have a default value[18:10:54] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'car' doesn't have a default value[18:10:54] [ERROR] CMySQLQuery::Execute[()] - (error #1364) Field 'safetresor' doesn't have a default value


    Den Rest, habe ich gefixt bekommen.


    //Edit Hat niemand eine Lösung?

    4 Mal editiert, zuletzt von .Shifty ()

  • Beitrag von .Shifty ()

    Dieser Beitrag wurde vom Autor gelöscht ().
  • Wie im MySQL.log beschrieben fehlen dir mehrere MySQL Datenbanken.

    Code
    [18:08:24] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'samp.pRP_account_main' doesn't exist
    [18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_gangwar' doesn't exist
    [18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_advertismentboards' doesn't exist
    [18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_stuff' doesn't exist
    [18:08:24] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'samp.pRP_fraktion_verwaltung' doesn't exist
    [18:09:36] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'HyperLink.pRP_races' doesn't exist
    [18:09:36] [ERROR] CMySQLQuery::Execute[OnQueryFinish(siii)] - (error #1146) Table 'HyperLink.pRP_gutscheine' doesn't exist

    Dazu gibt es in deiner bestehenden Datenbank mehrmals die Spalte "Friedhof" und "pMarried", am besten suchst du nach dem Duplikat in der Datenbank und löscht sie dann.


    Dazu gibt es noch mehrere Syntax Error, diese kommen wahrscheinlich davon dass das falsche MySQL Plugin benutzt.

  • Beitrag von LeonMrBonnie ()

    Dieser Beitrag wurde vom Autor gelöscht ().