| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
|---|---|---|---|---|---|---|---|---|---|
| 0000586 | v2.2 Release (Closed) | [All Projects] General | public | 2010-09-29 05:28 | 2010-12-19 13:23 | ||||
| Reporter | sham | ||||||||
| Assigned To | caseydk | ||||||||
| Priority | normal | Severity | major | Reproducibility | have not tried | ||||
| Status | closed | Resolution | fixed | ||||||
| Product Version | |||||||||
| Target Version | Fixed in Version | 2.2 | |||||||
| Summary | 0000586: viewing of projects ( in user mode) ( dept not added | ||||||||
| Description | i have created user gave limited Permission. i have attached jpg image of ready reference. if i dont have department to user and try to access project we get error( in user mode) also no tasks are not displayed for the users. | ||||||||
| Tags | No tags attached. | ||||||||
| Attached Files |
| ||||||||
 Relationships |
|
 Relationships |
| Notes |
|
|
caseydk (administrator) 2010-09-29 05:38 |
Could you copy/paste the entire error message? Thanks. |
|
sham (reporter) 2010-09-29 21:14 |
ERROR: C:\wamp\www\web2project-2.1\classes\w2p\Database\Query.class.php(1116) : query failed(SELECT projects.project_id, project_name, project_parent FROM ((`projects` AS projects)) INNER JOIN `companies` AS companies ON projects.project_company = company_id WHERE project_original_parent = 5 AND project_active = 1 AND ((0=1) OR dept_id IS NULL) ORDER BY project_name) - error was: Unknown column 'dept_id' in 'where clause' Backtrace: 0 C:\wamp\www\web2project-2.1\classes\w2p\Database\Query.class.php:1116 dprint() 1 C:\wamp\www\web2project-2.1\classes\w2p\Database\Query.class.php:1153 exec() 2 C:\wamp\www\web2project-2.1\modules\projects\projects.class.php:1220 loadList() 3 C:\wamp\www\web2project-2.1\modules\projects\vw_idx_projects.php:158 getStructuredProjects() 4 C:\wamp\www\web2project-2.1\style\web2project\overrides.php:101 require() 5 C:\wamp\www\web2project-2.1\modules\projects\index.php:152 show() 6 C:\wamp\www\web2project-2.1\index.php:363 require() |
|
caseydk (administrator) 2010-09-30 10:58 |
I've explored this one and it's trivial to reproduce.. just deny access to a department and poof. I've been hacking at it and don't see a clean way to handle it.. |
|
caseydk (administrator) 2010-10-06 20:50 |
Resolved in r1469 |
|
caseydk (administrator) 2010-12-19 13:23 |
In v2.2 release. |
| Notes |
| Issue History |
|||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-09-29 05:28 | sham | New Issue | |
| 2010-09-29 05:28 | sham | File Added: 1.JPG | |
| 2010-09-29 05:38 | caseydk | Note Added: 0001296 | |
| 2010-09-29 21:14 | sham | Note Added: 0001297 | |
| 2010-09-30 10:58 | caseydk | Note Added: 0001298 | |
| 2010-10-06 20:49 | caseydk | Project | v2.1 Release (Closed) => v2.2 Release (Closed) |
| 2010-10-06 20:50 | caseydk | Note Added: 0001301 | |
| 2010-10-06 20:50 | caseydk | Status | new => resolved |
| 2010-10-06 20:50 | caseydk | Resolution | open => fixed |
| 2010-10-06 20:50 | caseydk | Assigned To | => caseydk |
| 2010-12-19 13:23 | caseydk | Note Added: 0001464 | |
| 2010-12-19 13:23 | caseydk | Status | resolved => closed |
| 2010-12-19 13:23 | caseydk | Fixed in Version | => 2.2 |
| Issue History |