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?
DB Error : PHP Fatal error: Uncaught ADODB_Exception: postgres9 error: [-1: ERROR: current transaction is aborted..
-
- Posts: 3
- Joined: Mon Jun 12, 2023 4:13 am
- Contact:
-
- Posts: 3
- Joined: Mon Jun 12, 2023 4:13 am
- Contact:
Re: DB Error : PHP Fatal error: Uncaught ADODB_Exception: postgres9 error: [-1: ERROR: current transaction is aborted.
is there any manual installation script that can be run on cli ?
-
- Posts: 3
- Joined: Mon Jun 12, 2023 4:13 am
- Contact:
Re: DB Error : PHP Fatal error: Uncaught ADODB_Exception: postgres9 error: [-1: ERROR: current transaction is aborted.
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
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
Last edited by pablofalck on Wed Jun 14, 2023 1:37 am, edited 1 time in total.
Re: DB Error : PHP Fatal error: Uncaught ADODB_Exception: postgres9 error: [-1: ERROR: current transaction is aborted.
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.
Please attach your entire TimeTrex log here. Might be helpful to check your PostgreSQL or Apache error logs too.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!