Search found 238 matches

by wrc
Mon May 07, 2018 12:18 pm
Forum: Time Tracker
Topic: never Matching SQL in ttUser.class
Replies: 3
Views: 92

Re: never Matching SQL in ttUser.class

The second "or" part of the sql command will never match. Why? Because in the where clause is "u.id = 795" . Never ever would it be 31. It is an or , so not matching second part does not matter. The second part should match when you query for self ($user_id equals $this->id). For example, when edit...
by wrc
Tue Apr 17, 2018 11:14 pm
Forum: Time Tracker
Topic: DB error on upgrade
Replies: 10
Views: 316

Re: DB error on upgrade

Are you sure you use the latest version of Time Tracker? If so, which version exactly? As prior to 1.17.36.4048 there was a bug in dbinstall.php, which was basically causing an exit, because instead of echo there was a die in the code, which was addressed in 1.17.36.4048, but if you use a slightly p...
by wrc
Tue Apr 17, 2018 10:08 pm
Forum: Time Tracker
Topic: DB error on upgrade
Replies: 10
Views: 316

Re: DB error on upgrade

I see the steps to upgrade "database structure" on page 2 of the upgrade document. Could you clarify which upgrade document you are referring to? If your current version is 1.11.44.3634 - then in dbinstall.php, assuming you see it, you have to execute the 4 steps outlined in the red rectangle in th...
by wrc
Tue Apr 17, 2018 9:16 pm
Forum: Time Tracker
Topic: DB error on upgrade
Replies: 10
Views: 316

Re: DB error on upgrade

Do you see the Updates section below the error and DB Install step? If so, determine the version of the code that you have (in the footer of your old installation). Then execute all required steps in sequence from top to bottom. For example, suppose your existing version is 1.5.80. Then you need to ...
by wrc
Tue Apr 17, 2018 8:57 pm
Forum: Time Tracker
Topic: DB error on upgrade
Replies: 10
Views: 316

Re: DB error on upgrade

The code that fails at last step: $sql = "select param_value from tt_site_config where param_name = 'version_db'"; $res = $conn->query($sql); if (is_a($res, 'MDB2_Error')) { echo('<font color="red">Error: database schema version query failed. '.$res->getMessage().'</font><br>'); } else { $val = $res...
by wrc
Tue Apr 10, 2018 1:24 pm
Forum: Time Tracker
Topic: Enforce password length and complexity
Replies: 6
Views: 193

Re: Enforce password length and complexity

How about keeping things simple. Add ONE field to the Group settings called: "Password complexity". If the field is null, the policy is not enforced. If the field contains an EXAMPLE password, then the code will calculate all it needs from the example, specifically: - Minimum password length. - Mini...
by wrc
Thu Mar 29, 2018 5:03 pm
Forum: Time Tracker
Topic: Date is in future
Replies: 4
Views: 264

Re: Date is in future

The Group menu is in the latest code, where Profile is now split in 2 separate tabs - Profile for user and Group for group settings.
by wrc
Thu Mar 29, 2018 3:36 pm
Forum: Time Tracker
Topic: User roles and rights redesign
Replies: 50
Views: 2156

Re: User roles and rights redesign

I think that "view_all_reports" right is needed, too. It should allow users with a lower role to run reports for all users in group, including for users having higher roles.

Example: payroll operation. A person who is not a top manager processes reports for payroll for all people in group.
by wrc
Thu Mar 29, 2018 3:06 pm
Forum: Time Tracker
Topic: Date is in future
Replies: 4
Views: 264

Re: Date is in future

Future entries is now a group setting, not server-wide. See attachment. Scroll to the bottom to see it.
by wrc
Thu Mar 29, 2018 2:49 pm
Forum: Time Tracker
Topic: ldap authentication
Replies: 2
Views: 224

Re: ldap authentication

Users in Time Tracker have an ID, and also belong to a group. They are also assigned to some projects for time tracking, unless you are in time only tracking mode. They also have something called a role (user, supervisor, co-manager, manager, etc.) and other attributes. Everything user does in the s...
by wrc
Fri Mar 23, 2018 11:18 am
Forum: Time Tracker
Topic: Unable to delete a team
Replies: 4
Views: 225

Re: Unable to delete a team

Hi, I can't delete a team when using the admin acct. When I clicked the delete button the page goes error ' This page isn't working. 1xx.xxx.xxx.xx3 is currently unable to handle this request. HTTP ERROR 500 ' Then, if I refresh the page it goes back to the page where there is a delete button. I ho...
by wrc
Sat Mar 17, 2018 3:42 am
Forum: Time Tracker
Topic: Actual time of arrival and departure & the ip address
Replies: 11
Views: 464

Re: Actual time of arrival and departure & the ip address

1. I don't want to restrict access but to see from which ip the employee has connected. With the IP address I would like to check if an employee from his computer input the time of arrival and departure not only for him but and for other employees (it should not happen). 2. Any suggestion how to di...
by wrc
Fri Mar 16, 2018 2:32 pm
Forum: Time Tracker
Topic: User roles and rights redesign
Replies: 50
Views: 2156

Re: User roles and rights redesign

How about "set_rates" right for Manager (or Top Manager) only? As a way to edit rates by whoever has the "manage_users" right looks a bit weird.
by wrc
Wed Mar 14, 2018 3:59 pm
Forum: Time Tracker
Topic: User roles and rights redesign
Replies: 50
Views: 2156

Re: User roles and rights redesign

I suggest including "override_date_lock" to Supervisor role. This will allow them to override date locking (as configured by the Locking plugin) for themselves and lower roles.
by wrc
Wed Mar 14, 2018 2:06 pm
Forum: Time Tracker
Topic: I need cron runs every 5 mins
Replies: 5
Views: 274

Re: I need cron runs every 5 mins

Hi again, I use a pc with windows 8 and xampp. Why Windows? I suggest trying a better, more secure, and free OS, such as Ubuntu or something else Linux based with a nice desktop UI, simply because of ongoing evil we are getting from Redmond for a long time now. But if you insist on Windows, try to ...