Here it is:
> Can you pastie your development.sphinx.conf file? Don't forget to
> remove database passwords and anything else you don't want to share.
-----------------------------------------
indexer
{
}
searchd
{
address = 127.0.0.1
port = 3312
log = C:/work/fegdoc4/log/searchd.log
query_log = C:/work/fegdoc4/log/searchd.query.log
pid_file = C:/work/fegdoc4/log/searchd.development.pid
}
source document_0_core
{
type = mysql
sql_host = localhost
sql_user = monty
sql_pass =
sql_db = fegdoc4_development
sql_query_pre = SET NAMES utf8
sql_query_pre =
sql_query = SELECT `documents`.`id` * 1 + 0 AS `id` , CAST
(`documents`.`full_text` AS CHAR) AS `full_text`, CAST
(`documents`.`notes` AS CHAR) AS `notes`, CAST(`documents`.`author` AS
CHAR) AS `author`, CAST(`documents`.`from` AS CHAR) AS `from`, CAST
(`documents`.`to` AS CHAR) AS `to`, CAST(`documents`.`doc_file_name`
AS CHAR) AS `doc_file_name`, IFNULL(`documents`.`author`, '') AS
`author_sort`, IFNULL(`documents`.`from`, '') AS `from_sort`, IFNULL
(`documents`.`to`, '') AS `to_sort`, `documents`.`legal_case_id` AS
`legal_case_id`, IFNULL(`documents`.`code`, '') AS `code`,
`documents`.`pub` AS `pub`, `documents`.`privileged` AS `privileged`,
`documents`.`importance` AS `importance`, UNIX_TIMESTAMP
(`documents`.`last_access`) AS `last_access`,
`documents`.`date_written` AS `date_written`, UNIX_TIMESTAMP
(`documents`.`created_at`) AS `created_at`, UNIX_TIMESTAMP
(`documents`.`updated_at`) AS `updated_at`, IFNULL
(`documents`.`doc_type`, '') AS `doc_type`, IFNULL
(`documents`.`doc_file_type`, '') AS `doc_file_type`, IFNULL
(`documents`.`physical_folder`, '') AS `physical_folder`,
`documents`.`id` AS `sphinx_internal_id`, 555739168 AS `class_crc`,
'555739168' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM
documents WHERE `documents`.`id` >= $start AND `documents`.`id`
<= $end GROUP BY `documents`.`id` ORDER BY NULL
sql_query_range = SELECT MIN(`id`), MAX(`id`) FROM `documents`
sql_query_info = SELECT * FROM `documents` WHERE `id` = (($id -
0) / 1)
sql_attr_str2ordinal = author_sort
sql_attr_str2ordinal = from_sort
sql_attr_str2ordinal = to_sort
sql_attr_uint = legal_case_id
sql_attr_str2ordinal = code
sql_attr_bool = pub
sql_attr_bool = privileged
sql_attr_uint = importance
sql_attr_timestamp = last_access
sql_attr_uint = date_written
sql_attr_timestamp = created_at
sql_attr_timestamp = updated_at
sql_attr_str2ordinal = doc_type
sql_attr_str2ordinal = doc_file_type
sql_attr_str2ordinal = physical_folder
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_multi = uint subclass_crcs from field
sql_attr_uint = sphinx_deleted
}
index document_core
{
source = document_0_core
path = C:/work/fegdoc4/db/sphinx/development/document_core
charset_type = utf-8
morphology = stem_en
}
index document
{
type = distributed
local = document_core
}
------------------------------------------
> And what's the output when you run the index task?
-------------------------------------
Generating Configuartion to C:/work/fegdoc4/config/
development.sphinx.conf
indexer --config C:/work/fegdoc4/config/development.sphinx.conf --all
Sphinx 0.9.8-rc2 (r1234)
Copyright......
using config file 'C:/work/fegdoc4/config/development.sphinx.conf'...
indexing index 'document_core'...
collected 11 docs, 0.3MB
collected 0 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.0 Mhits, 100.0% done
total 11 docs, 284366 bytes
total 0.065 sec, 4345417.08 bytes/sec, 168.09 doc/sec
distributed index 'document' can not be directly indexed; skipping.
--------------------------------
Remark: the fact that there are only 11 documents being found, but the
[0, 0, ...] array had length 15 is fine; I just deleted 4 documents
from the database.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---
