Forum OpenACS Q&A: Categorizing bboards

Collapse
1: Categorizing bboards
Posted by Brian Mueller on 04/21/00 04:05 PM
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
2: Response to Categorizing bboards (response to 1)
Posted by Don Baccus on 04/21/00 10:04 PM
Wow, you're right!  I just committed a fix to the CVS tree, update and  try again.

How's that for service?

Collapse
3: Response to Categorizing bboards (response to 1)
Posted by Brian Mueller on 04/22/00 03:56 AM
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
4: Response to Categorizing bboards (response to 1)
Posted by Nathan Reeves on 05/30/00 03:48 AM
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
5: Response to Categorizing bboards (response to 1)
Posted by Don Baccus on 05/30/00 03:13 PM
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.