Ticket #465 (new defect)
asset/delete cascade problem?
| Reported by: | MC-arjen | Owned by: | |
|---|---|---|---|
| Priority: | major | Milestone: | MediaMosa X.X |
| Component: | Core | Version: | |
| Keywords: | Cc: | ||
| MoSCoW: | Should Have | Estimated time after impact analysis: | |
| Related to project: | none | Tested: | no |
| Accepted: | no | Estimated Hours: | 0 |
Description
Error seen on production:
REFERRER
MESSAGE 'PDOException caught file /var/opt/www/vpcore/htdocs/includes/database/database.inc at line 1927; SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails ("vpcore"."mediamosa_asset_mediafile", CONSTRAINT "fk_mediamosa_asset_mediafile_asset_id" FOREIGN KEY ("asset_id") REFERENCES "mediamosa_asset" ("asset_id")), trace; #0 /var/opt/www/vpcore/htdocs/includes/database/database.inc(1927): PDOStatement->execute(Array)
#1 /var/opt/www/vpcore/htdocs/includes/database/database.inc(557): DatabaseStatementBase?->execute(Array, Array)
#2 /var/opt/www/vpcore/htdocs/includes/database/query.inc(950): DatabaseConnection?->query(\'DELETE FROM {me...\', Array, Array)
#3 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/core/asset/mediamosa_asset.inc(278): DeleteQuery?->execute()
#4 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/modules/asset/mediamosa_asset.rest.inc(651): mediamosa_asset::delete(\'i1EUwMXAgWL7F9X...\', true)
#5 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/rest/mediamosa_rest_call.inc(281): mediamosa_rest_call_asset_delete->do_call()
#6 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/rest/mediamosa_rest.inc(314): mediamosa_rest_call->process_call()
#7 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/response/mediamosa_response.inc(131): mediamosa_rest->process_call(Array)
#8 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/mediamosa.module(124): mediamosa_response->process_rest()
#9 [internal function]: mediamosa_init()
#10 /var/opt/www/vpcore/htdocs/includes/module.inc(745): call_user_func_array(\'mediamosa_init\', Array)
#11 /var/opt/www/vpcore/htdocs/includes/common.inc(4561): module_invoke_all(\'init\')
#12 /var/opt/www/vpcore/htdocs/includes/bootstrap.inc(2015): _drupal_bootstrap_full()
#13 /var/opt/www/vpcore/htdocs/index.php(21): drupal_bootstrap(7)
#14 {main}.'
SEVERITY notice
