all fall down

[Creo 26]

x

[Originale 134]

repair table bootlog in log

 

DROP TABLE IF EXISTS `bootlog`;
CREATE TABLE `bootlog` (
`time`  datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`hostname`  char(128) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT 'UNKNOWN' ,
`channel`  tinyint(1) NOT NULL DEFAULT 0 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0;

[Creo 26]

 

repair table bootlog in log

 

DROP TABLE IF EXISTS `bootlog`;
CREATE TABLE `bootlog` (
`time`  datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`hostname`  char(128) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT 'UNKNOWN' ,
`channel`  tinyint(1) NOT NULL DEFAULT 0 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0;

okay, db & auth is okay right now, but channel is still shutting down

[Originale 134]

empty your logs, restart the server and post your logs here

[Creo 26]

empty your logs, restart the server and post your logs here

i have this on ch1:

http://wklej.to/0fzYX/text

 

and this on db:

http://wklej.to/w6Isa/text

[Creo 26]

hello

[AndreiYildirim 5]

hello

SYSERR: May 20 15:41:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: May 20 15:41:45 :: 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: May 20 15:41:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'selectedpid' in 'field list'

Check your tables. Thats why you're server its shutting down.

[Creo 26]

 

hello

SYSERR: May 20 15:41:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: May 20 15:41:45 :: 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: May 20 15:41:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'selectedpid' in 'field list'

Check your tables. Thats why you're server its shutting down.

 

i try and he still  

[ATAG 310]

Maybe it's some mob_proto or data/monster error...

[Creo 26]

 

hello

SYSERR: May 20 15:41:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: May 20 15:41:45 :: 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: May 20 15:41:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'selectedpid' in 'field list'

Check your tables. Thats why you're server its shutting down.

 

 

if someone knows something about that can tell me

[Benhero 23]

Check complete DB for errors..

select all -> Right Click -> Maintaine -> Repair Tables -> Extended

 

Greatz