search

andrewblake1 / WorksManagement

Project/Works management system for Northpower's Westcoast Energy
0 stars 3 forks source link

Error in duty view only for read only user #495

Closed hawea closed 9 years ago

hawea commented 10 years ago

After giving the users DutyRead access or Duty access, they are getting a CDBException error appear. This does not happen for me when logged in as the system admin. Issue seems to be that t.action_id column has not been defined in the SQL query for these users.

To recreate bug, do the following:

  1. Log in as read only user. Username: 3276; Password: password
  2. Go to this URL: http://dev.melbourne.wcewm.co.nz/TaskToAction/admin?task_id=2989
  3. Next, click on the eye button to the left of one of the Actions i.e. Traffic management.
  4. The below CDb Exception error comes up. image
hawea commented 9 years ago

Fixed. Was an error in the stored procedure referring to the duty table instead of dutystep table.