Forum OpenACS Q&A: Chat moderator error

Are you trying to access /chat/moderate.tcl when you see this?

At first glance, I don't see how this could ever have worked (I'm looking at the ACS 3.2.5 version.)  At the time chat_get_posts_to_moderate is called, the tcl page moderate.tcl already has a handle (presumably from main).  If so, then chat_get_posts_to_moderate should almost certainly fail as AOLserver doesn't let you allocate multiple handles from the same pool within a page unless you allocate them all in the same call.

If so, the fix would be to pass the db handle into the proc.

If a page allocates a db handle from pool n, it needs to pass that handle to any function that wants to use a handle from pool n, so all those functions that alloc their own handles from main appear to be wrong: they need to accept the handle as an input param.

from AOLserver's docs: http://www.aolserver.com/docs/deprecated/2.3.3/html/tapi-c31.htm

ns_db gethandle returns the specified number of handles from the specified pool. If poolname is not specified, the Defaultpool from the configuration file is used. If nhandles is not specified, 1 handle is returned. (Note that if you specify nhandles, you must also specify a poolname.) If not enough handles are available to fulfill the request, it waits until they are available. You must request all the handles you will need for a specific pool with one call to ns_db gethandle. You must release all your database handles explicitly (with ns_db releasehandle) before acquiring more. If you request multiple handles from the database, this function returns a Tcl list of database handles (space delimited). In this case, each handle must be released with a separate call to ns_db releasehandle.