Error on opening a sequence record: (...)column "increment_by" does not exist(..)

(Francisco Maria Moyano Casco) #1

Hello everyone,
I’m having this error on multiples tryton servers when I’m trying to open a sequence record (Administration/Sequences/Sequences):
psycopg2.ProgrammingError: column “increment_by” does not exist

I read some similar issues on, but have no clue on how to fix it.
I’m using trytond 4.2 and postgres 10.

(Cédric Krier) #2

This is Issue 6789: ir.sequence number_next does not work with postgresql 10.0 - Tryton issue tracker, all versions prior to 4.6 can not run on PostgreSQL 10.
So you must downgrade PostgreSQL or upgrade Tryton.

(Francisco Maria Moyano Casco) #3

That would be enough to make me crazy this week. Ha, ha, ha