openerp-india team mailing list archive

[Marco Rauchenstein <m.rauchenstein@xxxxxxxxxx>]

Public bug reported:

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...

** Affects: openobject-addons
     Importance: Undecided
         Status: New

** Attachment added: "openerp-server.log"
   https://bugs.launchpad.net/bugs/1097318/+attachment/3477041/+files/openerp-server.log

-- 
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