Search found 495 matches

by mikeb
Mon Oct 29, 2018 8:29 am
Forum: Help
Topic: API getting current logged in user data
Replies: 2
Views: 148

Re: API getting current logged in user data

Try this:

Code: Select all

postToURL( buildURL( 'APIAuthentication', 'getCurrentUser' ), NULL );
by mikeb
Mon Oct 29, 2018 8:16 am
Forum: Installation Help
Topic: upgarde from 10.7.2 to 11.0.2
Replies: 14
Views: 646

Re: upgarde from 10.7.2 to 11.0.2

Again your MySQL database isn't doing you any favors, so you will need to manually correct it. As always, when the upgrade fails with MySQL, you have to restore from most recent backup, make any corrections to the data, then attempt the upgrade again. To speed this process up, you will probably want...
by mikeb
Fri Oct 26, 2018 7:58 am
Forum: Installation Help
Topic: upgarde from 10.7.2 to 11.0.2
Replies: 14
Views: 646

Re: upgarde from 10.7.2 to 11.0.2

If you can provide more information as to what you did about the previous error, that would be helpful.
by mikeb
Wed Oct 24, 2018 7:53 am
Forum: Installation Help
Topic: upgarde from 10.7.2 to 11.0.2
Replies: 14
Views: 646

Re: upgarde from 10.7.2 to 11.0.2

The query that is failing is this: SET SQL_MODE='ALLOW_INVALID_DATES'; ALTER TABLE `recurring_schedule` CHANGE `start_time` `start_time` timestamp DEFAULT '1970-01-01 00:00:01', CHANGE `end_time` `end_time` timestamp DEFAULT '1970-01-01 00:00:01'; With the error being: mysqli error: [1067: Invalid d...
by mikeb
Tue Oct 23, 2018 4:24 pm
Forum: Help
Topic: Errorneous In Late Exception Notifications
Replies: 5
Views: 281

Re: Errorneous In Late Exception Notifications

Upon further investigation, it appears that you have intentionally modified your TimeTrex installation such that it is in violation of the license agreement. Therefore we will no longer be able to assist you while we forward the file to our legal department for further action.
by mikeb
Tue Oct 23, 2018 3:29 pm
Forum: Help
Topic: Errorneous In Late Exception Notifications
Replies: 5
Views: 281

Re: Errorneous In Late Exception Notifications

Can you please double click on the Oct 23rd 7:46AM punch, then send us a full uncropped screenshot of that screen, as well as a screenshot of the "Audit" tab.
by mikeb
Tue Oct 23, 2018 2:00 pm
Forum: Help
Topic: Errorneous In Late Exception Notifications
Replies: 5
Views: 281

Re: Errorneous In Late Exception Notifications

Could you please attach a copy of an exception email that the supervisor has received, as well as a full uncropped screenshot of the corresponding employees timesheet for the same day?
by mikeb
Tue Oct 23, 2018 1:58 pm
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

Could you attach your Apache error log and check the Windows Event Viewer for any other crash details please?
by mikeb
Tue Oct 23, 2018 10:56 am
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

What is the 1 quick popup that you see?
by mikeb
Tue Oct 23, 2018 8:55 am
Forum: Installation Help
Topic: upgarde from 10.7.2 to 11.0.2
Replies: 14
Views: 646

Re: upgarde from 10.7.2 to 11.0.2

It appears log1 is from upgrading the restored database, if thats the case, then your backup is corrupted, since there are already tables created in it that are from v11.0.2 of TimeTrex, so you would need to go to a earlier backup prior to any attempt of upgrading to v11.0.2. In log2, that appears t...
by mikeb
Tue Oct 23, 2018 8:40 am
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

The problem is definitely with PHP intermittently crashing on your system. Below is a link to an early copy of TimeTrex v11.3.0, which has newer versions of the stack components. Could you try upgrading to that and see if the issue is resolved? https://www.timetrex.com/direct_download/TimeTrex_Commu...
by mikeb
Mon Oct 22, 2018 8:07 am
Forum: Installation Help
Topic: upgarde from 10.7.2 to 11.0.2
Replies: 14
Views: 646

Re: upgarde from 10.7.2 to 11.0.2

It appears that there was a problem upgrading your MySQL database, therefore you will need to restore from your latest backup and attempt the upgrade again. Unfortunately due to a limitation with MySQL, if any errors occur during the database schema upgrade process you must restore from backup befor...
by mikeb
Mon Oct 22, 2018 8:04 am
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

I'm not seeing any errors in the TimeTrex log file, so my guess is Apache or PHP is crashing similar to those other forum posts I linked too. Please check your Windows event log for any crashes related to Apache or PHP and attach the details here. Additionally attach your Apache log file ( c:\timetr...
by mikeb
Fri Oct 19, 2018 4:52 pm
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

Can you attach a copy of the TimeTrex.log file here too please?

The following other forum posts also may be helpful:
viewtopic.php?f=1&t=7520&p=23177#p23177
viewtopic.php?f=2&t=7548&p=23346#p23346
by mikeb
Fri Oct 19, 2018 4:13 pm
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

You will need to enable the installer in the timetrex.ini.php file so you can continue on through all the steps.
by mikeb
Fri Oct 19, 2018 11:56 am
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

Okay, so no more errors when running MiscWeekly.php then by the looks of it? So I assume we are making some progress. Re-run the system requirements check, since there is an error on your screen saying that has failed, and attach any screenshots here if it continues to fail. Additionally, please ena...
by mikeb
Fri Oct 19, 2018 7:55 am
Forum: Installation Help
Topic: upgarde from 10.7.2 to 11.0.2
Replies: 14
Views: 646

Re: upgarde from 10.7.2 to 11.0.2

Yes, you can definitely upgrade from any version older than v11.0.2 to v11.0.2. Our FAQ explains the exact procedure:
viewtopic.php?f=6&t=7519

If you getting error messages, please copy and paste the full error message and any other relevant information here.
by mikeb
Fri Oct 19, 2018 7:46 am
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

It appears that the "report_schedule" table didn't get deleted from an earlier upgrade process, and its causing problems with other queries now, so that table just needs to be deleted. From the "psql.exe" console (you can find the password and such in the timetrex.ini.php file), just run: DROP TABLE...
by mikeb
Thu Oct 18, 2018 4:50 pm
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

Are you able to connect directly to the PostgreSQL database to run manual queries by chance?
by mikeb
Thu Oct 18, 2018 8:07 am
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

It seems like your database didn't get fully upgraded, can you please attach a full uncropped screenshot of the TimeTrex Help -> About screen?
by mikeb
Wed Oct 17, 2018 3:26 pm
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

Can you please attach a full uncropped screenshot showing the errors?
by mikeb
Wed Oct 17, 2018 11:13 am
Forum: Installation Help
Topic: Install setup URL
Replies: 41
Views: 2510

Re: Install setup URL

There is an icon in your Windows Start menu (under TimeTrex Community Edition) to run the installer.
by mikeb
Mon Sep 24, 2018 7:52 am
Forum: Help
Topic: Calculate selected overtime only
Replies: 1
Views: 185

Re: Calculate selected overtime only

You would need bank all overtime, then manually pay it out as required through an absence policy.

Alternatively you could upgrade to the Professional Edition of TimeTrex, which would have more flexibility around that, and allow you to more selectively pay overtime.
by mikeb
Mon Sep 17, 2018 1:33 pm
Forum: Help
Topic: Duplicate Employees
Replies: 3
Views: 175

Re: Duplicate Employees

If you enabled the "Employee -> Delete" permission, just logout of TimeTrex, then login again, and you should be able to delete employee records.
by mikeb
Fri Sep 14, 2018 8:29 am
Forum: Installation Help
Topic: Ubuntu Server 18.04.1 error after installing the ZIP Option
Replies: 24
Views: 1307

Re: Ubuntu Server 18.04.1 error after installing the ZIP Option

SSL is handled by your web server, which is completely separate from TimeTrex itself. There are many tutorials and HOWTOs available online that explain how to get SSL up and running with the Apache web server on Debian, I would recommend following one of those.