Clock in/out

[justinm]

I keep getting the error:

Incorrect Input!

1. Pay Period is Currently Locked, or Date/Time is incorrect.

The time and date input is correct im assuming because its the default values that are added. Ive got a pay period created as well.

[mikeb]

I keep getting the error:

Incorrect Input!

1. Pay Period is Currently Locked, or Date/Time is incorrect.

The time and date input is correct im assuming because its the default values that are added. Ive got a pay period created as well.

Make sure your pay period is created and that the employee your punching in/out with is actually assigned to that pay period schedule.

[poopa]

I have the same problem
Incorrect Input!

Pay Period is Currently Locked, or Date/Time is incorrect.

I went to Administration->Payroll->Pay period schedule administration
created a new Period Schedule and assigned all users.
Didnt help.
I noticed then when I try to punch in I see that the Time edit box which is grayed out doesnt have the correct time. its 2 hours ahead of time. I did make sure that the time zone is set correctly to my user (GMT+2).

what exactly is Daily Start Time and Continuous Time ?
Is there like a manual?

[mikeb]

I have the same problem
Incorrect Input!

Pay Period is Currently Locked, or Date/Time is incorrect.

I went to Administration->Payroll->Pay period schedule administration
created a new Period Schedule and assigned all users.
Didnt help.
I noticed then when I try to punch in I see that the Time edit box which is grayed out doesnt have the correct time. its 2 hours ahead of time. I did make sure that the time zone is set correctly to my user (GMT+2).

what exactly is Daily Start Time and Continuous Time ?
Is there like a manual?

Did TimeTrex actually create pay periods after you created the schedule? (Click View beside the Pay Period Schedule you created). You need to make sure if you adding a punch on 01-Dec-06 that it falls within a pay period.

As far as the time is concerned, TimeTrex uses the system time with the timezone offset you selected. So if the time is off by 2 hours and your timezone is +2 hours, then I'm guessing your server time is in the proper timezone and MySQL may be incorrectly adding 2 hours to that. All timezone functions are handled by the database, so try selecting a different timezone, or selecting GMT and see if the time is still off.

Yes, we do have a manual, when you're logged into TimeTrex at the top of the page click Help -> Administrator Guide.

[poopa]

yes, it did create pay periods after i created the schedule.

1 test Monthly N/A 01/12/06 8:00 01/01/07 7:59 01/01/07 8:00
2 test Monthly N/A 01/01/07 8:00 01/02/07 7:59 01/02/07 8:00
3 test Monthly N/A 01/02/07 8:00 01/03/07 7:59 01/03/07 8:00
4 test Monthly N/A 01/03/07 8:00 01/04/07 8:59 01/04/07 9:59
5 test Monthly N/A 01/04/07 9:00 01/05/07 7:59 01/05/07 8:00
6 test Monthly N/A 01/05/07 8:00 01/06/07 7:59 01/06/07 8:00
7 test Monthly N/A 01/06/07 8:00 01/07/07 7:59 01/07/07 8:00
8 test Monthly N/A 01/07/07 8:00 01/08/07 7:59 01/08/07 8:00
9 test Monthly N/A 01/08/07 8:00 01/09/07 7:59 01/09/07 8:00
10 test Monthly N/A 01/09/07 8:00 01/10/07 7:59 01/10/07 8:00
11 test Monthly N/A 01/10/07 8:00 01/11/07 7:59 01/11/07 8:00
12 test Monthly N/A 01/11/07 8:00 01/12/07 7:59 01/12/07 8:00
13 test Monthly N/A 01/12/07 8:00 01/01/08 7:59 01/01/08 8:00
...
...
here how's it look like
http://docs.google.com/View?docid=d6wtmxg_5ddxjmq

btw i had to use these
http://dev.mysql.com/downloads/timezones.html
i dont know if it has anything to do with it.

i just noticed that the status id the scheduled task is 'could not start'
php-win.exe D:\Program Files\xampp\htdocs\timetrex\classes\modules\core\..\..\..\maint\cron.php
I tried to run it maually but but it didnt seem to do anything, just game me the promt again, no erros.

[mikeb]

yes, it did create pay periods after i created the schedule.

1 test Monthly N/A 01/12/06 8:00 01/01/07 7:59 01/01/07 8:00
2 test Monthly N/A 01/01/07 8:00 01/02/07 7:59 01/02/07 8:00
3 test Monthly N/A 01/02/07 8:00 01/03/07 7:59 01/03/07 8:00
4 test Monthly N/A 01/03/07 8:00 01/04/07 8:59 01/04/07 9:59
5 test Monthly N/A 01/04/07 9:00 01/05/07 7:59 01/05/07 8:00
6 test Monthly N/A 01/05/07 8:00 01/06/07 7:59 01/06/07 8:00
7 test Monthly N/A 01/06/07 8:00 01/07/07 7:59 01/07/07 8:00
8 test Monthly N/A 01/07/07 8:00 01/08/07 7:59 01/08/07 8:00
9 test Monthly N/A 01/08/07 8:00 01/09/07 7:59 01/09/07 8:00
10 test Monthly N/A 01/09/07 8:00 01/10/07 7:59 01/10/07 8:00
11 test Monthly N/A 01/10/07 8:00 01/11/07 7:59 01/11/07 8:00
12 test Monthly N/A 01/11/07 8:00 01/12/07 7:59 01/12/07 8:00
13 test Monthly N/A 01/12/07 8:00 01/01/08 7:59 01/01/08 8:00
...
...
here how's it look like
http://docs.google.com/View?docid=d6wtmxg_5ddxjmq

btw i had to use these
http://dev.mysql.com/downloads/timezones.html
i dont know if it has anything to do with it.

Try changing your date format in your preferences (My Account -> Preferences) to DD-MMM-YY ie: 01-Dec-06, then try it again. Its possible it might not be parsing your date correctly.

Also try going to TimeSheet -> MyTimeSheet and adding punches on that screen.

[poopa]

tried that didnt seem to help.
also tried punching using MY timesheet, same error.

i just noticed that the status id the scheduled task is 'could not start'
php-win.exe D:\Program Files\xampp\htdocs\timetrex\classes\modules\core\..\..\..\maint\cron.php
I tried to run it maually but but it didnt seem to do anything, just game me the promt again, no erros.

[mikeb]

tried that didnt seem to help.
also tried punching using MY timesheet, same error.

i just noticed that the status id the scheduled task is 'could not start'
php-win.exe D:\Program Files\xampp\htdocs\timetrex\classes\modules\core\..\..\..\maint\cron.php
I tried to run it maually but but it didnt seem to do anything, just game me the promt again, no erros.

The Cron has nothing to do with this issue. So we'll hold off on looking at that for now.

Enable debug mode as per http://forums.timetrex.com/viewtopic.php?t=89 and set it to verbosity = 10, then try again. It should display a bunch of debug text at the bottom of the punch window that will hopefully help.

There are really only two issues going on here:

1. TimeTrex can't find the proper payperiod to place the punch.
2. TimeTrex is parsing the date wrong causing it to not find the pay period.

Did you try adding the punch in November or October? When you're on the MyTimeSheet page as well, near the bottom right above the "Paid Time" table does it tell you what pay period you are currently in?

If you can post screenshots of this page and the debug text that may help. Or email support@timetrex.com the IP address and login/password for me to login and try it myself would be great too.

[poopa]

http://tzvika33.no-ip.com/timetrex/interface/Login.php
user : tzvika pass: 12345

I can set you up with a VNC account if ud like.

hmm, in Mt timesheet it says that Employee is not currently assigned to a pay period!
and also Verification
tzvika zitzman Not Verified

here are the logs:
Punch In / Out
Incorrect Input!

Pay Period is Currently Locked, or Date/Time is incorrect.
Employee: tzvika zitzman
Time: ie: 20:09
Date: ie: 25-Feb-01
Transfer:
Punch Type: Normal Lunch Break
In/Out: In Out
Note:





Debug Buffer
============================================================================
Memory Usage: N/A
----------------------------------------------------------------------------
DEBUG [135]: [Function](): URI: /timetrex/interface/punch/Punch.php
DEBUG [137]: [Function](): Production: 1
DEBUG [92]: DateTime::setTimeZone(): Setting TimeZone: PST8PDT
DEBUG [423]: Authentication::Check(): Session Name: SessionID
DEBUG [429]: Authentication::Check(): Session ID: e0c2adff73d9edb3ffa821724e3b8ee7
DEBUG [278]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:e0c2adff73d9edb3ffa821724e3b8ee7
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400
DEBUG [278]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:e0c2adff73d9edb3ffa821724e3b8ee7
DEBUG [62]: [Function](): User Authenticated: tzvika
DEBUG [1622]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [92]: DateTime::setTimeZone(): Setting TimeZone: Etc/GMT-12
DEBUG [108]: DateTime::setDateFormat(): Setting Default Date Format: d-M-y
DEBUG [122]: DateTime::setTimeFormat(): Setting Default Time Format: G:i
DEBUG [136]: DateTime::setTimeUnitFormat(): Setting Default Time Unit Format: 10
DEBUG [1622]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [954]: UserPreferenceFactory::isPreferencesComplete(): User Preferences IS Complete:
DEBUG [105]: [Function](): Station ID Cookie found! 5ac2ac4a971f972b73efdd624646c59b
DEBUG [64]: [Function](): Submit!
DEBUG [707]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0
DEBUG [125]: PunchControlFactory::findUserDate(): Pay Period Schedule Continuous Time: 32400
DEBUG [243]: PunchListFactory::getFirstPunchByUserIDAndEpoch(): bPay Period Schedule Continuous Time: 32400
DEBUG [156]: PunchControlFactory::findUserDate(): Skipping Find...
DEBUG [157]: PunchControlFactory::findUserDate(): Pay Period Schedule Record Count: 1
DEBUG [195]: UserDateFactory::findOrInsertUserDate(): Inserting new UserDate row.
DEBUG [233]: Validator::isDate(): Raw Date: 1165519836 Converted Value: 1165519836
DEBUG [93]: UserDateFactory::findPayPeriod(): Attempting to find Pay Period for Start Date: 1165519836
DEBUG [99]: UserDateFactory::findPayPeriod(): Date: 1165519836
DEBUG [104]: UserDateFactory::findPayPeriod(): Pay Period Id:
DEBUG [112]: UserDateFactory::findPayPeriod(): Attempt failed:
DEBUG [724]: Factory::isValid(): Calling Validate()
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
bool(false)


DEBUG [382]: Validator::Error(): Validation Error: Label: pay_period Msg: Pay Period Missing
DEBUG [361] Array: Validator::isValid(): Errors
array(1) {
["pay_period"]=>
array(1) {
[0]=>
string(18) "Pay Period Missing"
}
}


DEBUG [206]: UserDateFactory::findOrInsertUserDate(): INVALID user date row. Pay Period Lockd?
DEBUG [212]: UserDateFactory::findOrInsertUserDate(): Cant find or insert User Date ID. User ID: 1 Date: 1165519836
DEBUG [164]: PunchControlFactory::setUserDate(): User Date ID:
DEBUG [169]: PunchControlFactory::setUserDate(): No User Date ID found
DEBUG [724]: Factory::isValid(): Calling Validate()
DEBUG [813]: PunchControlFactory::Validate(): Validating...
DEBUG [814]: PunchControlFactory::Validate(): User Date Id:
DEBUG [382]: Validator::Error(): Validation Error: Label: pay_period Msg: Pay Period is Currently Locked, or Date/Time is incorrect
DEBUG [361] Array: Validator::isValid(): Errors
array(1) {
["pay_period"]=>
array(1) {
[0]=>
string(57) "Pay Period is Currently Locked, or Date/Time is incorrect"
}
}


DEBUG [712]: Factory::FailTransaction(): FailTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [277]: PunchListFactory::getPreviousPunchByUserIdAndEpoch(): User ID: 1 Epoch: 1165519839
DEBUG [293]: PunchListFactory::getPreviousPunchByUserIdAndEpoch(): aPay Period Schedule Continuous Time: 32400
DEBUG [298]: PunchListFactory::getPreviousPunchByUserIdAndEpoch(): bPay Period Schedule Continuous Time: 32400
DEBUG [306]: PunchListFactory::getPreviousPunchByUserIdAndEpoch(): Start Time: 07-Dec-06 10:30
DEBUG [335]: PunchListFactory::getPreviousPunchByUserIdAndEpoch(): Query: select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = ? AND a.time_stamp >= ? AND a.time_stamp <= ? AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
DEBUG [290]: [Function](): DID NOT Find Previous Punch within Continuous Time from now:
DEBUG [475]: StationFactory::checkAllowed(): User ID: 1
DEBUG [481]: StationFactory::checkAllowed(): Station ID: 5ac2ac4a971f972b73efdd624646c59b
DEBUG [486]: StationFactory::checkAllowed(): Checking Station ID: 1
DEBUG [372]: StationFactory::isAllowed(): User ID: 1
DEBUG [378]: StationFactory::isAllowed(): Station ID: 5ac2ac4a971f972b73efdd624646c59b
DEBUG [380]: StationFactory::isAllowed(): Status: 20
DEBUG [388]: StationFactory::isAllowed(): User ID in list!:
DEBUG [389]: StationFactory::isAllowed(): Current Station: ANY
DEBUG [425]: StationFactory::isAllowed(): Remote IP: 127.0.0.1 Behind Proxy IP:
DEBUG [444]: StationFactory::isAllowed(): Station IS allowed!
DEBUG [233]: Validator::isDate(): Raw Date: 1165519839 Converted Value: 1165519839
DEBUG [707]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [796]: Factory::Save(): Updating...
DEBUG [621]: Factory::getUpdateQuery(): Update
DEBUG [233]: Validator::isDate(): Raw Date: 1165519839 Converted Value: 1165519839
DEBUG [652]: Factory::getUpdateQuery(): Data changed, set updated date:
DEBUG [106]: Validator::isNumeric(): Value:1
DEBUG [94]: Validator::inArrayKey(): Key: 20
DEBUG [144]: Validator::isLength(): Value: station Length: 7 Min: 2 Max: 250
DEBUG [144]: Validator::isLength(): Value: Station Length: 7 Min: 2 Max: 2000
DEBUG [707]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 1 Trans Off: 2
DEBUG [753]: Factory::Save(): Calling preSave()
DEBUG [233]: Validator::isDate(): Raw Date: 1165519839 Converted Value: 1165519839
DEBUG [783]: Factory::Save(): Insert ID: 166
DEBUG [689]: Factory::getInsertQuery(): Insert
DEBUG [717]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 3
DEBUG [834]: Factory::Save(): Calling postSave()
DEBUG [77]: Factory::removeCache(): Attempting to remove cache: ANY
DEBUG [717]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 2
DEBUG [453]: StationFactory::isAllowed(): Updating last allowed time for station.
DEBUG [106]: Validator::isNumeric(): Value:1
DEBUG [94]: Validator::inArrayKey(): Key: 200
DEBUG [144]: Validator::isLength(): Value: station Length: 7 Min: 2 Max: 250
DEBUG [144]: Validator::isLength(): Value: Access from station Allowed Length: 27 Min: 2 Max: 2000
DEBUG [707]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [753]: Factory::Save(): Calling preSave()
DEBUG [233]: Validator::isDate(): Raw Date: 1165519839 Converted Value: 1165519839
DEBUG [783]: Factory::Save(): Insert ID: 167
DEBUG [689]: Factory::getInsertQuery(): Insert
DEBUG [717]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 2
DEBUG [489]: StationFactory::checkAllowed(): Station IS allowed! 5ac2ac4a971f972b73efdd624646c59b - ID: 1
DEBUG [361] Array: Validator::isValid(): Errors
array(1) {
["pay_period"]=>
array(1) {
[0]=>
string(57) "Pay Period is Currently Locked, or Date/Time is incorrect"
}
}


DEBUG [351]: Validator::isValid(): Num Errors: 1
DEBUG [351]: Validator::isValid(): Num Errors: 1
============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 34.1060 ms (7.65 %) Authentication::Check()
4 12.0821 ms (2.71 %) getEmptyRecordSet()
1 334.3592 ms (75.04 %) unprofiled

65.0249 ms (14.59 %) Missed
============================================================================
445.5721 ms (100.00 %) OVERALL TIME
============================================================================

Thanks !

[mikeb]

The reason was when you created the pay period schedule you set "Create Initial Pay Periods From" to a date in the future, so TimeTrex didn't really create any pay periods for you. The reason you saw pay periods when you clicked "View" beside the pay period schedule was because TimeTrex will actually show you what WOULD be created. The "Status" column is set to "N/A" in this case.

So what I did was create a new pay period schedule with the "Create Initial Pay Periods From" set to 01-Nov-06 so it would create at least one months worth of pay periods for you. This fixed that specific problem.

However now when you go to TimeSheet -> MyTimeSheet you get this error:

Fatal error: Only variables can be passed by reference in D:\Program Files\xampp\htdocs\timetrex\interface\timesheet\ViewUserTimeSheet.php on line 1199

This is very strange, what version of PHP are you running?

[poopa]

PHP 5.0.5 (cli) (built: Sep 22 2005 10:49:43)
opyright (c) 1997-2004 The PHP Group
end Engine v2.0.5, Copyright (c) 1998-2004 Zend Technologies with Zend Extension Manager v1.0.8, Copyright (c) 2003-2005, by Zend Technolgies with Zend Optimizer v2.5.10, Copyright (c) 1998-2005, by Zend Technologies

Feel free to do whatever you want on the application: add users, remove stuff, whatever.

[mikeb]

PHP 5.0.5 (cli) (built: Sep 22 2005 10:49:43)
opyright (c) 1997-2004 The PHP Group
end Engine v2.0.5, Copyright (c) 1998-2004 Zend Technologies with Zend Extension Manager v1.0.8, Copyright (c) 2003-2005, by Zend Technolgies with Zend Optimizer v2.5.10, Copyright (c) 1998-2005, by Zend Technologies

Feel free to do whatever you want on the application: add users, remove stuff, whatever.

"PHP 5.0.5 (cli)" CLI means Command Line Interface, are you sure that matches the version of PHP your IIS or Apache is running?

Something seems really strange, I'm unable to replicate that error on my end here so I'm almost thinking its a bug in PHP somewhere. Can you upgrade to PHP v5.1.6 by chance and try that?

[poopa]

Im new to all that Linux stuff. never worked with Apache, PHP or mySQL before.
To Install everything I used XAMPP.
The first time I tried everything I used XAMPP 1.5.5
* Apache 2.2.3
* MySQL 5.0.27
* PHP 5.2.0 & PHP 4.4.4
* phpMyAdmin 2.9.1.1
* FileZilla FTP Server 0.9.20
* OpenSSL 0.9.8d

I had a lot of difficulties with this so I d/l an older version of XAMPP 1.4.16.
to get the PHP version i went to the PHP folder at d:\program files\XAMPP\PHP and at the command prompt i typed php -v.
thats what I pasted at the previous post.
Is there a different way to know what PHP my apache uses?

I can try installing the PHP version u suggested, although Im not sure how to do it without XAMPP.
I'll give it a try. I hope I dont ruin everything.

Ill post again after I installed it.

[mikeb]

Im new to all that Linux stuff. never worked with Apache, PHP or mySQL before.
To Install everything I used XAMPP.
The first time I tried everything I used XAMPP 1.5.5
* Apache 2.2.3
* MySQL 5.0.27
* PHP 5.2.0 & PHP 4.4.4
* phpMyAdmin 2.9.1.1
* FileZilla FTP Server 0.9.20
* OpenSSL 0.9.8d

I had a lot of difficulties with this so I d/l an older version of XAMPP 1.4.16.
to get the PHP version i went to the PHP folder at d:\program files\XAMPP\PHP and at the command prompt i typed php -v.
thats what I pasted at the previous post.
Is there a different way to know what PHP my apache uses?

I can try installing the PHP version u suggested, although Im not sure how to do it without XAMPP.
I'll give it a try. I hope I dont ruin everything.

Ill post again after I installed it.

If you go to the TimeTrex installer and go to the Requirements page, near the bottom there is a link for Detailed PHP Information. That will tell you what version of PHP your Apache is running.

[poopa]

when trying to do so I get:
The installer has already been run, as a safety measure it has been disabled from running again. If you are absolutely sure you want to run it again, or upgrade your system, please go to your timetrex.ini.php file and set "installer_enabled" to "TRUE". The line should look like:

"installer_enabled = TRUE"

After this change has been made, you can click the "Start" button below to begin your installation. After the installation is complete, you will want to change "installer_enabled" to "FALSE".

Should I do that?

[poopa]

I d/l
php-5.1.6-Win32.zip
and copy its content into my existing php folder. (i made backup)
after that I tried to start my apache but got many dll errors which are related to the PHP.
so i restored to the previous state.

I can try d/l another version of XAMPP, one that might use this ver of PHP.

[poopa]

ok, i changed installer_enabled to true
PHP Version: OK (v5.0.5)
Database Engine: OK
PHP BCMATH Enabled: OK
PHP SOAP Enabled: OK
PEAR: OK
Writable TimeTrex Configuration File (timetrex.ini.php): OK
Writable Cache Directory: OK
Writable Storage Directory: OK
Writable Log Directory: OK
PHP Safe Mode Turned Off: OK
PHP Memory Limit: OK

Your TimeTrex configuration file (timetrex.ini.php) is located at:
D:\Program Files\xampp\htdocs\timetrex\includes\..\timetrex.ini.php

Your PHP configuration file (php.ini) is located at:
D:\Program Files\xampp\apache\bin\php.ini, the include path is: ".;D:\Program Files\xampp\php\pear\"

Detailed PHP Information

[poopa]

ok, I decided to uninstall everything and install XAMPP with PHP 5.1.6 and it worked.
the XAMPP version if anyone wants to know is xampplite-win32-1.5.4.zip

I guess there is a problem with 5.0.5 php

Thanks for all your help!

now, about the cron error ill star another thread so other users can see it easily.