extDB2 Error + Log

Alala

Hay Leute ich habe ein problem wenn ich auf den server connecten will bekomme ich keine spawn auswahl es kommt im log immer das

Code

[14:28:11:815 +02:00] [Thread 1044] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Unknown column 'civ_stats' in 'field list'	[mysql_stmt_errno]: 1054	[mysql_stmt_sqlstate]: 42S22	[statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:11:815 +02:00] [Thread 1044] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:12:053 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Duplicate entry '76561198068883084' for key 'playerid'	[mysql_stmt_errno]: 1062	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198068883084', '[Sign]Alala', '0', '3000', '"[`[Sign]Alala`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[14:28:12:053 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198068883084', '[Sign]Alala', '0', '3000', '"[`[Sign]Alala`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[14:28:12:138 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Unknown column 'civ_stats' in 'field list'	[mysql_stmt_errno]: 1054	[mysql_stmt_sqlstate]: 42S22	[statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:12:138 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:12:407 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Unknown column 'civ_stats' in 'field list'	[mysql_stmt_errno]: 1054	[mysql_stmt_sqlstate]: 42S22	[statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:12:407 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:12:665 +02:00] [Thread 1044] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Duplicate entry '76561198068883084' for key 'playerid'	[mysql_stmt_errno]: 1062	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198068883084', '[Sign]Alala', '0', '3000', '"[`[Sign]Alala`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[14:28:12:665 +02:00] [Thread 1044] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198068883084', '[Sign]Alala', '0', '3000', '"[`[Sign]Alala`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[14:28:12:746 +02:00] [Thread 1044] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Unknown column 'civ_stats' in 'field list'	[mysql_stmt_errno]: 1054	[mysql_stmt_sqlstate]: 42S22	[statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:12:746 +02:00] [Thread 1044] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:12:991 +02:00] [Thread 1044] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Unknown column 'civ_stats' in 'field list'	[mysql_stmt_errno]: 1054	[mysql_stmt_sqlstate]: 42S22	[statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:12:992 +02:00] [Thread 1044] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:13:225 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: Duplicate entry '76561198068883084' for key 'playerid'	[mysql_stmt_errno]: 1062	[mysql_stmt_sqlstate]: 23000	[statemnt]: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198068883084', '[Sign]Alala', '0', '3000', '"[`[Sign]Alala`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[14:28:13:225 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198068883084', '[Sign]Alala', '0', '3000', '"[`[Sign]Alala`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[14:28:13:308 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Unknown column 'civ_stats' in 'field list'	[mysql_stmt_errno]: 1054	[mysql_stmt_sqlstate]: 42S22	[statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:13:308 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198068883084'
[14:28:13:615 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Table 'rpgtanoa.containers' doesn't exist	[mysql_stmt_errno]: 1146	[mysql_stmt_sqlstate]: 42S02	[statemnt]: SELECT pid, pos FROM containers WHERE pid='76561198068883084' AND owned='1'
[14:28:13:615 +02:00] [Thread 2668] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT pid, pos FROM containers WHERE pid='76561198068883084' AND owned='1'

Alles anzeigen

SBuserhy

deine Tabelle/Spalte existiert nicht in der Datenbank

Die Spalte civ_stats existiert nicht in der Tabelle players

Die Tabelle containers existiert nicht in der Datenbank rpgtanoa

Alala

aber ich habe die normale altis 4.4 db importier

SBuserhy

aber wahrscheinlich eine alte Version

Alala

habe es hinbekommen musste die db neu erstelle naber nun spawne ich nicht in kavala sondern immer beim head client

SBuserhy

mach dafür ein neues Thema auf und hänge den rpt.log von client & server mit an

Alala

hab es gefunden gab ein problem im standart altis script

extDB2 Error + Log

nox 25. März 2023 um 00:47

Ähnliche Themen

Datenbank Connection

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

frage spielerinformationen zu uid ab geht nicht weg

Weiterstehendes Problem mit der Datenbank

extDB2 Problem | #Kotzen