RESTORED DATABASE ERROR "psycopg2.ProgrammingError: query has no destination for result data"

Question

Hi,
Restored the database and when trying to validate any record ie invoice it getting error like this.
psycopg2.ProgrammingError: query has no destination for result data
HINT: If you want to discard the results of a SELECT, use PERFORM instead.
CONTEXT: PL/pgSQL function proc_postgres_fix() line 3 at SQL statement
Please does anyone have an idea regarding the same

Jose · Accepted Answer

Hi,
I think this is not from the Odoo default code . Please try to check is there any triggers set on database table
Thanks
For more information visit:
https://www.odoocustomization.com/ [1]

[1] https://www.odoocustomization.com/

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How To Set Char Type Field Only Have Number Input ODOO 12 ? 12.0	2 tammik. 25	6823
computed fields Ratkaistu 12.0	1 huhtik. 24	2800
running odoo 12 on ubuntu 22.04 OS, python 3.7, postgresql 15.0 12.0	1 jouluk. 23	5039
Menu item for users and group only Ratkaistu 12.0	2 marrask. 22	4166
configuration calendrier pour prise d'heur de RDV en ligne 12.0	0 marrask. 22	3958

Tämä kysymys on merkitty

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