TimeTrex Time and Attendance

Install a fresh new everything with latest versions
still get 1 hour off with my timezone but when change to GMT -2 (which is not my timezone) the time is correct.

any suggestions?

What I dont understand is why it happened suddenly.
It worked fine up until now.

thats weird
after running
set session time_zone="Etc/GMT+2";
select now();
I get 4 hours difference from the real time
when I set to GMT-2 i get the real time although its not my timezone
in any case
when clocking in/out i still get 1 our later

I have used gmt+2 gmt+4 gmt-2 gmt-10
none of them had any effect.
the version is 1.4.3
Would it help if I give a username?

I have downloaded the latest timezone tables
didnt help
It seems that when I change the time zone in a user prefs it does not change the clock time when i check in/out

The time displayed when running this command is incorrect
its 1 hour greater than real time.

I dont know what you mean by recognize daylight saving time.
I downloaded the latest timezone support as described in this post
http://forums.timetrex.com/viewtopic.php?t=40
It didnt do any change.
our timezone is GMT +2 which should be the same as Jerusalem.
any other suggestions?

All the users have the one hour gap problem.
All users use Asia/Jerusalem Time Zone.
Using MySql.

Time on machine running timetrex is correct but when punch in/out its one hour ahead.

Did that, gave me this output but still all engines are myISAM. Query OK, 0 rows affected (0.09 sec) Query OK, 0 rows affected (0.07 sec) Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 23 rows affected (0.09 sec) Query OK, 30 rows affected (0.09 sec) Query OK, 0 ...

I checked using the command you suggested
all the engine fields are myISAM.
I guess I should change that to innoDB.
How do I do that?

I was able to fix it by running REPAIR TABLE on punch , punch_control , user_date and users

Hi , Since today I'm getting this error when click on MyTimeSheet. Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1030: Got error 134 from storage engine] in EXECUTE(" select a.*, c.date_stamp as user_date_stamp from punch as a, punch_control as b, user_date as c...

yeah i know thanks.
I didnt mind posting it bcz there was nothing interesting there so no damage could be done, besides, i changed the password the day after.

It helped a lot!
thanks.

Hi, I have a weird problem with any report that is calculated according to pay period. When I choose to make a report for, let's say, 1.1.07-1.1.07 period, I get in the reports all the punched there were even before 1.1.07. Reports as of 1.2.07 seems to be fine. You can log on to castlelogic.no-ip.c...

OK it worked. Thanks! Something got really screwed though with the pay periods. when u make a report it calculated the time in correctly. for example if i make a report for january, in the otals i also see december. february looks ok though. I guess you can understand better if u login. http://castl...

I did exactly that
the email is correct
the app told me to wait for a mail but i didnt get any.

Darn!
I did not back it up.
I tried to use the forgot password but i didnt get any email.
any other way?
how exactly does it send the email? I dont remember configuring any smtp account.

Hi
After upgrading to version 1.4.3 from 1.3.1 according to the instructions on the readme file no one can login. they all get password error. including the admin.

I have access to the db using a sql enterprise manager look-a-like
Please help me as soon as possible!

thanks.

using mysql

Is there a way to calculate Average Working hours per day?

OK, you were right. It didn't load any php.ini file. It tried to took it from C:\windows. How do I change this path? I copied the php.ini file located in c:\Program Files\xampp\apache\bin\php.ini now, when running php cron.php I get this error: PHP Warning: PHP Startup: Unable to load dynamic librar...

I mentioned in my previuos post that there is no mention of php.ini in the output of php -i
I can paste the output here if u'd like.

Thanks.

Installed 1.4.0 beta2
when running cron.php getting this output
Jobs Executed: 0 of 8

is it supposed to be like that?