← Back to team overview

c2c-oerpscenario team mailing list archive

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

 

Public bug reported:

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.

** Affects: magentoerpconnect
     Importance: Undecided
         Status: New

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


Follow ups

References