c2c-oerpscenario team mailing list archive

["Kyle Waid - http://www.gcotech.com" <522495@xxxxxxxxxxxxxxxxxx>]

** Changed in: magentoerpconnect
       Status: New => Invalid

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

Title:
  SQL syntax error when importing product attributes rev.285

Status in Magento OpenERP Connector:
  Invalid

Bug description:
  SQL syntax error when pressing button 5-Import Product Atrributes.

    File "/var/openerp-server/custom_addons/magentoerpconnect/magerp_core.py", line 96, in sync_attribs
      self.pool.get('magerp.product_attribute_set').relate(cr, uid, mage_inp, inst.id, DEBUG)
    File "/var/openerp-server/custom_addons/magentoerpconnect/product.py", line 523, in relate
      cr.execute(query)
    File "/usr/lib/python2.4/site-packages/openerp-server/sql_db.py", line 77, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/lib/python2.4/site-packages/openerp-server/sql_db.py", line 122, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: syntax error at or near "," at character 67

  Printing out query gives:
  INSERT INTO magerp_attrset_attr_rel (set_id,attr_id) VALUES (1, 1),(1, 2),(1, 3),(1, 4),(1, 5),(1, 15),(1, 16),(1, 17),(1, 18),(1, 19),(1, 20),(1, 21),(1, 22),(1, 23),(1, 24),(1, 25),(1, 26),(1, 27),(1, 28),(1, 29),(1, 30),(1, 31),(1, 32),(1, 33),(1, 34),(1, 35),(1, 36),(1, 37),(1, 38),(1, 39),(1, 40),(1, 41),(1, 42),(1, 43),(1, 44),(1, 45),(1, 46),(1, 47),(1, 48),(1, 49),(1, 50),(1, 51),(1, 52),(1, 53),(1, 54),(1, 55),(1, 56),(1, 57),(1, 58);

  What is wrong when trying to execute SQL statement.
  Should be loop 
  INSERT INTO magerp_attrset_attr_rel (set_id,attr_id) VALUES (1, 1);
  INSERT INTO magerp_attrset_attr_rel (set_id,attr_id) VALUES (1, 2);
  etc.

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