View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] 1 ERRORS DURING UPGRADE TO VERSION V12.0.0 - ProjeQtOr
 

[SOLVED] 1 ERRORS DURING UPGRADE TO VERSION V12.0.0

More
08 Jan 2025 07:09 #1 by GhaziTriki
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

Please Log in or Create an account to join the conversation.

More
09 Jan 2025 09:10 #2 by maxca
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
The following user(s) said Thank You: GhaziTriki

Please Log in or Create an account to join the conversation.

More
09 Jan 2025 09:12 #3 by GhaziTriki
Thank you for the fix. Not urgent. It will wait for the next minor release.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.033 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.