Search found 25 matches

by JeffersonKim
Tue Jan 24, 2017 3:21 pm
Forum: Help
Topic: restore_database.bat after system crash
Replies: 0
Views: 1263

restore_database.bat after system crash

I have the application directory backed every night. timetrex_database_<DATE>.sql timetrex.ini.php Both files are on the backup hard drive. System crashed. I'm trying to follow directions to migrate TimeTrex from one computer to the other: https://help.timetrex.com/wiki/index.php/Frequently_Asked_Qu...
by JeffersonKim
Tue Oct 28, 2014 11:53 am
Forum: Installation Help
Topic: 7.4.6 Windows Installer Not Loading
Replies: 1
Views: 2613

7.4.6 Windows Installer Not Loading

I'm running Microsoft Windows Server 2003 R2 and whenever I double click the installer, nothing seems to pop up.

I'm currently running 7.3.6.
by JeffersonKim
Mon Oct 14, 2013 2:35 pm
Forum: Installation Help
Topic: Problem Updating to Latest Version
Replies: 5
Views: 2618

Re: Problem Updating to Latest Version

My guess is you didn't follow the onscreen instructions once the executable installed finished, as that is only phase 1... Phase 2 is to run the TimeTrex installer through your web-browser to complete the upgrade process. There should be a "TimeTrex Installer" icon in your start menu (under the Tim...
by JeffersonKim
Wed Sep 25, 2013 12:21 pm
Forum: Installation Help
Topic: Problem Updating to Latest Version
Replies: 5
Views: 2618

Re: Problem Updating to Latest Version

My guess is you didn't follow the onscreen instructions once the executable installed finished, as that is only phase 1... Phase 2 is to run the TimeTrex installer through your web-browser to complete the upgrade process. There should be a "TimeTrex Installer" icon in your start menu (under the Tim...
by JeffersonKim
Wed Sep 25, 2013 11:34 am
Forum: Installation Help
Topic: Problem Updating to Latest Version
Replies: 5
Views: 2618

Re: Problem Updating to Latest Version

shaunw wrote:Can you please attach a screenshot of the Help -> About screen, please do not crop the screenshot.
See attached.
by JeffersonKim
Tue Sep 24, 2013 5:19 pm
Forum: Installation Help
Topic: Problem Updating to Latest Version
Replies: 5
Views: 2618

Problem Updating to Latest Version

We tried to install an upgrade patch to the latest version a couple weeks ago. It now functions fine, but we now get this message at the top: WARNING: TimeTrex application version does not match database version. Please re-run the TimeTrex installer to complete the upgrade process. We haven't tried ...
by JeffersonKim
Tue Aug 24, 2010 10:38 am
Forum: Help
Topic: Current Version of Timetrex?
Replies: 3
Views: 1005

Current Version of Timetrex?

Hello, I have version 3.1.2 I noticed on sourceforge that the version is now 3.2.1, but I didn't get the typical red flag under the help section which let me know that there was an update available. When I press the button for "About TimeTrex" that states "Check for Updates" I get no confirmation th...
by JeffersonKim
Tue Jan 19, 2010 2:22 pm
Forum: Help
Topic: Update Notifications Via Email?
Replies: 4
Views: 1559

Re: Update Notifications Via Email?

noamparn wrote:SourceForge has an RSS feed that will notify you when new files are added for download.
The URL for the TimeTrex feed is:
http://sourceforge.net/api/file/index/p ... 174864/rss

--Noam
This works great. Thanks!
by JeffersonKim
Mon Jan 18, 2010 11:48 am
Forum: Help
Topic: Update Notifications Via Email?
Replies: 4
Views: 1559

Update Notifications Via Email?

Is there anyway to get notifications of new updates via email?
by JeffersonKim
Mon Jan 18, 2010 11:08 am
Forum: Help
Topic: Upgrading from 2.22.21 to Most Recent
Replies: 7
Views: 1640

Re: Upgrading from 2.22.21 to Most Recent

Have you tried the restore without modifying the restore_database.bat at all? Does it still fail? Assuming you didn't get far enough into the installation process to have any tables created, if you remove the first 50 or so lines from your .SQL file, up to but not including this line: \connect time...
by JeffersonKim
Sat Jan 16, 2010 6:25 pm
Forum: Help
Topic: Upgrading from 2.22.21 to Most Recent
Replies: 7
Views: 1640

Re: Upgrading from 2.22.21 to Most Recent

Can you post the restore_database.bat file here and the first 50 lines of your .SQL file. restore_database.bat [I just uninstalled and reinstalled so I haven't changed "template1" to "timetrex"] @echo off SET PGPASSWORD=2de8176f7 SET PGDATABASE=timetrex IF "%1" == "" GOTO NOFILE echo. echo Attempti...
by JeffersonKim
Sat Jan 16, 2010 5:23 pm
Forum: Help
Topic: Upgrading from 2.22.21 to Most Recent
Replies: 7
Views: 1640

Re: Upgrading from 2.22.21 to Most Recent

JeffersonKim wrote:
shaunw wrote:Did you modify the new restore_database.bat file as described in the thread you linked to?
Yes.
For clarification, I only saw one instance of "template1" that I had to replace.

I think there's some sort of password incompatibility issue.
by JeffersonKim
Sat Jan 16, 2010 5:02 pm
Forum: Help
Topic: Upgrading from 2.22.21 to Most Recent
Replies: 7
Views: 1640

Re: Upgrading from 2.22.21 to Most Recent

shaunw wrote:Did you modify the new restore_database.bat file as described in the thread you linked to?
Yes.
by JeffersonKim
Sat Jan 16, 2010 3:35 pm
Forum: Help
Topic: Upgrading from 2.22.21 to Most Recent
Replies: 7
Views: 1640

Upgrading from 2.22.21 to Most Recent

Yes, I know I haven't upgraded for over two years. I tried following this post and am now installing a fresh install on a new machine: http://forums.timetrex.com/viewtopic.php?p=6573#p6573 So I did a fresh install on a new machine, and quit after seeing the terms and conditions. I tried running Rest...
by JeffersonKim
Thu Jan 22, 2009 10:21 am
Forum: Help
Topic: Scheduling an Automatic Backup
Replies: 3
Views: 1441

How would I find out what the latest TimeTrex version is out?

Is there a website?
by JeffersonKim
Thu Jan 22, 2009 10:07 am
Forum: Help
Topic: Scheduling an Automatic Backup
Replies: 3
Views: 1441

Scheduling an Automatic Backup

Does anyone know how to schedule an automatic backup of the database?

Also, I think I messed up by database_backup.bat or whatever it's called.

Could someone post the code?
by JeffersonKim
Tue Jan 06, 2009 11:54 am
Forum: General Discussion
Topic: hard to restore DB in windows xp with TT 2.2.16.105
Replies: 19
Views: 7989

Props to Mike Benoit on making it work from the paid tech support. It turns out I used an old version of backup_database.bat to make my SQL backup. So when I was trying to use the above listed restore_database.bat there was a database mismatch which caused my problems. Mike had to remote into my com...
by JeffersonKim
Mon Jan 05, 2009 4:54 pm
Forum: General Discussion
Topic: hard to restore DB in windows xp with TT 2.2.16.105
Replies: 19
Views: 7989

You could also check in the dump file for something along the lines of: CREATE LANGUAGE Then remove the entire line. Though this could cause other problems too, make sure you have a copy of the dump file before modifying it. Thanks. That seemed to had worked and concurs with what Mike from tech sup...
by JeffersonKim
Mon Jan 05, 2009 3:43 pm
Forum: General Discussion
Topic: hard to restore DB in windows xp with TT 2.2.16.105
Replies: 19
Views: 7989

I'm thinking from the error message that I need to somehow clear out language "plpgsql" but I'm not exactly sure how I would do that.
by JeffersonKim
Mon Jan 05, 2009 2:48 pm
Forum: General Discussion
Topic: hard to restore DB in windows xp with TT 2.2.16.105
Replies: 19
Views: 7989

Unfortunately none of those are actual errors, they are just stating that an error occurred earlier and the transaction was aborted. If you can copy and paste the first error that occurred it would help. Also make sure you are restoring to a completely clean/fresh database, otherwise errors will oc...
by JeffersonKim
Mon Jan 05, 2009 1:35 pm
Forum: General Discussion
Topic: hard to restore DB in windows xp with TT 2.2.16.105
Replies: 19
Views: 7989

I'm getting this error when utilizing the restore_database.bat It's a 11 MB sql dump. I tried doing a copy and paste of what was coming up as it scrolled through quickly and there's much more of these items in a similar pattern. Anyone know what these errors mean? d, commands ignored until end of tr...
by JeffersonKim
Wed Nov 19, 2008 10:06 am
Forum: Help
Topic: Missing Saturdays?
Replies: 2
Views: 1230

Yup. That fixed it!

Boo to DST for causing all programmers headaches!
by JeffersonKim
Tue Nov 18, 2008 5:41 pm
Forum: Help
Topic: Missing Saturdays?
Replies: 2
Views: 1230

Missing Saturdays?

Hello, Timesheet --> MyTimeSheet When I go there, some people have Saturday completely missing. More specifically, Sat, Nov 8, is completely missing! All the other days of the week show up fine and I haven't seen any other days mysteriously missing. Anyone have a similar problem or have a solution t...
by JeffersonKim
Wed Aug 20, 2008 12:49 pm
Forum: Feature Requests
Topic: Detailed Timesheets
Replies: 15
Views: 14957

There's an alternative to using Crystal Reports that's free :)

http://forums.timetrex.com/viewtopic.php?p=4112
by JeffersonKim
Wed Aug 20, 2008 12:47 pm
Forum: General Discussion
Topic: California Compliance Potential Solutions
Replies: 2
Views: 3920

California Compliance Potential Solutions

From reading http://forums.timetrex.com/viewtopic.php?t=564& there seems to be some common problems that are unique to Californian employers. For a FREE, and powerful time software though, I can't complain :) Here are some limitations and potential work arounds that I've been trying to figure out. I...