5 replies to this topic

[funktasticmo]

Ok so since the update we had on my server we are now aspire-hearthstone.

We just started to make some more items and we are getting a incorrect column error for all the items we use with the aspire sql batch... any ideas?

[wolfnarq]

Showing the actual error would help

[Moartea]

probably another db structure change... that would be sick

[funktasticmo]

Ok... neither of those really helped. and I told you the EXACT error says it is an incorrect column. that is what it says.

[wolfnarq]

I want the actual error you get. Try to execute it then copy and paste the error that you get here. Otherwise you're on your own.

[xnaruto136x]

If it was just changing the server from arcemu to aspire then just use the conversion

-- itempages_localized
ALTER TABLE `itempages_localized` CHANGE column `text` `text` text DEFAULT NULL;
-- items
ALTER TABLE `items` CHANGE `entry` `entry` int(30) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `items` CHANGE `unk203_1` `RandomSuffixId`  int(11) NOT NULL DEFAULT 0 AFTER `randomprop`;
ALTER TABLE `items` CHANGE `unk2` `ArmorDamageModifier`  int(11) NOT NULL DEFAULT 0 AFTER `ReqDisenchantSkill`;
ALTER TABLE `items` DROP COLUMN `ScaledStatsDistributionId`;
ALTER TABLE `items` DROP COLUMN `ScaledStatsDistributionFlags`;
ALTER TABLE `items` DROP COLUMN `ItemLimitCategoryId`;

and it should work fine, but if you had another db than arc emu then it will be more challenging, and I could help more if I knew what db you started at. If you had arcemu and you don't have the entire db changed just tell me and I will post up a full conversion.