Forum OpenACS Q&A: Categorizing bboards

Collapse
Posted by Brian Mueller on
I have a bboard topic that works unless I turn on "present as
categorized" in the administration page. The topic's user page is
then inaccessible; links to it return the error message below.

There is an "edit categories" link on the topic administration page
to /bboard/admin-edit-categories.tcl, this also returns a "select"
error.

-----

Database operation "select" failed
    while executing
"ns_db select $db $sql"
    invoked from within
"set selection [ns_db select $db $sql]..."
    invoked from within
"if { ![info exists category_centric_p] || $category_centric_p
== "f" } {
    # we're not only doing categories
    set selection [ns_db select $db $sq ..."
    (file "/home/acs/acspg/www/bboard/q-and-a.tcl" line 118)
    invoked from within
"source $script" ...

Collapse
Posted by Don Baccus on
Wow, you're right!  I just committed a fix to the CVS tree, update and  try again.

How's that for service?

Collapse
Posted by Brian Mueller on
Lightning. I wish I could have implemented this fix as fast as it was made. One thing: I still can't get to the bboard/admin-edit-categories.tcl page, even though I can now get to a bboard topic that uses categories. I tried this in a freshly created database with the same result.
Collapse
Posted by Nathan Reeves on
Found the same problem.  Ended up connecting to the DB backend and just inserting records into the bboard_q_and_a_categories manually.  It means that the records then appear in the drop down box when you post a new message.
Hope this helps.

Cheers

Collapse
Posted by Don Baccus on
The other way to add categories is to visit the bboard's admin page, select an existing (!) message, and recategorize it.  There's a "Define new category" choice there.

No, this isn't  how this SHOULD be done.  It has been this way since the beginning, though.  We'll see how the ACS 4.0 rewrite of bboard is, if they haven't addressed this and certain other issues we'll probably want to improve it on our own, providing an alternative, fixed version.