[Ascent] Updated DB, Naked characters!

[DarkJade]

Well the title pretty much says it all. I just updated my DB to some MGT database or something.. I dunno I was told it was good. Anyways now when you try to login the chars are naked and their items are gone. How do i fix this? Thank you

DarkJade

[MentaL]

[SkH]

Well the title pretty much says it all. I just updated my DB to some MGT database or something.. I dunno I was told it was good. Anyways now when you try to login the chars are naked and their items are gone. How do i fix this? Thank you

DarkJade

I suggest you to use a newer DB, the best is NCDB, so just Grab The Newest one: NCDB Rev 633. ;)

Edit the tool file with a text editor and give your user and pass info aswell as your World and Character DB.

Good Luck!

[s3m3L]

I suggest you to use a newer DB, the best is NCDB, so just Grab The Newest one: NCDB Rev 633. ;)

Edit the tool file with a text editor and give your user and pass info aswell as your World and Character DB.

Good Luck!

Where you got that Rev633? oO

[SkH]

Where you got that Rev633? oO

From the very source!! ;)

[leslamarch]

Well the title pretty much says it all. I just updated my DB to some MGT database or something.. I dunno I was told it was good. Anyways now when you try to login the chars are naked and their items are gone. How do i fix this? Thank you

DarkJade

or just run this
alter table playeritems add column randomsuffix int(30) default 0 after randomprop;

[DarkJade]

i tried that it didnt help

[Paperz]

try these rev 1844 ALTER TABLE playerpets DROP COLUMN autocastspell; UPDATE playerpets SET actionbar=""; rev 1923 alter table playeritems add column randomsuffix int(30) default 0 after randomprop; rev 2068 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; alter table mailbox add column external_attached_item_guid bigint(20) not null default 0 after attached_item_guid; if you need any later revisions lemme know

[Paperz]

it appears its word wrapped :/ dont copy all of it,each part starts at "rev"

[DarkJade]

I have ascent rev2088