Forum OpenACS Development: Re: OpenFTS: Enable Search for package
great idea on creating an admin page for that issue.
Is that really hard to implemented?
I ran the sql script
$psql -f search-sc-create.sql
and i got error of duplicated id:
*************************8
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:8: NOTICE: adding missing FROM-clause entry for table "acs_object_id_seq"
CONTEXT: PL/pgSQL function "acs_object__new" line 17 at select into variables
PL/pgSQL function "acs_sc_contract__new" line 7 at assignment
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:8: ERROR: duplicate key violates unique constraint "acs_sc_contracts_name_un"
CONTEXT: PL/pgSQL function "acs_sc_contract__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:14: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:18: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
acs_sc_operation__new
-----------------------
1019
(1 row)
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:34: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:38: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
acs_sc_operation__new
-----------------------
1022
(1 row)
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:54: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:58: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
acs_sc_operation__new
-----------------------
1025
(1 row)
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:74: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:78: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
acs_sc_operation__new
-----------------------
1028
(1 row)
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:94: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:98: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
acs_sc_operation__new
-----------------------
1031
(1 row)
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:113: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:117: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
acs_sc_operation__new
-----------------------
1034
(1 row)
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:136: ERROR: duplicate key violates unique constraint "acs_sc_contracts_name_un"
CONTEXT: PL/pgSQL function "acs_sc_contract__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:141: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:145: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
acs_sc_operation__new
-----------------------
1038
(1 row)
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:161: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
psql:conaje/packages/search/sql/postgresql/search-sc-create.sql:165: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un"
CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 19 at SQL statement
acs_sc_operation__new
-----------------------
1041
(1 row)
*****************************************************
How do i enable search package?
I found a very good thread on oacs website
http://209.162.194.125/forums/message-view?message_id=89360
I can;t find AOLserver nsfts module to download and install it.
neither at debian pkgs
http://packages.debian.org/cgi-bin/search_packages.pl?keywords=aolserver&searchon=names&subword=1&version=stable&release=all
Plus, there's another thread:
https://openacs.org/forums/message-view?message_id=164980
which takes you to a OpenFTS Installation Tutorial
http://www.thedesignexperience.org/openacs/openfts-031
I've downliaded Search-OpenFTS-0.39 but i got stuck. There's no cofigure file to run
./configure --with-tcl=/usr/lib/tcl8.4 --with-aolserver-src=../aolserver4/
any clue?
