Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
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.