c2c-oerpscenario team mailing list archive

["Jay \(OpenERP\)" <jvo@xxxxxxxxxxx>]

Phong,

This is just a problem due to an Updated code without updated DB(or new
db).

Please update the code,db or work with new DB.

Thanks.

** Changed in: openobject-addons
       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/691835

Title:
  Programming error: column "comment" of relation "account_voucher" does not exist

Status in OpenObject Addons Modules:
  Invalid

Bug description:
  When using "Pay invoice" feature with account voucher installed, I experienced the following error

[2010-12-18 16:18:19,867][demo60] ERROR:db.cursor:Programming error: column "comment" of relation "account_voucher" does not exist
LINE 1: insert into "account_voucher" (id,"comment","payment_option"...
                                          ^
, in query insert into "account_voucher" (id,"comment","payment_option","account_id","reference","journal_id","currency_id","period_id","narration","date","partner_id","tax_id","name","pay_now","amount","company_id","state","pre_line","type",create_uid,create_date) values (217,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,now())
[2010-12-18 16:18:19,868][demo60] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 3740, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "comment" of relation "account_voucher" does not exist
LINE 1: insert into "account_voucher" (id,"comment","payment_option"...
                                          ^

[2010-12-18 16:18:19,868][demo60] DEBUG:web-services:netrpc: rpc-dispatching exception
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/service/netrpc_server.py", line 70, in run
    result = self.dispatch(msg[0], msg[1], msg[2:])
  File "/var/local/software/openerp-v6.0dev/server/bin/netsvc.py", line 499, in dispatch
    raise OpenERPDispatcherException(e, tb_s)
OpenERPDispatcherException
[2010-12-18 16:18:22,689][demo60] ERROR:db.cursor:Programming error: relation "publisher_warranty_contract" does not exist
LINE 1: SELECT "publisher_warranty_contract".id FROM "publisher_warr...
                                                     ^
, in query SELECT "publisher_warranty_contract".id FROM "publisher_warranty_contract" ORDER BY id
[2010-12-18 16:18:22,689][demo60] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 167, in execute_cr
   return getattr(object, method)(cr, uid, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base/publisher_warranty/publisher_warranty.py", line 247, in status
    return self.pool.get("publisher_warranty.contract").status(cr, uid)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base/publisher_warranty/publisher_warranty.py", line 68, in status
    contracts = self._get_valid_contracts(cr, uid)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base/publisher_warranty/publisher_warranty.py", line 62, in _get_valid_contracts
    return [contract for contract in self.browse(cr, uid, self.search(cr, uid, []))
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 1870, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 4095, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: relation "publisher_warranty_contract" does not exist
LINE 1: SELECT "publisher_warranty_contract".id FROM "publisher_warr...
                                                     ^

[2010-12-18 16:18:22,690][demo60] DEBUG:web-services:netrpc: rpc-dispatching exception
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/service/netrpc_server.py", line 70, in run
    result = self.dispatch(msg[0], msg[1], msg[2:])
  File "/var/local/software/openerp-v6.0dev/server/bin/netsvc.py", line 499, in dispatch
    raise OpenERPDispatcherException(e, tb_s)
OpenERPDispatcherException

addons/ : 4017 chs@xxxxxxxxxxx-20101216112752-9xg4i9ompw1bi81v
addons-community/ : 292 fran@fran-pc-20101213182241-2fogs8yh5u4ma31q
addons-extra/ : 5098 sebastien.beau@xxxxxxxxxxxxxxx-20101216111109-sts0gvimew1ro8xl
server/ : 3120 odo@xxxxxxxxxxx-20101216100749-z06fv08n4u5rhwl0