psycopg2.ProgrammingError: column ailsaodoo_session.color does not exist
LINE 2: ...ailsaodoo_session".id) AS "course_id_count" , sum("ailsaodoo...
^
actually I have define the color in .py file and use it in xml file
.py:
color = fields.Integer()
.xml
<kanban default_group_by="course_id">
<field name="color"/>
...
</kanban>
However, I fixed the problem by manually adding the column to database. I still want to know how to solve this by coding.
That is because the model is load after the inherit model, you can force load before and the database update use the next script:
odoo-bin -c <odoo.config.file> -d <database.name> -u <your.model.name>
I had the same problem and doing as follow fix the issue:
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Make sure that in the code, you have added the field color in the same model and also check whether the file is called in init.