Interlude database troubles

Find the proper support area, Saga-Version.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
guard163
Posts: 1
Joined: Mon Oct 21, 2013 4:40 pm

Interlude database troubles

Post by guard163 »

Hi all! I downloaded from http://www.l2jserver.com/nightly/index. ... terlude%2F datapack & l2jserver. When i start install updates for database by database_installer.sh, i has following errors:
050912-[1033].sql
ERROR 1061 (42000) at line 1: Duplicate key name 'key_item_id'
051016-[1334].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'custom_type1'
051103-[1438].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'clan_privs'
051104-[1447].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'wantspeace'
051112-[1505].sql
no errors
051112-[1506].sql
no errors
051129-[1670].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'crest_id'
051205-[1768].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'class_index'
051205-[1769].sql
no errors
051208-[1876].sql
no errors
060215-[c4_1489].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'crest_large_id'
060215-[c4req_update].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'type'
11012007_3477.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'paid'
20060305-[1575].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'onlinetime'
20060314-[1581].sql
ERROR 1146 (42S02) at line 2: Table 'interlude.npc' doesn't exist
20060412.sql
ERROR 1060 (42S21) at line 21: Duplicate column name 'heading'
20060424b.sql
no errors
20060424.sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'friend_id'
20060527-[2012].sql
ERROR 1060 (42S21) at line 4: Duplicate column name 'in_jail'
20060712-[2209].sql
ERROR 1146 (42S02) at line 1: Table 'interlude.spawnlist' doesn't exist
20060712-[dp1888].sql
no errors
20060712-[dp1896].sql
no errors
20060720-[2229].sql
no errors
20060920-[dp2090].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'power_grade'
20060925-[dp2103].sql
no errors
20061010-[dp2162].sql
ERROR 1146 (42S02) at line 3: Table 'interlude.pets_stats' doesn't exist
20061015-[dp2197].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'nobless'
20070501.sql
no errors
update05052006.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.etcitem' doesn't exist
update05092006.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.npc' doesn't exist
update05152006.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'class_index'
update06072007.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.pets_stats' doesn't exist
update06082007.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.pets_stats' doesn't exist
update06122007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'mana_left'
update09122007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'death_penalty_level'
update10152006.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'nobless'
update12092007.sql
no errors
update17092007.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.spawnlist' doesn't exist
update17112007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'buff_index'
update20060522.sql
no errors
update20060607.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'isin7sdungeon'
update20060614.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.npc' doesn't exist
update20061118.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'reputation_score'
update20061124.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'last_recom_date'
update20061126.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'reuse_delay'
update20061204.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.teleport' doesn't exist
update20061206.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'lvl_joined_academy'
update20061207.sql
no errors
update20061208.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.skill_trees' doesn't exist
update20061223.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.weapon' doesn't exist
update20061230.sql
ERROR 1060 (42S21) at line 3: Duplicate column name 'auction_bid_at'
update20070101.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'varka_ketra_ally'
update20070210.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.armor' doesn't exist
update20070216.sql
ERROR 1091 (42000) at line 1: Can't DROP 'objId'; check that column/key exists
update20070221.sql
no errors
update20070223.sql
ERROR 1091 (42000) at line 1: Can't DROP 'respawn_delay'; check that column/key exists
update20070303.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'ally_penalty_expiry_time'
update20070503-[dp2978].sql
ERROR 1146 (42S02) at line 1: Table 'interlude.merchant_buylists' doesn't exist
update20070503-[dp2980].sql
ERROR 1146 (42S02) at line 1: Table 'interlude.armor' doesn't exist
update20070511.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'expBeforeDeath'
update20070601.sql
ERROR 1146 (42S02) at line 1: Table 'interlude.accounts' doesn't exist
update20070929-[dp3399].sql
ERROR 1146 (42S02) at line 1: Table 'interlude.skill_trees' doesn't exist
update20071203.sql
no errors
update25052007.sql
ERROR 1091 (42000) at line 1: Can't DROP 'inDebt'; check that column/key exists
So, how i can fix it?
Post Reply