Column name in each table must be unique

[jumongski]

These logs always floods everytime I run DataServer same with DataServer2. Can someone please help me solve this problem?

12:16:29a szDbConnectDsn d:\exteam\season6episode3\source\ds\source_db\mainfrm.cpp
12:16:31a alter table [Character] add [pcpoint] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'pcpoint' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [ExFreePoints] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'ExFreePoints' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [Resets] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'Resets' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [gr_res] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'gr_res' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [ExQuestNum] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'ExQuestNum' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [ExQuestKill] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'ExQuestKill' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [PremiumTime] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'PremiumTime' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [ExCred] float not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'ExCred' in table 'Character' is specified more than once.
12:16:31a alter table [MEMB_INFO] add [ExCredit] float not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'ExCredit' in table 'MEMB_INFO' is specified more than once.
12:16:31a alter table [Character] add [BanChat] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'BanChat' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [BanPost] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'BanPost' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [BanChar] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'BanChar' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [ExpandedInventory] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'ExpandedInventory' in table 'Character' is specified more than once.
12:16:31a alter table [AccountCharacter] add [ExpandedWarehouse] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'ExpandedWarehouse' in table 'AccountCharacter' is specified more than once.
12:16:31a alter table [Character] add [ChaosBank] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'ChaosBank' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [BlessBank] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'BlessBank' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [SoulBank] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'SoulBank' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [LifeBank] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'LifeBank' in table 'Character' is specified more than once.
12:16:31a alter table [MEMB_INFO] add [MTDate] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'MTDate' in table 'MEMB_INFO' is specified more than once.
12:16:31a alter table [Character] add [AutoParty] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'AutoParty' in table 'Character' is specified more than once.
12:16:31a alter table [Character] add [Zen] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'Zen' in table 'Character' is specified more than once.
12:16:31a alter table [MEMB_INFO] add [QTDate] int not null default(0)
12:16:31a (2) SQLSTATE:42S21, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'QTDate' in table 'MEMB_INFO' is specified more than once.
12:16:31a CREATE TABLE RageSystem(Accaunt varchar(10),Name varchar(10),RageLevel int,RagePoint int,RageExp int,Damage int,FreePoints int,SummonPet int,WingsDamagePlus int,FinalMana int,IgnoreDefence int,ResetLevel int,Teleport int,CriticalDamageRate int,AbsordDamage int,PetDamageBonus int,FinalLife int,Strength int,DefenceRate int,FireDamage int,Energy int,Agility int,DoubleDamage int,FinalSD int,FinalDefence int,ZenDrop int,GuildBonus int,ReflectDamage int,ExellentDamageRate int,PvPBonusPlus int,MinDefence int,Experience int,StartSD int,PartyBonus int,IceDamage int,DistanceAttack int,AttackRate int,WeaponBonus int,ExellentDamage int,CriticalDamage int);
12:16:31a (2) SQLSTATE:42S01, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'RageSystem' in the database.
12:16:31a CREATE TABLE GensMember(Name varchar(10), Influence int, Class int, Contribute int, Rank int, RewardDate smalldatetime)
12:16:31a (2) SQLSTATE:42S01, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'GensMember' in the database.
12:16:31a CREATE TABLE WinQuest(Name varchar(10), S1 int, S2 int, S3 int, S4 int, S5 int, S6 int, S7 int, S8 int, S9 int, S10 int,N1 int, N2 int, N3 int, N4 int, N5 int, N6 int, N7 int, N8 int, N9 int, N10 int,C11 int, C12 int, C13 int, C14 int, C15 int,C21 int, C22 int, C23 int, C24 int, C25 int,C31 int, C32 int, C33 int, C34 int, C35 int,C41 int, C42 int, C43 int, C44 int, C45 int,C51 int, C52 int, C53 int, C54 int, C55 int,C61 int, C62 int, C63 int, C64 int, C65 int,C71 int, C72 int, C73 int, C74 int, C75 int,C81 int, C82 int, C83 int, C84 int, C85 int,C91 int, C92 int, C93 int, C94 int, C95 int,C101 int,C102 int,C103 int,C104 int,C105 int,Damage int,Defence int,Life int,SD int,Crit int,Exel int,DD int,Ignore int,Ref int,Exp int,Dr int);
12:16:31a (2) SQLSTATE:42S01, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'WinQuest' in the database.
12:16:33a alter table [Character] add [pcpoint] int not null default(0)

[MentaL]

[RevolGaming]

Maybe understand the error message...

alter table [Character] add [pcpoint] int not null default(0)

IS NOT NULL! So go into SQL design table and edit character- > pcpoints from not null to allow nulls, and it will be okey.

Do it with every another message, read it and fix it... If you cant read and understand the problem, how will you fix anything on your server?

dont make me sad, pls.

[jumongski]

@djsad94 I checked "allow nulls" and saved it. but still shows the same errors.

EDIT: you had me at "dont make me sad, pls"


Here below the sample.




The only Database that I have is MuOnline

- - - Updated - - -

is there anyway to edit MuOnline.bak without restoring it first? I mean I will directly edit MuOnline.bak

[RevolGaming]

alter table [Character] add [pcpoint] int not null default(0)

design the character table, and show me the properties of the pcpoint column.

[jumongski]

Mate, what I did was I deleted [pcpoint] then I run the server to check the logs. but log says "alter table [Character] add [pcpoint] int not null default(0)" even tho the pcpoint has already been deleted. kinda weird right?

And the "Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'pcpoint' in table 'Character' is specified more than once." has disappeared from the logs.