View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQL error on update - ProjeQtOr
 

SQL error on update

More
22 Feb 2012 10:50 #1 by Drubs2010
Hello,

I try to update the 1.9.1 to 2.0.1 version. But when I'm signing in, there's a SQL error during the update:
2012-02-22 09:58:06 ***** ERROR ***** [1054] Erreur SQL : Unknown column 'user.id' in 'field list'<br/><br/>INSERT INTO `pr_collapsed` (`idUser`, `scope` ) select user.id, concat(copyable.name,'_history') from `pr_user`, `pr_copyable`;

The complete log is below:
2012-02-22 09:19:12 ===== TRACE ===== NEW CONNECTED USER 'Olivier'
2012-02-22 09:19:43 ===== TRACE ===== DISCONNECTED USER 'Olivier'
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== =====================================
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== DataBase actual Version = V1.9.1
2012-02-22 09:58:06 ===== TRACE ===== ProjectOR actual Version = V2.0.1
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== =====================================
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== VERSION V2.0.0
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_activityprice" created.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_activityprice" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_bill" created.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_bill" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_client" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_billline" created.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_billline" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_project" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_project" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_recipient" created.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_term" created.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_term" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_user" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_user" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_work" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_work" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_planningelement" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_planningelement" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_assignment" altered.
2012-02-22 09:58:06 ===== TRACE =====  5 lines inserted into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  0 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  7 lines inserted into table "pr_accessright".
2012-02-22 09:58:06 ===== TRACE =====  7 lines inserted into table "pr_habilitation".
2012-02-22 09:58:06 ===== TRACE =====  1 lines inserted into table "pr_reportcategory".
2012-02-22 09:58:06 ===== TRACE =====  1 lines inserted into table "pr_report`(`id`,".
2012-02-22 09:58:06 ===== TRACE =====  3 lines inserted into table "pr_reportparameter".
2012-02-22 09:58:06 ===== TRACE =====  7 lines inserted into table "pr_habilitationreport".
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_documentdirectory" created.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_documentdirectory" altered.
2012-02-22 09:58:06 ===== TRACE =====  13 lines inserted into table "pr_documentdirectory".
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_document" created.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_document" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_documentversion" created.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_documentversion" altered.
2012-02-22 09:58:06 ===== TRACE =====  14 lines inserted into table "pr_type".
2012-02-22 09:58:06 ===== TRACE =====  1 lines inserted into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  1 lines inserted into table "pr_habilitation".
2012-02-22 09:58:06 ===== TRACE =====  4 lines inserted into table "pr_type".
2012-02-22 09:58:06 ===== TRACE =====  1 lines inserted into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  6 lines inserted into table "pr_habilitation".
2012-02-22 09:58:06 ===== TRACE =====  7 lines inserted into table "pr_accessright".
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_referencable" created.
2012-02-22 09:58:06 ===== TRACE =====  12 lines inserted into table "pr_referencable".
2012-02-22 09:58:06 ===== TRACE =====  1 lines inserted into table "pr_parameter".
2012-02-22 09:58:06 ===== TRACE =====  1 lines inserted into table "pr_parameter".
2012-02-22 09:58:06 ===== TRACE =====  14 lines inserted into table "pr_habilitationother".
2012-02-22 09:58:06 ===== TRACE =====  1 lines inserted into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  2 lines inserted into table "pr_habilitation".
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_type" altered.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_dependency" altered.
2012-02-22 09:58:06 ===== TRACE =====  3 lines inserted into table "pr_type".
2012-02-22 09:58:06 ===== TRACE =====  4 lines inserted into table "pr_parameter".
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_collapsed" created.
2012-02-22 09:58:06 ===== TRACE =====  Table "pr_collapsed" altered.
2012-02-22 09:58:06 ***** ERROR ***** [1054] Erreur SQL : Unknown column 'user.id' in 'field list'<br/><br/>INSERT INTO `pr_collapsed` (`idUser`, `scope` ) select user.id, concat(copyable.name,'_history') from `pr_user`, `pr_copyable`;

2012-02-22 09:58:06 ===== TRACE ===== <br/>***** SQL ERROR WHILE EXECUTING SQL REQUEST *****
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== Erreur SQL : Unknown column 'user.id' in 'field list'<br/><br/>INSERT INTO `pr_collapsed` (`idUser`, `scope` ) select user.id, concat(copyable.name,'_history') from `pr_user`, `pr_copyable`;

2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== *************************************************
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE =====  2 lines updated into table "pr_parameter".
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== DATABASE UPDATED
2012-02-22 09:58:06 ===== TRACE =====  WITH 1 ERROR
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== =====================================
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== VERSION V2.0.1
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE =====  2 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  3 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  0 lines updated into table "pr_habilitation".
2012-02-22 09:58:06 ===== TRACE =====  1 lines deleted from table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  7 lines deleted from table "pr_habilitation".
2012-02-22 09:58:06 ===== TRACE =====  1 lines updated into table "pr_menu".
2012-02-22 09:58:06 ===== TRACE =====  21 lines updated into table "pr_report".
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== DATABASE UPDATED
2012-02-22 09:58:06 ===== TRACE =====  WITH NO ERROR
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== =====================================
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== 1 ERRORS DURING UPDATE TO VERSION V2.0.1
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:06 ===== TRACE ===== =====================================
2012-02-22 09:58:06 ===== TRACE ===== 
2012-02-22 09:58:10 ===== TRACE ===== NEW CONNECTED USER 'Olivier'

Regards,

Drubs2010

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

More
22 Feb 2012 13:58 #2 by babynus
Replied by babynus on topic RE : SQL error on update
Hi,

This issue is minor.
You can continue working without any scare.


For information, the script that failed just sets the "history" section as "collapsed" (see new features in V2.0) for all users and all item types.
So users will see this section "extended" by default. If they collapse the section, it will then be displayed as "collapsed".



It is fixed for next deployments.

Thanks for reporting the issue.

Babynus
Administrator of ProjeQtOr web site

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

More
22 Feb 2012 15:49 #3 by Drubs2010
Replied by Drubs2010 on topic RE : SQL error on update
I'm sorry I though that's the consequence of the next problem.

Do I wait a long time before I can work? Because it blocks on the loading splash and I do not pass to the next.

Drubs2010.

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

More
22 Feb 2012 16:14 - 07 Mar 2014 14:54 #4 by Drubs2010
Replied by Drubs2010 on topic RE : SQL error on update
I update twice and now it runs.

Regards,

Drubs2010.
Last edit: 07 Mar 2014 14:54 by Drubs2010.

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

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