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

Support System Administrator
1

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?

2

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.

3

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