#bot delete issue

[Drakson]

When using the bot delete command, if there are any buffs in the botbuffs table for the bot you try to delete you get a constraint error.

Database Error:#1451. Cannot delete or update a parent row: a foreign key constraint fails ('peq/botbuffs', CONSTRAINT ' FK_botbuff_1' FOREIGN KEY ('Botid') REFERENCES 'Bots' ('botID'))

A cascade delete needs to be put on this constaint.

Error posted here:
http://raven.fullongamer.com/forums/viewtopic.php?f=24&t=40

EDIT: Server is on Rev: 1038

[WildcardX]

Ooopppsss.

[louis1016]

I am getting this issue on a clean server install when I try to delete any bots (buffed or not buffed already). Anyone know what the issue is?

[LordAdakos]

Bumping this because its happening to me.

[bad_captain]

This should be fixed in rev 2087.

[steve007]

Bumped this as it happening again it seems.. was this an issue in the new Rev?

Anyone else experiencing this issue?

UPDATE::

I can delete bots with basic names.. i.e Hulk, tiptoe

But not.

Raidclerictwo

Raidwarriortwo

and so on...

[steve007]

Solution:

You cannot delete Bots which are in raid groups or Bot botgroups... remove from bot groups. (Even if not summoned) to delete :)