[Help] Ascent - Chacters & their items

[Digital727]

When someone relog's they get a duplicate item error and it will respawn past items that have been thrown away

i'm running Ascent Stable 2.4 , 0.2.3 milestone , 2.3.0 Full Char DB

Is there a SQL update or anything that will fix this?

And also whenever someone dies and does release spirit... they get sent to ironforge.

can someone tell me how to fix that? (extract map files tut)

[MentaL]

[qbert0]

I don't think anyone well reply because you spelled character wrong in the title. To extract map files go to your WoW Directory and make a new folder called maps. Copy and paste the ad.exe for the language you want to the WoW Directory. If you are running on Vista right click and go to properties click on the compatibility tab and run in compatibility with Windows XP SP2 and then click ok then right click on ad.exe and select run as administrator. I told you the way for vista because I had difficulties with Vista's UAC when setting up a server.

[jab416171]

He's using Ascent Stable 2.4. This question has been answered before, and when you get an answer, please PM me so I can add it to the FAQ. If I find the answer before that, I'll let you know.

[Digital727]

I didn't spell it wrong on purpose..
Characters*

sorry. :\

[jab416171]

need to update this was fixed in revision 2421

[Digital727]

The character & items issue still isnt fixed... the SQL updates wont load.. says theres an error

[jab416171]

Well what's the error say?

[Digital727]

there ya go.

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`),
UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-23 15:56:54
Line no.:26
Error Code: 1109 - Unknown table 'account_data' in information_schema

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`),
UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-23 15:57:02
Line no.:26
Error Code: 1109 - Unknown table 'account_data' in information_schema

Query:
CREATE TABLE `account_data` (
`acct` int(30) NOT NULL,
`accountdata0` text NOT NULL,
`accountdata1` text NOT NULL,
`accountdata2` text NOT NULL,
`accountdata3` text NOT NULL,
`accountdata4` text NOT NULL,
`accountdata5` text NOT NULL,
`accountdata6` text NOT NULL,
`accountdata7` text NOT NULL,
PRIMARY KEY (`acct`),
UNIQUE KEY `ind` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-23 15:57:56
Line no.:26
Error Code: 1050 - Table 'account_data' already exists

Query:
CREATE TABLE `weather` (
`zoneId` int(11) unsigned NOT NULL DEFAULT '0',
`high_chance` int(11) unsigned NOT NULL DEFAULT '0',
`high_type` int(11) unsigned NOT NULL DEFAULT '0',
`med_chance` int(11) unsigned NOT NULL DEFAULT '0',
`med_type` int(11) unsigned NOT NULL DEFAULT '0',
`low_chance` int(11) unsigned NOT NULL DEFAULT '0',
`low_type` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`zoneId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System'

Error occured at:2007-11-25 01:14:19
Line no.:23
Error Code: 1050 - Table 'weather' already exists

Query:
CREATE TABLE `weather` (
`zoneId` int(11) unsigned NOT NULL DEFAULT '0',
`high_chance` int(11) unsigned NOT NULL DEFAULT '0',
`high_type` int(11) unsigned NOT NULL DEFAULT '0',
`med_chance` int(11) unsigned NOT NULL DEFAULT '0',
`med_type` int(11) unsigned NOT NULL DEFAULT '0',
`low_chance` int(11) unsigned NOT NULL DEFAULT '0',
`low_type` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`zoneId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System'

Error occured at:2007-11-25 01:14:28
Line no.:23
Error Code: 1050 - Table 'weather' already exists

Query:
CREATE TABLE `spell_proc_data` (
`name_hash` int(30) NOT NULL,
`proc_chance` int(30) NOT NULL,
`forced_proc_flags` int(30) NOT NULL default '-1',
PRIMARY KEY (`name_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-25 01:14:49
Line no.:6
Error Code: 1050 - Table 'spell_proc_data' already exists

Query:
ALTER TABLE `worldmap_info` ADD COLUMN `heroic_keyid_1` INTEGER(30) NOT NULL DEFAULT 0 AFTER `required_item`

Error occured at:2007-11-25 01:15:56
Line no.:2
Error Code: 1060 - Duplicate column name 'heroic_keyid_1'

Query:
ALTER TABLE `quests` ADD COLUMN `ReqCastSpellId1` INTEGER(11) NOT NULL DEFAULT 0 AFTER `ReqKillMobOrGOCount4`

Error occured at:2007-11-25 01:16:04
Line no.:1
Error Code: 1060 - Duplicate column name 'ReqCastSpellId1'

Query:
ALTER TABLE `creatureloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`

Error occured at:2007-11-25 01:16:08
Line no.:1
Error Code: 1060 - Duplicate column name 'ffa_loot'

Query:
alter table worldmap_info add column viewingDistance float(0) not null default 80.0

Error occured at:2007-11-25 01:16:12
Line no.:1
Error Code: 1060 - Duplicate column name 'viewingDistance'

Query:
/* -- Project Re-name --
In this project We've decided to start rename column names, and make them more understand able.
*/
ALTER TABLE `ai_agents` CHANGE `entryId` `entry` INT(11) UNSIGNED NOT NULL DEFAULT '0'

Error occured at:2007-11-25 01:16:19
Line no.:6
Error Code: 1054 - Unknown column 'entryId' in 'ai_agents'

Query:
alter table items add column ArenaRankRequirement int(30) not null default 0 after ItemExtendedCost

Error occured at:2007-11-25 01:16:39
Line no.:1
Error Code: 1060 - Duplicate column name 'ArenaRankRequirement'

Query:
alter table worldmap_info add column required_checkpoint int(30) not null default 0

Error occured at:2007-11-25 01:16:55
Line no.:1
Error Code: 1060 - Duplicate column name 'required_checkpoint'

Query:
CREATE TABLE `charters` (
`charterId` int(30) NOT NULL,
`charterType` int(30) NOT NULL default '0',
`leaderGuid` int(20) unsigned NOT NULL default '0',
`guildName` varchar(32) NOT NULL default '',
`itemGuid` bigint(40) unsigned NOT NULL default '0',
`signer1` int(10) unsigned NOT NULL default '0',
`signer2` int(10) unsigned NOT NULL default '0',
`signer3` int(10) unsigned NOT NULL default '0',
`signer4` int(10) unsigned NOT NULL default '0',
`signer5` int(10) unsigned NOT NULL default '0',
`signer6` int(10) unsigned NOT NULL default '0',
`signer7` int(10) unsigned NOT NULL default '0',
`signer8` int(10) unsigned NOT NULL default '0',
`signer9` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`charterId`),
UNIQUE KEY `leaderGuid` (`leaderGuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-25 01:17:10
Line no.:18
Error Code: 1050 - Table 'charters' already exists

Query:
CREATE TABLE `server_settings` (
`setting_id` varchar(200) NOT NULL,
`setting_value` int(50) NOT NULL,
PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-25 01:17:17
Line no.:5
Error Code: 1050 - Table 'server_settings' already exists

Query:
CREATE TABLE `arenateams` (
`id` int(30) NOT NULL,
`type` int(30) NOT NULL,
`leader` int(30) NOT NULL,
`name` varchar(150) NOT NULL,
`emblemstyle` int(40) NOT NULL,
`emblemcolour` bigint(40) NOT NULL,
`borderstyle` int(40) NOT NULL,
`bordercolour` bigint(40) NOT NULL,
`backgroundcolour` bigint(40) NOT NULL,
`rating` int(30) NOT NULL,
`data` varchar(150) NOT NULL,
`ranking` int(30) NOT NULL,
`player_data1` varchar(60) NOT NULL,
`player_data2` varchar(60) NOT NULL,
`player_data3` varchar(60) NOT NULL,
`player_data4` varchar(60) NOT NULL,
`player_data5` varchar(60) NOT NULL,
`player_data6` varchar(60) NOT NULL,
`player_data7` varchar(60) NOT NULL,
`player_data8` varchar(60) NOT NULL,
`player_data9` varchar(60) NOT NULL,
`player_data10` varchar(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-25 01:17:21
Line no.:25
Error Code: 1050 - Table 'arenateams' already exists

Query:
alter table characters add column custom_faction int(30) default 0 not null after gender

Error occured at:2007-11-25 01:17:26
Line no.:1
Error Code: 1060 - Duplicate column name 'custom_faction'

Query:
ALTER TABLE playerpets DROP COLUMN autocastspell

Error occured at:2007-11-25 01:17:30
Line no.:1
Error Code: 1091 - Can't DROP 'autocastspell'; check that column/key exists

Query:
alter table playeritems add column randomsuffix int(30) default 0 after randomprop

Error occured at:2007-11-25 01:17:34
Line no.:1
Error Code: 1060 - Duplicate column name 'randomsuffix'

Query:
alter table mailbox add column external_attached_item_guid bigint(20) not null default 0 after attached_item_guid

Error occured at:2007-11-25 01:17:39
Line no.:1
Error Code: 1060 - Duplicate column name 'external_attached_item_guid'

Query:
alter table accounts add column forceLanguage varchar(5) not null default "enUS"

Error occured at:2007-11-25 01:17:51
Line no.:1
Error Code: 1060 - Duplicate column name 'forceLanguage'

Query:
alter table playeritems add column wrapped_item_id int(30) not null default 0 after entry

Error occured at:2007-11-25 01:18:05
Line no.:1
Error Code: 1060 - Duplicate column name 'wrapped_item_id'

Query:
ALTER TABLE `creatureloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`

Error occured at:2007-11-25 01:43:07
Line no.:1
Error Code: 1060 - Duplicate column name 'ffa_loot'

Query:
ALTER TABLE `creatureloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`

Error occured at:2007-11-25 01:43:11
Line no.:1
Error Code: 1060 - Duplicate column name 'ffa_loot'

Query:
ALTER TABLE `quests` ADD COLUMN `ReqCastSpellId1` INTEGER(11) NOT NULL DEFAULT 0 AFTER `ReqKillMobOrGOCount4`

Error occured at:2007-11-25 01:43:15
Line no.:1
Error Code: 1060 - Duplicate column name 'ReqCastSpellId1'

Query:
ALTER TABLE `worldmap_info` ADD COLUMN `heroic_keyid_1` INTEGER(30) NOT NULL DEFAULT 0 AFTER `required_item`

Error occured at:2007-11-25 01:43:20
Line no.:2
Error Code: 1060 - Duplicate column name 'heroic_keyid_1'

Query:
alter table accounts add column forceLanguage varchar(5) not null default "enUS"

Error occured at:2007-11-25 01:43:31
Line no.:1
Error Code: 1060 - Duplicate column name 'forceLanguage'

Query:
alter table mailbox add column external_attached_item_guid bigint(20) not null default 0 after attached_item_guid

Error occured at:2007-11-25 01:43:40
Line no.:1
Error Code: 1060 - Duplicate column name 'external_attached_item_guid'

Query:
CREATE TABLE `playeritems_external` (
`ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
`guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`entry` int(10) unsigned NOT NULL DEFAULT '0',
`creator` int(10) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`charges` int(10) unsigned NOT NULL DEFAULT '0',
`flags` int(10) unsigned NOT NULL DEFAULT '0',
`randomprop` int(10) unsigned NOT NULL DEFAULT '0',
`randomsuffix` int(30) NOT NULL,
`itemtext` int(10) unsigned NOT NULL DEFAULT '0',
`durability` int(10) unsigned NOT NULL DEFAULT '0',
`containerslot` int(11) DEFAULT '-1' COMMENT '',
`slot` tinyint(4) NOT NULL DEFAULT '0',
`enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`guid`),
UNIQUE KEY `guid` (`guid`),
KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Error occured at:2007-11-25 01:43:44
Line no.:19
Error Code: 1050 - Table 'playeritems_external' already exists

Query:
ALTER TABLE `creatureloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`

Error occured at:2007-11-25 09:09:43
Line no.:1
Error Code: 1060 - Duplicate column name 'ffa_loot'

Query:
ALTER TABLE `worldmap_info` ADD COLUMN `heroic_keyid_1` INTEGER(30) NOT NULL DEFAULT 0 AFTER `required_item`

Error occured at:2007-11-25 09:09:49
Line no.:2
Error Code: 1060 - Duplicate column name 'heroic_keyid_1'

Query:
CREATE TABLE `weather` (
`zoneId` int(11) unsigned NOT NULL DEFAULT '0',
`high_chance` int(11) unsigned NOT NULL DEFAULT '0',
`high_type` int(11) unsigned NOT NULL DEFAULT '0',
`med_chance` int(11) unsigned NOT NULL DEFAULT '0',
`med_type` int(11) unsigned NOT NULL DEFAULT '0',
`low_chance` int(11) unsigned NOT NULL DEFAULT '0',
`low_type` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`zoneId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System'

Error occured at:2007-11-25 09:10:01
Line no.:23
Error Code: 1050 - Table 'weather' already exists

Query:
CREATE TABLE `spell_proc_data` (
`name_hash` int(30) NOT NULL,
`proc_chance` int(30) NOT NULL,
`forced_proc_flags` int(30) NOT NULL default '-1',
PRIMARY KEY (`name_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-25 09:10:10
Line no.:6
Error Code: 1050 - Table 'spell_proc_data' already exists

Query:
alter table items add column ArenaRankRequirement int(30) not null default 0 after ItemExtendedCost

Error occured at:2007-11-25 09:10:39
Line no.:1
Error Code: 1060 - Duplicate column name 'ArenaRankRequirement'

Query:
alter table creature_names add column mouseFlags int(30) not null default 0 after subname

Error occured at:2007-11-25 09:10:44
Line no.:1
Error Code: 1060 - Duplicate column name 'mouseFlags'

Query:
CREATE TABLE `charters` (
`charterId` int(30) NOT NULL,
`charterType` int(30) NOT NULL default '0',
`leaderGuid` int(20) unsigned NOT NULL default '0',
`guildName` varchar(32) NOT NULL default '',
`itemGuid` bigint(40) unsigned NOT NULL default '0',
`signer1` int(10) unsigned NOT NULL default '0',
`signer2` int(10) unsigned NOT NULL default '0',
`signer3` int(10) unsigned NOT NULL default '0',
`signer4` int(10) unsigned NOT NULL default '0',
`signer5` int(10) unsigned NOT NULL default '0',
`signer6` int(10) unsigned NOT NULL default '0',
`signer7` int(10) unsigned NOT NULL default '0',
`signer8` int(10) unsigned NOT NULL default '0',
`signer9` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`charterId`),
UNIQUE KEY `leaderGuid` (`leaderGuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-26 00:51:34
Line no.:18
Error Code: 1050 - Table 'charters' already exists

Query:
alter table characters add column custom_faction int(30) default 0 not null after gender

Error occured at:2007-11-26 00:51:41
Line no.:1
Error Code: 1060 - Duplicate column name 'custom_faction'

Query:
alter table playeritems add column randomsuffix int(30) default 0 after randomprop

Error occured at:2007-11-26 00:51:44
Line no.:1
Error Code: 1060 - Duplicate column name 'randomsuffix'

Query:
alter table playeritems add column wrapped_item_id int(30) not null default 0 after entry

Error occured at:2007-11-26 00:51:53
Line no.:1
Error Code: 1060 - Duplicate column name 'wrapped_item_id'

Query:
CREATE TABLE `playeritems_external` (
`ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
`guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`entry` int(10) unsigned NOT NULL DEFAULT '0',
`creator` int(10) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`charges` int(10) unsigned NOT NULL DEFAULT '0',
`flags` int(10) unsigned NOT NULL DEFAULT '0',
`randomprop` int(10) unsigned NOT NULL DEFAULT '0',
`randomsuffix` int(30) NOT NULL,
`itemtext` int(10) unsigned NOT NULL DEFAULT '0',
`durability` int(10) unsigned NOT NULL DEFAULT '0',
`containerslot` int(11) DEFAULT '-1' COMMENT '',
`slot` tinyint(4) NOT NULL DEFAULT '0',
`enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`guid`),
UNIQUE KEY `guid` (`guid`),
KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Error occured at:2007-11-26 00:52:11
Line no.:19
Error Code: 1050 - Table 'playeritems_external' already exists

Query:
alter table playeritems add column wrapped_item_id int(30) not null default 0 after entry

Error occured at:2007-11-26 00:52:31
Line no.:1
Error Code: 1060 - Duplicate column name 'wrapped_item_id'

Query:
insert into `creature_names` (`entry`, `name`, `subname`, `mouseFlags`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('100002','Hunter Trainer','Ackhole Custom Trainers','0','0','4','0','3','0','0','18106','18106','0','0','1','1','0','0')

Error occured at:2007-11-26 08:52:52
Line no.:3
Error Code: 1062 - Duplicate entry '100002' for key 'entry'

Query:
CREATE TABLE `charters` (
`charterId` int(30) NOT NULL,
`charterType` int(30) NOT NULL default '0',
`leaderGuid` int(20) unsigned NOT NULL default '0',
`guildName` varchar(32) NOT NULL default '',
`itemGuid` bigint(40) unsigned NOT NULL default '0',
`signer1` int(10) unsigned NOT NULL default '0',
`signer2` int(10) unsigned NOT NULL default '0',
`signer3` int(10) unsigned NOT NULL default '0',
`signer4` int(10) unsigned NOT NULL default '0',
`signer5` int(10) unsigned NOT NULL default '0',
`signer6` int(10) unsigned NOT NULL default '0',
`signer7` int(10) unsigned NOT NULL default '0',
`signer8` int(10) unsigned NOT NULL default '0',
`signer9` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`charterId`),
UNIQUE KEY `leaderGuid` (`leaderGuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-26 11:04:15
Line no.:18
Error Code: 1050 - Table 'charters' already exists

Query:
alter table playeritems add column wrapped_item_id int(30) not null default 0 after entry

Error occured at:2007-11-26 11:04:33
Line no.:1
Error Code: 1060 - Duplicate column name 'wrapped_item_id'

Query:
CREATE TABLE `charters` (
`charterId` int(30) NOT NULL,
`charterType` int(30) NOT NULL default '0',
`leaderGuid` int(20) unsigned NOT NULL default '0',
`guildName` varchar(32) NOT NULL default '',
`itemGuid` bigint(40) unsigned NOT NULL default '0',
`signer1` int(10) unsigned NOT NULL default '0',
`signer2` int(10) unsigned NOT NULL default '0',
`signer3` int(10) unsigned NOT NULL default '0',
`signer4` int(10) unsigned NOT NULL default '0',
`signer5` int(10) unsigned NOT NULL default '0',
`signer6` int(10) unsigned NOT NULL default '0',
`signer7` int(10) unsigned NOT NULL default '0',
`signer8` int(10) unsigned NOT NULL default '0',
`signer9` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`charterId`),
UNIQUE KEY `leaderGuid` (`leaderGuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-11-26 22:34:15
Line no.:18
Error Code: 1050 - Table 'charters' already exists

Query:
alter table guild_ranks add column rankRights_1 int(30) not null default 0

Error occured at:2007-11-26 22:34:49
Line no.:1
Error Code: 1060 - Duplicate column name 'rankRights_1'

Query:
alter table playeritems add column wrapped_item_id int(30) not null default 0 after entry

Error occured at:2007-11-26 22:35:00
Line no.:1
Error Code: 1060 - Duplicate column name 'wrapped_item_id'

Query:
alter table playeritems add column wrapped_item_id int(30) not null default 0 after entry

Error occured at:2007-11-26 22:35:01
Line no.:1
Error Code: 1060 - Duplicate column name 'wrapped_item_id'

Query:
alter table accounts add column forceLanguage varchar(5) not null default "enUS"

Error occured at:2007-11-26 22:35:25
Line no.:1
Error Code: 1060 - Duplicate column name 'forceLanguage'

Query:
CREATE TABLE `playeritems_external` (
`ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
`guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`entry` int(10) unsigned NOT NULL DEFAULT '0',
`creator` int(10) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`charges` int(10) unsigned NOT NULL DEFAULT '0',
`flags` int(10) unsigned NOT NULL DEFAULT '0',
`randomprop` int(10) unsigned NOT NULL DEFAULT '0',
`randomsuffix` int(30) NOT NULL,
`itemtext` int(10) unsigned NOT NULL DEFAULT '0',
`durability` int(10) unsigned NOT NULL DEFAULT '0',
`containerslot` int(11) DEFAULT '-1' COMMENT '',
`slot` tinyint(4) NOT NULL DEFAULT '0',
`enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`guid`),
UNIQUE KEY `guid` (`guid`),
KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Error occured at:2007-11-26 22:35:30
Line no.:19
Error Code: 1050 - Table 'playeritems_external' already exists

Query:
alter table mailbox add column external_attached_item_guid bigint(20) not null default 0 after attached_item_guid

Error occured at:2007-11-26 22:35:34
Line no.:1
Error Code: 1060 - Duplicate column name 'external_attached_item_guid'

Query:
alter table playeritems add column randomsuffix int(30) default 0 after randomprop

Error occured at:2007-11-26 22:35:38
Line no.:1
Error Code: 1060 - Duplicate column name 'randomsuffix'

Query:
alter table worldmap_info add column required_checkpoint int(30) not null default 0

Error occured at:2007-11-26 22:35:50
Line no.:1
Error Code: 1060 - Duplicate column name 'required_checkpoint'

Query:
alter table creature_names add column mouseFlags int(30) not null default 0 after subname

Error occured at:2007-11-26 22:36:00
Line no.:1
Error Code: 1060 - Duplicate column name 'mouseFlags'

Query:
alter table items add column ArenaRankRequirement int(30) not null default 0 after ItemExtendedCost

Error occured at:2007-11-26 22:36:04
Line no.:1
Error Code: 1060 - Duplicate column name 'ArenaRankRequirement'

Query:
alter table worldmap_info add column viewingDistance float(0) not null default 80.0

Error occured at:2007-11-26 22:36:08
Line no.:1
Error Code: 1060 - Duplicate column name 'viewingDistance'

Query:
ALTER TABLE `quests` ADD COLUMN `ReqCastSpellId1` INTEGER(11) NOT NULL DEFAULT 0 AFTER `ReqKillMobOrGOCount4`

Error occured at:2007-11-26 22:36:12
Line no.:1
Error Code: 1060 - Duplicate column name 'ReqCastSpellId1'

Query:
ALTER TABLE `worldmap_info` ADD COLUMN `heroic_keyid_1` INTEGER(30) NOT NULL DEFAULT 0 AFTER `required_item`

Error occured at:2007-11-26 22:36:16
Line no.:2
Error Code: 1060 - Duplicate column name 'heroic_keyid_1'

Query:
alter table playeritems add column wrapped_item_id int(30) not null default 0 after entry

Error occured at:2007-11-26 23:35:50
Line no.:1
Error Code: 1060 - Duplicate column name 'wrapped_item_id'

Same error's i've been getting over the last few days

[grandmst20]

Means the update is implemented. T_T

Add that to the FAQ jab.

Q: I get an error when trying to run a SQL update.
A: You're either a moron or it's already implemented.

:D

[Paco44]

So mean but so true.

[grandmst20]

Just a quick note. Not all of you are morons. If you fix a problem after attempt #1 of someone telling you what to do, consider yourself of the better half.

[Digital727]

Erm... None of the SQL Updates fixed my character & there items issue.
It still happends..

[Paco44]

I'm the better half, lol.

[Digital727]

yeah... i am too :P

[qbert0]

He's also a noob because he uses SQLyog

[Paco44]

You got a problem with SQLYog?

[grandmst20]

He's also a noob because he uses SQLyog

You lookin' to start something?

[Digital727]

Got beef? :\


Grr... Only 2 bugs i have are the character coming back with deleted items and this damn release spirit shit...

Is there any way i can get these damn maps right.. I extracted my own using ad_enUS
and everything it needed and it still is releasing at ironforge..
and i'm not too sure if the items are still coming back, haven't really fully tested it.
but they probably are because i haven't really found out how to fix it.

i'm on rev 2427 now with 0.2.3 milestone.. possibly about to be rev 664