DB Error : PHP Fatal error: Uncaught ADODB_Exception: postgres9 error: [-1: ERROR: current transaction is aborted..

[pablofalck]

Hi all!

When running the installator im receiving at the last part this error:

PHP Fatal error: Uncaught ADODB_Exception: postgres9 error: [-1: ERROR: current transaction is aborted, commands ignored until end of transaction block] in EXECUTE("\n\t\t\tselect table_name,'T' from information_schema.tables where table_schema not in ( 'pg_catalog','information_schema')\n\t\t\tunion\n\t\t\tselect table_name,'V' from information_schema.views where table_schema not in ( 'pg_catalog','information_schema') ") in /var/www/html/timetrex/classes/adodb/adodb-exceptions.inc.php:89\nStack trace:\n#0 /var/www/html/timetrex/classes/adodb/adodb.inc.php(341): adodb_throw()\n#1 /var/www/html/timetrex/classes/adodb/adodb.inc.php(1676): ADODB_TransMonitor()\n#2 /var/www/html/timetrex/classes/adodb/adodb.inc.php(1642): ADOConnection->_Execute()\n#3 /var/www/html/timetrex/classes/adodb/adodb.inc.php(3184): ADOConnection->Execute()\n#4 /var/www/html/timetrex/classes/adodb/drivers/adodb-postgres64.inc.php(245): ADOConnection->MetaTables()\n#5 /var/www/html/timetrex/classes/modules/install/Install.class.php(556): ADODB_postgres64->MetaTables()\n#6 /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php(239): Install->checkTableExists()\n#7 /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php(876): TimeTrexSoapClient->getPrimaryCompanyData()\n#8 /var/www/html/timetrex/classes/modules/core/TTMail.class.php(494): TimeTrexSoapClient->sendEmail()\n#9 /var/www/html/timetrex/classes/modules/core/Misc.class.php(2654): TTMail->Send()\n#10 /var/www/html/timetrex/classes/modules/core/Debug.class.php(726): Misc::sendSystemMail()\n#11 /var/www/html/timetrex/classes/modules/core/Exception.class.php(111): Debug::emailLog()\n#12 /var/www/html/timetrex/classes/modules/install/InstallSchema_Base.class.php(253): DBError->__construct()\n#13 /var/www/html/timetrex/classes/modules/install/InstallSchema_Base.class.php(299): InstallSchema_Base->_InstallSchema()\n#14 /var/www/html/timetrex/classes/modules/install/InstallSchema.class.php(139): InstallSchema_Base->InstallSchema()\n#15 /var/www/html/timetrex/classes/modules/install/Install.class.php(886): InstallSchema->__call()\n#16 /var/www/html/timetrex/classes/modules/install/Install.class.php(784): Install->createSchema()\n#17 /var/www/html/timetrex/classes/modules/api/core/APIInstall.class.php(534): Install->createSchemaRange()\n#18 /var/www/html/timetrex/api/json/api.php(139): APIInstall->setDatabaseSchema()\n#19 /var/www/html/timetrex/api/json/api.php(199): invokeService()\n#20 /var/www/html/timetrex/api/json/api.php(411): unauthenticatedInvokeService()\n#21 {main}\n thrown in /var/www/html/timetrex/classes/adodb/adodb-exceptions.inc.php on line 89


Setup:
Centos 7.9
php 8.2
postgres 15


Followed all instructions in https://www.timetrex.com/how-to-install ... nux-centos adapting them to my setup. The note about the socket connections did not work either.

Any idea?

[pablofalck]

is there any manual installation script that can be run on cli ?

[pablofalck]

just tried downgrading to php8.1 and same problem:

PHP Fatal error: Uncaught ADODB_Exception: postgres9 error: [-1: ERROR: current transaction is aborted, commands ignored until end of transaction block] in EXECUTE("\n\t\t\tselect table_name,'T' from information_schema.tables where table_schema not in ( 'pg_catalog','information_schema')\n\t\t\tunion\n\t\t\tselect table_name,'V' from information_schema.views where table_schema not in ( 'pg_catalog','information_schema') ") in /var/www/html/timetrex/classes/adodb/adodb-exceptions.inc.php:89\nStack trace:\n#0 /var/www/html/timetrex/classes/adodb/adodb.inc.php(341): adodb_throw()\n#1 /var/www/html/timetrex/classes/adodb/adodb.inc.php(1676): ADODB_TransMonitor()\n#2 /var/www/html/timetrex/classes/adodb/adodb.inc.php(1642): ADOConnection->_Execute()\n#3 /var/www/html/timetrex/classes/adodb/adodb.inc.php(3184): ADOConnection->Execute()\n#4 /var/www/html/timetrex/classes/adodb/drivers/adodb-postgres64.inc.php(245): ADOConnection->MetaTables()\n#5 /var/www/html/timetrex/classes/modules/install/Install.class.php(556): ADODB_postgres64->MetaTables()\n#6 /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php(239): Install->checkTableExists()\n#7 /var/www/html/timetrex/classes/modules/soap/TimeTrexSoapClient.class.php(876): TimeTrexSoapClient->getPrimaryCompanyData()\n#8 /var/www/html/timetrex/classes/modules/core/TTMail.class.php(494): TimeTrexSoapClient->sendEmail()\n#9 /var/www/html/timetrex/classes/modules/core/Misc.class.php(2654): TTMail->Send()\n#10 /var/www/html/timetrex/classes/modules/core/Debug.class.php(726): Misc::sendSystemMail()\n#11 /var/www/html/timetrex/classes/modules/core/Exception.class.php(111): Debug::emailLog()\n#12 /var/www/html/timetrex/classes/modules/install/InstallSchema_Base.class.php(253): DBError->__construct()\n#13 /var/www/html/timetrex/classes/modules/install/InstallSchema_Base.class.php(299): InstallSchema_Base->_InstallSchema()\n#14 /var/www/html/timetrex/classes/modules/install/InstallSchema.class.php(139): InstallSchema_Base->InstallSchema()\n#15 /var/www/html/timetrex/classes/modules/install/Install.class.php(886): InstallSchema->__call()\n#16 /var/www/html/timetrex/classes/modules/install/Install.class.php(784): Install->createSchema()\n#17 /var/www/html/timetrex/classes/modules/api/core/APIInstall.class.php(534): Install->createSchemaRange()\n#18 /var/www/html/timetrex/api/json/api.php(139): APIInstall->setDatabaseSchema()\n#19 /var/www/html/timetrex/api/json/api.php(199): invokeService()\n#20 /var/www/html/timetrex/api/json/api.php(411): unauthenticatedInvokeService()\n#21 {main}\n thrown in /var/www/html/timetrex/classes/adodb/adodb-exceptions.inc.php on line 89

[mikeb]

That error message is not the cause, but simply the result of another error happening before it. Its likely related to your database as well, either a connection problem, or permission problem preventing certain queries from being run.

Please attach your entire TimeTrex log here. Might be helpful to check your PostgreSQL or Apache error logs too.