View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Planning view only with 'administrator' profile - Page 2 - ProjeQtOr
 

Planning view only with 'administrator' profile

More
27 Oct 2011 14:31 #7 by jul35
Hi,

First, as a new member, I want to congratulate you for Project'Or !

I've got the same problem as "fredparis", so if you've got an answer, I'm very interesting...

I use Project'Or V1.7.2.

Please Log in or Create an account to join the conversation.

More
29 Oct 2011 20:07 #8 by babynus
Hi,

Really, I cannot reproduce your issue.
I've tried several databases and all is ok for me : project leader can access to Gantt planning.

I also tried to reproduce your case :
- started from empty database
- connect with admin
- create 1 user : projectleader, profile Project Leader, also a resource called "Project Leader"
- updated data access so that projectleader can create project : defined right as creator+ to Project screen for profile Project Leader
- updated data access so that projectleader can create affectations to projects he is not affected to (to be able to self affect) : define right as manager+ to Affectation screen for profile Project Leader
- disconnect
- connect as projectleader
- create 8 projects Project1 to Project8
- affect Project Leader to the 8 projects
- disconnect and reconnect projectleader to retrieve correct acces rights to the new projects
- see gannt chant : 8 projects are displayed
- create 2 tickets (ticket1 and ticket2) and 3 milestones : milestone1 to milestone3 on project project1
- see gannt chant : 8 projects and 3 milestones are displayed

All is OK for me.
I uploaded some databases exports so that you can test :
- projectorria.toolware.fr/files/projectorria_v17.sql : some existing default data I use to generate manual screenshots
- projectorria.toolware.fr/files/projectorria_test.sql : result of upper tests
Maybe you can try and import it to test :
- use phpmyadmin
- create emty database
- import file into this new database
- change pamareters.php file to point out to this database

If you still reproduce the issue on your database, please profide as much data as possible :
- print screen for gantt view, affectations, users, activities
- maybe, if your database does not include confidential data, you can send an export of the databse
Send this to This email address is being protected from spambots. You need JavaScript enabled to view it.

Thanks.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
03 Nov 2011 13:28 #9 by jul35
Hi,

the problem seems to come from the sql request. Here is the log :

Erreur SQL : Champ 'PlanningElement.idProject' inconnu dans where clause<br/><br/>select planningelement.* from planningelement where planningelement.idle=0 and PlanningElement.idProject in (6, 7, 9, 10) and planningelement.idProject in (0, 2, 3, 4, 5, 6, 7, 9, 8, 10) order by planningelement.wbsSortable

The name of the table is "PlanningElement" instead of "planningelement".

The same request works on windows platform but not on linux platform cause the tables names are case sensitive on Linux and not on windows ( dev.mysql.com/doc/refman/5.0/en/identifi...ase-sensitivity.html )

Regards,
Jul

Please Log in or Create an account to join the conversation.

More
03 Nov 2011 15:17 #10 by babynus
Many thanks Jul for your accurate analysis.

Issue is now fixed an will soon be deployed.

For information, to fix it, just replace :
$queryWhere.=getAccesResctictionClause('Activity',$objectClass);
with
$queryWhere.=getAccesResctictionClause('Activity',$table);
in
/tool/jsonPlanning.php
/report/costPlan.php
/report/workPlan.php

Regards.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
03 Nov 2011 16:44 #11 by jul35
thanks for your quick answer ! Now, everything works...

Best regards

Please Log in or Create an account to join the conversation.

More
04 Nov 2011 17:21 - 05 Nov 2011 02:14 #12 by fredparis
Hi Babynus, hi Jul,

I have juste uploaded the 1.8.3 version on my laptop under WAMP with Win XP.

It works fine now :
- all profiles (admin, project leader, user) can see the Gantt planning.
- before, it was just allowed to admin profile.

I will test this new version on my web hosting space (under Linux), but I'm shure it is now fixed !
=> yes, it is ! (verified a few hours later, at home)

Thanks to Jul for his analysis.
Thanks to you, Babynus, for this new version.

Regards,

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.072 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.