In 3.2, I get a permissions error on displaying files connected to a project. I think the join is wrong.\npr.project_id is referenced, but pr is not defined in sql. new sql: SELECT * FROM ((`files` AS files)) LEFT JOIN `project_departments` AS project_departments ON pr.project_id = project_departments.project_id LEFT JOIN `departments` AS dep ON dep.dept_id=project_departments.department_id WHERE file_id = 53 OLD sql in 3.0 SELECT * FROM ((`files` AS files)) LEFT JOIN `projects` AS pr ON pr.project_id = file_project LEFT JOIN `companies` AS co ON co.company_id = pr.project_company LEFT JOIN `project_departments` AS project_departments ON pr.project_id = project_departments.project_id LEFT JOIN `departments` AS dep ON dep.dept_id=project_departments.department_id WHERE file_id = 53 As a result, I am redirected with no permissons to view file in 3.2 Keith, here I need your help, no idea what to do about this. Klaus

asked 04 Mar '14, 09:56

opto's gravatar image

opto ♦
83346110132
accept rate: 10%

asked 04 Mar '14, 09:56


Resolved on master:\nhttps://github.com/web2project/web2project/commit/7cb77def314060e292d195f0fc3ef2889f6ca2c3
permanent link

answered 04 Mar '14, 18:50

caseydk's gravatar image

caseydk ♦♦
742314248
accept rate: 32%

answered 04 Mar '14, 18:50

thanks, that did it.

(04 Mar '14, 22:42) opto ♦ opto's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×12
×11
×8

question asked: 04 Mar '14, 09:56

question was seen: 629 times

last updated: 04 Mar '14, 22:42

powered by Bitnami OSQA