TimeTrex Time and Attendance

Okay, so the MySQL timezones are working at least. I would try upgrading to v1.6.4 and see if that fixes your issue, or at least allows you to change timezones.

Okay, check your PHP error log again, see if anything is showing up in there.

I'm not sure we're on the right path here, something is definitely strange as I have not seen this issue before. It almost seems like the installation has failed, which is causing all these other issues.

By default TimeTrex allows flexible shifts, in that employees have no restrictions when they can punch in/out.

Try these commands are your MySQL console: select now(); set session time_zone="Etc/GMT+2"; select now(); Does that return the expected time? This is what it looks like on our test server here: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2007-05-02 08:3...

Okay, can you try editing interface/index.php and comment out the block of code around line 47. It should look something like this after you add /* and */ around it. /* //Find last login name. $llf = new LogListFactory(); $log_obj = $llf->getLastEntryByUserIdAndActionAndTable( $current_user->getId()...

Just in case, I would try re-installing once more with a fresh database and see if the issue continues.

Does this topic help you at all?
http://forums.timetrex.com/viewtopic.ph ... ight=login

If not, enable debug verbosity 11, and try to login again. It should take you to a screen with just debug output, paste that output here.

Please follow this FAQ entry and provide more details.

http://forums.timetrex.com/viewtopic.php?t=89

Which other timezones have you tried? Have you tried using the Etc/GMT+2 timezone?

Are you getting any error messages appearing at the top of the pages in TimeTrex?

What version of TimeTrex are you running?

Okay, so either you have selected the incorrect time zone, or your timezone database in MySQL is incorrect. Have you downloaded the latest timezone tables described here: http://forums.timetrex.com/viewtopic.php?t=40 If that doesn't fix the issue, then I would suggest finding a different timezone th...

You will need to use a fixed amount.

If there are no hours in their TimeSheet they won't get any regular earnings, TimeTrex will just see the PS amendment for maternity leave and pay them that amount.

IIS ISAPI module is probably the best choice.

This feature will definitely be available much sooner then in a few years. We are planning to greatly improve the scheduling module within TimeTrex in the near future and shift swapping (among many other) is already on that list.

You could see it as early as the end of the summer.

Noted, we appreciate the show of support for individual features, it helps us gauge the demand better especially in cases where we may have mis estimated it.

If you change timezones, to GMT+0 for instance are the times correct if they happened in that timezone? Or are they off by an hour there too? When using MySQL timezone issues are almost certainly caused by MySQL itself, all TimeTrex does is pass the timezone on to MySQL so it can do the conversions....

The down for maintenance page shows up when a database error has occurred. So you will need to enable debugging in your timetrex.ini.php with verbosity 11 so you can see what SQL query is causing the failure.

You will want to check your logs as well.

I see hours based accruals are already on our TODO list, so they will be done at some point in the near future. In the mean time, it may be possible to mimic a similar behavior by using dollar based accruals. Thats how they do it in Canada, they basically take 4% of the employees gross wage and accr...

By remove, I hope you mean replaced with "su apache" or whatever other user your web server runs as.

This is required otherwise you will see all kinds of problems crop up. You need to make sure there are never any cache files owned by root in your TimeTrex cache directory.

If you are running Linux, please follow the Linux portion of this FAQ entry:

http://forums.timetrex.com/viewtopic.php?t=40

Okay, you will need to make sure in your Scheduled Tasks it is running that exact same command line that you said worked.

The scheduled tasks need to be running for about 24hrs before that message will go away.

Try running this, all as one command:

"C:\Program Files\xampp\php\php-win.exe" "C:\Program Files\xampp\htdocs\Time\maint\cron.php"

I think it could be because of the space in "Program Files" that is breaking things.

What happens when you run this command by itself?

C:\Program Files\xampp\php\php-win.exe C:\Program Files\xampp\htdocs\Time\maint\cron.php

When you installed TimeTrex, did you follow the instructions on this page?

/interface/install/MaintenanceJobs.php

Mike just informed me that another customer running Windows Server 2003 had this same issue, and it was fixed once they enabled modify permissions for the IIS user on the templates_c directory.

Full instructions here:

http://forums.timetrex.com/viewtopic.php?t=66

TimeTrex basically has 4 ways to differentiate employees: 1. Company .. 2. Branch .. 3. Department .. 4. Group Company is a hard category, by that I mean you can add an unlimited number of companies to TimeTrex, and employees in each company can not see each other. Even administrators in one company...