Odoo Enterprise 18 – Error installing HR Attendance (column "work_date" does not exist)

hr attendance

1 Vastaa

1417 Näkymät

TIMSOLL AVTO Limited

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.

Cybrosys Techno Solutions Pvt.Ltd

Hi,

During installation, Odoo's ORM tries to drop a NOT NULL constraint on the `work_date` column in the hr_attendance table, but the column doesn't exist in the database, causing PostgreSQL to throw an UndefinedColumn error.

This is a database/metadata inconsistency, not a code bug in the standard module. The most likely causes are:

A previous third-party or custom module added work_date to hr.attendance, was uninstalled improperly, and left behind orphaned migration state

A partial migration: the database came from an older Odoo version (e.g. 16 or 17) where work_date existed, and a migration script was partially applied, leaving Odoo thinking the column still needs cleanup

Manual database intervention: someone previously dropped the column directly from PostgreSQL without going through Odoo, leaving Odoo's internal state out of sync

Fix:

Since the column doesn't exist but Odoo is trying to alter it, the safest fix is to temporarily create the column so Odoo's alteration can complete, then You

can clean it up yourself afterward.

Hope it helps

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Connect fingerprint devices to Odoo Ratkaistu hr attendance	1 toukok. 25	3392
Allow employees to see their own attendances Ratkaistu hr attendance	6 tammik. 23	20034
odoo13: Button with function of capture image Ratkaistu hr attendance	2 jouluk. 22	7137
attendance link not coming on the above header hr attendance	0 jouluk. 17	5286
how to track Attendance (overtime worked, hrs owed to the company)? hr attendance	6 kesäk. 17	12903

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!