Hi Pat Second file generated when I used version 1.3.14 and I sent you only some part of file (Means contact, account and opportunity related part)
As you asked, following is an output - >> ThinkingSphinx.context.indexed_models => ["Account", "Contact", "Matter", "Opportunity", "Physical::Crm::Campaign::Campaign"] >> On Jan 6, 4:20 am, Pat Allan <[email protected]> wrote: > Hmm, there's a lot of models missing, comparing the two files. And everything > that's there is duplicated... > > In script/console, what's the output of the following: > ThinkingSphinx.context.indexed_models > > -- > Pat > > On 06/01/2010, at 1:11 AM, rahul100885 wrote: > > > Sorry Pat > > Actually I posted wrong file. > > pravious file is generated when I use thinking sphinx version 1.3.5 > > > This is correct file of version 1.3.14 > > > indexer > > { > > mem_limit = 1024M > > } > > > searchd > > { > > listen = 127.0.0.1:3310 > > log = /home/rahul/application/demo/log/searchd.log > > query_log = /home/rahul/application/demo/log/searchd.query.log > > pid_file = /home/rahul/application/demo/log/searchd.development.pid > > } > > > source account_core_0 > > { > > type = pgsql > > sql_host = 127.0.0.1 > > sql_user = ***** > > sql_pass = ***** > > sql_db = demo_dev_29122009 > > sql_query_pre = UPDATE "accounts" SET "delta" = FALSE WHERE "delta" > > = TRUE > > sql_query = SELECT "accounts"."id" * 6 + 0 AS "id" , > > "accounts"."name" AS "account_name", array_to_string(array_accum > > (COALESCE("contacts"."first_name", '0')), ' ') AS > > "contact_first_name", array_to_string(array_accum(COALESCE > > ("contacts"."last_name", '0')), ' ') AS "contact_last_name", > > array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ') > > AS "contact_email", "accounts"."id" AS "sphinx_internal_id", > > 2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS > > "sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS > > "company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON > > ("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN > > "contacts" ON ("contacts"."id" = "account_contacts"."contact_id") > > WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND > > "accounts"."delta" = FALSE AND accounts.deleted_at is null GROUP BY > > "accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id", > > "accounts"."company_id" > > sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX > > ("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = FALSE > > sql_attr_uint = sphinx_internal_id > > sql_attr_uint = class_crc > > sql_attr_uint = sphinx_deleted > > sql_attr_uint = id > > sql_attr_uint = company_id > > sql_attr_multi = uint subclass_crcs from field > > sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 0) / > > 6) > > } > > > index account_core > > { > > source = account_core_0 > > path = /home/rahul/application/demo/db/sphinx/development/ > > account_core > > morphology = none > > min_word_len = 2 > > charset_type = utf-8 > > min_prefix_len = 2 > > prefix_fields = account_name, contact_first_name, contact_last_name, > > contact_email > > enable_star = 1 > > } > > > source account_delta_0 : account_core_0 > > { > > type = pgsql > > sql_host = 127.0.0.1 > > sql_user = ***** > > sql_pass = ***** > > sql_db = demo_dev_29122009 > > sql_query_pre = > > sql_query = SELECT "accounts"."id" * 6 + 0 AS "id" , > > "accounts"."name" AS "account_name", array_to_string(array_accum > > (COALESCE("contacts"."first_name", '0')), ' ') AS > > "contact_first_name", array_to_string(array_accum(COALESCE > > ("contacts"."last_name", '0')), ' ') AS "contact_last_name", > > array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ') > > AS "contact_email", "accounts"."id" AS "sphinx_internal_id", > > 2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS > > "sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS > > "company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON > > ("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN > > "contacts" ON ("contacts"."id" = "account_contacts"."contact_id") > > WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND > > "accounts"."delta" = TRUE AND accounts.deleted_at is null GROUP BY > > "accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id", > > "accounts"."company_id" > > sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX > > ("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = TRUE > > sql_attr_uint = sphinx_internal_id > > sql_attr_uint = class_crc > > sql_attr_uint = sphinx_deleted > > sql_attr_uint = id > > sql_attr_uint = company_id > > sql_attr_multi = uint subclass_crcs from field > > sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 0) / > > 6) > > } > > > index account_delta : account_core > > { > > source = account_delta_0 > > path = /home/rahul/application/demo/db/sphinx/development/ > > account_delta > > } > > > index account > > { > > type = distributed > > local = account_delta > > local = account_core > > } > > > source account_core_0 > > { > > type = pgsql > > sql_host = 127.0.0.1 > > sql_user = ***** > > sql_pass = ***** > > sql_db = demo_dev_29122009 > > sql_query_pre = UPDATE "accounts" SET "delta" = FALSE WHERE "delta" > > = TRUE > > sql_query = SELECT "accounts"."id" * 6 + 0 AS "id" , > > "accounts"."name" AS "account_name", array_to_string(array_accum > > (COALESCE("contacts"."first_name", '0')), ' ') AS > > "contact_first_name", array_to_string(array_accum(COALESCE > > ("contacts"."last_name", '0')), ' ') AS "contact_last_name", > > array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ') > > AS "contact_email", "accounts"."id" AS "sphinx_internal_id", > > 2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS > > "sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS > > "company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON > > ("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN > > "contacts" ON ("contacts"."id" = "account_contacts"."contact_id") > > WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND > > "accounts"."delta" = FALSE AND accounts.deleted_at is null GROUP BY > > "accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id", > > "accounts"."company_id" > > sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX > > ("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = FALSE > > sql_attr_uint = sphinx_internal_id > > sql_attr_uint = class_crc > > sql_attr_uint = sphinx_deleted > > sql_attr_uint = id > > sql_attr_uint = company_id > > sql_attr_multi = uint subclass_crcs from field > > sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 0) / > > 6) > > } > > > index account_core > > { > > source = account_core_0 > > path = /home/rahul/application/demo/db/sphinx/development/ > > account_core > > morphology = none > > min_word_len = 2 > > charset_type = utf-8 > > min_prefix_len = 2 > > prefix_fields = account_name, contact_first_name, contact_last_name, > > contact_email > > enable_star = 1 > > } > > > source account_delta_0 : account_core_0 > > { > > type = pgsql > > sql_host = 127.0.0.1 > > sql_user = ***** > > sql_pass = ***** > > sql_db = demo_dev_29122009 > > sql_query_pre = > > sql_query = SELECT "accounts"."id" * 6 + 0 AS "id" , > > "accounts"."name" AS "account_name", array_to_string(array_accum > > (COALESCE("contacts"."first_name", '0')), ' ') AS > > "contact_first_name", array_to_string(array_accum(COALESCE > > ("contacts"."last_name", '0')), ' ') AS "contact_last_name", > > array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ') > > AS "contact_email", "accounts"."id" AS "sphinx_internal_id", > > 2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS > > "sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS > > "company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON > > ("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN > > "contacts" ON ("contacts"."id" = "account_contacts"."contact_id") > > WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND > > "accounts"."delta" = TRUE AND accounts.deleted_at is null GROUP BY > > "accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id", > > "accounts"."company_id" > > sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX > > ("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = TRUE > > sql_attr_uint = sphinx_internal_id > > sql_attr_uint = class_crc > > sql_attr_uint = sphinx_deleted > > sql_attr_uint = id > > sql_attr_uint = company_id > > sql_attr_multi = uint subclass_crcs from field > > sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 0) / > > 6) > > } > > > index account_delta : account_core > > { > > source = account_delta_0 > > path = /home/rahul/application/demo/db/sphinx/development/ > > account_delta > > } > > > index account > > { > > type = distributed > > local = account_delta > > local = account_core > > } > > > source contact_core_0 > > { > > type = pgsql > > sql_host = 127.0.0.1 > > sql_user = ***** > > sql_pass = ***** > > sql_db = demo_dev_29122009 > > sql_query_pre = UPDATE "contacts" SET "delta" = FALSE WHERE "delta" > > = TRUE > > sql_query = SELECT "contacts"."id" * 6 + 1 AS "id" , > > "contacts"."first_name" AS "first_name", "contacts"."last_name" AS > > "last_name", "contacts"."email" AS "email", "accounts"."name" AS > > "contact_account_name", "contacts"."id" AS "sphinx_internal_id", > > 2212487076 AS "class_crc", '2212487076' AS "subclass_crcs", 0 AS > > "sphinx_deleted", "contacts"."id" AS "id", "contacts"."company_id" AS > > "company_id", "contacts"."status_type" AS "status_type", > > "accounts"."id" AS "contact_account_id" FROM "contacts" LEFT OUTER > > JOIN "account_contacts" ON ("contacts"."id" = > > "account_contacts"."contact_id") LEFT OUTER JOIN "accounts" ON > > ("accounts"."id" = "account_contacts"."account_id") WHERE > > "contacts"."id" >= $start AND "contacts"."id" <= $end AND > > "contacts"."delta" = FALSE AND status_type in (select id from lookups > > where (type='ProspectStatusType' or type = 'LeadStatusType') and > > lvalue<>'Rejected') or contacts.deleted_at is null GROUP BY > > "contacts"."id", "contacts"."first_name", "contacts"."last_name", > > "contacts"."email", "accounts"."name", "contacts"."id", > > "contacts"."id", "contacts"."company_id", "contacts"."status_type", > > "accounts"."id" > > sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX > > ("id"), 1::bigint) FROM "contacts" WHERE "contacts"."delta" = FALSE > > sql_attr_uint = > > ... > > read more »
-- 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.
