openerp-india team mailing list archive

Thread
Date
[Bug 1080779] [NEW] installing bill time on task addons crash the database

To: openerp-india@xxxxxxxxxxxxxxxxxxx
From: Houssine <1080779@xxxxxxxxxxxxxxxxxx>
Date: Mon, 19 Nov 2012 16:47:37 -0000
Reply-to: Bug 1080779 <1080779@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

Hi There,

OpenERP version : 7.0 Beta
OS : Windows :
Env : running the server from sources in eclipse with pydev

On a new fresh database with demo data.

You first install the project management module then you try to install
the Bill time on tasks addon => it fails giving the following
stacktrace.

After that you're not able to install anything else.

2012-11-19 17:35:59,733 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading sale_view.xml
2012-11-19 17:36:01,217 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading res_partner_view.xml
2012-11-19 17:36:02,625 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading report/sale_report_view.xml
2012-11-19 17:36:02,842 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading process/sale_process.xml
2012-11-19 17:36:02,921 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading board_sale_view.xml
2012-11-19 17:36:03,062 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading edi/sale_order_action_data.xml
2012-11-19 17:36:03,171 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading res_config_view.xml
2012-11-19 17:36:03,265 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading sale_demo.xml
2012-11-19 17:36:06,796 324 WARNING reprod_bug_on_beta openerp.osv.orm: No such field(s) in model product.product: supply_method.
2012-11-19 17:36:07,155 324 INFO reprod_bug_on_beta openerp.modules.loading: module account_analytic_analysis: loading objects
2012-11-19 17:36:07,171 324 INFO reprod_bug_on_beta openerp.modules.module: module account_analytic_analysis: creating or updating database tables
2012-11-19 17:36:07,328 324 ERROR reprod_bug_on_beta 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)
2012-11-19 17:36:07,328 324 ERROR reprod_bug_on_beta openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\base\module\module.py", line 368, in button_immediate_install
    return self._button_immediate_function(cr, uid, ids, self.button_install, context=context)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\base\module\module.py", line 418, in _button_immediate_function
    _, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\pooler.py", line 39, in restart_pool
    registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\registry.py", line 178, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 337, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 248, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 161, in load_module_graph
    init_module_models(cr, package.name, models)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\module.py", line 377, in init_module_models
    obj.init(cr)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\account_analytic_analysis\account_analytic_analysis.py", line 530, in init
    from lu, mu)''')
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\sql_db.py", line 162, in wrapper
    return f(self, *args, **kwargs)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
ProgrammingError: syntax error at or near "with mu"
LINE 2:             with mu as
                    ^

2012-11-19 17:36:07,328 324 ERROR reprod_bug_on_beta openerp.netsvc: syntax error at or near "with mu"
LINE 2:             with mu as
                    ^
Traceback (most recent call last):
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\netsvc.py", line 361, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\service\web_services.py", line 596, in dispatch
    res = fn(db, uid, *params)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\base\module\module.py", line 368, in button_immediate_install
    return self._button_immediate_function(cr, uid, ids, self.button_install, context=context)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\base\module\module.py", line 418, in _button_immediate_function
    _, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\pooler.py", line 39, in restart_pool
    registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\registry.py", line 178, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 337, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 248, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 161, in load_module_graph
    init_module_models(cr, package.name, models)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\module.py", line 377, in init_module_models
    obj.init(cr)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\account_analytic_analysis\account_analytic_analysis.py", line 530, in init
    from lu, mu)''')
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\sql_db.py", line 162, in wrapper
    return f(self, *args, **kwargs)
  File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
ProgrammingError: syntax error at or near "with mu"
LINE 2:             with mu as
                    ^

2012-11-19 17:36:07,342 324 INFO reprod_bug_on_beta werkzeug: 127.0.0.1
- - [19/Nov/2012 17:36:07] "POST /web/dataset/call_button HTTP/1.1" 200
-

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

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

Title:
  installing bill time on task addons crash the database

Status in OpenERP Addons (modules):
  New

Bug description:
  Hi There,

  OpenERP version : 7.0 Beta
  OS : Windows :
  Env : running the server from sources in eclipse with pydev

  On a new fresh database with demo data.

  You first install the project management module then you try to
  install the Bill time on tasks addon => it fails giving the following
  stacktrace.

  After that you're not able to install anything else.

  2012-11-19 17:35:59,733 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading sale_view.xml
  2012-11-19 17:36:01,217 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading res_partner_view.xml
  2012-11-19 17:36:02,625 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading report/sale_report_view.xml
  2012-11-19 17:36:02,842 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading process/sale_process.xml
  2012-11-19 17:36:02,921 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading board_sale_view.xml
  2012-11-19 17:36:03,062 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading edi/sale_order_action_data.xml
  2012-11-19 17:36:03,171 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading res_config_view.xml
  2012-11-19 17:36:03,265 324 INFO reprod_bug_on_beta openerp.modules.loading: module sale: loading sale_demo.xml
  2012-11-19 17:36:06,796 324 WARNING reprod_bug_on_beta openerp.osv.orm: No such field(s) in model product.product: supply_method.
  2012-11-19 17:36:07,155 324 INFO reprod_bug_on_beta openerp.modules.loading: module account_analytic_analysis: loading objects
  2012-11-19 17:36:07,171 324 INFO reprod_bug_on_beta openerp.modules.module: module account_analytic_analysis: creating or updating database tables
  2012-11-19 17:36:07,328 324 ERROR reprod_bug_on_beta 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)
  2012-11-19 17:36:07,328 324 ERROR reprod_bug_on_beta openerp.osv.osv: Uncaught exception
  Traceback (most recent call last):
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\base\module\module.py", line 368, in button_immediate_install
      return self._button_immediate_function(cr, uid, ids, self.button_install, context=context)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\base\module\module.py", line 418, in _button_immediate_function
      _, pool = pooler.restart_pool(cr.dbname, update_module=True)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\pooler.py", line 39, in restart_pool
      registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\registry.py", line 178, in new
      openerp.modules.load_modules(registry.db, force_demo, status, update_module)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 337, in load_modules
      processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 248, in load_marked_modules
      loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 161, in load_module_graph
      init_module_models(cr, package.name, models)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\module.py", line 377, in init_module_models
      obj.init(cr)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\account_analytic_analysis\account_analytic_analysis.py", line 530, in init
      from lu, mu)''')
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\sql_db.py", line 162, in wrapper
      return f(self, *args, **kwargs)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\sql_db.py", line 227, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: syntax error at or near "with mu"
  LINE 2:             with mu as
                      ^

  2012-11-19 17:36:07,328 324 ERROR reprod_bug_on_beta openerp.netsvc: syntax error at or near "with mu"
  LINE 2:             with mu as
                      ^
  Traceback (most recent call last):
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\netsvc.py", line 361, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\service\web_services.py", line 596, in dispatch
      res = fn(db, uid, *params)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 167, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\osv\osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\base\module\module.py", line 368, in button_immediate_install
      return self._button_immediate_function(cr, uid, ids, self.button_install, context=context)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\base\module\module.py", line 418, in _button_immediate_function
      _, pool = pooler.restart_pool(cr.dbname, update_module=True)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\pooler.py", line 39, in restart_pool
      registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\registry.py", line 178, in new
      openerp.modules.load_modules(registry.db, force_demo, status, update_module)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 337, in load_modules
      processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 248, in load_marked_modules
      loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\loading.py", line 161, in load_module_graph
      init_module_models(cr, package.name, models)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\modules\module.py", line 377, in init_module_models
      obj.init(cr)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\addons\account_analytic_analysis\account_analytic_analysis.py", line 530, in init
      from lu, mu)''')
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\sql_db.py", line 162, in wrapper
      return f(self, *args, **kwargs)
    File "C:\workspace_OpenERP\openerp_server_7_0_Beta\openerp\sql_db.py", line 227, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: syntax error at or near "with mu"
  LINE 2:             with mu as
                      ^

  2012-11-19 17:36:07,342 324 INFO reprod_bug_on_beta werkzeug:
  127.0.0.1 - - [19/Nov/2012 17:36:07] "POST /web/dataset/call_button
  HTTP/1.1" 200 -

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

[Bug 1080779] Re: installing bill time on task addons crash the database
From: Jignesh Rathod(OpenERP), 2012-12-04
[Bug 1080779] Re: installing bill time on task addons crash the database
From: Houssine, 2012-12-03
[Bug 1080779] Re: installing bill time on task addons crash the database
From: Houssine, 2012-12-03
[Bug 1080779] Re: installing bill time on task addons crash the database
From: Jignesh Rathod(OpenERP), 2012-12-03
[Bug 1080779] [NEW] installing bill time on task addons crash the database
From: Houssine, 2012-11-19
References

[Bug 1080779] [NEW] installing bill time on task addons crash the database
From: Houssine, 2012-11-19