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

SQL ERRO during update from 12.1.2 TO 12.4

More
23 Dec 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 Log in or Create an account to join the conversation.

More
23 Dec 2025 10:59 - 23 Dec 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 Dec 2025 11:00 by Damian.sd.

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

Moderators: babynusprotion
Time to create page: 0.035 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.