I am running AC Web Ultimate Repack ArcEmu Trunk r 534. I cannot get my pets to save after logout. I get the following error from the datatbase.
Column count doesnt match value count at row 1........
I have completed all the sql updates from the appropriate folder, as well as entered the following
DROP TABLE IF EXISTS `playerpets`;
CREATE TABLE `playerpets` (
`ownerguid` bigint(20) NOT NULL default '0',
`petnumber` int(11) NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`entry` int(10) unsigned NOT NULL default '0',
`fields` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
`xp` int(11) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '0',
`level` int(11) NOT NULL default '0',
`happiness` int(11) NOT NULL default '0',
`actionbar` varchar(200) NOT NULL default '',
`happinessupdate` int(11) NOT NULL default '0',
`summon` int(11) NOT NULL default '0',
`loyaltypts` int(11) NOT NULL,
`loyaltyupdate` int(11) NOT NULL,
`reset_time` int(10) unsigned NOT NULL default '0',
`reset_cost` int(10) NOT NULL default '0',
PRIMARY KEY (`ownerguid`,`petnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playerpetspells
-- ----------------------------
DROP TABLE IF EXISTS `playerpetspells`;
CREATE TABLE `playerpetspells` (
`ownerguid` bigint(20) NOT NULL default '0',
`petnumber` int(4) NOT NULL default '0',
`spellid` int(4) NOT NULL default '0',
`flags` int(4) NOT NULL default '0',
KEY `a` (`ownerguid`),
KEY `b` (`petnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE playerpets ADD COLUMN reset_time int(10) unsigned NOT NULL DEFAULT 0;
ALTER TABLE playerpets ADD COLUMN reset_cost int(10) NOT NULL DEFAULT 0
I am using navicat to edit the database. Any help and or assitance with this problem would be greatly appreciated. Thank you for your time and attention.