Pet error doesnt save menu

User Tag List

Results 1 to 3 of 3
  1. #1
    paradox1252003's Avatar Member
    Reputation
    1
    Join Date
    Oct 2008
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Pet error doesnt save

    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.

    Pet error doesnt save
  2. #2
    Lukas 45's Avatar Active Member
    Reputation
    43
    Join Date
    Jan 2008
    Posts
    559
    Thanks G/R
    4/4
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    paradox1252003's Avatar Member
    Reputation
    1
    Join Date
    Oct 2008
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I looked over the information via the link you posted. I used the code found there, but am still having the same problems. You mentioned that there may be an error in the .exe of .dll file, if so which one, and where would I go to find working replacements?

Similar Threads

  1. [ArcEmu] Hunter pets not being saved after relog
    By RoyPwns in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 04-15-2010, 02:19 PM
  2. Pet doesnt save? :O
    By zlo in forum WoW EMU Questions & Requests
    Replies: 2
    Last Post: 08-09-2008, 07:50 PM
  3. [HELP]Quest Doesnt Save
    By aziz in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 06-14-2008, 05:08 PM
  4. when i start DButilEx it says "Crittical error cant find file players.save"
    By Foxmandan in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 01-11-2008, 03:11 PM
  5. how do i add and save pets for Antrix?
    By ScottyBoy in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 09-17-2007, 07:48 PM
All times are GMT -5. The time now is 07:09 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search