TimeTrex Time and Attendance

I finally decided to scrap trying to install on CentOS 4.4 in favor of a "modern" distro (forgive me, but I think modern is the wrong term for the distro to be used with Timetrex). So, I installed Ubunti-6.06-server. After installing all the requisite pieces (php5, mysql5, etc.), I try to ...

I think I got relevant output from postgresql (I have very little experience w/ it). But, it's very long. Here's a snippet from the very end of the log: Jan 9 18:00:50 braintree postgres[4575]: [1-2] LOCATION: exec_simple_query, postgres.c:10 15 Jan 9 18:00:50 braintree postgres[4575]: [2-1] ERROR: ...

And now I'm back to the "Down for Maintenance" page. Ungh!

With last change to 1000A.sql, I got to page 4, but then got: Fatal error: Uncaught exception 'ADODB_Exception' with message 'postgres7 error: [-1: ERROR: relation "system_setting" does not exist] in EXECUTE(" select * from system_setting where name = ? ") ' in /var/www/html/time...

Fatal error: Uncaught exception 'ADODB_Exception' with message 'postgres7 error: [-1: ERROR: unrecognized configuration parameter "default_with_oids"] in adodb_throw( SET default_with_oids = false, ) ' in /var/www/html/timetrex/classes/adodb/adodb-exceptions.inc.php:78 Removed the default_...

There is a php.d directory with a pdo_pgsql.ini file in it, so I disabled that extension. Thanks for the tip. Debug verbosity is not set to 11. I have enabled display_errors in my php.ini file. I'm not sure what I did ('cause of hacked around so much), but I just got the following output while tryin...

Hmmm. Don't seem to find any reference to pdo_pgsql.so in php.ini. Regardless, this error has no affect on Timetrex anyway, correct?

Diggy

Thought I'd try rolling back to postgresql-7.4.13-2.RHEL4.1 and try again. Database connectivity works, but step 4 (database creation) once again produces a blank page. The database is created, but is not populated with any tables. From timetrex.log: ---------------[ Tue, 09 Jan 2007 06:26:12 -0800 ...

Hi, Mike. Thanks for the reply. I fully understand your wanting to use the functionality pf PHP 5. I guess part of my frustration lies with the fact that I had Timetrex working in CentOS 3.8, with php-5.0.4 and postgresql-8.1.4 previously. I reinstalled everything from the OS up (or, at least, thoug...

Please don't misunderstand me - I think Timtrex is a very good app. that can become great. I'm not trying to start a fw here, but it strikes me as odd that there is so much effort needed to get it running on as "mainstream" a distro as CentOS 4 or RHEL 4. The "modern" distros you...

Thanks. I've installed VMWare Server on one of my machines, so I can add on of those distros as a vm and give Timetrex another try. But, does this mean that Timetrex won't run on say, RHEL 4, without some serious, and time-consuming, changes (afaik, php 4 and postgresql 7 are the default installs in...

What linux distro do you recommend loading Timetrex on? I've had no success with CentOS 4.4/RHEL AS 4 without going through (and never emerging from) rpm dependency hell.

Diggy

Despite trying to get the latest version working, or at least getting meaningful debug info., I seem to have failed on both counts. So, for grins, I set up another box, this time using the xampp stack. This time, rather than get a "maintenance" page in step 4, I got a blank page - rrrrrrrr...

More info. - if I set debug verbosity to 11, I can't get beyond step 1 in the install process. I stay on the license page.

I can't add the php-pgsql module because of a major dependency issue (wants postgresql-libs-7.4.13-2, not the installed 8.1.4-1). Arrrgh!!!

Ok, let me add to the mystery. This could be my fault (although I'm not sure how I could have caused it) but, just for fun I thought I'd try using Timetrex with postgresql-8.1.4-1 (which I've used in the past) to see if I could sidestep the "Maintenance" issue. Timetrex.ini.php is configur...

Yes, true, I did have to update a couple of php modules, but only after emerging from deep within rpm dependency hell. Now, at least, no more php errors. But I still get the "Maintenance" error in step 4.

PHP error log output:

[29-Dec-2006 11:31:49] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/odbc.so' - /usr/lib/php/modules/odbc.so: undefined symbol: empty_string in Unknown on line 0

I had to reinstall Timetrex 1.4 again on a CentOS 4.4 box running MySQL-server-standard-5.0.27-0.rhel4, and various php-5.1.6. On installation, when I get to step 4, where the database is going to be created, I get: TimeTrex is currently undergoing maintenance. We're sorry for any inconvenience this...

That was the fix. Thanks Mike (and apologies for yesterday's online faux pas).

Diggy

Here's output from httpd's error_log:

[client 192.168.100.53] PHP Fatal error: Only variables can be passed by reference in /var/www/html/timetrex/interface/timesheet/ViewUserTimeSheet.php on line 1226, referer: http://192.168.100.7/timetrex/interface//index.php

Hello all. Having had to scrub a previous installation of timetrex-1.3.1, I installed the beta version on a new CentOS 4 box. Also installed are postgresql-8.1.4-1.centos.1 and php-5.0.4-4.centos4 (and php-pear-5.0.4, etc. - these are the same as in the previous 1.3.1 installation). The timetrex ins...

Sorry for the reply to my own post, but I did the following: - renamed timtrex directory to timetrexA - unzipped TimeTrex_Standard_Edition_v1.2.1-beta2.zip and renamed directory to timtrex - changed "installer_enabled =" to TRUE -ran installer again - logged into timetrex as me the employe...

Here's the snippet from the PunchControlFactory.classs.php file on my system: * $Revision: 114 $ * $Id: PunchControlFactory.class.php 114 2006-09-15 23:47:37Z ipso $ * $Date: 2006-09-15 16:47:37 -0700 (Fri, 15 Sep 2006) $ So, it appears that it's the wrong version. When I upgraded, I ran "unzip...

This is probably my bad, but I lifted the cron job command directly from one of the Timetrex install pages. It turns out that it pointed to the wrong location for cron.php. Now that it's corrected (on my system, /var/www/html/timetrex/maint/cron.php), the cron job appears to be running every minute,...