Error in 24.04.000.077 - SQL Insert fails

Use this forum to report bugs and to check for bugfixes and new releases of OpenEMM

Moderator: moderator

JuergenB
Posts: 142
Joined: Thu Dec 05, 2019 9:03 pm

Error in 24.04.000.077 - SQL Insert fails

Post by JuergenB »

After upgrading to 24.04.000.077 i can´t change mailings.
After hitting save, there is a box with message error.

i get an email with this error message

Code: Select all

SQL: INSERT INTO undo_mailing_tbl (mailing_id, undo_creation_date, undo_admin_id) VALUES (?, ?, ?) autoincrement: undo_id
Parameter: 158, java.util.Date:'2024-06-26_11:50:19,157', 2
Exception:
DataIntegrityViolationException:
PreparedStatementCallback; SQL [INSERT INTO undo_mailing_tbl (mailing_id, undo_creation_date, undo_admin_id) VALUES (?, ?, ?)]; (conn=66) Field 'undo_id' doesn't have a default value; nested exception is java.sql.SQLException: (conn=66) Field 'undo_id' doesn't have a default value
...
Found the bug, the upgrade scripts from early version missed to change undo_mailing_tbl
I changed the default value to AUTO INCREMENT and added a Key to this entry.