The Toolkit for Online Communities
18814 Community Members, 0 members online, 1875 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : Problem with intermedia migrating acs3 instance : One Message

Forum OpenACS Q&A: Response to Problem with intermedia migrating acs3 instance

Posted by Tilmann Singer on
The proc sws_user_proc_staging is meant to be owned by the ctxsys user, which it is when installing it normally because the installation script reconnects as ctxsys before creating it. The import seems to have recreated that procedure owned by your normal database user, instead of ctxsys. Try to drop the sws_user_proc_staging proc in the ctxsys scheme and manually run the block in doc/sql/site-wide-search.sql that is executed as ctxsys (line 958 to 974 on my copy).

This is just a guess though.