Forum OpenACS Q&A: Re: OpenFTS Request Error

Collapse
Posted by Jon Griffin on
Phillip,
Since you don't seem to believe you have a partial install, I will post my steps yet again.


drop table fts_unknown_lexem;
drop table txt;
drop table fts_conf;

select relname from pg_class where relname like 'index%';
 relname
-------------
index1
index10
index10_key
index11
index11_key
index12
index12_key
index13
index13_key
index2
index2_key
index3
index3_key
index4
index4_key
etc....

drop all of those index
You need to do this and then reinstall openfts-driver.