Deleting Media items from inside the layout timeline editor does not work

[Alex Harrington]

Deleting Media items from inside the layout timeline editor does not work. Unassigning fine.

Steps to reproduce.

* Create new layout.
* Add Region
* Double-click new region
* Add Image (upload a new file)
* Back on the timeline view, click "Delete"
* Choose "Delete this media" from the options
* Click "Yes".

Error message displayed "Database error deleting this media record".

From the log:
<errormsg>The query [DELETE FROM media WHERE mediaid = 6 ] failed to execute<br />MySQL error: Cannot delete or update a parent row: a foreign key constraint fails (`xibo_1/lklayoutmedia`, CONSTRAINT `lklayoutmedia_ibfk_1` FOREIGN KEY (`mediaID`) REFERENCES `media` (`mediaID`))</errormsg>
<errornum>1024</errornum>
<errortype>User Notice</errortype>
<scriptname>/sites/xibo.longhill.org.uk/htdocs/xibo-server/server/modules/image.module.php</scriptname>
<scriptlinenum>842</scriptlinenum>

-------------------------------------------------------------------------
If I choose "Unassign from this region only" -> Yes, then visit the library and delete the item there, it works fine.

[Dan Garner (dangarner)]

OK - I can recreate this.

Seems to be ignoring / missing a call to unassign the media before deleting. I will check this out.

[Dan Garner (dangarner)]

Will fix for RC2