This question has been flagged
1 Reply
5839 Views

i have created my new module in open erp using web interface i have create it is showing perfectly but when click on save button it show me error ERROR "Open ERP Server Error"

OpenERP Server Error
    Client Traceback (most recent call last):
 File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\http.py", line 204, in  
     dispatch
         response["result"] = method(self, **self.params)
     File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\controllers\main.py", 
       line          1128, in call_kw
 return self._call_kw(req, model, method, args, kwargs)
    File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\controllers\main.py", line    
       1120, in _call_kw
     return getattr(req.session.model(model), method)(*args, **kwargs)
    File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\session.py", line 42, in 
   proxy
result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
     File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\session.py", line 30, in 
         proxy_method
result = self.session.send(self.service_name, method, *args)
      File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\session.py", line 103, in 
  send
     raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)
       Server Traceback (most recent call last):
      File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\session.py", line 89, in 
    send
return openerp.netsvc.dispatch_rpc(service_name, method, args)

      File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\netsvc.py", line 292, in dispatch_rpc

     result = ExportService.getService(service_name).dispatch(method, params)
       File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\service\web_services.py", line 626, in  
             dispatch
       res = fn(db, uid, *params)
   File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
 File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
     File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\orm.py", line 4434, in create
cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
      File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\sql_db.py", line 161, in wrapper
return f(self, *args, **kwargs)
       File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
    ProgrammingError: column "x_number" of relation "x_test" does not exist
     L INE 1: insert into "x_test" (id,"x_number","x_name","x_products",cr...
                             ^
Avatar
Discard

Can you paste the full error log ? or the code?

Author

please see my update question @pravitha

have you upgraded the module from the interface?

If you creating physical module or new addons then please do not use x_field name, x_ use for live field addition, just give proper field names.

then reload and upgrade module then try to test again.

do not use x_[fieldname],

Author

i have created the field name with x and field label without x . but when i create a field name without x so it gives me error and does not save

Best Answer

The following Server error means you field is not existing. You must upgrade the module in openerp installed modules from the interface. Also i have found something as follows:

openerp.osv.orm.check_object_name(name)

Check if the given name is a valid openerp object name.

The _name attribute in osv and osv_memory object is subject to some restrictions. This function returns True or False whether the given name is allowed or not.

TODO: this is an approximation. The goal in this approximation is to disallow uppercase characters (in some places, we quote table/column names and in other not, which leads to this kind of errors:

psycopg2.ProgrammingError: relation "xxx" does not exist).

The same restriction should apply to both osv and osv_memory objects for consistency

Avatar
Discard