Die Account, werden nicht in der Datenbank gespeichert hat jemand eine Lösung?
Accounts werden nicht gespeichert
- .Shifty
- Geschlossen
- Erledigt
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 (). -
Ohne Code nichts
Prüfe zunächst ob du eine Speicherfunktion hast wenn ja -> wird sie aufgeführt wenn ja -> lasse es dich Printen
-
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;
} -
Wieso schickst Du uns den Teil wo die Accounts geladen werden? Das hat doch garnichts mit dem Issue zu tun...
-
Wir brauchen mehr Code...
Speicher und Laden Funktion wäre nicht schlecht.
-
Wir brauchen mehr Code...
Speicher und Laden Funktion wäre nicht schlecht.
Ich habe das bei meinem Kollegen versucht, bei ihm speichert alles. Habe die Datenbank auch schon gewechselt etc. Geht trotzdem nicht habe einen Linux Root (Ubuntu 16.04)
-
Logs.... Letzte Aufforderung, danach bin ich weg vom Thread und jemand anders soll Dir helfen.
-
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?
-
Wenn Du den Log anstaendig postest, dann kann man Dir auch helfen. Aber die Errors, die ich ueberflogen habe, sprechen fuer sich.
-
-
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 (). -
davon dass das falsche MySQL Plugin benutzt.
Es liegt wohl eher an dem Syntax den er verwendet und nicht am Plugin ansich.
-
Es liegt wohl eher an dem Syntax den er verwendet und nicht am Plugin ansich.
Kann auch sein, aber da er ja ein heruntergeladenes Script verwendet(denke ich mal), sollte der Syntax richtig sein.
-
Nur weil etwas heruntergeladen wurde, heisst es nicht das es bugfrei ist. Ausserdem hat er sicher auch was mal editiert.
-
breadfish.de
Hat das Thema geschlossen.