2017-07-24 06:08:41.742 ** ERROR ** [V6.3.1] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-07-24 06:08:41.855 ** ERROR ** [V6.3.1] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-07-24 06:08:41.868 ===== TRACE =====
2017-07-24 06:08:41.868 ===== TRACE ===== =====================================
2017-07-24 06:08:41.868 ===== TRACE =====
2017-07-24 06:08:41.868 ===== TRACE ===== DataBase actual Version = V6.3.1
2017-07-24 06:08:41.868 ===== TRACE ===== ProjeQtOr actual Version = V6.3.2
2017-07-24 06:08:41.868 ===== TRACE =====
2017-07-24 06:08:41.868 ===== TRACE ===== =====================================
2017-07-24 06:08:41.868 ===== TRACE =====
2017-07-24 06:08:41.868 ===== TRACE ===== VERSION V6.3.2
2017-07-24 06:08:41.868 ===== TRACE =====
2017-07-24 06:08:41.875 ** ERROR ** [V6.3.1] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'handled' in 'field list'
2017-07-24 06:08:41.875 ** ERROR ** [V6.3.1] For query : UPDATE `pro_project` set handled=1 where idStatus in (select id from `pro_status` where setHandledStatus=1);
2017-07-24 06:08:41.875 ** ERROR ** [V6.3.1] Strack trace :
2017-07-24 06:08:41.875 ** ERROR ** [V6.3.1] #0 Sql->query called at [/x/db/maintenanceFunctions.php:71]
2017-07-24 06:08:41.875 ** ERROR ** [V6.3.1] #1 runScript called at [/x/db/maintenance.php:101]
2017-07-24 06:08:41.875 ** ERROR ** [V6.3.1] #2 include called at [/x/tool/loginCheck.php:135]
2017-07-24 06:08:41.876 ===== TRACE =====
2017-07-24 06:08:41.876 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.3.2 (see above message)
2017-07-24 06:08:41.876 ===== TRACE =====
2017-07-24 06:08:41.876 ===== TRACE ===== **********************************************
2017-07-24 06:08:41.876 ===== TRACE =====
2017-07-24 06:08:41.876 ===== TRACE =====
2017-07-24 06:08:41.876 ===== TRACE ===== DATABASE UPDATED
2017-07-24 06:08:41.876 ===== TRACE ===== WITH 1 ERROR
2017-07-24 06:08:41.876 ===== TRACE =====
2017-07-24 06:08:42.095 ===== TRACE ===== =====================================
2017-07-24 06:08:42.095 ===== TRACE =====
2017-07-24 06:08:42.095 ===== TRACE ===== 1 ERRORS DURING UPDATE TO VERSION V6.3.2
2017-07-24 06:08:42.095 ===== TRACE =====
2017-07-24 06:08:42.095 ===== TRACE ===== =====================================
2017-07-24 06:08:42.095 ===== TRACE =====
2017-07-24 06:08:46.414 ** ERROR ** [V6.3.2] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-07-24 06:08:46.526 ** ERROR ** [V6.3.2] Error on SqlElement to get 'idLanguage' for Class 'User' : field 'idLanguage' not found in Database.
2017-07-24 06:08:46.537 ===== TRACE ===== NEW CONNECTED USER 'diriwe'
2017-07-24 06:08:46.933 ** ERROR ** [V6.3.2] Error on SqlElement to get 'handled' for Class 'Project' : field 'handled' not found in Database.
2017-07-24 06:08:46.933 ** ERROR ** [V6.3.2] Error on SqlElement to get 'handledDate' for Class 'Project' : field 'handledDate' not found in Database.
2017-07-24 06:08:47.745 ** ERROR ** [V6.3.2] Error on SqlElement to get 'handled' for Class 'Project' : field 'handled' not found in Database.
2017-07-24 06:08:47.745 ** ERROR ** [V6.3.2] Error on SqlElement to get 'handledDate' for Class 'Project' : field 'handledDate' not found in Database.
2017-07-24 06:08:47.745 ** ERROR ** [V6.3.2] Error on SqlElement to get 'handled' for Class 'Project' : field 'handled' not found in Database.
2017-07-24 06:08:47.745 ** ERROR ** [V6.3.2] Error on SqlElement to get 'handledDate' for Class 'Project' : field 'handledDate' not found in Database.
2017-07-24 06:08:47.855 ** ERROR ** [V6.3.2] Error on SqlElement to get 'handled' for Class 'Project' : field 'handled' not found in Database.
2017-07-24 06:08:47.855 ** ERROR ***** [V6.3.2] Error on SqlElement to get 'handledDate' for Class 'Project' : field 'handledDate' not found in Database.
2017-07-24 06:08:55.362 ===== TRACE ===== Cron started at 24/07/2017 06:08:55
Wich database (MySql / MariaDB, Postgres) and version ?
mySQL 5.5.55, PHP 7.0.21 (PHP not sure atm, PHP 7.0.x for sure).
Hi,
It seems there was an error when migrating to V6.3.0.
Please check table pro_project, if columns `handled` and `handleDate` exist.
If they do not, you should try this :
ALTER TABLE `pro_project` ADD `handled` int(1) DEFAULT '0', ADD `handledDate` date DEFAULT NULL;
But you should check migration log to V6.3.0 if errors exist.
Thank you for answering.
DB trouble started with update to 6.3.0, there is also something with field "idle". Must have a look at it.