openerp-india team mailing list archive

["Twinkle Christian\(OpenERP\)" <tch@xxxxxxxxxxx>]

*** This bug is a duplicate of bug 1082924 ***
    https://bugs.launchpad.net/bugs/1082924

** This bug has been marked a duplicate of bug 1082924
   [Windows]Version 7 - Contracts Mgmt installation stops with error

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1094186

Title:
  Error when install account_analytic_analysis module

Status in OpenERP Addons (modules):
  New

Bug description:
  7.0alpha-20121221-154954\Server\server\.\openerp\sql_db.py", line 227, in execute
  ProgrammingError: syntax error at or near "with mu"
  LINE 2:             with mu as

  
  CREATE OR REPLACE VIEW account_analytic_analysis_summary_user AS (
              with mu as
                  (select max(id) as max_user from res_users)
              , lu AS
                  (SELECT   
                   l.account_id AS account_id,   
                   coalesce(l.user_id, 0) AS user_id,   
                   SUM(l.unit_amount) AS unit_amount   
               FROM account_analytic_line AS l,   
                   account_analytic_journal AS j   
               WHERE (j.type = 'general' ) and (j.id=l.journal_id)   
               GROUP BY l.account_id, l.user_id   
              )
              select (lu.account_id * mu.max_user) + lu.user_id as id,
                      lu.account_id as account_id,
                      lu.user_id as "user",
                      unit_amount
              from lu, mu)

  Somebody said postgresql8.3 in Windows Allinone package don't support
  this SQL method, so I advice you package more higher version PGSQL in
  the installer, eg, 8.4 or 9.1

  No reason to change the code for this.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1094186/+subscriptions