There are a couple of common things that can go wrong with OpenFTS. Could you post the exact database error? You can find it in the error log. The location of the error log is specified in the aolserver configuration file. For OpenACS 4.6, the config file is probably
/usr/local/aolserver/openacs4.tcl
, with this line:
ns_param serverlog ${serverroot}/log/error.log
Once you've found the error log, search for some text from the tcl error and look near it for the full SQL error.
(Happily, with 4.6.2 and the new postgres driver the full database error message is right on the web page and you don't have to dig through the log.)