View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - 6.3.2 update errors in sql - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

6.3.2 update errors in sql

More
24 Juil 2017 06:16 #1 by diri
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

Please Connexion or Create an account to join the conversation.

More
24 Juil 2017 08:25 #2 by babynus
Replied by babynus on topic 6.3.2 update errors in sql
Wich database (MySql / MariaDB, Postgres) and version ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
25 Juil 2017 06:11 #3 by diri
Replied by diri on topic 6.3.2 update errors in sql
mySQL 5.5.55, PHP 7.0.21 (PHP not sure atm, PHP 7.0.x for sure).

Please Connexion or Create an account to join the conversation.

More
25 Juil 2017 08:50 - 25 Juil 2017 08:50 #4 by babynus
Replied by babynus on topic 6.3.2 update errors in sql
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.

Babynus
Administrator of ProjeQtOr web site
Last edit: 25 Juil 2017 08:50 by babynus.

Please Connexion or Create an account to join the conversation.

More
26 Juil 2017 05:02 #5 by diri
Replied by diri on topic 6.3.2 update errors in sql
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.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.042 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.