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/

관련 게시물	답글	화면
How To Set Char Type Field Only Have Number Input ODOO 12 ? 12.0	2 1월 25	6824
computed fields 해결 완료 12.0	1 4월 24	2801
running odoo 12 on ubuntu 22.04 OS, python 3.7, postgresql 15.0 12.0	1 12월 23	5048
Menu item for users and group only 해결 완료 12.0	2 11월 22	4170
configuration calendrier pour prise d'heur de RDV en ligne 12.0	0 11월 22	3959

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!