Hello,
I just updated to 12.0.0 and I got this SQL error2025-01-08 07:05:46.430 ** ERROR ** [V11.4.2] [1] 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-08 07:05:46.430 ** ERROR ** [V11.4.2] [1] For query : INSERT INTO copyable (id, name, idle, sortOrder, idDefaultCopyable) VALUES (NULL, 'Acceptance', '0', '930', '15');
2025-01-08 07:05:46.430 ** ERROR ** [V11.4.2] [1] Strack trace :
2025-01-08 07:05:46.431 ** ERROR ** [V11.4.2] [1] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:72]
2025-01-08 07:05:46.431 ** ERROR ** [V11.4.2] [1] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:179]
2025-01-08 07:05:46.431 ** ERROR ** [V11.4.2] [1] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:144]
2025-01-08 07:05:46.431 ===== TRACE ===== [1]
2025-01-08 07:05:46.431 ===== TRACE ===== [1] Error # 1 => SQL error while executing maintenance query for version V12.0.0 (see above message)
Thanks
Hello,
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');
the correction is available on the subscription service
Have a nice day,
Maxca
Thank you for the fix. Not urgent. It will wait for the next minor release.