Ascent Question/Error?

[Coty]

First off I'm running spartansp's repack. And what keeps happening and I'll extract the sql files into the database with Navicat 8, run the server which goes fine, then I'll add an item to myself. When I add the item then log off the item disappears, but it shows it as being equipped on the character selection page but you enter the realm and your naked. Anyone know why it keeps happening? All help is appreciated.

Thanks,
Coty

[Lich King]

I have no idea, that happens to me to, if any1 could figure out a fix for that, it would be nice

[**Sweeny**]

Thats exactly whats happening too me! lol weird...using spartansp's repack aswell..

[Lich King]

actually it happens on alot of repacks, i have no idea why

[Coty]

I asked him about it on MSN and he said its something with the database, he said I'm missing tables or something. Meaning he didn't include them in the repack? I'm not sure.. But I'd really like a fix o.O

[**Sweeny**]

Make sure you got all the tables, check here Categoryatabase - Ascent Wiki I got all the tables,deleted chache folder. still doesnt work.. :S

[**Sweeny**]

Oh yes, sorry for double post but try this found it on ragezone..

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;

run into db

[Coty]

Oh yes, sorry for double post but try this found it on ragezone..

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;

run into db

Wait, so this is saying if I'm correct is to seperate the databases? And execute this command?

[**Sweeny**]

No, I think its just change the top bit

USE `character`;

character too ur db name e.g. ascent then under it copy that table, import into same db save as notepad like fix.sql or import into db in query.

[Coty]

Yeah.. Didn't work.

[Lich King]

aww well, some one will find a way

[**Sweeny**]

Yeah, didnt work for me either, just going too use a diffrent repack, others work for me. Tried replacing the playeritems table aswell, but still nothing.. alot of ppl are talking about the ascent revs of it being the problem going too try a new rev too see if that works.

[Coty]

I'm gonna try Rouslan's Repack, hope it works.

[Lich King]

if it woks send me a message and tell me

[Coty]

Mk, will do I hope it works.