Forum

SQL ERRO during upd...
 
Notifications
Retirer tout

SQL ERRO during update from 12.1.2 TO 12.4

2 Posts
2 Utilisateurs
0 Reactions
441 Vu
(@pipobru)
Posts: 180
Reputable Member
Début du sujet
 
[#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.


 
Posté : 23/12/2025 10:30 am
Damian
(@damian-sd)
Posts: 119
Membre 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.


 
Posté : 23/12/2025 12:59 pm
Share:
Retour en haut