# psycopg2.errors.UndefinedColumn: column a.series does not exist

**URL:** https://discuss.tryton.org/t/psycopg2-errors-undefinedcolumn-column-a-series-does-not-exist/9007
**Category:** System Administrator
**Created:** [December 9, 2025, 1:00pm UTC](https://discuss.tryton.org/t/psycopg2-errors-undefinedcolumn-column-a-series-does-not-exist/9007 "2025-12-09T13:00:38Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Simon](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/simon/32/1150_2.png) [@Simon](https://discuss.tryton.org/u/Simon)
#### Post date: [December 9, 2025, 1:00pm UTC](https://discuss.tryton.org/t/psycopg2-errors-undefinedcolumn-column-a-series-does-not-exist/9007/1 "2025-12-09T13:00:38Z")

</div>

Hi everybody,

I’m trying to migrate from 7.0 to 7.6 but I have this error when running `trytond-console`

`File “/usr/local/lib/python3.11/dist-packages/trytond/model/modelsql.py”, line 1916, in search`  
`cursor.execute(*select)`  
`File “/usr/local/lib/python3.11/dist-packages/trytond/backend/postgresql/database.py”, line 78, in execute`  
`cursor.execute(self, sql, args)`  
`psycopg2.errors.UndefinedColumn: column a.series does not exist`  
`LINE 1: …roduct_price_decimal" AS “product_price_decimal”, “a”."serie…`

Any clue how to fix this?

---

<div class="post-metadata">

### Author: ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [December 9, 2025, 1:26pm UTC](https://discuss.tryton.org/t/psycopg2-errors-undefinedcolumn-column-a-series-does-not-exist/9007/2 "2025-12-09T13:26:26Z")

</div>

In order to migrate the series you must run `trytond-admin` first so the database is upgraded to the newer series. After update you can run `trytond-console` to run the needed scripts.

---

<div class="post-metadata">

### Author: ![Simon](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/simon/32/1150_2.png) [@Simon](https://discuss.tryton.org/u/Simon)
#### Post date: [December 10, 2025, 4:01pm UTC](https://discuss.tryton.org/t/psycopg2-errors-undefinedcolumn-column-a-series-does-not-exist/9007/3 "2025-12-10T16:01:30Z")

</div>

Thanks a lot. It may be obvious, but since it isn’t mentioned on the migration page, I forgot about this step…

---

<div class="post-metadata">

### Author: ![system](https://discuss-cdn.tryton.org/uploads/default/original/1X/c6f8ec0a40525cdcd50058c734283450a4b3d38b.png) [@system](https://discuss.tryton.org/u/system)
#### Post date: [December 11, 2025, 4:02pm UTC](https://discuss.tryton.org/t/psycopg2-errors-undefinedcolumn-column-a-series-does-not-exist/9007/4 "2025-12-11T16:02:07Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.