TimeTrex Time and Attendance

Assuming this is a new installation, can you try deleting the TimeTrex database and going through the web-based installer again to see if the error persists?

I am having the same problem, I have tried again what you just said by erasing DataBase but then you still have the same problems. Also on other systems tried there you have the same error message.

We need to confirm if it is in fact the same underlying error or not. Please enable debug logging as described in this FAQ, then try to connect again and attach a copy of the log file here, it should contain a more specific error message.

Here you can find the more specific error log

Upon further investigation it appears this is actually a bug in PostgreSQL v9.4.23, v9.5.18, v9.6.14, v10.9 (version you are running) and v11.4. All of which were released on 20-Jun-2019 and the specific bug was introduced by the release note item: "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint (Tom Lane)". The bug has already been fixed and is just waiting on the next release of PostgreSQL which is due out in early August 2019.

It only affects new installations of TimeTrex, or upgrades from TimeTrex versions prior to v11.0.0. We are looking at possible work-arounds from our end, but it may not be possible or practical due to the nature of the bug, and in either case will take some time to implement, test and release ourselves.

However installing an earlier point release of Ubuntu 18.04 or downgrading PostgreSQL to 10.8 or earlier would also allow the install to complete. Once the installation is completed you could upgrade to the latest point release and TimeTrex won't be affected anymore.

Hello but the problem to install TimeTrex is also with the latest version of Postgresql for Ubuntu - psql (11.4 (Ubuntu 11.4-1.pgdg16.04+1))
Still it fails while filling in the main database during the install process.
What is the manual workaround to install it please?
I can't install TimeTrex to test it so I can't put it in our company into a candidate for time tracking SW in the future...
Can you provide an earlier version of TimeTrex that is not affected by this bug?

lumirl wrote: ↑Mon Jul 29, 2019 8:23 am Hello but the problem to install TimeTrex is also with the latest version of Postgresql for Ubuntu - psql (11.4 (Ubuntu 11.4-1.pgdg16.04+1))
Still it fails while filling in the main database during the install process.
What is the manual workaround to install it please?
I can't install TimeTrex to test it so I can't put it in our company into a candidate for time tracking SW in the future...
Can you provide an earlier version of TimeTrex that is not affected by this bug?

The problem isn't with TimeTrex, its with a bug in all of the latest versions of PostgreSQL. Downgrading PostgreSQL by one version (ie: from 11.4 to 11.3) will resolve the issue. We are looking into a possible way to work around the bug in PostgreSQL, but that doesn't change the fact that the problem is with PostgreSQL and not TimeTrex.

We have posted a quick guide on how to work around the PostgreSQL bug that is affecting new TimeTrex installs here:
viewtopic.php?f=6&t=7837

Hello,
there is a new version of Postgres 11.4.1 and still I cannot install your timetrex.
I cannot downgrade according your howto because I have Ubunutu 16.04
So what is the workaround for me?

lumirl wrote: ↑Mon Aug 05, 2019 2:38 am Hello,
there is a new version of Postgres 11.4.1 and still I cannot install your timetrex.
I cannot downgrade according your howto because I have Ubunutu 16.04
So what is the workaround for me?

Unfortunately the PostgreSQL community has not yet released a new version that fixes the bug causing TimeTrex to fail during the install/upgrade yet, though its expected to be released soon.

If you are using the PGDB APT repository, you can download old versions of the PostgreSQL packages (ie: v11.3) from there and install them in a similar way as described in the FAQ.

This link may help to find the files you need to download: http://apt.postgresql.org/pub/repos/apt ... gresql-11/