Forum

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.

SQL ERRO during upd...
 
Notifications
Clear all

SQL ERRO during update from 12.1.2 TO 12.4

2 Posts
2 Users
0 Reactions
525 Views
(@pipobru)
Posts: 180
Active Member
Topic starter
 
[#10013]

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.


 
Posted : 23 Dec 2025 10H30
Damian
(@damian-sd)
Posts: 119
Active Member Admin Registered
 

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.


 
Posted : 23 Dec 2025 12H59
Share:

Scroll to Top