Conflict with sequence_postgres module for 6.0

[Kyle Waid]

Hi,

We have sequence_postgres module in use and it causes conflict with this module, I believe because it has no sequences defined. See traceback

Traceback (most recent call last):
  File "/usr/local/openerp/openerp-server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/usr/local/openerp/openerp-server/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/openerp/openerp-server/bin/addons/base/module/wizard/base_module_upgrade.py", line 98, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/local/openerp/openerp-server/bin/pooler.py", line 60, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/usr/local/openerp/openerp-server/bin/pooler.py", line 39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/usr/local/openerp/openerp-server/bin/addons/__init__.py", line 883, in load_modules
    processed_modules.extend(load_module_graph(cr, graph, status, report=report, skip_modules=processed_modules))
  File "/usr/local/openerp/openerp-server/bin/addons/__init__.py", line 719, in load_module_graph
    init_module_objects(cr, package.name, modules)
  File "/usr/local/openerp/openerp-server/bin/addons/__init__.py", line 414, in init_module_objects
    result = obj._auto_init(cr, {'module': module_name})
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 2682, in _auto_init
    default = self._defaults[k](self, cr, 1, context)
  File "/usr/local/openerp/addons/crm_claim_rma/crm_claim_rma.py", line 263, in <lambda>
    'sequence': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'crm.claim'),
  File "/usr/local/openerp/addons/sequence-postgres/ir_sequence.py", line 130, in get
    return self.get_id(cr, uid, code, test='code', context=context)
  File "/usr/local/openerp/addons/account/sequence.py", line 64, in get_id
    context=context)
  File "/usr/local/openerp/addons/sequence-postgres/ir_sequence.py", line 112, in get_id
    ], limit=1, context=context)
ValueError: need more than 0 values to unpack

[Kyle Waid (midwest)]

[2012-01-18 10:38:02,957][midwestsupplies] INFO:init:module crm_claim_rma: creating or updating database tables
/usr/local/openerp/openerp-server/bin/osv/orm.py:515: UnicodeWarning: Unicode unequal comparison failed to convert both arguments to Unicode - interpreting them as being unequal
  if cols[k][key] != vals[key]:
[2012-01-18 10:38:03,174][midwestsupplies] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/openerp/openerp-server/bin/addons/base/module/wizard/base_module_upgrade.py", line 98, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/local/openerp/openerp-server/bin/pooler.py", line 60, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/usr/local/openerp/openerp-server/bin/pooler.py", line 39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/usr/local/openerp/openerp-server/bin/addons/__init__.py", line 883, in load_modules
    processed_modules.extend(load_module_graph(cr, graph, status, report=report, skip_modules=processed_modules))
  File "/usr/local/openerp/openerp-server/bin/addons/__init__.py", line 719, in load_module_graph
    init_module_objects(cr, package.name, modules)
  File "/usr/local/openerp/openerp-server/bin/addons/__init__.py", line 414, in init_module_objects
    result = obj._auto_init(cr, {'module': module_name})
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 2597, in _auto_init
    default = self._defaults[k](self, cr, 1, context)
  File "/usr/local/openerp/addons/crm_claim_rma/crm_claim_rma.py", line 263, in <lambda>
    'sequence': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'crm.claim'),
  File "/usr/local/openerp/addons/sequence-postgres/ir_sequence.py", line 130, in get
    return self.get_id(cr, uid, code, test='code', context=context)
  File "/usr/local/openerp/addons/account/sequence.py", line 64, in get_id
    context=context)
  File "/usr/local/openerp/addons/sequence-postgres/ir_sequence.py", line 112, in get_id
    ], limit=0, context=context)
ValueError: need more than 0 values to unpack

[Kyle Waid (midwest)]

The problem is with this line,
'sequence': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'crm.claim'),

Im not sure if this is a problem with this module specifically or not, I did notice I couldnt save a new claim because a required field was not met, but no red fields were available

[Kyle Waid (midwest)]

I confirm that if I create the xml records, then change to postgres sequences the installation if the module works fine