#bot delete issue

Drakson · #1 11-02-2009, 06:58 PM

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.

Code:

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/....php?f=24&t=40

EDIT: Server is on Rev: 1038

**WildcardX** · #2 11-02-2009, 09:29 PM

Ooopppsss.

louis1016 · #3 07-29-2011, 11:04 AM

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 · #4 10-16-2011, 01:22 PM

Bumping this because its happening to me.

**bad_captain** · #5 12-07-2011, 12:17 PM

This should be fixed in rev 2087.

steve007 · #6 02-01-2014, 10:19 AM

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 · #7 02-01-2014, 10:27 AM

Solution:

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