← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 813422] Re: LINE 1: ..._groups" WHERE magerp_product_attribute_groups.id IN

 

Follow-up
Thanks to Kyle Waid from www.gcotech.com that has suggested by mail to install the latest version of magentoerpconnect-v6 at the following address:
https://code.launchpad.net/~magentoerpconnect-core-editors/magentoerpconnect/magentoerpconnect-v6
This error message has disappeared and the "magento fields" are accessible but...
At the same time this error started, the products by attribute sets were not accessible. Unfortunatly, if i click on products > Spiritueux (and all others ex: Vins, Encens, Bieres) the list is empty (not normal)
Any suggestion is greatly appreciated.

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

Title:
  LINE 1: ..._groups" WHERE magerp_product_attribute_groups.id IN

Status in Magento OpenERP Connector:
  New

Bug description:
  Last night everything was working fine, I imported three new attributes wich one had rhône inside. (notice the ô accent)
  Not sure if this is the problem, modified to rhone in magento, resinchronised and imported attributes. Unfortunatly error persists. I am unable to access "magento fields" tab inside products. Does anyone have an idea? 

  This error report:

  Environment Information : 
  System : Windows-XP-5.1.2600-SP3
  OS Name : nt
  Operating System Release : XP
  Operating System Version : 5.1.2600
  Operating System Architecture : 32bit
  Operating System Locale : fr_FR.cp1252
  Python Version : 2.5.2
  OpenERP-Client Version : 6.0.1
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "/usr/share/pyshared/openerp-server/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/usr/share/pyshared/openerp-server/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/usr/share/pyshared/openerp-server/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/share/pyshared/openerp-server/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/share/pyshared/openerp-server/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/share/pyshared/openerp-server/addons/magentoerpconnect-v6.zip/magentoerpconnect-v6/product.py", line 838, in fields_view_get
      view_part = self.redefine_prod_view(cr, uid, field_names, context) #.decode('utf8') It is not necessary, the translated view could be in UTF8
    File "/usr/share/pyshared/openerp-server/addons/magentoerpconnect-v6.zip/magentoerpconnect-v6/product.py", line 768, in redefine_prod_view
      group_name = attr_group_obj.read(cr, uid, oerp_group_id, ['attribute_group_name'])['attribute_group_name']
    File "/usr/share/pyshared/openerp-server/osv/orm.py", line 2921, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/usr/share/pyshared/openerp-server/osv/orm.py", line 2980, in _read_flat
      cr.execute(query, (tuple(sub_ids),))
    File "/usr/share/pyshared/openerp-server/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/share/pyshared/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: ERREUR:  l'opérateur n'existe pas : integer = boolean
  LINE 1: ..._groups" WHERE magerp_product_attribute_groups.id IN (false)...
                                                               ^
  HINT:  Aucun opérateur ne correspond au nom donné et aux types d'arguments.
  Vous devez ajouter des conversions explicites de type.

To manage notifications about this bug go to:
https://bugs.launchpad.net/magentoerpconnect/+bug/813422/+subscriptions


References