After I've entered purchases and sales invoice for a whole month successfully,
I'm currently getting this error whenever I enter a new sales quotation :
ERROR:common.message:MSG ERROR: column "topnotes" of relation "sale_order"
does not exist
LINE 1: insert into "sale_order" (id,perm_id,"origin","topnotes","da...
^
insert into "sale_order"
(id,perm_id,"origin","topnotes","date_order","user_id","name","partner_shipping_id","incoterm","picking_policy","order_policy","partner_order_id","note","state","shop_id","invoice_quantity","client_order_ref","partner_invoice_id","pricelist_id","project_id","partner_id",create_uid,create_date)
values (18,NULL,NULL,'
TEST','2007-01-08','3','SO/016','25',NULL,'direct','manual','25',NULL,'draft','1','order',NULL,'25','2',NULL,'22',3,now()):
Traceback (most recent call last):
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.0/bin/netsvc.py",
line 206, in _dispatch
r=m(*params)
File
"/home/asamir/Documents/tinyERP/tinyerp-server-4.2.0/bin/service/web_services.py",
line 366, in execute
res = service.execute(db, uid, object, method, *args)
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.0/bin/osv/osv.py",
line 111, in execute
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.0/bin/osv/osv.py",
line 92, in execute_cr
res = getattr(object,method)(cr, uid, *args, **kw)
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.0/bin/osv/orm.py",
line 1156, in create
cr.execute('insert into "'+self._table+'" (id,perm_id'+upd0+") values
("+str(id_new)+',NULL'+upd1+')', tuple(upd2))
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.0/bin/sql_db.py",
line 73, in execute
res = self.obj.execute(sql, p)
ProgrammingError: ERROR: column "topnotes" of relation "sale_order" does not
exist
LINE 1: insert into "sale_order" (id,perm_id,"origin","topnotes","da...
I'm using tinyerp-4.2.0
I backed up my database and upgraded to tinyerp-4.2.2. After I applied
update=all to update my database, I still get this error whenever I open the
sales module :
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.2/bin/netsvc.py", line
200, in _dispatch
r=m(*params)
File
"/home/asamir/Documents/tinyERP/tinyerp-server-4.2.2/bin/service/web_services.py",
line 366, in execute
res = service.execute(db, uid, object, method, *args)
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.2/bin/osv/osv.py",
line 111, in execute
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.2/bin/osv/osv.py",
line 92, in execute_cr
res = getattr(object,method)(cr, uid, *args, **kw)
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.2/bin/osv/orm.py",
line 1544, in fields_view_get
xarch, xfields = self.__view_look_dom_arch(cr, user, doc, context=context)
File "/home/asamir/Documents/tinyERP/tinyerp-server-4.2.2/bin/osv/orm.py",
line 1409, in __view_look_dom_arch
fields[field].update(fields_def[field])
KeyError: u'topnotes'
I'm using SuSE 10.3
Thanks..
------------------------
Ahmed Samir - www.am4computers.com
_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman/listinfo/tinyerp-users
