View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQLState Error, V11.4.2 and beyond. - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

6 mars 2025 (10h30-12h)

3 avril 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

18 et 19 mars 2025 (9h-12h30)

15 et 16 avril 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

18 et 19 février (9h-12h30)

25 et 26 mars (9h-12h30)

 

 

 

SQLState Error, V11.4.2 and beyond.

More
06 Jan 2025 11:05 #1 by VERNCon
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.

Please Connexion or Create an account to join the conversation.

More
06 Jan 2025 14:45 - 06 Jan 2025 14:46 #2 by Damian.sd
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');
Last edit: 06 Jan 2025 14:46 by Damian.sd.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.034 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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