Ticket #220 (closed defect: fixed)
Deleting asset with running jobs gives an error.
| Reported by: | MC-arjen | Owned by: | robert |
|---|---|---|---|
| Priority: | major | Milestone: | MediaMosa 2.1 |
| Component: | Core | Version: | |
| Keywords: | Cc: | ||
| MoSCoW: | Must Have | Estimated time after impact analysis: | |
| Related to project: | none | Tested: | yes |
| Accepted: | yes | Estimated Hours: |
Description
Deleting a mediafile from an asset can give an msyql error:
* user warning: Cannot delete or update a parent row: a foreign key constraint fails (`vpx_data`.`job`, CONSTRAINT `fk_job_asset` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`asset_id`)) query: _media_management_delete_asset /* admin : _media_management_delete_asset */ DELETE FROM asset WHERE asset_id = 'YVCeB3kwcshca87QwjTPdQbS' in /var/opt/www/vpx/htdocs/sites/all/modules/media_management/media_management.module on line 299.
* A unexpected program error / problem happened
This message should at least be handled in a nicer way.
(In the current design you cannot delete an asset with a running job, after 2 days the job will be deleted in the cron cleanup jobs)
Change History
Note: See
TracTickets for help on using
tickets.
