TimeTrex Time and Attendance

I am currently runing Timetrex on a 550 Mhz FreeBSD 6.2 box with 300 some-odd MB RAM, and a 1.5 MB DSL connection. Timetrex runs great, but page loads are pretty slow (10-15 seconds). How might I best go about improving this performance? Would I be best off upgrading the processor, RAM, or connectio...

Alright, I got the new timezone files in there, and the issue seems to be resolved. I was only hesistant to try it because the download page clearly states that FreeBSD users should use their own timezone files.

Thanks so much!

I've downloaded the timezone database files - do I just copy them into the /var/db/mysql directory and then restart the mysql server?

I don't know what kind of problems this might cause, but I resolved the error by opening the mysql timezone table, and changing the PST8PDT zone to PST. The error disappeared. now I'm taking a stab with the Cron jobs not run in 48 hours error. Making progress though. Thanks for the tips.

Thanks for your response. The output I get is: Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. I am noticing that the debug info says: DEBUG [92]: TTDate::setTimeZone(): Setting TimeZone: PST When I do a set session time_zone="PST"; I get: ERROR 1298 (HY00...

Here's the debug output for the first page after logging in. Debug Buffer ============================================================================ Memory Usage: 5910392 ---------------------------------------------------------------------------- DEBUG [153]: [Function](): URI: /interface/ DEBUG ...

Unfortunately, even after upgrading to mysql 5.0.27 I continue to receive the same error. Any suggestions would be greatly appreciated.

After I posted this I got to reading the requirements and realized that I was still using MySQL 4.1.23 when the req's call for 4.1.3+. I'm upgrading in hopes that this resolves the timezone issue. Will let you know.

Hi All, I have gotten Timetrex up and running and am very impressed with what it has to offer. Unfortunately, I am receiving the WARNING: Timetrex was unable to set your time zone error. I have tried the "mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -p mysql" fix, to no avail. I am usi...

Sorry for rehashing a months old post, but Threevolve, can you discuss what you did to fix it?