During installation, I encountered an error upon completing Configure Site stage. At first, I was prompted with 504 Gateway Timeout error. So I adjusted the php.ini max execution time from 30 to 120. Then I resintalled the OpenIdeaL and after the Configuration Site stage, I get the following error:

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block.

Please advise how to fixed this problem.

Also prior to that issue, I get SQL exception but managed to fixed it myself. During installation, they are looking for FROM_UNIXTIME() function and Postgres has no such function so I created the functions myself.

Thank you!

Best regards,
Adrian