← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 799560] Re: Programming error

 

@JAG
El primer error de:
"ProgrammingError: permission denied for relation account_invoice_report"
Es por permisos de usuario.
Esto se puede dar cuando se ejecuta el query con otro usuario diferente al que usa naturalmente OpenERP, ya que le cambia el owner por default.

La solución es cambiarle el owner a la view "account_invoice_report"

El otro error que te da:
ERROR: syntax error at or near "DROP"
LINE 1: DROP VIEW IF EXISTS account_invoice_report;
Esto es, porque te está jalando un caracter raro, talvez a la hora de copiar & pegar
El caracter raro es "ï»"
Tal vez en tu editor no lo verás debido a que es un caracter raro y no todos los editores los interpretan, y ponen NADA.

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/799560

Title:
  Programming error

Status in openerp-mexico-localization:
  Fix Released

Bug description:
  ***Steps to reproduce:***

  1) l10n_mx_facturae installation

  2) Clicking on 'Sales' to open Sales Dashboard

  ***Observed result:***

  Access to Sales Dashboard is not possible, the following error is
  reported:

  
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 1743, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 4024, in _search
      cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: relation "account_invoice_report" does not exist
  LINE 1: SELECT "account_invoice_report".id FROM "account_invoice_rep...
                                                  ^

  ***Expected result:***

  Sales Dashboard displaying without error.

  ***Installation platform***

  Ubuntu 10.04 LTS (up to date xc. 06.19.11)

  ***OpenERP version***

  OpenERP 6.0.2 (trunk) rev 3444

  ***openerp-mexico-localization version***

  6.0 (trunk) rev 52

  ***module name***

  l10n_mx_facturae

  ***Log/Tracebak***

  (See above)

  ***Notes***

  Two different tests were made in two different servers with clean
  installations, error persisted in both. Error was not present up until
  l10n_mx_facturae module installation. Error persists even after
  l10n_mx_facturae module removal.

  **********************************************

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-mexico-localization/+bug/799560/+subscriptions


References