Local Install - "Your instance has been upgraded to 7.4.1"

Ask your questions regarding TimeTrex installation here.
Post Reply
fullmoonguru
Posts: 106
Joined: Wed Jun 16, 2010 5:08 am

Local Install - "Your instance has been upgraded to 7.4.1"

Post by fullmoonguru »

I got this message and the page is not loading. It says network timeout.

How is it that my instance is being upgraded on my local server, and to 7.4.1, which I don't even see available for download?
fullmoonguru
Posts: 106
Joined: Wed Jun 16, 2010 5:08 am

Re: Local Install - "Your instance has been upgraded to 7.4.

Post by fullmoonguru »

Now I'm trying to install v4.0. In the installation screen it says version 7.4.1 is avaialble for download. But when I go there the local hosted version is the same 7.4.0 that I am trying to install.
fullmoonguru
Posts: 106
Joined: Wed Jun 16, 2010 5:08 am

Re: Local Install - "Your instance has been upgraded to 7.4.

Post by fullmoonguru »

OK, a little more info. I was running TT on a lamp server running Ubuntu Server 12.04 in Virtualbox.

The 7.4.1 notice came up when we logged in yesterday (Friday) morning. I had just run updates on the host machine, but had not touched the VB install,so I don't see how that could have affected it. While trying to diagnose the TT issue I realized that there were still updates to run on the host machine. So I did that, rebooted the VB and host, and TT worked fine, with 7.3.8 showing as the installed version again.

Checking it this morning, the 7.4.1 notice is back. After more checking I realize that all te pages seem to work OK accept for items under the attendance tab, which I get the network timeout error on. I tried loading 7.4.0 but got the same result.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Local Install - "Your instance has been upgraded to 7.4.

Post by shaunw »

Can you check your PHP/Apache error logs for any errors that may be occurring? If you don't see anything there, enabling logging in TimeTrex and checking its log would also be helpful, see instructions here: http://forums.timetrex.com/viewtopic.php?f=6&t=89
fullmoonguru
Posts: 106
Joined: Wed Jun 16, 2010 5:08 am

Re: Local Install - "Your instance has been upgraded to 7.4.

Post by fullmoonguru »

Apache 2 error log:

Code: Select all

[Mon Sep 01 19:05:08 2014] [notice] Apache/2.2.22 (Ubuntu) PHP/5.3.10-1ubuntu3.13 with Suhosin-Patch mod_perl/2.0.5 Perl/v5.14.2 configured -- resuming normal operations
[Mon Sep 01 19:48:25 2014] [error] [client 10.0.0.20] File does not exist: /var/www/favicon.ico
[Mon Sep 01 20:17:06 2014] [error] [client 10.0.0.20] PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 35 bytes) in /var/www/timetrex/classes/modules/core/Debug.class.php on line 171, referer: http://10.0.0.1/timetrex/interface/flex/ui.swf?v=7.4.1-1409381054
[Mon Sep 01 20:23:50 2014] [error] [client 10.0.0.20] PHP Warning:  Cannot modify header information - headers already sent by (output started at /var/www/timetrex/classes/modules/core/Exception.class.php:84) in /var/www/timetrex/classes/modules/core/Redirect.class.php on line 54, referer: http://10.0.0.1/timetrex/interface/flex/ui.swf?v=7.4.1-1409381054-54050e11e80ae
TT log:

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) ]---------------
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Local Install - "Your instance has been upgraded to 7.4.

Post by shaunw »

It would appear that you have several issues going on.
[Mon Sep 01 20:17:06 2014] [error] [client 10.0.0.20] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 35 bytes) in /var/www/timetrex/classes/modules/core/Debug.class.php on line 171, referer: http://10.0.0.1/timetrex/interface/flex ... 1409381054
Your PHP memory limit is set too low and PHP is exiting before TimeTrex is able to finish processing the request, so you should definitely increase your PHP memory limit, the higher the better usually, as setting it too low simply causes failures/timeouts.
DEBUG [L0069] [183ms]: <b>DBError::__construct()</b>: postgres7 error: [-1: ERROR: invalid page header in block 42 of relation base/16386/161155]
It would appear that your PostgreSQL database is also corrupt and is not able to read/write data properly. This is extremely rare with PostgreSQL, so I would highly recommend checking out your hardware as there may be a problem there.
fullmoonguru
Posts: 106
Joined: Wed Jun 16, 2010 5:08 am

Re: Local Install - "Your instance has been upgraded to 7.4.

Post by fullmoonguru »

Yeah something screwy happened on Friday. This is on a virtualbox so I restored a version I had from a month ago, restored the db from Thursday, and then installed 7.4.1 which is now available for the community edition. It appears to be working fine but I'll check teh memory for php.

Thx-
Post Reply