hi guys,
I successfully imported everything from your tutorial till the orders. All orders are failing in the import with the following error:
Traceback (most recent call last):
File "/opt/openerp-custom/addons/connector/connector/queue/worker.py", line 124, in run_job
job.perform(session)
File "/opt/openerp-custom/addons/connector/connector/queue/job.py", line 466, in perform
self.result = self.func(session, _self.args, *_self.kwargs)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 379, in import_record
importer.run(magento_id, force=force)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 225, in run
self._after_import(binding)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/sale.py", line 727, in _after_import
self._create_payment(binding)
File "/opt/openerp-custom/addons/connector-magento/magentoerpconnect/sale.py", line 691, in _create_payment
binding.openerp_id.automatic_payment(amount)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/opt/openerp-custom/addons/e-commerce/sale_payment_method/sale.py", line 107, in automatic_payment
self._add_payment(journal, amount, date)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/opt/openerp-custom/addons/e-commerce/sale_payment_method/sale.py", line 136, in _add_payment
move_model.create(move_vals)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 462, in new_api
result = method(self._model, cr, uid, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/addons/account/account.py", line 1402, in create
result = super(account_move, self).create(cr, uid, vals, c)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
return old_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 336, in old_api
result = method(recs, _args, *_kwargs)
File "/opt/openerp-custom/addons/connector/connector/producer.py", line 48, in create
record_id = create_original(self, vals)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4074, in create
record = self.browse(self._create(old_vals))
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 462, in new_api
result = method(self._model, cr, uid, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4259, in _create
result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
File "/usr/lib/python2.7/dist-packages/openerp/osv/fields.py", line 811, in set
id_new = obj.create(cr, user, act[2], context=context)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
return old_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/addons/account/account_move_line.py", line 1282, in create
if ('account_id' in vals) and not account_obj.read(cr, uid, [vals['account_id']], ['active'])[0]['active']:
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
return old_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3139, in read
result = BaseModel.read(records, fields, load=load)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3174, in read
self._read_from_database(stored, inherited)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3386, in _read_from_database
forbidden = missing.exists()
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper
return new_api(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4860, in exists
self._cr.execute(query, [tuple(ids)])
File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 158, in wrapper
return f(self, _args, *_kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute
res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: SELECT id FROM "account_account" WHERE id IN (false)
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Do you have an idea whats going on here?
Thanks,
Michael