[Ascent] Naked Characters! Help!?

[SithMaster]

The characters are naked. And do not have any items.
Please tell me what to do to fix it!?
Using NCDB Rev 636
NCDB Character Database (Full)

[MentaL]

[hate_a3]

same here, i bought items for the char then log out then he's naked again

[pudgemuffins]

I have this same problem. I believe it has something to do with Playeritems table being corrupted. I will work on this tonight.

[grandmst20]

I'll take a look and see.

Oh...make sure if you're using Full you are using the latest Ascent Rev.

[SithMaster]

I don't know how to compile T_T
The newest server software always fails for me.

[hantu]

The characters are naked. And do not have any items.
Please tell me what to do to fix it!?
Using NCDB Rev 636
NCDB Character Database (Full)

Hello,

I had same problem before, what helped me is that code below. Just removed the "playeritems" table from DB and ran this query in SQLyog:

USE `character`;change "character" to your database name

CREATE TABLE `playeritems` (
  `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) DEFAULT '0',
  `itemtext` int(10) unsigned NOT NULL DEFAULT '0',
  `durability` int(10) unsigned NOT NULL DEFAULT '0',
  `containerslot` int(11) DEFAULT '-1' COMMENT 'couldnt find this being used in source',
  `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;

Let me know if it helped.

Have Fun !!

[SithMaster]

I will try it out.
I have to repair the WOW client. So When thats done. I will load it up And see if it fixed it.
Hope it works if not will post here again.

[SithMaster]

Thanks dude it worked!

[rasta-raus]

The characters are naked. And do not have any items.
Please tell me what to do to fix it!?
Using NCDB Rev 636
NCDB Character Database (Full)

Im having the same problem and ive tried everything possibol...


EDIT: Cant figure out how to run the query in SQLyog

EDIT: Got it thanks for the help!

[rasta-raus]

sry for double post but i dont see a playeritems to tell u the truth lol

[inphyy]

Hello,

I had same problem before, what helped me is that code below. Just removed the "playeritems" table from DB and ran this query in SQLyog:

USE `character`;change "character" to your database name

CREATE TABLE `playeritems` (
  `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) DEFAULT '0',
  `itemtext` int(10) unsigned NOT NULL DEFAULT '0',
  `durability` int(10) unsigned NOT NULL DEFAULT '0',
  `containerslot` int(11) DEFAULT '-1' COMMENT 'couldnt find this being used in source',
  `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;

Let me know if it helped.

Have Fun !!

:/ isnt working for me ,, i use ascent 2303 and ncdb 643 , i tride to fix it but nothing seems to help ,