Error in 24.04.000.077 - SQL Insert fails
Posted: Wed Jun 26, 2024 10:55 am
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
...
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.
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.