post it please here in the thread
Quote:
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=66230
SYSERR: Oct 6 23:34:44 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=67145
SYSERR: Oct 6 23:39:48 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 6 23:42:08 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '136261' for key 'PRIMARY' (query: INSERT INTO safebox (account_id, size) VALUES(136261, 1) errno: 1062)
SYSERR: Oct 6 23:49:33 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '136200' for key 'PRIMARY' (query: INSERT INTO safebox (account_id, size) VALUES(136200, 1) errno: 1062)
SYSERR: Oct 6 23:52:05 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 6 23:52:05 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 6 23:52:05 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 7 00:03:03 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1
query: INSERT INTO player_deleted SELECT * FROM player WHERE id=66177
SYSERR: Oct 7 00:05:32 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct 7 00:08:50 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '135778' for key 'PRIMARY' (query: INSERT INTO safebox (account_id, size) VALUES(135778, 1) errno: 1062)
SYSERR: Oct 7 00:17:13 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 7 10:16:46 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 7 10:16:47 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Oct 7 10:16:47 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Oct 7 10:16:47 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Oct 7 10:28:37 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Oct 7 10:38:55 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Oct 7 10:51:37 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Oct 7 10:52:43 :: ChildLoop: AsyncSQL: query failed: Table 'player.affect' doesn't exist (query: DELETE FROM affect WHERE dwPID=66927 AND bType=209 AND bApplyOn=0 errno: 1146)
SYSERR: Oct 7 10:52:51 :: ChildLoop: AsyncSQL: query failed: Table 'player.monarch' doesn't exist (query: UPDATE monarch set money=0 where empire=1 errno: 1146)
SYSERR: Oct 7 10:52:51 :: ChildLoop: AsyncSQL: query failed: Table 'player.monarch' doesn't exist (query: UPDATE monarch set money=0 where empire=1 errno: 1146)
SYSERR: Oct 7 10:52:51 :: ChildLoop: AsyncSQL: query failed: Table 'player.monarch' doesn't exist (query: UPDATE monarch set money=0 where empire=1 errno: 1146)
SYSERR: Oct 7 10:53:34 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
|
sollte eigentlich eindeutig sein..
repair your tables in your database!