Index: openacs-4/packages/chat/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/index-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/chat/www/index-postgresql.xql 7 Jun 2007 09:14:25 -0000 1.3 +++ openacs-4/packages/chat/www/index-postgresql.xql 24 Jun 2007 15:21:19 -0000 1.4 @@ -44,7 +44,7 @@ from site_nodes where site_nodes.object_id = obj.context_id) as base_url from chat_rooms rm, - acs_objects obj,dotlrn_communities_all as dot + acs_objects obj where rm.room_id = obj.object_id order by rm.pretty_name