Hello,

I am using Odoo Enterprise 18 and encountering an error while installing the HR Attendance module.

During installation, Odoo crashes with the following error:

psycopg2.errors.UndefinedColumn:
column "work_date" of relation "hr_attendance" does not exist

The traceback shows that the issue happens during:

model._auto_init()
_check_removed_columns()
sql.drop_not_null()

It seems that Odoo is trying to alter a column named work_date in the hr_attendance table, but this column does not exist in the database.

Additional information:

• There is no work_date field in ir_model_fields for hr.attendance

• There are no constraints referencing work_date

• The error occurs during button_immediate_install

What could be causing Odoo to expect this column?

Is this related to a previous module installation, a migration issue, or metadata inconsistency?

What is the correct and safe way to fix this problem in Odoo Enterprise 18?

Thank you.