openerp-india team mailing list archive

["Amit Bhavsar \(Open ERP\)" <1097318@xxxxxxxxxxxxxxxxxx>]

*** 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/1097318

Title:
  Windows AllinOne Installer - Error in Serverlog after update to latest
  nightly build

Status in OpenERP Addons (modules):
  New

Bug description:
  Install via AllinOne Setup ist ok.

  Then using the command below

  "C:\OpenERP\Server\server\openerp-server.exe" -d MyDatabase -u all

  to update the latest changes to the database produces the error:

  2013-01-08 16:36:34,342 2528 ERROR MyDatabase openerp.sql_db: Programming error: syntax error at or near "with mu"
  LINE 2:             with mu as
                      ^
  , in query 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)
  2013-01-08 16:36:34,342 2528 ERROR MyDatabase openerp: Failed to initialize database `MyDatabase`.
  Traceback (most recent call last):
    File "C:\OpenERP\Server\server\.\openerp\cli\server.py", line 98, in preload_registry
    File "C:\OpenERP\Server\server\.\openerp\pooler.py", line 33, in get_db_and_pool
    File "C:\OpenERP\Server\server\.\openerp\modules\registry.py", line 192, in get
    File "C:\OpenERP\Server\server\.\openerp\modules\registry.py", line 214, in new
    File "C:\OpenERP\Server\server\.\openerp\modules\loading.py", line 349, in load_modules
    File "C:\OpenERP\Server\server\.\openerp\modules\loading.py", line 260, in load_marked_modules
    File "C:\OpenERP\Server\server\.\openerp\modules\loading.py", line 169, in load_module_graph
    File "C:\OpenERP\Server\server\.\openerp\modules\module.py", line 378, in init_module_models
    File "C:\OpenERP\Server\server\openerp\addons\account_analytic_analysis\account_analytic_analysis.py", line 540, in init
    File "C:\OpenERP\Server\server\.\openerp\sql_db.py", line 162, in wrapper
    File "C:\OpenERP\Server\server\.\openerp\sql_db.py", line 227, in execute
  ProgrammingError: syntax error at or near "with mu"
  LINE 2:             with mu as
                      ^

  2013-01-08 16:36:34,342 2528 INFO MyDatabase openerp: OpenERP server
  is running, waiting for connections...

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