Code: Select all
--------[ 01-Sep-2014 20:23:50 -0400 (PID: 6524) ]---------------
DEBUG [L0459] [6ms]: <b>[Function]()</b>: URI: /timetrex/api/amf/api.php?SessionID=79d958f850823c6b01830080f95763bcfd36fc35 IP Address: 10.0.0.20<br>
DEBUG [L0462] [6ms]: <b>[Function]()</b>: Version: 7.4.1 Edition: 10 Production: 0 Database: Type: postgres8 Name: timetrex Config: /var/www/timetrex/includes/../timetrex.ini.php Demo Mode: 0<br>
DEBUG [L0167] [54ms]: <b>TTDate::setTimeZone()</b>: Setting TimeZone: America/New_York<br>
DEBUG [L0173] [58ms]: <b>[Function]()</b>: AMF Session ID: 79d958f850823c6b01830080f95763bcfd36fc35 Source IP: 10.0.0.20<br>
DEBUG [L0687] [58ms]: <b>Authentication::Check()</b>: Session ID: 79d958f850823c6b01830080f95763bcfd36fc35 IP Address: 10.0.0.20 URL: /timetrex/api/amf/api.php?SessionID=79d958f850823c6b01830080f95763bcfd36fc35 Touch Updated Date: 1<br>
DEBUG [L0167] [81ms]: <b>TTDate::setTimeZone()</b>: Setting TimeZone: EST5EDT<br>
DEBUG [L0208] [82ms]: <b>TTDate::setDateFormat()</b>: Setting Default Date Format: m/d/y<br>
DEBUG [L0222] [82ms]: <b>TTDate::setTimeFormat()</b>: Setting Default Time Format: g:i a<br>
DEBUG [L0236] [82ms]: <b>TTDate::setTimeUnitFormat()</b>: Setting Default Time Unit Format: 10<br>
DEBUG [L0184] [83ms]: <b>[Function]()</b>: Locale Cookie: en_US<br>
DEBUG [L0192] [84ms]: <b>[Function]()</b>: User Preference Language matches cookie!<br>
DEBUG [L0411] [86ms]: <b>TTi18n::setLocale()</b>: Set Master Locale To: en_US.UTF-8<br>
DEBUG [L0206] [94ms]: <b>[Function]()</b>: Handling AMF Call To API... UserName: skye<br>
DEBUG [L0154] [98ms]: <b>SabreAMF_CallbackServer::exec()</b>: Protocol: AMF3<br>
DEBUG [L0108] [98ms]: <b>ServiceMapper::invokeService()</b>: Service: core.APITimeSheet Method: getTimeSheetData Class: APITimeSheet<br>
DEBUG [L0116] [101ms] Array: <b>ServiceMapper::invokeService()</b>: Arguments:
<pre>array(3) {
[0]=>
string(1) "1"
[1]=>
string(8) "09/01/14"
[2]=>
array(1) {
["filter_data"]=>
array(0) {
}
}
}
</pre><br>
DEBUG [L1462] [126ms]: <b>TTDate::getEndWeekEpoch()</b>: Epoch: 09/01/14 12:00 am Retval: 09/04/14 11:59 pm Start Day of Week: 5<br>
DEBUG [L1561] [131ms]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [L0061] [183ms]: <b>DBError::__construct()</b>: Begin Exception...<br>
DEBUG [L0062] [183ms] Array: <b>DBError::__construct()</b>: BackTrace:
<pre>string(4415) "#0.Debug::backTrace()
#1.DBError->__construct(Object(ADODB_Exception))
#2.Factory->ExecuteSQL(
select
a.id as 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,
a.original_time_stamp as original_time_stamp,
a.longitude,
a.latitude,
a.transfer,
a.has_image,
a.created_by as created_by,
a.created_date as created_date,
a.updated_by as updated_by,
a.updated_date as updated_date,
b.user_date_id as user_date_id,
b.branch_id as branch_id,
j.name as branch,
b.department_id as department_id,
k.name as department,
b.job_id as job_id,
b.job_item_id as job_item_id,
b.quantity as quantity,
b.bad_quantity as bad_quantity,
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,
CASE WHEN c.user_id != a.created_by OR a.created_by != a.updated_by OR ( a.created_by is NULL AND a.updated_by is NOT NULL ) THEN 1 ELSE 0 END as tainted,
d.first_name as first_name,
d.last_name as last_name,
d.status_id as user_status_id,
d.group_id as group_id,
g.name as "group",
d.title_id as title_id,
h.name as title,
d.default_branch_id as default_branch_id,
e.name as default_branch,
d.default_department_id as default_department_id,
f.name as default_department,
d.created_by as user_created_by,
l.id as station_id,
l.type_id as station_type_id,
l.station_id as station_station_id,
l.source as station_source,
l.description as station_description,
w.id as user_wage_id,
w.effective_date as user_wage_effective_date,
y.first_name as created_by_first_name,
y.middle_name as created_by_middle_name,
y.last_name as created_by_last_name,
z.first_name as updated_by_first_name,
z.middle_name as updated_by_middle_name,
z.last_name as updated_by_last_name
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 branch as e ON ( d.default_branch_id = e.id AND e.deleted = 0)
LEFT JOIN department as f ON ( d.default_department_id = f.id AND f.deleted = 0)
LEFT JOIN user_group as g ON ( d.group_id = g.id AND g.deleted = 0 )
LEFT JOIN user_title as h ON ( d.title_id = h.id AND h.deleted = 0 )
LEFT JOIN branch as j ON ( b.branch_id = j.id AND j.deleted = 0)
LEFT JOIN department as k ON ( b.department_id = k.id AND k.deleted = 0)
LEFT JOIN station as l ON ( a.station_id = l.id AND l.deleted = 0 )
LEFT JOIN user_wage as w ON w.id = (select w.id
from user_wage as w
where w.user_id = c.user_id
and w.effective_date <= c.date_stamp
and w.deleted = 0
order by w.effective_date desc LiMiT 1)
LEFT JOIN users as y ON ( a.created_by = y.id AND y.deleted = 0 )
LEFT JOIN users as z ON ( a.updated_by = z.id AND z.deleted = 0 )
WHERE d.company_id = ? AND c.user_id IN (?) AND c.date_stamp >= ? AND c.date_stamp <= ? 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, Array(4), , )
#3.PunchListFactory->getAPISearchByCompanyIdAndArrayCriteria(1, Array(3), , , , )
#4.APITimeSheet->getTimeSheetData(1, 09/01/14, Array(1))
#5.call_user_func_array(Array(2), Array(3))
#6.ServiceMapper->invokeService(core.APITimeSheet, getTimeSheetData, Array(3), Array(1))
#7.call_user_func_array(Array(2), Array(4))
#8.SabreAMF_CallbackServer->invokeService(core.APITimeSheet, getTimeSheetData, Array(3), Array(1))
#9.SabreAMF_CallbackServer->exec()
#10.ServiceMapper->exec()
"
</pre><br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: postgres7 error: [-1: ERROR: invalid page header in block 42 of relation base/16386/161155] in adodb_throw(<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: select<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.id as id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.punch_control_id as punch_control_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.type_id as type_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.status_id as status_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.time_stamp as time_stamp,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.actual_time_stamp as actual_time_stamp,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.original_time_stamp as original_time_stamp,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.longitude,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.latitude,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.transfer,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.has_image,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.created_by as created_by,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.created_date as created_date,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.updated_by as updated_by,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: a.updated_date as updated_date,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.user_date_id as user_date_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.branch_id as branch_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: j.name as branch,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.department_id as department_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: k.name as department,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.job_id as job_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.job_item_id as job_item_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.quantity as quantity,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.bad_quantity as bad_quantity,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.total_time as total_time,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.actual_total_time as actual_total_time,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.meal_policy_id as meal_policy_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.other_id1 as other_id1,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.other_id2 as other_id2,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.other_id3 as other_id3,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.other_id4 as other_id4,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.other_id5 as other_id5,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: b.note as note,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: c.user_id as user_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: c.date_stamp as date_stamp,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: c.pay_period_id as pay_period_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: CASE WHEN c.user_id != a.created_by OR a.created_by != a.updated_by OR ( a.created_by is NULL AND a.updated_by is NOT NULL ) THEN 1 ELSE 0 END as tainted,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: d.first_name as first_name,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: d.last_name as last_name,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: d.status_id as user_status_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: d.group_id as group_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: g.name as "group",<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: d.title_id as title_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: h.name as title,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: d.default_branch_id as default_branch_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: e.name as default_branch,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: d.default_department_id as default_department_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: f.name as default_department,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: d.created_by as user_created_by,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: l.id as station_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: l.type_id as station_type_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: l.station_id as station_station_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: l.source as station_source,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: l.description as station_description,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: w.id as user_wage_id,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: w.effective_date as user_wage_effective_date,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: y.first_name as created_by_first_name,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: y.middle_name as created_by_middle_name,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: y.last_name as created_by_last_name,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: z.first_name as updated_by_first_name,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: z.middle_name as updated_by_middle_name,<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: z.last_name as updated_by_last_name<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: from punch as a<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN punch_control as b ON a.punch_control_id = b.id<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN user_date as c ON b.user_date_id = c.id<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN users as d ON c.user_id = d.id<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN branch as e ON ( d.default_branch_id = e.id AND e.deleted = 0)<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN department as f ON ( d.default_department_id = f.id AND f.deleted = 0)<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN user_group as g ON ( d.group_id = g.id AND g.deleted = 0 )<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN user_title as h ON ( d.title_id = h.id AND h.deleted = 0 )<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN branch as j ON ( b.branch_id = j.id AND j.deleted = 0)<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN department as k ON ( b.department_id = k.id AND k.deleted = 0)<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN station as l ON ( a.station_id = l.id AND l.deleted = 0 )<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN user_wage as w ON w.id = (select w.id<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: from user_wage as w<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: where w.user_id = c.user_id<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: and w.effective_date <= c.date_stamp<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: and w.deleted = 0<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: order by w.effective_date desc LiMiT 1)<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN users as y ON ( a.created_by = y.id AND y.deleted = 0 )<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: LEFT JOIN users as z ON ( a.updated_by = z.id AND z.deleted = 0 )<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: WHERE d.company_id = ? AND c.user_id IN (?) AND c.date_stamp >= ? AND c.date_stamp <= ? AND (a.deleted = 0 AND b.deleted = 0 AND c.deleted = 0 AND d.deleted = 0) order by c.pay_period_id asc,c<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: .user_id asc,a.time_stamp asc,a.punch_control_id asc,a.status_id asc, Array)<br>
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: <br>
DEBUG [L0077] [184ms]: <b>DBError::__construct()</b>: End Exception...<br>
DEBUG [L0054] [186ms]: <b>Debug::ErrorHandler()</b>: PHP ERROR - WARNING(2): Cannot modify header information - headers already sent by (output started at /var/www/timetrex/classes/modules/core/Exception.class.php:84) File: /var/www/timetrex/classes/mod<br>
DEBUG [L0054] [186ms]: <b>Debug::ErrorHandler()</b>: ules/core/Redirect.class.php Line: 54<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #0.Debug::backTrace()<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #1.Debug::ErrorHandler(2, Cannot modify header information - headers already sent by (output started at /var/www/timetrex/classes/modules/core/Exception.class.php:84), /var/www/timetrex/classes/module<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: s/core/Redirect.class.php, 54, Array(1))<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #2.header(Location: /timetrex/interface/DownForMaintenance.php?exception=DBError<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: )<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #3.Redirect::page(/timetrex/interface/DownForMaintenance.php?exception=DBError)<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #4.DBError->__construct(Object(ADODB_Exception))<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #5.Factory->ExecuteSQL(<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: select<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.id as id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.punch_control_id as punch_control_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.type_id as type_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.status_id as status_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.time_stamp as time_stamp,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.actual_time_stamp as actual_time_stamp,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.original_time_stamp as original_time_stamp,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.longitude,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.latitude,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.transfer,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.has_image,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.created_by as created_by,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.created_date as created_date,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.updated_by as updated_by,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: a.updated_date as updated_date,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.user_date_id as user_date_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.branch_id as branch_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: j.name as branch,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.department_id as department_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: k.name as department,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.job_id as job_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.job_item_id as job_item_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.quantity as quantity,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.bad_quantity as bad_quantity,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.total_time as total_time,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.actual_total_time as actual_total_time,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.meal_policy_id as meal_policy_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.other_id1 as other_id1,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.other_id2 as other_id2,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.other_id3 as other_id3,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.other_id4 as other_id4,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.other_id5 as other_id5,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: b.note as note,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: c.user_id as user_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: c.date_stamp as date_stamp,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: c.pay_period_id as pay_period_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: CASE WHEN c.user_id != a.created_by OR a.created_by != a.updated_by OR ( a.created_by is NULL AND a.updated_by is NOT NULL ) THEN 1 ELSE 0 END as tainted,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: d.first_name as first_name,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: d.last_name as last_name,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: d.status_id as user_status_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: d.group_id as group_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: g.name as "group",<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: d.title_id as title_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: h.name as title,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: d.default_branch_id as default_branch_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: e.name as default_branch,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: d.default_department_id as default_department_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: f.name as default_department,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: d.created_by as user_created_by,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: l.id as station_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: l.type_id as station_type_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: l.station_id as station_station_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: l.source as station_source,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: l.description as station_description,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: w.id as user_wage_id,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: w.effective_date as user_wage_effective_date,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: y.first_name as created_by_first_name,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: y.middle_name as created_by_middle_name,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: y.last_name as created_by_last_name,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: z.first_name as updated_by_first_name,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: z.middle_name as updated_by_middle_name,<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: z.last_name as updated_by_last_name<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: from punch as a<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN punch_control as b ON a.punch_control_id = b.id<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN user_date as c ON b.user_date_id = c.id<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN users as d ON c.user_id = d.id<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN branch as e ON ( d.default_branch_id = e.id AND e.deleted = 0)<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN department as f ON ( d.default_department_id = f.id AND f.deleted = 0)<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN user_group as g ON ( d.group_id = g.id AND g.deleted = 0 )<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN user_title as h ON ( d.title_id = h.id AND h.deleted = 0 )<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN branch as j ON ( b.branch_id = j.id AND j.deleted = 0)<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN department as k ON ( b.department_id = k.id AND k.deleted = 0)<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN station as l ON ( a.station_id = l.id AND l.deleted = 0 )<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN user_wage as w ON w.id = (select w.id<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: from user_wage as w<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: where w.user_id = c.user_id<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: and w.effective_date <= c.date_stamp<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: and w.deleted = 0<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: order by w.effective_date desc LiMiT 1)<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN users as y ON ( a.created_by = y.id AND y.deleted = 0 )<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: LEFT JOIN users as z ON ( a.updated_by = z.id AND z.deleted = 0 )<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: WHERE d.company_id = ? AND c.user_id IN (?) AND c.date_stamp >= ? AND c.date_stamp <= ? AND (a.deleted = 0 AND b.deleted = 0 AND c.deleted = 0 AND d.deleted = 0) order by c.pay_period_id asc,c<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: .user_id asc,a.time_stamp asc,a.punch_control_id asc,a.status_id asc, Array(4), , )<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #6.PunchListFactory->getAPISearchByCompanyIdAndArrayCriteria(1, Array(3), , , , )<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #7.APITimeSheet->getTimeSheetData(1, 09/01/14, Array(1))<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #8.call_user_func_array(Array(2), Array(3))<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #9.ServiceMapper->invokeService(core.APITimeSheet, getTimeSheetData, Array(3), Array(1))<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #10.call_user_func_array(Array(2), Array(4))<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #11.SabreAMF_CallbackServer->invokeService(core.APITimeSheet, getTimeSheetData, Array(3), Array(1))<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #12.SabreAMF_CallbackServer->exec()<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: #13.ServiceMapper->exec()<br>
DEBUG [L0054] [187ms]: <b>Debug::ErrorHandler()</b>: <br>
DEBUG [L0184] [188ms]: <b>Debug::Text()</b>: Detected PHP errors (1), emailing log...<br>
DEBUG [L0184] [188ms]: <b>Debug::Text()</b>: ---------------[ 01-Sep-2014 20:23:50 -0400 (PID: 6524) ]---------------<br>
---------------[ 01-Sep-2014 20:23:50 -0400 (PID: 6524) ]---------------
---------------[ 01-Sep-2014 20:23:52 -0400 (PID: 6524) ]---------------
DEBUG [L0459] [6ms]: <b>[Function]()</b>: URI: /timetrex/api/amf/api.php?SessionID=79d958f850823c6b01830080f95763bcfd36fc35 IP Address: 10.0.0.20<br>
DEBUG [L0462] [6ms]: <b>[Function]()</b>: Version: 7.4.1 Edition: 10 Production: 0 Database: Type: postgres8 Name: timetrex Config: /var/www/timetrex/includes/../timetrex.ini.php Demo Mode: 0<br>
DEBUG [L0167] [50ms]: <b>TTDate::setTimeZone()</b>: Setting TimeZone: America/New_York<br>
DEBUG [L0173] [54ms]: <b>[Function]()</b>: AMF Session ID: 79d958f850823c6b01830080f95763bcfd36fc35 Source IP: 10.0.0.20<br>
DEBUG [L0687] [54ms]: <b>Authentication::Check()</b>: Session ID: 79d958f850823c6b01830080f95763bcfd36fc35 IP Address: 10.0.0.20 URL: /timetrex/api/amf/api.php?SessionID=79d958f850823c6b01830080f95763bcfd36fc35 Touch Updated Date: 1<br>
DEBUG [L0167] [76ms]: <b>TTDate::setTimeZone()</b>: Setting TimeZone: EST5EDT<br>
DEBUG [L0208] [77ms]: <b>TTDate::setDateFormat()</b>: Setting Default Date Format: m/d/y<br>
DEBUG [L0222] [77ms]: <b>TTDate::setTimeFormat()</b>: Setting Default Time Format: g:i a<br>
DEBUG [L0236] [77ms]: <b>TTDate::setTimeUnitFormat()</b>: Setting Default Time Unit Format: 10<br>
DEBUG [L0184] [78ms]: <b>[Function]()</b>: Locale Cookie: en_US<br>
DEBUG [L0192] [79ms]: <b>[Function]()</b>: User Preference Language matches cookie!<br>
DEBUG [L0411] [80ms]: <b>TTi18n::setLocale()</b>: Set Master Locale To: en_US.UTF-8<br>
DEBUG [L0206] [88ms]: <b>[Function]()</b>: Handling AMF Call To API... UserName: skye<br>
DEBUG [L0174] [92ms]: <b>SabreAMF_CallbackServer::exec()</b>: Protocol: AMF0<br>
DEBUG [L0108] [92ms]: <b>ServiceMapper::invokeService()</b>: Service: core.APIProgressBar Method: get Class: APIProgressBar<br>
DEBUG [L0116] [92ms] Array: <b>ServiceMapper::invokeService()</b>: Arguments:
<pre>array(1) {
[0]=>
string(36) "26B401A5-819A-9326-8237-33BF07727713"
}
</pre><br>
DEBUG [L0155] [93ms]: <b>ServiceMapper::invokeService()</b>: Returning 6 bytes of data... Response Time: 0.00084996223449707<br>
DEBUG [L0241] [93ms]: <b>[Function]()</b>: Server Response Time: 0.092095851898193<br>
---------------[ 01-Sep-2014 20:23:52 -0400 (PID: 6524) ]---------------