AsyncSQL: connected to localhost (reconnect 1)

[xywl]

server9# ./db
Real Server
Log Offlog_file_delete_old: stat: No such file or directory
AsyncSQL: connected to localhost (reconnect 1)
Success PLAYER
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success ACCOUNT
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success COMMON
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success HOTBACKUP
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
server9#

HELP
THX

[.Marcel']

Guck in die syserrs wen dir was komisch vorkommt, und mach nicht so einen unnsingen Thread auf

[xywl]

Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.
Jan 11 16:22:24 :: AsyncSQL: closing mysql connection.

[#SoNiice]

Da sind keine Errors. Du siehst doch oben 1 Reconnect, sprich:
-> closing connection und neu verbinden. Darum einmal alles geschlosse,
ist dann doch normal.

[xywl]

SYSERR: Jan 11 16:29:46 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 11 16:29:46 :: DirectQuery: AsyncSQL:irectQuery : mysql_query error: Unknown column 'LOCALE' in 'field list'
query: SELECT vnum, name, LOCALE, 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 11 16:29:46 :: DirectQuery: AsyncSQL:irectQuery : mysql_query error: Unknown column 'LOCALE' in 'field list'
query: SELECT vnum, type, subtype, name, LOCALE, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag+0, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 FROM item_proto ORDER BY vnum
SYSERR: Jan 11 16:29:46 :: InitializeItemTable: query error: SELECT vnum, type, subtype, name, LOCALE, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag+0, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 FROM item_proto ORDER BY vnum
SYSERR: Jan 11 16:29:46 :: InitializeTables: InitializeItemTable FAILED
SYSERR: Jan 11 16:29:46 :: Initialize: Table Initialize FAILED

This's syserr

[#SoNiice]

Das ist schon eher ein Fehler und erklärt den reconnect.

Warum bitte hast du eine LOCALE Spalte in deiner item_proto?

[.Scy]

solltest mal die spalte LOCALE weg machen.

also erstmal backup danach rechtsklick auf die spalte locale die dann löschen und nochmal versuchen zu starten vllt gehts dann

[xywl]

NOW

SYSERR: Jan 11 16:34:15 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 11 16:34:16 :: DirectQuery: AsyncSQL:irectQuery : 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 11 16:34:16 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Jan 11 16:34:16 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jan 11 16:34:19 :: Process: FDWATCH: peer null in event: ident 21

[#SoNiice]

#reported, ein Post reicht.

Und ja, ist normal.

[xywl]

Thx!!