2069_required_pets.sql Error

[Huppy]

In this last sql update 2069_required_pets.sql it creates the specified tables,
but doesn't create the columns in the 'pets" table :

ALTER TABLE `pets` ADD COLUMN `petpower` int NOT NULL default '0' AFTER `type`, ADD COLUMN `petcontrol` tinyint NOT NULL default '0', ADD COLUMN `petnaming` tinyint NOT NULL default '0' ADD COLUMN `monsterflag` tinyint NOT NULL default '0', ADD COLUMN `equipmentset` int NOT NULL default -1, ADD PRIMARY KEY (`type`, `petpower`);

And obviously, after 2070 server update, one gets an error when trying to summon a pet:

[11.27. - 13:28:45] Error in GetPoweredPetEntry query 'SELECT npcID, temp, petpower, petcontrol, petnaming, monsterflag, equipmentset FROM pets WHERE type='DruidPet' AND petpower=0': #1054: Unknown column 'petpower' in 'field list'

[Tabasco]

I had a problem with this when I updated this morning. There is a missing comma.

ADD COLUMN `petnaming` tinyint NOT NULL default '0', ADD COLUMN `monsterflag`

From there you might need to comment out the first drop line since it executes properly.

[Huppy]

Originally Posted by Tabasco

I had a problem with this when I updated this morning. There is a missing comma.

ADD COLUMN `petnaming` tinyint NOT NULL default '0', ADD COLUMN `monsterflag`

From there you might need to comment out the first drop line since it executes properly.

Thank you very much, those 2 steps worked perfect

[Shayne]

I noticed with this patch also, every time you camp with bots that have pets it will crash the zone. I cleared out all of the botpet tables and still same result?

[Leere]

Thank you for finding the typo, I thought I had tested the whole thing, but apparently that was one thing I forgot. Sorry about that.

Fixing it now for the SVN along with the bot problem.