Odoo Help


Error while updating custom module in Database. Why this eroor comes

Amol Gangajaliwale
on 1/14/16, 3:19 AM 712 views

2016-01-14 07:49:27,554 18361 INFO schoolreal openerp.modules.loading: loading 32 modules...

2016-01-14 07:49:27,972 18361 WARNING schoolreal openerp.fields: Field op.subject.course_id with unknown comodel_name 'op.course'

2016-01-14 07:49:28,209 18361 INFO schoolreal openerp.modules.module: module school: creating or updating database tables

2016-01-14 07:49:28,593 18361 ERROR schoolreal openerp.sql_db: Programming error: column "grn_number" named in key does not exist

, in query ALTER TABLE "student_student" ADD CONSTRAINT "student_student_grn_unique" unique(grn_number)

2016-01-14 07:49:28,594 18361 WARNING schoolreal openerp.models.schema: Table 'student_student': unable to add 'unique(grn_number)' constraint !

If you want to have it, you should update the records and execute manually:

ALTER TABLE "student_student" ADD CONSTRAINT "student_student_grn_unique" unique(grn_number)

2016-01-14 07:49:29,172 18361 INFO schoolreal openerp.addons.auth_crypt.auth_crypt: Hashing passwords, may be slow for databases with many users...

2016-01-14 07:49:29,397 18361 INFO schoolreal openerp.modules.loading: loading school/wizard/wiz_send_email_view.xml

2016-01-14 07:49:29,442 18361 INFO schoolreal openerp.modules.loading: loading school/school_view.xml

2016-01-14 07:49:29,532 18361 ERROR schoolreal openerp.tools.convert.init: Could not eval([(4, ref('school.group_school_student'))]) for groups in {}

2016-01-14 07:49:29,533 18361 ERROR schoolreal openerp.http: Exception during JSON request handling.

Traceback (most recent call last):

File "/home/infinity/odoo/odoo/odoo/openerp/http.py", line 537, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/home/infinity/odoo/odoo/odoo/openerp/http.py", line 574, in dispatch

result = self._call_function(**self.params)

File "/home/infinity/odoo/odoo/odoo/openerp/http.py", line 310, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/home/infinity/odoo/odoo/odoo/openerp/service/model.py", line 118, in wrapper

return f(dbname, *args, **kwargs)

File "/home/infinity/odoo/odoo/odoo/openerp/http.py", line 307, in checked_call

return self.endpoint(*a, **kw)

File "/home/infinity/odoo/odoo/odoo/openerp/http.py", line 803, in __call__

return self.method(*args, **kw)

File "/home/infinity/odoo/odoo/odoo/openerp/http.py", line 403, in response_wrap

response = f(*args, **kw)

File "/home/infinity/odoo/odoo/odoo/addons/web/controllers/main.py", line 948, in call_button

action = self._call_kw(model, method, args, {})

File "/home/infinity/odoo/odoo/odoo/addons/web/controllers/main.py", line 936, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/home/infinity/odoo/odoo/odoo/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "/home/infinity/odoo/odoo/odoo/openerp/addons/base/module/module.py", line 447, in button_immediate_install

return self._button_immediate_function(cr, uid, ids, self.button_install, context=context)

File "/home/infinity/odoo/odoo/odoo/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "/home/infinity/odoo/odoo/odoo/openerp/addons/base/module/module.py", line 495, in _button_immediate_function

registry = openerp.modules.registry.RegistryManager.new(cr.dbname, update_module=True)

File "/home/infinity/odoo/odoo/odoo/openerp/modules/registry.py", line 370, in new

openerp.modules.load_modules(registry._db, force_demo, status, update_module)

File "/home/infinity/odoo/odoo/odoo/openerp/modules/loading.py", line 355, in load_modules

loaded_modules, update_module)

File "/home/infinity/odoo/odoo/odoo/openerp/modules/loading.py", line 255, in load_marked_modules

loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)

File "/home/infinity/odoo/odoo/odoo/openerp/modules/loading.py", line 176, in load_module_graph

_load_data(cr, module_name, idref, mode, kind='data')

File "/home/infinity/odoo/odoo/odoo/openerp/modules/loading.py", line 118, in _load_data

tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)

File "/home/infinity/odoo/odoo/odoo/openerp/tools/convert.py", line 901, in convert_file

convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

File "/home/infinity/odoo/odoo/odoo/openerp/tools/convert.py", line 987, in convert_xml_import

obj.parse(doc.getroot(), mode=mode)

File "/home/infinity/odoo/odoo/odoo/openerp/tools/convert.py", line 853, in parse

self._tags[rec.tag](self.cr, rec, n, mode=mode)

File "/home/infinity/odoo/odoo/odoo/openerp/tools/convert.py", line 757, in _tag_record

f_val = _eval_xml(self,field, self.pool, cr, self.uid, self.idref)

File "/home/infinity/odoo/odoo/odoo/openerp/tools/convert.py", line 151, in _eval_xml

return unsafe_eval(a_eval, idref2)

File "<string>", line 1, in <module>

File "/home/infinity/odoo/odoo/odoo/openerp/tools/convert.py", line 83, in <lambda>

return lambda x: self.id_get(cr, x)

File "/home/infinity/odoo/odoo/odoo/openerp/tools/convert.py", line 832, in id_get

res = self.model_id_get(cr, id_str, raise_if_not_found)

File "/home/infinity/odoo/odoo/odoo/openerp/tools/convert.py", line 843, in model_id_get


File "/home/infinity/odoo/odoo/odoo/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "/home/infinity/odoo/odoo/odoo/openerp/addons/base/ir/ir_model.py", line 911, in xmlid_to_res_model_res_id

return self.xmlid_lookup(cr, uid, xmlid)[1:3]

File "/home/infinity/odoo/odoo/odoo/openerp/api.py", line 250, in wrapper

return old_api(self, *args, **kwargs)

File "<string>", line 2, in xmlid_lookup

File "/home/infinity/odoo/odoo/odoo/openerp/tools/cache.py", line 74, in lookup

value = d[key] = self.method(*args, **kwargs)

File "/home/infinity/odoo/odoo/odoo/openerp/addons/base/ir/ir_model.py", line 901, in xmlid_lookup

raise ValueError('External ID not found in the system: %s' % (xmlid))

ParseError: "External ID not found in the system: school.group_school_student" while parsing /home/infinity/odoo/odoo/odoo/sch_check/school/school_view.xml:293, near

<record id="student_rule_student_profile_record" model="ir.rule">

<field name="name">Personal Student Profile Record</field>

<field ref="model_student_student" name="model_id"/>

<field eval="1" name="global"/>

<field name="domain_force">[('user_id','=',user.id)]</field>

<field name="groups" eval="[(4, ref('school.group_school_student'))]"/>


you have to properly add your class name in the XML file.

on 1/14/16, 3:30 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 1/14/16, 3:19 AM
Seen: 712 times
Last updated: 1/14/16, 3:19 AM