End of year and verification?

[zeuschaos]

I have been running Timetrex locally to use as a very basic contractor time sheet for over a year.
My time sheets are printed weekly. Today, without changing timetrex (or having other administrtators change it) when you go to print the time sheet, it prints this week and the next two weeks as well. These weeks are blank and have never been filled in. I also cannot click on the "verify" button in the corner.


I have no specific steps that I was doing, I just came in today (long weekend) and started updating my time. Some of the diagnostic steps I have done have been:

1: Updated my timetrex from the version from June of this year to the one published in december (2.2.17).
2: Restored my database from several different time frames, upgraded them, and examined this week. I see the same results, regardless of data entered into the week of 21 december 2008
3: deleted my timetrex database entirely and created a new database,added in some default configurations. (same results)


4. What version of PHP you are using.
5.2.6

5. What operating system you are running.
XP SP2

6. What web server you are using.
XAMP Apache 2.2.11


On the debug settings I see:
Debug Buffer
============================================================================
Memory Usage: 16792088
----------------------------------------------------------------------------
DEBUG [111]: TTDate::setTimeZone(): Setting TimeZone: US/Eastern
DEBUG [539]: Authentication::Check(): Session Name: SessionID
DEBUG [545]: Authentication::Check(): Session ID: f4196417a0ce64ef168bee972913f738
DEBUG [403]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:f4196417a0ce64ef168bee972913f738
DEBUG [82]: Authentication::getIdle(): Idle Seconds Allowed: 14400
DEBUG [403]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:f4196417a0ce64ef168bee972913f738
DEBUG [70]: [Function](): User Authenticated: craigw Created Date: 1230657322
DEBUG [1987]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [106]: TTDate::setTimeZone(): TimeZone already set to: US/Eastern
DEBUG [139]: TTDate::setDateFormat(): Setting Default Date Format: d-M-y
DEBUG [153]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A
DEBUG [167]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 10
DEBUG [108]: [Function](): Locale Cookie: en_US
DEBUG [291]: TTi18n::getLanguageFromLocale(): Locale: en_US
DEBUG [116]: [Function](): User Preference Language matches cookie!
DEBUG [322]: TTi18n::setLocale(): Generated/Passed In Locale:
DEBUG [256]: TTi18n::generateLocale(): Array of Locales to try in order: en_US,en
DEBUG [207]: TTi18n::tryLocale(): Found valid windows locale: English_United States.1252 Linux locale: en_US
DEBUG [215]: TTi18n::tryLocale(): Found valid locale: en_US
DEBUG [328]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 0 Current Locale:
DEBUG [331]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US
DEBUG [344]: TTi18n::setLocale(): Setting translator locale to: en_US
DEBUG [361]: TTi18n::setLocale(): Set Master Locale To: en_US
DEBUG [1987]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [1145]: UserPreferenceFactory::isPreferencesComplete(): User Preferences IS Complete:
DEBUG [142]: [Function](): Station ID Cookie found! 8fbaabfe46e9a219a16109a84acf6f86
DEBUG [248]: [Function](): UnRead Messages: 0
DEBUG [118]: [Function](): Found Default Filter!
DEBUG [356]: FastTree::getAllChildren(): Getting Root ID: 0
DEBUG [178]: [Function](): Viewing all users timesheet
DEBUG [380]: TTDate::parseDateTime(): String: 1230008400 Date Format: d-M-y
DEBUG [473]: TTDate::parseDateTime(): NO Custom Parse Format detected!
DEBUG [476]: TTDate::parseDateTime(): Parsing Date: 1230008400
DEBUG [149]: Validator::isLength(): Value: Default Length: 7 Min: 1 Max: 100
DEBUG [149]: Validator::isLength(): Value: /timetrex/interface/timesheet/ViewUserTimeSheet.php Length: 51 Min: 1 Max: 250
DEBUG [743]: Factory::isValid(): Calling Validate()
DEBUG [726]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0
DEBUG [772]: Factory::Save(): Calling preSave()
DEBUG [174]: UserGenericDataFactory::preSave(): Removing Default Flag From: 1
DEBUG [743]: Factory::isValid(): Calling Validate()
DEBUG [726]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [772]: Factory::Save(): Calling preSave()
DEBUG [743]: Factory::isValid(): Calling Validate()
DEBUG [815]: Factory::Save(): Updating...
DEBUG [640]: Factory::getUpdateQuery(): Update
DEBUG [358]: Validator::isDate(): Raw Date: 1230658297 Converted Value: 1230658297
DEBUG [671]: Factory::getUpdateQuery(): Data changed, set updated date:
DEBUG [736]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 2
DEBUG [743]: Factory::isValid(): Calling Validate()
DEBUG [815]: Factory::Save(): Updating...
DEBUG [640]: Factory::getUpdateQuery(): Update
DEBUG [358]: Validator::isDate(): Raw Date: 1230658297 Converted Value: 1230658297
DEBUG [671]: Factory::getUpdateQuery(): Data changed, set updated date:
DEBUG [736]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [295]: [Function](): Pay Period ID: 0
DEBUG [307]: [Function](): Action:
DEBUG [52]: BreadCrumb::setCrumb(): Dropping Bread Crumb: My Timesheet URL: /timetrex/interface/timesheet/ViewUserTimeSheet.php
DEBUG [425]: [Function](): Default Action:
DEBUG [1187]: TTDate::getBeginWeekEpoch(): Epoch: 23-Dec-08 12:00 AM Retval: 21-Dec-08 12:00 AM Start Day of Week: 0 Offset: 2
DEBUG [1187]: TTDate::getBeginWeekEpoch(): Epoch: 23-Dec-08 12:00 PM Retval: 21-Dec-08 12:00 AM Start Day of Week: 0 Offset: 2
DEBUG [430]: [Function](): Start Date: 21-Dec-08 12:00 AM End Date: 27-Dec-08 11:59 PM
DEBUG [1354]: TTDate::getCalendarArray(): Start Day Of Week: 0
DEBUG [1356]: TTDate::getCalendarArray(): Raw Start Date: 21-Dec-08 12:00 AM Raw End Date: 27-Dec-08 11:59 PM
DEBUG [1187]: TTDate::getBeginWeekEpoch(): Epoch: 21-Dec-08 12:00 AM Retval: 21-Dec-08 12:00 AM Start Day of Week: 0 Offset: 0
DEBUG [1187]: TTDate::getBeginWeekEpoch(): Epoch: 27-Dec-08 12:00 PM Retval: 21-Dec-08 12:00 AM Start Day of Week: 0 Offset: 6
DEBUG [1367]: TTDate::getCalendarArray(): Cal Start Date: 21-Dec-08 12:00 AM Cal End Date: 27-Dec-08 11:59 PM
DEBUG [625]: [Function](): No Punch Count: 4 Max: 14
DEBUG [625]: [Function](): No Punch Count: 4 Max: 14
DEBUG [625]: [Function](): No Punch Count: 4 Max: 14
DEBUG [625]: [Function](): No Punch Count: 4 Max: 14
DEBUG [625]: [Function](): No Punch Count: 11 Max: 14
DEBUG [625]: [Function](): No Punch Count: 18 Max: 14
DEBUG [629]: [Function](): Stopping Loop at: 5
DEBUG [639]: [Function](): Popping Off Last TWO Row: 5
DEBUG [39]: TimeSheetFormatArrayByDate(): Group Array While Loop:
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 0 Max No Punch Count: 7 Type ID: 100 ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 2 Max: 7
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 1 Max No Punch Count: 7 Type ID: 200 ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 6 Max: 7
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 2 Max No Punch Count: 7 Type ID: ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 7 Max: 7
DEBUG [83]: TimeSheetFormatArrayByDate(): Stopping Loop at: 2
DEBUG [874]: [Function](): Formatting Branch Array By Date:
DEBUG [39]: TimeSheetFormatArrayByDate(): Group Array While Loop:
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 0 Max No Punch Count: 7 Type ID: 3 ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 6 Max: 7
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 1 Max No Punch Count: 7 Type ID: ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 7 Max: 7
DEBUG [83]: TimeSheetFormatArrayByDate(): Stopping Loop at: 1
DEBUG [39]: TimeSheetFormatArrayByDate(): Group Array While Loop:
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 0 Max No Punch Count: 7 Type ID: 1 ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 6 Max: 7
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 1 Max No Punch Count: 7 Type ID: ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 7 Max: 7
DEBUG [83]: TimeSheetFormatArrayByDate(): Stopping Loop at: 1
DEBUG [1276]: UserDateTotalListFactory::getWorkedTimeSumByUserIDAndPayPeriodId(): Total: 28800
DEBUG [1282]: [Function](): Worked Total Time: 28800
DEBUG [1356]: UserDateTotalListFactory::getPaidAbsenceTimeSumByUserIDAndPayPeriodId(): Total:
DEBUG [1285]: [Function](): Paid Absence Total Time:
DEBUG [1438]: UserDateTotalListFactory::getDockAbsenceTimeSumByUserIDAndPayPeriodId(): Total:
DEBUG [1288]: [Function](): Dock Absence Total Time:
DEBUG [1297]: [Function](): Type ID: 20 OverTime Policy ID: 0 Total Time: 28800
DEBUG [1360]: [Function](): Pay Period Object NOT Found!
DEBUG [1365]: [Function](): Pay Period Schedule Found!
DEBUG [1521]: CompanyFactory::getLogoFileName(): Logo File Name: C:\xampp\htdocs\TimeTrex\classes\modules\core\..\..\..\\interface\images\timetrex_logo_wbg_small2.jpg


(I highlighted the pay period object not found, which may be the problem?)

I see no error file getting generated and the isn't helpful.

[zeuschaos]

(mysqlt): SET SESSION sql_mode='ansi' (mysqlt): SET TRANSACTION ISOLATION LEVEL READ COMMITTED (mysqlt): SET SESSION time_zone='US/Eastern' (mysqlt): select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = 'f4196417a0ce64ef168bee972913f738' AND ip_address = '127.0.0.1' AND updated_date >= 1230644108 (mysqlt): update authentication set updated_date = 1230658508 where session_id = 'f4196417a0ce64ef168bee972913f738' (mysqlt): select * from station where company_id = '1' AND station_id = '8fbaabfe46e9a219a16109a84acf6f86' AND deleted = 0 (mysqlt): select * from cron WHERE deleted = 0 ORDER BY last_run_date DESC LIMIT 1 (mysqlt): select d.severity_id as severity_id, count(*) as count from exception as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN exception_policy as d ON a.exception_policy_id = d.id LEFT JOIN pay_period as e ON b.pay_period_id = e.id where b.user_id = '1' AND a.type_id = 50 AND b.date_stamp < '2008-12-30' AND e.status_id = 10 AND NOT EXISTS ( select z.id from request as z where z.user_date_id = a.user_date_id AND z.status_id = 30 ) AND ( a.deleted = 0 AND b.deleted = 0 AND e.deleted=0) GROUP BY d.severity_id ORDER BY d.severity_id desc C:\xampp\htdocs\TimeTrex\log\cache\/ff/adodb_fffc22a72c35c8e5fb285eae961ef72c.cache reloaded, ttl=85220 [ select * from over_time_policy where id = -1 ]
(mysqlt): select a.*, ( (select count(*) from policy_group_over_time_policy as x, policy_group as w where x.policy_group_id = w.id AND x.over_time_policy_id = a.id and w.deleted = 0 )+ (select count(*) from schedule_policy as z where z.over_time_policy_id = a.id and z.deleted = 0) ) as assigned_policy_groups from over_time_policy as a where a.company_id = '1' AND a.deleted = 0 order by a.type_id asc,a.name asc C:\xampp\htdocs\TimeTrex\log\cache\/c2/adodb_c26f0004b4d74a9a1126c0f3e4e36dec.cache reloaded, ttl=85220 [ select * from premium_policy where id = -1 ]
(mysqlt): select a.*, (select count(*) from policy_group_premium_policy as z, policy_group as y where z.policy_group_id = y.id AND z.premium_policy_id = a.id AND y.deleted = 0 ) as assigned_policy_groups from premium_policy as a where a.company_id = '1' AND a.deleted = 0 order by a.type_id asc,a.name asc C:\xampp\htdocs\TimeTrex\log\cache\/07/adodb_07da2a118c1d8d1691581f55510b314b.cache reloaded, ttl=85220 [ select * from absence_policy where id = -1 ]
(mysqlt): select a.* from absence_policy as a where a.company_id = '1' AND a.deleted = 0 order by a.type_id asc,a.name asc C:\xampp\htdocs\TimeTrex\log\cache\/80/adodb_809bbeb2d4f3db67131aa47a7d8ad8fb.cache reloaded, ttl=85193 [ select * from pay_period where id = -1 ]
(mysqlt): select * from pay_period where company_id = '1' AND deleted=0 order by start_date desc C:\xampp\htdocs\TimeTrex\log\cache\/80/adodb_809bbeb2d4f3db67131aa47a7d8ad8fb.cache reloaded, ttl=85193 [ select * from pay_period where id = -1 ]
(mysqlt): select a.* from pay_period as a, pay_period_schedule as b where a.pay_period_schedule_id = b.id AND a.id in ( '70','69','68','67','66','65','64','63','62','61','60','59','58',
'57','56','55','54','53','52','51','50','49','48','47','46','45','44','43','42','41','40','39','38','37','36','35','34','33','32','31','30','29','28','27','26','25','24','23','22','21','20','19','18','17','16','15','14','13','12','11','10','9','8','7','6','5','4','3' ) AND a.deleted=0 AND b.deleted=0 order by start_date desc (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 (mysqlt): select * from pay_period_schedule where id = '2' AND deleted=0 C:\xampp\htdocs\TimeTrex\log\cache\/0e/adodb_0e9afd8cfc1db9db627f8c51a5b08c65.cache reloaded, ttl=85151 [ select * from users where id = -1 ]
(mysqlt): select a.* from users as a LEFT JOIN branch as b ON a.default_branch_id = b.id LEFT JOIN department as c ON a.default_department_id = c.id LEFT JOIN user_group as d ON a.group_id = d.id LEFT JOIN user_title as e ON a.title_id = e.id where a.company_id = '1' AND a.id in (1) AND a.deleted = 0 order by status_id asc,last_name asc,first_name asc,middle_name asc C:\xampp\htdocs\TimeTrex\log\cache\/5b/adodb_5b3d62b4a5b1a8504e2003111b84f891.cache reloaded, ttl=85244 [ select * from user_date_total where id = -1 ]
(mysqlt): select z.id, tmp.* from users as z LEFT JOIN ( select b.user_id, b.pay_period_id as pay_period_id, b.date_stamp as date_stamp, a.branch_id as branch_id, a.department_id as department_id, a.status_id as status_id, a.type_id as type_id, a.over_time_policy_id as over_time_policy_id, a.absence_policy_id as absence_policy_id, a.premium_policy_id as premium_policy_id, z.id as user_wage_id, z.effective_date as user_wage_effective_date, tmp2.min_punch_time_stamp as min_punch_time_stamp, tmp2.max_punch_time_stamp as max_punch_time_stamp, sum(total_Time) as total_time, sum(actual_total_Time) as actual_total_time from user_date_total as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN user_wage as z ON z.id = (select z.id from user_wage as z where z.user_id = b.user_id and z.effective_date <= b.date_stamp and z.deleted = 0 order by z.effective_date desc limit 1) LEFT JOIN ( select tmp3.id, min(tmp3.min_punch_time_stamp) as min_punch_time_stamp, max(tmp3.max_punch_time_stamp) as max_punch_time_stamp from ( select tmp2_a.id, CASE WHEN tmp2_c.status_id = 10 THEN min(tmp2_c.time_stamp) ELSE NULL END as min_punch_time_stamp, CASE WHEN tmp2_c.status_id = 20 THEN max(tmp2_c.time_stamp) ELSE NULL END as max_punch_time_stamp from user_date as tmp2_a LEFT JOIN punch_control as tmp2_b ON tmp2_a.id = tmp2_b.user_date_id LEFT JOIN punch as tmp2_c ON tmp2_b.id = tmp2_c.punch_control_id WHERE 1=1 AND tmp2_a.user_id in ('1') AND tmp2_a.pay_period_id in ('0') AND tmp2_c.time_stamp is not null AND ( tmp2_a.deleted = 0 AND tmp2_b.deleted = 0 AND tmp2_c.deleted = 0 ) group by tmp2_a.id, tmp2_c.status_id ) as tmp3 group by tmp3.id ) as tmp2 ON b.id = tmp2.id where 1=1 AND b.user_id in ('1') AND b.pay_period_id in ('0') AND a.status_id in (10,20,30) AND ( a.deleted = 0 AND b.deleted = 0 ) group by b.user_id, b.pay_period_id, a.branch_id, a.department_id, b.date_stamp, user_wage_id, user_wage_effective_date, a.status_id, a.type_id, a.over_time_policy_id, a.absence_policy_id, a.premium_policy_id, tmp2.min_punch_time_stamp, tmp2.max_punch_time_stamp ) as tmp ON z.id = tmp.user_id WHERE z.company_id = '1' AND z.id in ('1') AND z.deleted = 0 order by tmp.pay_period_id asc,z.last_name asc,tmp.date_stamp asc (mysqlt): select b.user_id as user_id, b.pay_period_id as pay_period_id, b.date_stamp as date_stamp, a.status_id as status_id, sum(total_time) as total_time from schedule as a, user_date as b, users as c where a.user_date_id = b.id AND b.user_id = c.id AND c.company_id = '1' AND b.user_id in ('1') AND b.pay_period_id in ('0') AND ( a.deleted = 0 AND b.deleted = 0 AND c.deleted = 0) GROUP BY b.user_id,b.pay_period_id,b.date_stamp,a.status_id C:\xampp\htdocs\TimeTrex\log\cache\/e5/adodb_e52a03a0fd4c6c188ca377794c9a31a6.cache reloaded, ttl=85397 [ select * from punch where id = -1 ]
(mysqlt): select a.id as punch_id, a.punch_control_id as punch_control_id, a.type_id as type_id, a.status_id as status_id, a.time_stamp as time_stamp, a.actual_time_stamp as actual_time_stamp, b.user_date_id as user_date_id, b.branch_id as branch_id, b.department_id as department_id, b.job_id as job_id, b.job_item_id as job_item_id, b.quantity as quantity_id, b.bad_quantity as bad_quantity_id, b.total_time as total_time, b.actual_total_time as actual_total_time, b.meal_policy_id as meal_policy_id, b.other_id1 as other_id1, b.other_id2 as other_id2, b.other_id3 as other_id3, b.other_id4 as other_id4, b.other_id5 as other_id5, b.note as note, c.user_id as user_id, c.date_stamp as date_stamp, c.pay_period_id as pay_period_id, e.type_id as station_type_id, e.station_id as station_station_id, e.source as station_source, e.description as station_description, z.id as user_wage_id, z.effective_date as user_wage_effective_date from punch as a LEFT JOIN punch_control as b ON a.punch_control_id = b.id LEFT JOIN user_date as c ON b.user_date_id = c.id LEFT JOIN users as d ON c.user_id = d.id LEFT JOIN station as e ON a.station_id = e.id LEFT JOIN user_wage as z ON z.id = (select z.id from user_wage as z where z.user_id = c.user_id and z.effective_date <= c.date_stamp and z.deleted = 0 order by z.effective_date desc limit 1) WHERE d.company_id = '1' AND d.id in (1) AND c.pay_period_id in ('0') AND (a.deleted = 0 AND b.deleted = 0 AND c.deleted = 0 AND d.deleted = 0) order by c.pay_period_id asc,c.user_id asc,a.time_stamp asc,a.punch_control_id asc,a.status_id asc C:\xampp\htdocs\TimeTrex\log\cache\/1d/adodb_1d4f0dc4643e63d9e075ed43fc102eaf.cache reloaded, ttl=85243 [ select * from user_title where id = -1 ]
(mysqlt): select * from user_title where company_id = '1' AND deleted = 0 order by name asc C:\xampp\htdocs\TimeTrex\log\cache\/e8/adodb_e87823365cf91e7abab08c3b051641b9.cache reloaded, ttl=85218 [ select * from branch where id = -1 ]
(mysqlt): select * from branch where company_id = '1' AND deleted = 0 order by status_id asc,name asc C:\xampp\htdocs\TimeTrex\log\cache\/00/adodb_002af0b0267dd7e7fa18315fc82e7ec0.cache reloaded, ttl=85218 [ select * from department where id = -1 ]
(mysqlt): select * from department where company_id = '1' AND deleted = 0 order by status_id asc,name asc (mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM user_group_tree a LEFT JOIN user_group_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = 0 GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id (mysqlt): SELECT object_id FROM user_group_tree WHERE tree_id = '1' AND parent_id = -1 LIMIT 1 (mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM user_group_tree a LEFT JOIN user_group_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = '0' GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id (mysqlt): SELECT a.object_id, a.parent_id, count(b.object_id) as level FROM user_group_tree a LEFT JOIN user_group_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND b.left_id > '0' AND b.right_id <= '1000' AND a.object_id != '0' GROUP BY a.object_id, a.parent_id, a.left_id ORDER BY a.left_id (mysqlt): select * from user_group where id = 1 (mysqlt): select a.* from pay_period_time_sheet_verify as a, users as b where a.user_id = b.id AND b.company_id = '1' AND a.pay_period_id in ('0') AND ( a.deleted = 0 AND b.deleted = 0 ) ERROR: Employee TimeSheet(s) not available!

[zeuschaos]

So when I try to generate the pdf to print I get the message in debug mode that it doesn't exist. It works in normal mode, it just gives me 3 weeks worth of data?

[zeuschaos]

Sorry about the formatting, I can't figure out how to post a file?

[shaunw]

When you are looking at todays date on the timesheet, at the bottom (just about the total hour tables) what does it say for the pay period dates?

It should look something like this:
Pay Period: 12/27/08 to 01/09/09

[zeuschaos]

it says Pay Period N/A.

[shaunw]

Okay, thats the issue then. You're pay periods aren't being created properly, so its causing all sorts of issues for you.

If you go to Admin -> Payroll -> Pay Period Schedules, then click "View" on the pay period schedule, can you copy and paste the table of pay periods here?

[zeuschaos]

1 Weekly Weekly N/A 11-Jan-09 12:00 AM 17-Jan-09 11:59 PM 17-Jan-09 11:59 PM
2 Weekly Weekly OPEN 04-Jan-09 12:00 AM 10-Jan-09 11:59 PM 10-Jan-09 11:59 PM [ View ] [ Edit ]
3 Weekly Weekly OPEN 28-Dec-08 12:00 AM 03-Jan-09 11:59 PM 03-Jan-09 11:59 PM [ View ] [ Edit ]
4 Weekly Weekly OPEN 21-Dec-08 12:00 AM 27-Dec-08 11:59 PM 27-Dec-08 11:59 PM [ View ] [ Edit ]
5 Weekly Weekly OPEN 14-Dec-08 12:00 AM 20-Dec-08 11:59 PM 20-Dec-08 11:59 PM [ View ] [ Edit ]
6 Weekly Weekly OPEN 07-Dec-08 12:00 AM 13-Dec-08 11:59 PM 13-Dec-08 11:59 PM [ View ] [ Edit ]
7 Weekly Weekly OPEN 30-Nov-08 12:00 AM 06-Dec-08 11:59 PM 06-Dec-08 11:59 PM [ View ] [ Edit ]
8 Weekly Weekly OPEN 23-Nov-08 12:00 AM 29-Nov-08 11:59 PM 29-Nov-08 11:59 PM [ View ] [ Edit ]
9 Weekly Weekly OPEN 16-Nov-08 12:00 AM 22-Nov-08 11:59 PM 22-Nov-08 11:59 PM [ View ] [ Edit ]
10 Weekly Weekly OPEN 09-Nov-08 12:00 AM 15-Nov-08 11:59 PM 15-Nov-08 11:59 PM [ View ] [ Edit ]
11 Weekly Weekly OPEN 02-Nov-08 1:00 AM 08-Nov-08 11:59 PM 08-Nov-08 11:59 PM [ View ] [ Edit ]
12 Weekly Weekly OPEN 26-Oct-08 12:00 AM 01-Nov-08 11:59 PM 01-Nov-08 11:59 PM [ View ] [ Edit ]
13 Weekly Weekly OPEN 19-Oct-08 12:00 AM 25-Oct-08 11:59 PM 25-Oct-08 11:59 PM [ View ] [ Edit ]
14 Weekly Weekly OPEN 12-Oct-08 12:00 AM 18-Oct-08 11:59 PM 18-Oct-08 11:59 PM [ View ] [ Edit ]
15 Weekly Weekly OPEN 05-Oct-08 12:00 AM 11-Oct-08 11:59 PM 11-Oct-08 11:59 PM [ View ] [ Edit ]
16 Weekly Weekly OPEN 28-Sep-08 12:00 AM 04-Oct-08 11:59 PM 04-Oct-08 11:59 PM [ View ] [ Edit ]
17 Weekly Weekly OPEN 21-Sep-08 12:00 AM 27-Sep-08 11:59 PM 27-Sep-08 11:59 PM [ View ] [ Edit ]
18 Weekly Weekly OPEN 14-Sep-08 12:00 AM 20-Sep-08 11:59 PM 20-Sep-08 11:59 PM [ View ] [ Edit ]
19 Weekly Weekly OPEN 07-Sep-08 12:00 AM 13-Sep-08 11:59 PM 13-Sep-08 11:59 PM [ View ] [ Edit ]
20 Weekly Weekly OPEN 31-Aug-08 12:00 AM 06-Sep-08 11:59 PM 06-Sep-08 11:59 PM [ View ] [ Edit ]
21 Weekly Weekly OPEN 24-Aug-08 12:00 AM 30-Aug-08 11:59 PM 30-Aug-08 11:59 PM [ View ] [ Edit ]
22 Weekly Weekly OPEN 17-Aug-08 12:00 AM 23-Aug-08 11:59 PM 23-Aug-08 11:59 PM [ View ] [ Edit ]
23 Weekly Weekly OPEN 10-Aug-08 12:00 AM 16-Aug-08 11:59 PM 16-Aug-08 11:59 PM [ View ] [ Edit ]
24 Weekly Weekly OPEN 03-Aug-08 12:00 AM 09-Aug-08 11:59 PM 09-Aug-08 11:59 PM [ View ] [ Edit ]
25 Weekly Weekly OPEN 27-Jul-08 12:00 AM 02-Aug-08 11:59 PM 02-Aug-08 11:59 PM [ View ] [ Edit ]

[zeuschaos]

The really strange thing is that today, it works fine. I can't really explain that, maybe there is some kind of overnight cleanup that happened?

[shaunw]

If you had an issue with maintenance jobs running, that could cause this issue. Pay periods are added when the maintenance jobs run, but they are added in advance to prevent this type of issue from happening.

Good to hear that the issue is fixed now though.