c2c-oerpscenario team mailing list archive

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

Public bug reported:

Problem : Found Error when "Upstream Traceability" and "Downstream Traceability" Perform
            step 1 : Warehouse --> traceability --> production lots
            step 2 : In form view click on "Upstream Traceability" or "Downstream Traceability"
            
Error are found . . .
================================================================================
[2011-10-05 09:34:12,881][?] ERROR:db.cursor:Programming error: syntax error at or near ")"
LINE 7: ...0, 21, 25, 26, 11, 12, 19, 18) and prodlot_id IN () group by...
                                                             ^
, in query select
                    prodlot_id,
                    sum(qty)
                from
                    stock_report_prodlots
                where
                    location_id IN %s and prodlot_id IN %s group by prodlot_id
[2011-10-05 09:34:12,881][?] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/amb/source/server/trunk/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/amb/source/server/trunk/openerp/osv/osv.py", line 172, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/amb/source/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/amb/source/server/trunk/openerp/osv/orm.py", line 3219, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/amb/source/server/trunk/openerp/osv/orm.py", line 3342, in _read_flat
    res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
  File "/home/amb/source/server/trunk/openerp/osv/fields.py", line 1000, in get
    result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
  File "/home/amb/source/addons/trunk/stock/stock.py", line 1379, in _get_stock
    location_id IN %s and prodlot_id IN %s group by prodlot_id''',(tuple(locations),tuple(ids),))
  File "/home/amb/source/server/trunk/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/amb/source/server/trunk/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
ProgrammingError: syntax error at or near ")"
LINE 7: ...0, 21, 25, 26, 11, 12, 19, 18) and prodlot_id IN () group by...

** Affects: openerp-web
     Importance: Undecided
         Status: New

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

Title:
  Found Error when "Upstream Traceability" and "Downstream Traceability"
  Perform

Status in OpenERP Web:
  New

Bug description:
  Problem : Found Error when "Upstream Traceability" and "Downstream Traceability" Perform
              step 1 : Warehouse --> traceability --> production lots
              step 2 : In form view click on "Upstream Traceability" or "Downstream Traceability"
              
  Error are found . . .
  ================================================================================
  [2011-10-05 09:34:12,881][?] ERROR:db.cursor:Programming error: syntax error at or near ")"
  LINE 7: ...0, 21, 25, 26, 11, 12, 19, 18) and prodlot_id IN () group by...
                                                               ^
  , in query select
                      prodlot_id,
                      sum(qty)
                  from
                      stock_report_prodlots
                  where
                      location_id IN %s and prodlot_id IN %s group by prodlot_id
  [2011-10-05 09:34:12,881][?] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/home/amb/source/server/trunk/openerp/osv/osv.py", line 120, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/amb/source/server/trunk/openerp/osv/osv.py", line 172, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/amb/source/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/amb/source/server/trunk/openerp/osv/orm.py", line 3219, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/amb/source/server/trunk/openerp/osv/orm.py", line 3342, in _read_flat
      res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
    File "/home/amb/source/server/trunk/openerp/osv/fields.py", line 1000, in get
      result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
    File "/home/amb/source/addons/trunk/stock/stock.py", line 1379, in _get_stock
      location_id IN %s and prodlot_id IN %s group by prodlot_id''',(tuple(locations),tuple(ids),))
    File "/home/amb/source/server/trunk/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/amb/source/server/trunk/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: syntax error at or near ")"
  LINE 7: ...0, 21, 25, 26, 11, 12, 19, 18) and prodlot_id IN () group by...

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-web/+bug/868271/+subscriptions