[Ascent]Naked character & Item cannot be saved

[yakkheng]

I'm Using:
WinXP Service Pack 2
SQLyog v6.14
Ascent Rev2527 (Tried 2539Ascent_Trunk)
Character 2.30 DB
2.3.0 enUS DBC
NCDB_Rev692 (Tried rev100)
Update SQL from Ascent 2527 Folder (also tried from Shadei's link)

I tried to search forum and FAQ also didn't solve the problem.
I'm also redo several times on character 2.30 DB,NCDB Rev692 and SQL update
still didn't solve the problem especially on Character.playeritems DB

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',              
               `wrapped_item_id` int(30) NOT NULL DEFAULT '0',             
               `wrapped_creator` int(30) 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(11) NOT NULL DEFAULT '0',                
               `itemtext` int(10) unsigned NOT NULL DEFAULT '0',           
               `durability` int(10) unsigned NOT NULL DEFAULT '0',         
               `containerslot` int(11) NOT NULL DEFAULT '-1',              
               `slot` tinyint(4) NOT NULL DEFAULT '0',                     
               `enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,   
               PRIMARY KEY (`guid`),                                       
               KEY `ownerguid` (`ownerguid`)                               
             ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

I can't think any other possibilities to solve it.Please enlighten me thank you.:native:

[MentaL]

[yakkheng]

Come On!! Anybody??

The latest i tried by using:

2.3.0 enUS DBC
695ncdb
Character 2.3.0
sql_updates12122007
Ascent 2546


still no luck..
why i'm the only getting this error.??

[Shadei]

delete your old character db and try this one

Shadei_CharacterDB_2.3.0.rar - 7.4 Kb

[yakkheng]

sadly, the problem still remain..but i only can see my character wearing cloth or armor when i choosing characters...if in the game my character will be naked :(

[Shadei]

hmm you may need to clean your cache files out. Also try a new clean install with newest revision database.

[yakkheng]

I tired to use:
[2548]Ascent_Trunk.rar - 2.8 Mb
AscentDBs.rar - 11.2 Mb
[2.3.0]DBC enUS - 3.1 Mb
Re-extract my maps
Clear my cache files

still cannot solve..this is very strange..what else did i done wrong :'(

[Shadei]

I can't think of anything that you did wrong...Have you added and client mods in the past? If so they may be causing the problems...

[yakkheng]

I use WoW-2.0.0-enUS-Installer , Burning Crusade and full patch to WoW-2.3.0-enUS.Nothing more...

Is there any log files i can show to the community?
Or is there any things i missed like... Microsoft .NET Framework 2.0..ect?

[nyfing]

man..if u want...download de mafiaboy repack..shopping mall and more...u'll need make a small updates...if not work try download milestone 2.2+ and uptade de DB
i hope can help..:angel_not:

http://forum.ragezone.com/f114/mafia...screen-330162/

[Maphew08]

I know, its the Player items tables
Delete and reimport fresh ones
Good Luck (y)

[Shadei]

I know, its the Player items tables
Delete and reimport fresh ones
Good Luck (y)

Oi, why didn't I think of that. Make sure, if your db is having trouble, when you are importing the new db that you delete the old one. :P

**EDIT**
anyone know why random replys i post get delete? It's been doing it since I signed up. No rule breaking, mod warnings, nothing. They just disappear.

[Maphew08]

I Have nooo idea.

[Paco44]

Make sure you have updated your server with all queries needed.

[yakkheng]

sigh...looks like i gona try to install all over again..

[Edit]
I tried to update sql manually over and over but still can't make it...can you guys share a working playeritems db to let me try pls thx..

This is my current playeritems Db with Ascent 2553:

         

/*DDL Information For - character.playeritems*/
-----------------------------------------------

Table        Create Table                                                                              
-----------  ------------------------------------------------------------------------------------------
playeritems  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',                                          
               `wrapped_item_id` int(30) NOT NULL DEFAULT '0',                                         
               `wrapped_creator` int(30) 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 '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

[oneybm]

I had the same problem and I can't remember how many times I uninstalled/reinstalled MySQL and cleared out the databases. I tried all the way to the latest revision and had the same problem. Then to top it off even if we played the chars as soon as we logged out we had lost our entire inventories. Good times I tell you.

Sorry I couldn't be of better help

Oneybm

[yakkheng]

Yea..sigh..I lost my confident to fix this unknown error..or meybe we need to wait till ascent have better SQL Database Version..

[markzarkdavis]

I refuse to belive there is no solution to this!

[PachecoF]

omg im having the same problem, and im usind NCDB 701 and Ascent 2554

[markzarkdavis]

I've found out that if your character.playeritems DB has nothing but 1 item in it, that item will appear when you log back in. As soon as there is more then 1 item, no items appear.

[Paco44]

Playeritems is the database which obviously stores the gear. It should display everyones items, or else, you may have to get a fresh one and start over again, because it is corrupted.

[nalfien]

Add two columns to your character.playeritems table.

Doesn't matter what they're called, just add them.

If anybody knows how to get the characters to show up not naked at the login screen, I would be most appreciative.

[stepbystep]

if you are running mysql 6 uninstall and get 5.0
MySQL AB :: MySQL 5.0 Downloads

thar solved the naked problem for me.

-Allan