Creo 26 Posted May 17, 2015 Share Posted May 17, 2015 x Link to comment Share on other sites More sharing options...
Originale 134 Posted May 17, 2015 Share Posted May 17, 2015 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; 1 Link to comment Share on other sites More sharing options...
Creo 26 Posted May 18, 2015 Author Share Posted May 18, 2015 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 Link to comment Share on other sites More sharing options...
Originale 134 Posted May 18, 2015 Share Posted May 18, 2015 empty your logs, restart the server and post your logs here Link to comment Share on other sites More sharing options...
Creo 26 Posted May 20, 2015 Author Share Posted May 20, 2015 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 Link to comment Share on other sites More sharing options...
Creo 26 Posted May 20, 2015 Author Share Posted May 20, 2015 hello Link to comment Share on other sites More sharing options...
Premium AndreiYildirim 5 Posted May 20, 2015 Premium Share Posted May 20, 2015 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. Link to comment Share on other sites More sharing options...
Creo 26 Posted May 20, 2015 Author Share Posted May 20, 2015 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 Link to comment Share on other sites More sharing options...
Active Member ATAG 310 Posted May 20, 2015 Active Member Share Posted May 20, 2015 Maybe it's some mob_proto or data/monster error... Link to comment Share on other sites More sharing options...
Creo 26 Posted May 22, 2015 Author Share Posted May 22, 2015 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 Link to comment Share on other sites More sharing options...
Benhero 23 Posted May 24, 2015 Share Posted May 24, 2015 Check complete DB for errors.. select all -> Right Click -> Maintaine -> Repair Tables -> Extended Greatz Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now