Forum OpenACS Q&A: Outer Join in bboard moderation

Collapse
Posted by Rob Meyer on
As I was walking through the various pages, I came across one that
results in an error in the server log. Every time I tried to moderate
a bboard that my user was an admin on, the server would error out.
Upon investigation, it looks like there's an outer join
in /bboard/admin-q-and-a-fetch-msg.tcl (line 34). My SQL skills are
(to put it nicely 😊 ) weak, and I'm not familiar enough with the
data model to be able to do anything about it anyway yet. Should this
get logged as a bug?
Collapse
Posted by Rob Meyer on
After a (slightly) more in-depth look, it appears as if this is only an issue when file upload is enabled in the acs.ini file (a different query runs if it is). Perhaps this is a known issue somewhere that I just missed?
Collapse
Posted by Don Baccus on
I don't think it's a known issue, file uploading used to work.  The query might've changed considerably in 3.2 and probably got stuffed in with the outer join included.

This is a great opportunity for you to learn to use the software development manager's bug submission procedure!  Go to "Your Workspace" and follow the links.  You'll also find out if someone has already reported this problem if you check outstanding bug reports on the bboard module.