Hi,
Happy New Year to all.
After upgrading to 11.4.2 version I got an error relating to SQLSTATE "non null violation", and it continues after upgrade to 12.0.0.
The Log excerpt is:
2025-01-06 10:25:08.552 ===== TRACE ===== Table "workcommand" altered.
2025-01-06 10:25:08.554 ===== TRACE ===== Table "workcommand" altered.
2025-01-06 10:25:08.556 ===== TRACE ===== Table "workcommandaccepted" altered.
2025-01-06 10:25:08.558 ===== TRACE ===== Table "workcommandaccepted" altered.
2025-01-06 10:25:08.560 ** ERROR ** [V11.4.2] Exception-[23502] SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "id" of relation "copyable" violates not-null constraint
DETAIL: Failing row contains (null, Acceptance, 0, 930, 15).
2025-01-06 10:25:08.560 ** ERROR ** [V11.4.2] For query : INSERT INTO copyable (id, name, idle, sortOrder, idDefaultCopyable) VALUES (NULL, 'Acceptance', '0', '930', '15');
2025-01-06 10:25:08.560 ** ERROR ** [V11.4.2] Strack trace :
2025-01-06 10:25:08.560 ** ERROR ** [V11.4.2] #0 Sql->query called at [/srv/www/html/verncon/projeqtor/db/maintenanceFunctions.php:72]
2025-01-06 10:25:08.560 ** ERROR ** [V11.4.2] #1 runScript called at [/srv/www/html/verncon/projeqtor/db/maintenance.php:179]
2025-01-06 10:25:08.561 ** ERROR ** [V11.4.2] #2 include called at [/srv/www/html/verncon/projeqtor/tool/loginCheck.php:144]
2025-01-06 10:25:08.561 ===== TRACE =====
2025-01-06 10:25:08.561 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V12.0.0 (see above message)
2025-01-06 10:25:08.561 ===== TRACE =====
2025-01-06 10:25:08.561 ===== TRACE ===== *************************************************
Checking table "copyable" in the database, the Values listed in the error message are not seen, i.e, VALUES (NULL, 'Acceptance', '0', '930', '15')
Your assistance in correcting the error will be greatly appreciated.
Cheers,
Garth.
Happy new year !
This issue has been fixed but not deployed yet, it's not a blocking issue but if you need to fixed it yourself try remove 'id' and NULL in the sql script from the files projeqtor_V12.0.0.sql like this : INSERT INTO `${prefix}copyable` (`name`, `idle`, `sortOrder`, `idDefaultCopyable`) VALUES ('Acceptance', '0', '930', '15');