Newbie Spellweaver
- Joined
- Apr 7, 2007
- Messages
- 31
- Reaction score
- 0
Ok, ThanksSQL 2000 Need (local) IpAdress=(local)
Getting lots of error updating:
"============================================================
[2012/5/21](5:27 PM) Titan DB Updater VERSION: 1.1.0.0
=============================================================
NORMAL UPDATE
-------------------------------------------------------------
[Error] Failed Adding Summoner Row: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Error] Failed Adding RageFighter Row: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Error] Failed Adding Marry Column(1): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFMarried' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Marry Column(2): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFMarryHusbandWife' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Master Column(1): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFMasterLevel' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Master Column(2): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFMasterPoints' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding CustomQuest Column: ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFCustomQuest' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed PCPoints ColumnERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFPCPoints' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Resets Column: ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'Resets' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(1): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensFamily' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(2); ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensContribution' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(3): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensRank' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(4): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensDateLeave' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(5): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensRecvReward' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(6): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFG_Gens' in table 'MuOnline.dbo.Guild' is specified more than once.
[Error] Failed Adding VIP Column(1): ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding VIP Column(2): ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding VIP Column(3): ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding VIP Ware Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding LuckyCoins Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Creating ExtendedWarehouse Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'ExtendedWarehouse' in the database.
[Error] Failed Creating BotPet Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'BotPet' in the database.
[Error] Failed Creating Quest Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'SCFS5Quest' in the database.
[Done] Success Creating LuckyCoins Table
[Error] Failed Creating GuildWarehouse Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'GuildWarehouse' in the database.
[Error] Failed Adding BotPet Column(1): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'BotVersion' in table 'MuOnline.dbo.BotPet' is specified more than once.
[Error] Failed Creating MuExtraData Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'MuExtraData' in the database.
[Done] Success Adding MAP_SRV
[Done] Success Alter Procedure WZ_SetGuildDelete
[Done] Success Alter Procedure WZ_CreateCharacter
[Error] Failed Create Procedure SCF_GENSRANKINGUPDATE: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'SCF_GENSRANKINGUPDATE' in the database.
-------------------------------------------------------------
UPDATE 2011/06/26
-------------------------------------------------------------
[Done] Success Adding MasterSkill Column
[Done] Success Adding ExtInventory Column
[Done] Success Adding UpdatedPShop Column
[Error] Failed Adding ExtWarehouse Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Done] Success Adding RKey Column
-------------------------------------------------------------
UPDATE 2011/07/16
-------------------------------------------------------------
[Done] Success Creating OfficialHelper Table
-------------------------------------------------------------
UPDATE 2011/07/28
-------------------------------------------------------------
[Error] Failed Adding WCoin Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding WCoinP Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding GoblinCoin Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
=============================================================
[2012/5/21](5:29 PM) Titan DB Updater VERSION: 1.1.0.0
=============================================================
NORMAL UPDATE
-------------------------------------------------------------
[Error] Failed Adding Summoner Row: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Error] Failed Adding RageFighter Row: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Error] Failed Adding Marry Column(1): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFMarried' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Marry Column(2): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFMarryHusbandWife' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Master Column(1): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFMasterLevel' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Master Column(2): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFMasterPoints' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding CustomQuest Column: ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFCustomQuest' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed PCPoints ColumnERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFPCPoints' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Resets Column: ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'Resets' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(1): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensFamily' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(2); ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensContribution' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(3): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensRank' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(4): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensDateLeave' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(5): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFGensRecvReward' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding Gens Column(6): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFG_Gens' in table 'MuOnline.dbo.Guild' is specified more than once.
[Error] Failed Adding VIP Column(1): ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding VIP Column(2): ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding VIP Column(3): ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding VIP Ware Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding LuckyCoins Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Creating ExtendedWarehouse Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'ExtendedWarehouse' in the database.
[Error] Failed Creating BotPet Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'BotPet' in the database.
[Error] Failed Creating Quest Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'SCFS5Quest' in the database.
[Error] Failed Creating LuckyCoins Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'LuckyCoinsRank' in the database.
[Error] Failed Creating GuildWarehouse Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'GuildWarehouse' in the database.
[Error] Failed Adding BotPet Column(1): ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'BotVersion' in table 'MuOnline.dbo.BotPet' is specified more than once.
[Error] Failed Creating MuExtraData Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'MuExtraData' in the database.
[Error] Failed Adding MAP_SRV: ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'MAP_SRV' in table 'MuOnline.dbo.MuExtraData' is specified more than once.
[Done] Success Alter Procedure WZ_SetGuildDelete
[Done] Success Alter Procedure WZ_CreateCharacter
[Error] Failed Create Procedure SCF_GENSRANKINGUPDATE: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'SCF_GENSRANKINGUPDATE' in the database.
-------------------------------------------------------------
UPDATE 2011/06/26
-------------------------------------------------------------
[Error] Failed Adding MasterSkill Column: ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFMasterSkill' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding ExtInventory Column: ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFExtInventory' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding UpdatedPShop Column: ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SCFUpdatedPShop' in table 'MuOnline.dbo.Character' is specified more than once.
[Error] Failed Adding ExtWarehouse Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding RKey Column: ERROR [42S21] [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'RKey' in table 'MuOnline.dbptionData' is specified more than once.
-------------------------------------------------------------
UPDATE 2011/07/16
-------------------------------------------------------------
[Error] Failed Creating OfficialHelper Table: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'OfficialHelper' in the database.
-------------------------------------------------------------
UPDATE 2011/07/28
-------------------------------------------------------------
[Error] Failed Adding WCoin Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding WCoinP Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding GoblinCoin Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Error] Failed Adding MuItemShopList Column: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'OfficialHelper' in the database.
[Error] Failed Adding MuItemShopGiftList Column: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'OfficialHelper' in the database.
[Error] Failed Adding MuItemShopGiftMsg Column: ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'OfficialHelper' in the database.
[Done] Success Adding MuShopItemCount Column
[Done] Success Create Procedure TT_GetMuShopItemSerial
-------------------------------------------------------------
UPDATE 2011/08/08
-------------------------------------------------------------
[Error] Failed Adding GoldChannelTime Column: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'MuOnline.dbo.MEMB_INFO' because this table does not exist in database 'MuOnline'.
[Done] Success Adding SCFSealItem Column
[Done] Success Adding SCFSealTime Column
[Done] Success Adding SCFScrollItem Column
[Done] Success Adding SCFScrollTime Column
-------------------------------------------------------------
UPDATE 2011/12/04
-------------------------------------------------------------
[Error] Failed Adding DW Row: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Error] Failed Adding DK Row: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Error] Failed Adding ELF Row: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Error] Failed Adding MG Row: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Error] Failed Adding DL Row: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_DefaultClassType'. Cannot insert duplicate key in object 'DefaultClassType'.
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Done] Success Master SkillTree
-------------------------------------------------------------
UPDATE 2012/02/29
-------------------------------------------------------------
[Done] Success Creating Titan_Rewards Table
[Done] Success Creating Race_Data Table
[Done] Success Creating Race_Data Table
-------------------------------------------------------------
UPDATE 2012/03/12
-------------------------------------------------------------
[Done] Success Creating TT_WriteMemoMail procedure
TASK COMPLETED
What do i need to patch client as from "patch client 1.04c"
Last edited: