Maintenance Jobs Last Ran: Never

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Locked
bad8174
Posts: 29
Joined: Tue Aug 28, 2007 2:03 pm

Maintenance Jobs Last Ran: Never

Post by bad8174 »

However, my job scheduler is running just fine with a result of 0x0. And my timetrex_cron_last_executed log file has the same completed time as my job scheduler. All of my paths look correct in the properties of the task scheduler.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

I wonder if the maintenance commands in your database are incorrect. Please follow this post: http://forums.timetrex.com/viewtopic.php?p=2125#2125

and paste the output of that SQL command here.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

Actually, this appears like it could be a bug in the installer.

Try upgrading to TimeTrex v2.1.0-rc3 (just released) and see if that fixes the issue. It may take 24-48hours before you notice any difference.
bad8174
Posts: 29
Joined: Tue Aug 28, 2007 2:03 pm

Post by bad8174 »

OK I upgraded successfully. How do I run those cmds from the SQL DB? Im really green on PostGreSQL. I installed right from the windows exec. So my path is as follows C:\program files\timetrex\PostgreSQL. Thanks Guys.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

C:\program files\timetrex\PostgreSQL\bin\psql -h localhost -U timetrex -p 5433 timetrex

Then it will ask you for a password, you need to get the database password from:

C:\program files\timetrex\timetrex\timetrex.ini.php

It should be a 8 or 9 character random password.

From there you can run the SQL command from the other post I directed you to.
Locked