View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQL ERRO during update from 12.1.2 TO 12.4 - ProjeQtOr

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

7 janvier 2026 (10h30-12h)

3 février 2026 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 janvier 2026 (9h-12h30)

10 et 11 février 2026 (9h-12h30)

 
 

Administrez avec ProjeQtOr

21 et 22 janvier 2026 (9h-12h30)

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

 

 

 

SQL ERRO during update from 12.1.2 TO 12.4

More
23 Déc 2025 08:30 #1 by pipobru
Hello,
During the update process i have this SQL error:2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 7 ERROR: numeric field overflow
DETAIL: A field with precision 3, scale 0 must round to an absolute value less than 10^3.
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] For query : INSERT INTO columnselector
(scope,objectClass,idUser,field,attribute,hidden,sortOrder,name)
SELECT
'workflow' AS scope,
CONCAT('workflow#', w.id) AS objectClass,
s.id AS idUser,
s.name AS field,
s.name AS attribute,
CASE
WHEN s.forAgileScrum = '1' THEN 0
WHEN s.id = (
SELECT s2.id
FROM status s2
WHERE s2.forAgileScrum = '0'
AND s2.idle = '0'
ORDER BY s2.sortOrder ASC, s2.id ASC
LIMIT 1
) THEN 0
ELSE 1
END AS hidden,
COALESCE(s.sortOrder, s.id) * 10 + 300 AS sortOrder,
CONCAT('workflow#', w.id, ' status#', s.id) AS name
FROM workflow w
JOIN status s ON 1=1
LEFT JOIN columnselector cs
ON cs.scope='workflow'
AND cs.objectClass = CONCAT('workflow#', w.id)
AND cs.idUser = s.id
WHERE w.name = 'Agile'
AND cs.id IS NULL;
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] Strack trace :
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] #0 Sql->query called at [/var/www/html/db/maintenanceFunctions.php:72]
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] #1 runScript called at [/var/www/html/db/maintenance.php:179]
2025-12-22 17:55:59.066 ***** ERROR ***** [V12.1.2] #2 include called at [/var/www/html/tool/loginCheck.php:145]
2025-12-22 17:55:59.067 ===== TRACE =====
2025-12-22 17:55:59.067 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V12.4.0 (see above message)
2025-12-22 17:55:59.067 ===== TRACE =====
2025-12-22 17:55:59.067 ===== TRACE ===== *************************************************

My question is: it is un blooking point or not ?
Thanks for your feedback.
Bruno.

Please Connexion or Create an account to join the conversation.

More
23 Déc 2025 10:59 - 23 Déc 2025 11:00 #2 by Damian.sd
Hi,
thank for your feedback,
this sql error is not blocking if your not using the new Agile scrum feature.
We create a new ticket #10951 for this issue it will be fix in next patch and if your got subscription you can get the fixe as soon has it will be fixed.
Last edit: 23 Déc 2025 11:00 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.