agrihold / sagi

Sistema de Mantenimiento y Seguimiento de Documentos.
1 stars 0 forks source link

Error al crear una sgr.registry_category #207

Closed jjscarafia closed 11 years ago

jjscarafia commented 11 years ago

Al intentar crear una cetgoría de registro desde cualquier tipo de registro o desde "sgr/configuratcion/productos y registros/registry category" da el error Client Traceback (most recent call last): File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/http.py", line 203, in dispatch response["result"] = method(self, *_self.params) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/controllers/main.py", line 1129, in call_kw return self._call_kw(req, model, method, args, kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/controllers/main.py", line 1121, in _call_kw return getattr(req.session.model(model), method)(_args, *kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 43, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 31, in proxy_method result = self.session.send(self.service_name, method, args) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 104, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last): File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/addons/web/session.py", line 90, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/netsvc.py", line 293, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/service/web_services.py", line 620, in dispatch res = fn(db, uid, _params) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, args, _kw or {}) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, _args, _kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, _args, _kw) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, _args, _kw) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/orm.py", line 4470, in create result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or [] File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/osv/fields.py", line 779, in set cr.execute('delete from '+rel+' where '+id1+'=%s AND '+id2+' IN (SELECT '+rel+'.'+id2+' FROM '+rel+', '+','.join(tables)+' WHERE '+rel+'.'+id1+'=%s AND '+rel+'.'+id2+' = '+obj._table+'.id '+ d1 +')', [id, id]+d2) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/sql_db.py", line 161, in wrapper return f(self, _args, _kwargs) File "/opt/openerp/v7.0/default/lib/python2.6/site-packages/openerp-7.0-py2.6.egg/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: ERRO: coluna "registry_category_id" não existe LINHA 1: ...stry_category_ids_document_category_ids_rel where registry_c...

csrocha commented 11 years ago

es una tontería Estuve limpiando de columnas inútiles a la base de datos _sagi y una de las columnas que eliminé fue uid de wkf_instance Prometo recuperar eso en un par de horas.

jjscarafia commented 11 years ago

Se probo y parece andar bien. Se podría cerrar este issue

csrocha commented 11 years ago

Lo cierro entonces. Cualquier cosa se vuelve a abrir.