docdoku / docdoku-plm

The project purpose is to develop a comprehensive, robust open source PLM (Product LifeCycle Management) solution.
http://www.docdokuplm.com
GNU Affero General Public License v3.0
242 stars 99 forks source link

Error 500 on WS for customization on columns of parts #1133

Closed hobywhan closed 6 years ago

hobywhan commented 6 years ago

When doing a customization on columns of parts, when I select columns or click on default columns and save, there is an error 500 on the WS https://server/eplmp-server-rest/api/workspaces/workspacename/front-options

Unhandled system error : sun.reflect.NativeConstructorAccessorImpl.newInstance0 threw com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (docdokuplm.WORKSPACE_PARTTABLECOLUMN, CONSTRAINT FK_WORKSPACE_PARTTABLECOLUMN_WORKSPACE_ID FOREIGN KEY (WORKSPACE_ID) REFERENCES WORKSPACEOPTIONS (WORKSPACE_ID)) in NativeConstructorAccessorImpl.java at line -2

hobywhan commented 6 years ago

Database error, forgot to do a sql migration on the database which thrown an exception.