← Back to team overview

touch-packages team mailing list archive

[Bug 1352451] [NEW] Departments in Apps don't match Store

 

Public bug reported:

The departments menu in Apps scope has some extra top-level departments,
such as "3D", that don't exist in the Store.

There are three causes for this issue, all connected:
1) we have entries in the departments db with locale "", and they are used as a fallback for name lookups
2) we never update it while refreshing departments in the Store scope, as we use non-empty locale ("en_US" by default, or whatever reported by the shell), and only update entries for that locale.
3) the SQL query used for depts_v uses a join against deptnames table, but since the statement is not restricted for a specific locale, it just uses all names, including the ones that are never updated because of (2).

** Affects: unity-scope-click (Ubuntu)
     Importance: Undecided
     Assignee: Pawel Stolowski (stolowski)
         Status: Confirmed


** Tags: rtm14

** Changed in: unity-scope-click (Ubuntu)
     Assignee: (unassigned) => Pawel Stolowski (stolowski)

** Changed in: unity-scope-click (Ubuntu)
       Status: New => Confirmed

** Description changed:

- The departments menu has some extra top-level departments, such as "3D",
- that don't exist in the Store.
+ The departments menu in Apps scope has some extra top-level departments,
+ such as "3D", that don't exist in the Store.
  
  There are three causes for this issue, all connected:
  1) we have entries in the departments db with locale "", and they are used as a fallback for name lookups
  2) we never update it in the Store, as we us-non empty locale ("en_US" by default), and only updated entries for current locale.
  3) the SQL query used for depts_v uses a join against deptnames table, but since the statement is not restricted for a specific locale, it just uses all names, including the ones that are never updated because of (2).

** Description changed:

  The departments menu in Apps scope has some extra top-level departments,
  such as "3D", that don't exist in the Store.
  
  There are three causes for this issue, all connected:
  1) we have entries in the departments db with locale "", and they are used as a fallback for name lookups
- 2) we never update it in the Store, as we us-non empty locale ("en_US" by default), and only updated entries for current locale.
+ 2) we never update it while refreshing departments in the Store scope, as we us-non empty locale ("en_US" by default), and only updated entries for current locale.
  3) the SQL query used for depts_v uses a join against deptnames table, but since the statement is not restricted for a specific locale, it just uses all names, including the ones that are never updated because of (2).

** Description changed:

  The departments menu in Apps scope has some extra top-level departments,
  such as "3D", that don't exist in the Store.
  
  There are three causes for this issue, all connected:
  1) we have entries in the departments db with locale "", and they are used as a fallback for name lookups
- 2) we never update it while refreshing departments in the Store scope, as we us-non empty locale ("en_US" by default), and only updated entries for current locale.
+ 2) we never update it while refreshing departments in the Store scope, as we use non-empty locale ("en_US" by default), and only updated entries for current locale.
  3) the SQL query used for depts_v uses a join against deptnames table, but since the statement is not restricted for a specific locale, it just uses all names, including the ones that are never updated because of (2).

** Description changed:

  The departments menu in Apps scope has some extra top-level departments,
  such as "3D", that don't exist in the Store.
  
  There are three causes for this issue, all connected:
  1) we have entries in the departments db with locale "", and they are used as a fallback for name lookups
- 2) we never update it while refreshing departments in the Store scope, as we use non-empty locale ("en_US" by default), and only updated entries for current locale.
+ 2) we never update it while refreshing departments in the Store scope, as we use non-empty locale ("en_US" by default, or whatever reported by the shell), and only update entries for that locale.
  3) the SQL query used for depts_v uses a join against deptnames table, but since the statement is not restricted for a specific locale, it just uses all names, including the ones that are never updated because of (2).

-- 
You received this bug notification because you are a member of Ubuntu
Touch seeded packages, which is subscribed to unity-scope-click in
Ubuntu.
https://bugs.launchpad.net/bugs/1352451

Title:
  Departments in Apps don't match Store

Status in “unity-scope-click” package in Ubuntu:
  Confirmed

Bug description:
  The departments menu in Apps scope has some extra top-level
  departments, such as "3D", that don't exist in the Store.

  There are three causes for this issue, all connected:
  1) we have entries in the departments db with locale "", and they are used as a fallback for name lookups
  2) we never update it while refreshing departments in the Store scope, as we use non-empty locale ("en_US" by default, or whatever reported by the shell), and only update entries for that locale.
  3) the SQL query used for depts_v uses a join against deptnames table, but since the statement is not restricted for a specific locale, it just uses all names, including the ones that are never updated because of (2).

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/unity-scope-click/+bug/1352451/+subscriptions


Follow ups

References