Trellis Learning Management System

Main | My View | View Issues | Change Log | Roadmap
  

Viewing Issue Simple Details [ Jump to Notes ] [ View Advanced ] [ Issue History ] [ Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000162 [Trellis] Administration/Reports minor always 2008-10-20 17:21 2009-11-19 15:26
Reporter henry View Status public  
Assigned To carlos
Priority normal Resolution open  
Status assigned   Product Version 0.5.2
Summary 0000162: filtering by uploader in course browser results in sql error
Description Attempting to filter courses by uploader in the course browser results in:

"Error 31024

SteamDB->select_field(SELECT COUNT(*) FROM ( courses c, courses_communities ccm) LEFT JOIN users u ON c.uploader_id = u.user_id WHERE c.course_id = ccm.course_id AND ccm.community_id = '1' AND ( uploader_name LIKE 'henry' AND c.course_status IN ('active', 'inactive', 'staging', 'expired')) LIMIT 1): the query could not be completed; Unknown column 'uploader_name' in 'where clause'
In ../core/global/classes/SteamDB_to_TrellisDB.php on line 443."
Additional Information
Tags No tags attached.
Error Code
URI
Attached Files ? file icon uploader_filter_patch.patch (4,032 bytes) 2008-12-15 10:34

- Relationships

-  Notes
User avatar (0000587)
henry (developer)
2008-10-20 17:23

 Note that 'uploader_name' is not an actual field name. It refers to the concatenation of users.first_name and users.last_name (separated by a space) that is selected as uploader_name in TrellisLMS->get_courses().
User avatar (0000596)
shaddy (reporter)
2008-10-22 22:57

 solution: remove that from the available fields on which to filter
User avatar (0000650)
carlos (developer)
2008-12-11 10:12
edited on: 2008-12-11 10:12

 I would like to know if this was ever removed and if the issue has already been fixed.
User avatar (0000655)
james (administrator)
2008-12-11 13:58

 if there is no notes here, then it has not been fixed.
User avatar (0000657)
carlos (developer)
2008-12-15 10:34

 I have tested a solution that seems to fix this problem. Here is the patch.
User avatar (0000856)
carlos (developer)
2009-05-29 13:16

 Reminder sent to: james

This one seems to be working fine. Ready to be reviewed.
User avatar (0000886)
carlos (developer)
2009-06-03 12:36

 issue#162 filtering by uploader has been added to course browser

Repository: /var/svn/trellis-dev, Revision: 8533, Committer: carlos
User avatar (0001051)
vcs (reporter)
2009-11-13 16:19

 issue#162 export field for uploader should show the name and not the id, also simplified the filter for uploader



Repository: /var/svn/trellis-dev, Revision: 8803, Committer: henry
User avatar (0001053)
henry (developer)
2009-11-13 16:26

 Was it definitively decided whether or not the uploader filter would be kept?
User avatar (0001054)
james (administrator)
2009-11-13 16:39

 let's leave it off for now.
User avatar (0001060)
vcs (reporter)
2009-11-19 15:26

 issue#162 removed uploader filter


Repository: /var/svn/trellis-dev, Revision: 8814, Committer: henry

- Issue History
Date Modified Username Field Change
2008-10-20 17:21 henry New Issue
2008-10-20 17:23 henry Note Added: 0000587
2008-10-22 22:57 shaddy Note Added: 0000596
2008-10-22 22:57 shaddy Status new => confirmed
2008-12-11 10:12 carlos Note Added: 0000650
2008-12-11 10:12 carlos Note Edited: 0000650
2008-12-11 13:58 james Note Added: 0000655
2008-12-11 13:58 james Assigned To => carlos
2008-12-11 13:58 james Status confirmed => assigned
2008-12-15 10:34 carlos Note Added: 0000657
2008-12-15 10:34 carlos File Added: uploader_filter_patch.patch
2009-05-29 13:16 carlos Issue Monitored: james
2009-05-29 13:16 carlos Note Added: 0000856
2009-06-03 12:36 carlos Note Added: 0000886
2009-11-13 16:19 vcs Checkin
2009-11-13 16:19 vcs Note Added: 0001051
2009-11-13 16:26 henry Note Added: 0001053
2009-11-13 16:39 james Note Added: 0001054
2009-11-19 15:26 vcs Checkin
2009-11-19 15:26 vcs Note Added: 0001060

Main | My View | View Issues | Change Log | Roadmap
  

Mantis 1.1.6[^]
Copyright © 2000 - 2008 Mantis Group
Powered by Mantis Bugtracker