I've successfully installed and used OpenFTS several times (Redhat 7.2 and Suse 8 with postgresql). But I've been failing in the last few days, trying both 4.6.2-beta2 and with 4.6 head. I'm using notes package for testing. I was finally going to post here and ask, why is this happening? --
[11/Apr/2003:10:17:02][15199.2051][-sched-] Notice: Running scheduled proc search_indexer...
[11/Apr/2003:10:17:02][15199.2051][-sched-] Warning: ACS-SC: Function Not Found: AcsSc.FtsContentProvider.datasource.note
[11/Apr/2003:10:17:02][15199.2051][-sched-] Error: can't read "datasource(content)": no such element in array
can't read "datasource(content)": no such element in array
while executing
"search_content_get txt $datasource(content) $datasource(mime) $datasource(storage_type)"
("INSERT" arm line 5)
invoked from within
...
I'd reinstalled a few times, followed the new instructions, referred to the old instructions, restarted extra times, etc. Finally thought hey! I'll set debug to true and see what I find. I swear I did nothing else (directly). And it started working:
[11/Apr/2003:10:18:06][17092.2051][-sched-] Notice: Running scheduled proc search_indexer...
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: sql =
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = :package_id
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = :parameter_name
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: bind var: package_id = 310
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: bind var: parameter_name = FtsEngineDriver
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: query with bind variables substituted =
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '310'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'FtsEngineDriver'
[11/Apr/2003:10:18:06][17092.2051][-sched-] Notice: Querying '
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '310'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'FtsEngineDriver';'
[11/Apr/2003:10:18:06][17092.2051][-sched-] Notice: dbinit: sql(localhost::ttcdev7): '
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '310'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'FtsEngineDriver'
'
[11/Apr/2003:10:18:06][17092.2051][-sched-] Debug: PgBindCmd: sql =
select object_id, event_date, event
from search_observer_queue
order by event_date asc
I changed debug back, it still works now. Does that make sense? And what sort of thing might be wrong that could cause that first error?
Thanks