View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [RESOLVE] Error update 11,1,2 -> 11.1.3 - ProjeQtOr
 
 

[RESOLVE] Error update 11,1,2 -> 11.1.3

More
21 Jan 2024 18:09 - 22 Jan 2024 13:02 #1 by sharky
Hello,

I have an error when update 11,1,2 -> 11.1.3
2024-01-21 17:48:26.637 ===== TRACE ===== 
2024-01-21 17:48:26.638 ===== TRACE ===== =====================================
2024-01-21 17:48:26.638 ===== TRACE ===== 
2024-01-21 17:48:26.638 ===== TRACE ===== DataBase actual Version = V11.1.2
2024-01-21 17:48:26.638 ===== TRACE ===== ProjeQtOr actual Version = V11.1.3
2024-01-21 17:48:26.638 ===== TRACE ===== 
2024-01-21 17:48:26.639 ===== TRACE ===== =====================================
2024-01-21 17:48:26.639 ===== TRACE ===== 
2024-01-21 17:48:26.639 ===== TRACE ===== VERSION V11.1.3
2024-01-21 17:48:26.639 ===== TRACE ===== 
2024-01-21 17:48:26.640 ***** ERROR ***** [V11.1.2] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table '[DBNAME].reportlayout' doesn't exist
2024-01-21 17:48:26.640 ***** ERROR ***** [V11.1.2]    For query : ALTER TABLE `reportlayout` CHANGE `idFilterCriteria` `idFilter` INT UNSIGNED NULL DEFAULT NULL COMMENT '12';
2024-01-21 17:48:26.640 ***** ERROR ***** [V11.1.2]    Strack trace :
2024-01-21 17:48:26.640 ***** ERROR ***** [V11.1.2]    #0 Sql->query called at [/...Full Path.../db/maintenanceFunctions.php:72]
2024-01-21 17:48:26.641 ***** ERROR ***** [V11.1.2]    #1 runScript called at [/...Full Path.../db/maintenance.php:178]
2024-01-21 17:48:26.641 ***** ERROR ***** [V11.1.2]    #2 include called at [/...Full Path.../tool/loginCheck.php:144]
2024-01-21 17:48:26.641 ===== TRACE ===== 
2024-01-21 17:48:26.641 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V11.1.3 (see above message)
2024-01-21 17:48:26.641 ===== TRACE ===== 
2024-01-21 17:48:26.641 ===== TRACE ===== *************************************************
2024-01-21 17:48:26.642 ===== TRACE ===== 
2024-01-21 17:48:26.642 ===== TRACE ===== 
2024-01-21 17:48:26.642 ===== TRACE ===== DATABASE UPDATED
2024-01-21 17:48:26.642 ===== TRACE =====  WITH 1 ERROR
2024-01-21 17:48:26.642 ===== TRACE ===== 
2024-01-21 17:48:26.847 ===== TRACE ===== =====================================
2024-01-21 17:48:26.847 ===== TRACE ===== 
2024-01-21 17:48:26.848 ===== TRACE ===== 1 ERRORS DURING UPGRADE TO VERSION V11.1.3
2024-01-21 17:48:26.848 ===== TRACE ===== 
2024-01-21 17:48:26.848 ===== TRACE ===== =====================================
2024-01-21 17:48:26.848 ===== TRACE ===== 


Thanks
Last edit: 22 Jan 2024 13:02 by sharky.

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

More
22 Jan 2024 10:38 #2 by babynus
Hi,
This will be fixed.
To fix your instance, please execute
ALTER TABLE `qtor_reportlayout` CHANGE `idFilterCriteria` `idFilter` INT UNSIGNED NULL DEFAULT NULL COMMENT '12';

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: sharky

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

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