openerp-india team mailing list archive

["Dmitrijs Ledkovs \(credativ\)" <592741@xxxxxxxxxxxxxxxxxx>]

try installing product_expiry module?

It defines stock_report_prodlots and somehow product_serial depends on
that (in sql).

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

Title:
  TRUNK: ProgrammingError: relation "stock_report_prodlots" does not
  exist

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  
  Open a new repair. Select the stock movement. Open the stock movement and try assigning a prod_lot to the line. I obtain this error. 

  Environment Information : 
  System : Windows-32bit
  OS Name : nt
  Operating System Release : 
  Operating System Version : 32bit
  Operating System Architecture : 32bit
  Operating System Locale : es_ES.cp1252
  Python Version : 2.5.2
  OpenERP-Client Version : 6.0dev
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "/home/openerp/production/openerp-server/bin/netsvc.py", line 394, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/home/openerp/production/openerp-server/bin/service/web_services.py", line 587, in dispatch
      res = fn(db, uid, *params)
    File "/home/openerp/production/openerp-server/bin/osv/osv.py", line 57, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/openerp/production/openerp-server/bin/osv/osv.py", line 133, in execute
      res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/openerp/production/openerp-server/bin/osv/osv.py", line 123, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/openerp/production/openerp-server/bin/osv/orm.py", line 2745, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/openerp/production/openerp-server/bin/osv/orm.py", line 2876, in _read_flat
      res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
    File "/home/openerp/production/openerp-server/bin/osv/fields.py", line 684, in get
      res = self._fnct(obj, cr, user, ids, name, self._arg, context)
    File "/home/openerp/production/openerp-server/bin/addons/stock/stock.py", line 1095, in _get_stock
      location_id =ANY(%s) and prodlot_id =ANY(%s) group by prodlot_id''',(locations,ids,))
    File "/home/openerp/production/openerp-server/bin/sql_db.py", line 74, in wrapper
      return f(self, *args, **kwargs)
    File "/home/openerp/production/openerp-server/bin/sql_db.py", line 119, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: relation "stock_report_prodlots" does not exist

  After the error I have tryied:

  Click the checkbox tracking incoming on a product.
  New entry packing
  New line on entry packing for the product
  Try to assign a new prodlot. I obtain same error.

  Thank you!!

  Ana

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