DB write errors

[jpyou127]

I just moved and updated a DB that was running on an older source. Everything looks to be working splendidly. One issue I am having and I cannot seem to figure it out but can recreate is that AAs that are bought will disappear after zoning and I am also seeing the inability to purchase AAs. Any ideas on if this is a DB or source issue? Also, it seems that this is new characters as well as older characters.


Celestial

[jpyou127]

Update: Looks like its a mismatch between client and database. Not sure how to repair it yet.


Celestial

[demonstar55]

What does DESCRIBE character_alternate_abilities; return?

[jpyou127]

Here is whats returned: DESCRIBE character_alternate_abilities;


Field Type Null Key Default Extra
id int(11) unsigned NO PRI 0
slot smallint(11) unsigned NO PRI 0
aa_id smallint(11) unsigned NO 0
aa_value smallint(11) unsigned NO 0
charges smallint(11) unsigned NO 0


Thanks for the Code Block suggestion!

[Cilraaz]

I'm no help on the issue at hand, but you can use a code block in place of a quote block to maintain formatting.

[jpyou127]

I ran the query against a current DB and I see that the table column "slot" is not present.

I think it maybe safe to remove that column and readjust.


Celestial

[demonstar55]

I guess this didn't happen?

RENAME TABLE `character_alternate_abilities` TO `character_alternate_abilities_old`;
DROP TABLE IF EXISTS `character_alternate_abilities`;
CREATE TABLE IF NOT EXISTS `character_alternate_abilities` (
`id` int(11) unsigned NOT NULL DEFAULT '0',
`aa_id` smallint(11) unsigned NOT NULL DEFAULT '0',
`aa_value` smallint(11) unsigned NOT NULL DEFAULT '0',
`charges` smallint(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`,`aa_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[jpyou127]

You are correct I do not have a 'character_alternate_abilities_old'

=)


Celestial

[jpyou127]

I posted earlier, but I guess it didnt make it. But I deleted the column 'slot' and set primary keys to match the table in a newer DB.


Celestial