EQEmulator Forums - 2069_required

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - 2069_required_pets.sql Error (https://www.eqemulator.org/forums/showthread.php?t=34523)

2069_required_pets.sql Error

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

Code:

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'

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

Code:

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.

Quote:

Originally Posted by Tabasco (Post 204900)

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

Code:

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 :)

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?

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.