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.

[RESOLVE] Error upd...
 
Notifications
Clear all

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

2 Posts
2 Users
0 Reactions
1,494 Views
sharky
(@sharky)
Posts: 47
Active Member
Topic starter
 
[#9254]

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


 
Posted : 21 Jan 2024 20H09
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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';

 
Posted : 22 Jan 2024 12H38
Share:

Scroll to Top