c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #29259
[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