c2c-oerpscenario team mailing list archive

[ag2888 <667735@xxxxxxxxxxxxxxxxxx>]

Exactly !


Environment Information : 
System : Windows-32bit
OS Name : nt
Operating System Release : 
Operating System Version : 32bit
Operating System Architecture : 32bit
Operating System Locale : fr_FR.cp1252
Python Version : 2.5.2
OpenERP-Client Version : 6.0.0-rc1-1
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/opt/openerp/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/opt/openerp/server/bin/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/bin/osv/osv.py", line 57, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/bin/osv/osv.py", line 140, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/bin/osv/osv.py", line 130, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/addons/base_sale_multichannels/sale.py", line 170, in export_catalog
    self.export_inventory(cr, uid, ids, ctx)
  File "/opt/openerp/addons/base_sale_multichannels/sale.py", line 181, in export_inventory
    recent_move_ids = self.pool.get('stock.move').search(cr, uid, [('date_planned', '>', shop.last_inventory_export_date), ('product_id', 'in', product_ids), ('state', '!=', 'draft'), ('state', '!=', 'cancel')])
  File "/opt/openerp/server/bin/osv/orm.py", line 1804, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/opt/openerp/server/bin/osv/orm.py", line 4035, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/opt/openerp/server/bin/sql_db.py", line 75, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: ERREUR:  la colonne stock_move.date_planned n'existe pas
LIGNE 1 : SELECT "stock_move".id FROM "stock_move" WHERE (stock_move.d...
                                                          ^

Sincerely

-- 
OpenERP fixed stock_move.date_planned typo on OpenERP v6, we are impacted.
https://bugs.launchpad.net/bugs/667735
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in Magento Open ERP Connector: New

Bug description:
Hello,

Looks like OpenERP SA finally took care of that renaming the stock_move.date_planned field into stock_move.date_expected on OpenERP v6.

the magentoerpconnect module should follow that change on the v6 serie. A trivial sed script will do it.

We should ensure that date_expected is what stands for date_planned though.