extDB2 Problem | #Kotzen

Gloescht

Moin Kinnas,

Fogendes Problem...
Aus heiterem Himmel kommt aufeinmal das im rpt und mann kommt nicht mehr auf den server...

Haut alles in die Kommentare was es sein könnte.

Danke im vorraus

Code

17:19:40 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:40 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:40 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:40 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:40 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:40 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:41 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:41 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:41 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:41 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:41 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:41 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:41 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:41 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:42 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:42 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:42 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:42 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:42 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:42 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:42 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:43 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:43 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:43 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:43 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:43 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:43 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:43 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:43 "extDB2: Protocol Error: [0,""Error Statement Exception""]"
17:19:44 "extDB2: Protocol Error: [0,""Error Statement Exception""]"

Alles anzeigen

Yeyz

Hast du DynMarket drauf?
Schicke doch bitte auch einmal die [lexicon]extDB[/lexicon] Logs bin rein.

Gloescht

Komplett standard 5.0

Nichts dran verändert!

extDB2: Found [lexicon]extdb[/lexicon]-conf.ini
extDB2: Detected 32 Cores, Setting up 6 Worker Threads

[15:36:56:248598 +02:00] [Thread 13708] extDB2: Database Type: MySQL
[15:36:56:280153 +02:00] [Thread 13708] extDB2: Database Session Pool Started
[15:36:56:364481 +02:00] [Thread 13708] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
[15:36:56:711524 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'houses.garage' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT houses.id, houses.pid, houses.pos, players.name, houses.garage FROM houses INNER JOIN players WHERE houses.owned='1' AND houses.pid = players.pid LIMIT 0,10
[15:36:56:712008 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT houses.id, houses.pid, houses.pos, players.name, houses.garage FROM houses INNER JOIN players WHERE houses.owned='1' AND houses.pid = players.pid LIMIT 0,10
[15:48:31:928926 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, cop_licenses, coplevel, cop_gear, blacklist, cop_stats, playtime FROM players WHERE pid='76561198296589587'
[15:48:31:929828 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, cop_licenses, coplevel, cop_gear, blacklist, cop_stats, playtime FROM players WHERE pid='76561198296589587'
[15:48:32:206577 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name FROM players WHERE pid='76561198296589587'
[15:48:32:206937 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name FROM players WHERE pid='76561198296589587'
[15:48:32:210689 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198296589587', 'TimMeier', '0', '50000', '"[`TimMeier`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[15:48:32:211183 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198296589587', 'TimMeier', '0', '50000', '"[`TimMeier`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[15:59:01:848148 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198296589587'
[15:59:01:848743 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198296589587'
[15:59:02:061870 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name FROM players WHERE pid='76561198296589587'
[15:59:02:062276 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name FROM players WHERE pid='76561198296589587'
[15:59:02:065615 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198296589587', 'TimMeier', '0', '50000', '"[`TimMeier`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[15:59:02:066389 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198296589587', 'TimMeier', '0', '50000', '"[`TimMeier`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[16:25:49:259718 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, cop_licenses, coplevel, cop_gear, blacklist, cop_stats, playtime FROM players WHERE pid='76561198133937820'
[16:25:49:260201 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, cop_licenses, coplevel, cop_gear, blacklist, cop_stats, playtime FROM players WHERE pid='76561198133937820'
[16:26:35:099457 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name FROM players WHERE pid='76561198133937820'
[16:26:35:099967 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name FROM players WHERE pid='76561198133937820'
[16:26:35:103933 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198133937820', 'Matze Media', '-1', '50000', '"[`Matze Media`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[16:26:35:104580 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198133937820', 'Matze Media', '-1', '50000', '"[`Matze Media`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[16:26:35:169097 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198133937820'
[16:26:35:169610 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198133937820'
[16:26:35:234750 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198133937820'
[16:26:35:235367 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198133937820'
[16:26:35:550669 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name FROM players WHERE pid='76561198133937820'
[16:26:35:550986 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name FROM players WHERE pid='76561198133937820'
[16:26:35:555846 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198133937820', 'Matze Media', '0', '50000', '"[`Matze Media`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[16:26:35:556471 +02:00] [Thread 9840] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198133937820', 'Matze Media', '0', '50000', '"[`Matze Media`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[16:26:35:556789 +02:00] [Thread 5424] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name FROM players WHERE pid='76561198133937820'
[16:26:35:557337 +02:00] [Thread 5424] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name FROM players WHERE pid='76561198133937820'
[16:26:35:562330 +02:00] [Thread 5424] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198133937820', 'Matze Media', '0', '50000', '"[`Matze Media`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[16:26:35:562844 +02:00] [Thread 5424] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198133937820', 'Matze Media', '0', '50000', '"[`Matze Media`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[16:26:35:709067 +02:00] [Thread 5424] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198133937820'
[16:26:35:709799 +02:00] [Thread 5424] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198133937820'
[16:26:35:727983 +02:00] [Thread 5424] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'pid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198133937820'
[16:26:35:728404 +02:00] [Thread 5424] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE pid='76561198133937820'

Yeyz

Zitat von Matze Design

Komplett standard 5.0

Nichts dran verändert!

Okay gut.
Könntest du trotzdem bitte einmal die [lexicon]extDB[/lexicon] Logs hier hinein schreiben?
Da steht dann evtl. mehr drin als in den RPT-Logs.

Gloescht

Is oben jetzt drinne

Yeyz

Wenn ich mich nicht irre, ist etwas mit deiner Datenbank an sich nicht in Ordnung.
Ich denke dort wurden einige Sachen nicht erstellt bzw. sie existieren nicht.
Importiere die SQL-Datei noch einmal neu und teste es erneut.

Rom

Ich fasse mich mal kurz:
Unbekannte Spalte 'garage' in der Tabelle houses
Unbekannte Spalte 'pid' in der Tabelle players

Überprüfe deine SQL-Befehle und ändere diese ab. z.B. heißt in manchen AL-Versionen die Spalte 'pid' -> 'uid' oder 'playerid'.
Mit houses bin ich mir nicht ganz sicher. Mit der AL-Version kenne ich mich nicht so aus

Gloescht

aber ich habe da absolut nix geändert ...

wieso treten solche fehler auf ?

extDB2 Problem | #Kotzen

Ähnliche Themen

Datenbank Problem AltisLife Call extension 'extDB2' could not be loaded: %1 ist keine zul�ssige Win32-Anwendung.

Setting up Client Info und keine richtigen Logs

Call extension 'extDB2'

Error with Database Connection

extDB2 Error

Hideout - Problem (English)

Benutzer online in diesem Thema