MySQL conversion script for mh_assets_asset table not setup completely

Steps to reproduce

Columns `mediapackage` and `version` are not dropped

Activity

Show:
Stephen Marquard
December 5, 2017, 10:03 AM

The presence of the non-null mediapackage field in mh_assets_asset can cause insertion errors:

017-12-04 09:18:53,400 | WARN | pool-2-thread-1 | (JavaLog:300) -
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Field 'mediapackage' doesn't have a default value <--- mediapackage is null over here
Error Code: 1364
Call: INSERT INTO mh_assets_asset (id, checksum, mediapackage_element_id, mime_type, size, snapshot_id) VALUES (?, ?, ?, ?, ?, ?)
bind => [6 parameters bound]
Query: InsertObjectQuery(org.opencastproject.assetmanager.impl.persistence.AssetDto@3eb2322e)

Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Unassigned

Reporter

duncan smith

Severity

Non Functioning