openerp-connector-community team mailing list archive

[Landis Arnold <larnold@xxxxxxxxxxx>]

Just ran my first order import.  Worked through all the orders and basically left the ones that were more than 30 days old.  However, the most recent ones ended with the following error in "failed jobs".

These are a split of normal Magento orders and orders that come into Magento from Amazon, but are Magento Orders none the less.  No Orders, Quotations or Invoices have come in.  

Any guidance would be appreciated.  Not sure what is causing this.


Traceback (most recent call last):
  File "/opt/openerp/source/openerp-connector/connector/queue/worker.py", line 122, in run_job
    job.perform(session)
  File "/opt/openerp/source/openerp-connector/connector/queue/job.py", line 460, in perform
    self.result = self.func(session, *self.args, **self.kwargs)
  File "/opt/openerp/source/openerp-connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 329, in import_record
    importer.run(magento_id, force=force)
  File "/opt/openerp/source/openerp-connector-magento/magentoerpconnect/unit/import_synchronizer.py", line 191, in run
    self._after_import(binding_id)
  File "/opt/openerp/source/openerp-connector-magento/magentoerpconnect/sale.py", line 481, in _after_import
    self._create_payment(binding_id)
  File "/opt/openerp/source/openerp-connector-magento/magentoerpconnect/sale.py", line 438, in _create_payment
    amount, context=context)
  File "/opt/openerp/source/e-commerce-addons/sale_payment_method/sale.py", line 122, in automatic_payment
    amount, date, context=context)
  File "/opt/openerp/source/e-commerce-addons/sale_payment_method/sale.py", line 157, in _add_payment
    move_obj.create(cr, uid, move_vals, context=context)
  File "/opt/openerp/addons/account/account.py", line 1434, in create
    result = super(account_move, self).create(cr, uid, vals, c)
  File "/opt/openerp/source/openerp-connector/connector/producer.py", line 42, in create
    record_id = create_original(self, cr, uid, vals, context=context)
  File "/opt/openerp/server/openerp/osv/orm.py", line 4477, in create
    result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
  File "/opt/openerp/server/openerp/osv/fields.py", line 558, in set
    id_new = obj.create(cr, user, act[2], context=context)
  File "/opt/openerp/addons/account/account_move_line.py", line 1142, in create
    if ('account_id' in vals) and not account_obj.read(cr, uid, vals['account_id'], ['active'])['active']:
  File "/opt/openerp/server/openerp/osv/orm.py", line 3612, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/opt/openerp/server/openerp/osv/orm.py", line 3664, in _read_flat
    cr.execute(query, [tuple(sub_ids)] + rule_params)
  File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...d FROM "account_account" WHERE account_account.id IN (false)...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

-- 

Thanks in advance,

Landis Arnold
Boulder, CO USA