Forum

Forums
Requests
Submit issues
SQL error on update
 
Notifications
Clear all

SQL error on update

 
Submit issues
Last Post by Drubs2010 14 years ago
4 Posts
2 Users
0 Reactions
4,676 Views
RSS
 Drubs2010
(@drubs2010)
Posts: 25
Active Member
Topic starter
 
[#373]

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'

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'

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 ===== 
** 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'

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


 
Posted : 22 Feb 2012 12H50
 babynus
(@babynus)
Posts: 14952
Member Admin
 

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.


 
Posted : 22 Feb 2012 15H58
 Drubs2010
(@drubs2010)
Posts: 25
Active Member
Topic starter
 

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.


 
Posted : 22 Feb 2012 17H49
 Drubs2010
(@drubs2010)
Posts: 25
Active Member
Topic starter
 

I update twice and now it runs.

Regards,

Drubs2010.


 
Posted : 22 Feb 2012 18H14
Forum Jump:
  Previous Topic
Next Topic  
Share:

Scroll to Top