TimeTrex Time and Attendance

You would need bank all overtime, then manually pay it out as required through an absence policy.

Alternatively you could upgrade to the Professional Edition of TimeTrex, which would have more flexibility around that, and allow you to more selectively pay overtime.

If you enabled the "Employee -> Delete" permission, just logout of TimeTrex, then login again, and you should be able to delete employee records.

SSL is handled by your web server, which is completely separate from TimeTrex itself. There are many tutorials and HOWTOs available online that explain how to get SSL up and running with the Apache web server on Debian, I would recommend following one of those.

When you go to http://<domain>/install/install.php it would tell you immediately if there was an error in the timetrex.ini.php file. Since you didn't see that my guess is you modified the .ini file after you already started the installer, which would make the error much more difficult to decipher.

There appears to be a syntax error in your timetrex.ini.php file on line 61, so TimeTrex can't finish the install process.

According to that your sources.list is still broken.

At this stage I may suggest that you consider purchasing a support package or using a Ubuntu forum for further help with getting the packages installed.

Okay, for whatever reason your sources aren't correct. The "universe" repository isn't enabled for all sources (mainly the security one), so when there is a security update it breaks your packages. The below should enable all repositories and fix your issue: deb http://us.archive.ubuntu.com/ubuntu/ ...

Definitely something wrong with your APT sources, can you please attach your /etc/apt/sources.list file here?

What is the output of the following command:

It would be super helpful if you would actually show us all the commands that you run and their output like I did.

Without that specific information its is extremely difficult to follow what you are doing or where the actual problem is.

If you use TimeTrex for payroll, you will need to run this query as well to fix the pay stub dates: WITH pp_tz AS ( SELECT pp.*, (extract(TIMEZONE FROM pp.start_date :: TIMESTAMP AT TIME ZONE pps.time_zone) :: TEXT || ' secs') :: INTERVAL AS utc_offset FROM pay_period AS pp LEFT JOIN pay_period_sche...

Below is the full output that I just performed from a stock Ubuntu 18.04 install: timetrex@ubuntu-18-04-stock:~$ cat /etc/lsb-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=18.04 DISTRIB_CODENAME=bionic DISTRIB_DESCRIPTION="Ubuntu 18.04.1 LTS" timetrex@ubuntu-18-04-stock:~$ wget https://www.timetrex.com/...

I think it may be related to the fact that MySQL doesn't actually have a concept of timestamps without timezones like PostgreSQL, so the two are getting confused. Make sure you have a backup of your PostgreSQL database and run the following queries on your PostgreSQL database to see if it fixes the ...

Okay, you will need to enable debugging in the timetrex.ini.php file as per the FAQ, then attach the TimeTrex log file here.

What happens when you click the "Test Connection" button?

If you are attempting to install any PHP packages manually (outside of APT), you are already on the wrong path and setting yourself up for failure.

I personally tested those instructions with a stock minimal Ubuntu 18.04 install, and it worked fine for me. If you could copy & paste the entire console output here showing the commands that you run and the exact output, that is always much more helpful than a summary of the error. Its strange that...

You shouldn't be receiving that "The following packages have unmet dependencies: php7.2-imap : depends: libc-client2007e but it is not uninstallable" error message on a stock Ubuntu 18.04 install, you likely have something wrong with your packages. Might want to try "sudo apt-get install -f" to see ...

Can you please post a screenshot of Payroll -> Pay Periods using the PostgreSQL database so we can see the specific times.

Please follow the instructions here:
https://www.timetrex.com/how-to-install ... ntu-debian

Changing the timezone won't change historical pay period times, it just changes future pay period times. If the problem occurred after the MySQL -> PostgreSQL conversion, its likely there was a problem during that step. Step #4 of our conversion FAQ https://forums.timetrex.com/viewtopic.php?f=6&t=75...

When you edit your pay period schedule, under the "Adcanced" tab, you can specify the timezone that is used for it there. Its completely separate from the "system_timezome" setting in the .ini file.

TimeTrex requires a minimum of 5% free space on the drive, by default most Linux systems reserve that amount for root and will start throwing "out of disk space" error messages to applications running as non-root. Not to mention if your drive is that full it results in severely compromised performan...

pribis wrote: ↑

Wed Aug 22, 2018 10:59 am

What? Wait...no....that log is from a fresh install of 11.0.2 of the postgres version of TT. It is brand new.

It definitely wasn't, it contained SQL schema files from newer versions of TimeTrex.

According to that log its trying to apply SQL schema changes from versions newer than v11.0.2, which of course are failing. That tells me that you have likely unzipped a version of TimeTrex newer than v11.0.2 over top of v11.0.2, then tried to downgrade, by unzipping a older version over top of the ...