Originally Posted by .Hazel
PHP Code:
SYSERR: Dec 26 10:54:36 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Dec 26 10:54:37 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.monarch_candidacy' doesn't exist
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Dec 26 10:54:37 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Dec 26 10:54:37 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.monarch_election' doesn't exist
query: SELECT pid, selectedpid, electiondata FROM monarch_election
SYSERR: Dec 26 10:54:37 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist
query: SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry
SYSERR: Dec 26 10:54:37 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Dec 26 10:54:40 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Dec 26 10:54:40 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='5.53.210.100')
SYSERR: Dec 26 10:54:41 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Dec 26 10:54:41 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='5.53.210.100')
SYSERR: Dec 26 10:54:41 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec 26 10:54:42 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Jan 20 12:24:04 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 20 12:24:05 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive FROM mob_proto ORDER BY vnum
SYSERR: Jan 20 12:24:05 :: 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: Jan 20 12:24:05 :: 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: Jan 20 12:24:05 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Jan 20 12:26:46 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 20 12:27:29 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 20 12:27:29 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critSYSERR: Jan 20 12:28:38 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 20 12:28:38 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive FROM mob_proto ORDER BY vnum
SYSERR: Jan 20 12:28:39 :: 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: Jan 20 12:28:39 :: 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: Jan 20 12:28:39 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Jan 20 12:29:05 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 20 12:30:43 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 20 12:30:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive FROM mob_proto ORDER BY vnum
SYSERR: Jan 20 12:30:44 :: 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: Jan 20 12:30:44 :: 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: Jan 20 12:30:44 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Jan 20 12:38:40 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 20 12:38:40 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive FROM mob_proto ORDER BY vnum
SYSERR: Jan 20 12:38:40 :: 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: Jan 20 12:38:40 :: 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: Jan 20 12:38:40 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Jan 20 12:38:40 :: socket_bind: bind: Address already in use
SYSERR: Jan 20 12:38:54 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 20 12:38:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive FROM mob_proto ORDER BY vnum
SYSERR: Jan 20 12:38:55 :: 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: Jan 20 12:38:55 :: 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: Jan 20 12:38:55 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Jan 20 12:38:55 :: socket_bind: bind: Address already in use
SYSERR: Jan 20 12:39:06 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 20 12:39:06 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive FROM mob_proto ORDER BY vnum
SYSERR: Jan 20 12:39:06 :: 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: Jan 20 12:39:06 :: 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: Jan 20 12:39:06 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Jan 20 12:39:06 :: socket_bind: bind: Address already in use
SYSERR: Jan 20 12:44:07 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 20 12:49:17 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 20 12:49:17 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive FROM mob_proto ORDER BY vnum
SYSERR: Jan 20 12:49:17 :: 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: Jan 20 12:49:17 :: 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: Jan 20 12:49:17 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Jan 20 12:59:36 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Jan 20 12:59:36 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan 20 12:59:37 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 20 18:54:40 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 20 18:54:40 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'skill_vnum2' in 'field list'
query: SELECT vnum, name, gb2312name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive FROM mob_proto ORDER BY vnum
SYSERR: Jan 20 18:54:41 :: 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: Jan 20 18:54:41 :: 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: Jan 20 18:54:41 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
Dir fehlt ein Teil der Datenbank, er kann manche Querrys nicht ausführen.
PHP Code:
SYSERR: Jan 20 12:24:11 :: LoadSetting: [INIT_FORKED] Do not open file (locale/hongkong/forkedmapindex.txt)
SYSERR: Jan 20 12:24:11 :: Cube_init: Cube_Init failed
SYSERR: Jan 20 12:24:11 :: Blend_Item_init: <Blend_Item_init> fail
SYSERR: Jan 20 12:26:46 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 20 12:27:35 :: LoadSetting: [INIT_FORKED] Do not open file (locale/hongkong/forkedmapindex.txt)
SYSERR: Jan 20 12:27:35 :: Cube_init: Cube_Init failed
SYSERR: Jan 20 12:27:35 :: Blend_Item_init: <Blend_Item_init> fail
SYSERR: Jan 20 12:28:44 :: LoadSetting: [INIT_FORKED] Do not open file (locale/hongkong/forkedmapindex.txt)
SYSERR: Jan 20 12:28:45 :: Cube_init: Cube_Init failed
SYSERR: Jan 20 12:28:45 :: Blend_Item_init: <Blend_Item_init> fail
SYSERR: Jan 20 12:29:05 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 20 12:30:49 :: LoadSetting: [INIT_FORKED] Do not open file (locale/hongkong/forkedmapindex.txt)
SYSERR: Jan 20 12:30:49 :: Cube_init: Cube_Init failed
SYSERR: Jan 20 12:30:49 :: Blend_Item_init: <Blend_Item_init> fail
SYSERR: Jan 20 12:38:46 :: LoadSetting: [INIT_FORKED] Do not open file (locale/hongkong/forkedmapindex.txt)
SYSERR: Jan 20 12:38:46 :: socket_bind: bind: Address already in use
SYSERR: Jan 20 12:39:01 :: LoadSetting: [INIT_FORKED] Do not open file (locale/hongkong/forkedmapindex.txt)
SYSERR: Jan 20 12:39:01 :: socket_bind: bind: Address already in use
SYSERR: Jan 20 12:39:12 :: LoadSetting: [INIT_FORKED] Do not open file (locale/hongkong/forkedmapindex.txt)
SYSERR: Jan 20 12:39:12 :: socket_bind: bind: Address already in use
SYSERR: Jan 20 12:44:07 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 20 12:49:23 :: LoadSetting: [INIT_FORKED] Do not open file (locale/hongkong/forkedmapindex.txt)
SYSERR: Jan 20 12:49:23 :: Cube_init: Cube_Init failed
SYSERR: Jan 20 12:49:23 :: Blend_Item_init: <Blend_Item_init> fail
SYSERR: Jan 20 12:59:37 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 20 18:54:46 :: LoadSetting: [INIT_FORKED] Do not open file (locale/hongkong/forkedmapindex.txt)
SYSERR: Jan 20 18:54:46 :: Cube_init: Cube_Init failed
SYSERR: Jan 20 18:54:46 :: Blend_Item_init: <Blend_Item_init> fail
- Server schon gestartet
- die forkedmapindex kann nicht geöffnet werden
PHP Code:
SYSERR: Dec 26 10:54:41 :: ReadSpecialDropItemFile: ReadSpecialDropItemFile : there is no item 11905 : node blautod
SYSERR: Dec 26 10:54:41 :: Boot: cannot load SpecialItemGroup: locale/germany/special_item_group.txt
- das Item 11905 exestiert nicht
- die special_item_group.txt kann nicht gefunden werden
Schau' nach, ob Deine locale Tabelle überall Germany ist, danach sieht es mir nämlich nicht aus. Guck' auch in der Datenbank nach.
PHP Code:
:: ReadSpecialDropItemFile: ReadSpecialDropItemFile : there is no item 11905 : node blautod
SYSERR: Dec 26 10:54:42 :: Boot: cannot load SpecialItemGroup: locale/germany/special_item_group.txt
Das gleiche wie bei game.
|