Home
The Toolkit for Online Communities
17512 Community Members, 2 members online, 2320 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : How does the Chat package work? Mine gave an error.

Forum OpenACS Q&A: How does the Chat package work? Mine gave an error.

Icon of envelope Request notifications

So I created a subfolder under dotlrn called "chat" and added the application chat to it. However, when I went there, I got the following error. I don't know how Chat works....am I supposed to create a room first somehow?

There was a server error processing your request. We apologize.

Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:

Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR: relation "chat_rooms" does not exist

SQL:
select rm.room_id, rm.pretty_name, rm.description, rm.moderated_p, rm.active_p, rm.archive_p,
acs_permission.permission_p(room_id, '1359', 'chat_room_admin') as admin_p
from chat_rooms rm, acs_objects obj
where obj.context_id = '2135'
and rm.room_id = obj.object_id
order by rm.pretty_name

while executing
"ns_pg_bind select nsdb0 {
select rm.room_id, rm.pretty_name, rm.description, rm.moderated_p, rm.active_p, rm.archive_p,
acs_permission..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec select $db $full_statement_name $sql]
set local_counter 0

# Make sure 'n..."
(procedure "db_multirow" line 40)
invoked from within
"db_multirow rooms rooms_list {
select rm.room_id, rm.pretty_name, rm.description, rm.moderated_p, rm.active_p, rm.archive_p,
acs_permi..."
("uplevel" body line 26)
invoked from within
"uplevel {
#/chat/www/index.tcl
ad_page_contract {
Display a list of available chat rooms that the user has permission to edit.

@author..."
(procedure "code::tcl::/var/lib/aolserver/mathdev/packages/chat/www/inde..." line 2)
invoked from within
"code::tcl::$__adp_stub"
invoked from within
"if { [file exists $__adp_stub.tcl] } {

# ensure that data source preparation procedure exists and is up-to-date
adp_init tcl $__adp_stub
..."
("uplevel" body line 3)
invoked from within
"uplevel {

if { [file exists $__adp_stub.tcl] } {

# ensure that data source preparation procedure exists and is up-to-date
adp_init t..."
(procedure "adp_prepare" line 2)
invoked from within
"adp_prepare "
(procedure "template::adp_parse" line 30)
invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
(procedure "adp_parse_ad_conn_file" line 5)
invoked from within
"$handler"
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
$handler
} ad_script_abort val {
# do nothing
}"
invoked from within
"rp_serve_concrete_file [ad_conn file]"
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$path""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$path"
set tcl_url2file([ad_conn url]) [ad_conn file]
set tcl_url2path_info..."

Collapse
Posted by Caroline Meeks on
I think this is the old Jabber based Chat.

We (Solution Grove) are moving to using the XOWiki chat with our clients. I believe the dotLRN consortium also decided to use XOWiki Chat as thier standard.

There are quite a few posts about how to install XOWiki and XOtcl, once you've done that its very easy to get chat.

Collapse
Posted by Iuri Sampaio on
nice to read that??
I'd like to test it. is this package available at cvs already??
sorry...
nice to read that!!
I'd like to test it. is this package available at cvs already??
get the chat package. i have updated the following page
http://www.openacs.org/xowiki/pages/en/chat
to address the interelations of the chat plus xowiki chat.
Gustaf, I havent found the link to download the package. is it available on CVS? if so, where?

by the way,
i guess it takes me to another huge task. I need to install xowiki on my oacs box!! it's just amazing!

which package?

chat is packages/chat (oacs-5-2)
xowiki is packages/xowiki (in oacs head)