TimeTrex Time and Attendance

Hello! When updating mtsql database to postgres, I get an error: psql:timetrex_mysql.sql:45938: ERROR: duplicate key value violates unique constraint "punch_punch_control_status_id" DETAIL: Key (punch_control_id, status_id)=(16b7f494-c185-f362-80d3-000000015400, 20) already exists. what to...

I assume, that when calculating or establishing some old dates of database, Mariadb has a bug. You can make manually a sql query with dates with dates 1971 ... 1980, and some will be installed, some not. no_zero_in_dates parameter did not help. The solution was to set the server date to UTC, and the...

id not have time to edit. Probably the answer will be - my base is corrupted ...

Hi!
I overcame the error with the date. There is a new one when updating the database.
log in attachment.

thank. I'll try to figure it.

I use MariaDB 5.5.60 with default InnoDB engine.

OK. I restored the database from the dump and tried to upgrade. Same. What is not clear - I made a new empty database, launched the installer under 10.7.2 - everything worked fine. But the upgrade to 11.0.2 again failed! In the attachment 2 logs (1 - the base of the dump, 2 - empty). Thanks. PS. I d...

Hello!
I read viewtopic.php?f=6&t=7519 and make updates on this instruction.
Check on the necessary paths / requirements.
Go to upgrade databases...
Than I have error: Timetrex is unable to connect to its database...
Error log in attachments.
Thanks.

Good day. Now I have a mysql version of the database. I want to upgrade to version 11.0.2, then make postgres version of the database. Is it possible to upgrade from version 10.7.2 to version 11.0.2? The upgrade ends with an error (even clean mysql database, created in 10.7.2). Is it possible to con...