Hi Pat,
I re-ran the index rake task last night and it "seems" to be ok now. I'm
unable to ascertain though if there are any remaining records where
sphinx_internal_class is null (as sphinxql doesnt seem to recognise NULL's)
- any pointers there?
Also, you mentioned checking the sql_query for stories in conf file:
source story_core_0
{
type = pgsql
sql_host = localhost
sql_user = robbie
sql_pass = postgres
sql_db = ynn_development
sql_query_pre = SET TIME ZONE UTC
sql_query = SELECT "stories"."id" * 9 + 2 AS "id", "stories"."heading" AS
"heading", "stories"."tagline" AS "tagline", "stories"."tags" AS "tags",
"stories"."id" AS "sphinx_internal_id", 'Story' AS "sphinx_internal_class",
0 AS "sphinx_deleted", "stories"."category_id" AS "category_id" FROM
"stories" WHERE ("stories"."id" BETWEEN $start AND $end AND status =
'published') GROUP BY "stories"."id", "stories"."heading",
"stories"."tagline", "stories"."tags", "stories"."id",
"stories"."category_id"
sql_query_range = SELECT COALESCE(MIN("stories"."id"), 1),
COALESCE(MAX("stories"."id"), 1) FROM "stories"
sql_attr_uint = sphinx_internal_id
sql_attr_uint = sphinx_deleted
sql_attr_uint = category_id
sql_attr_string = sphinx_internal_class
sql_query_post_index = UPDATE "stories" SET "delta" = FALSE WHERE "delta"
= TRUE
sql_query_info = SELECT "stories".* FROM "stories" WHERE ("stories"."id"
= ($id - 2) / 9)
}
On Tuesday, May 5, 2015 at 7:27:50 PM UTC+10, Pat Allan wrote:
>
> So, is it definitely story records that have the problem? (remove other
> indices from that query to check). The sphinx_internal_id attribute is the
> model’s primary key, so that may be useful for debugging… Also worth
> looking at the sql_query value for that specific source in
> config/development.sphinx.conf locally, see where that
> sphinx_internal_class value is coming from and possibly going wrong (it
> could be a type column, perhaps?)
>
> —
> Pat
>
> On 5 May 2015, at 7:14 pm, Robbie Shepherd <[email protected]
> <javascript:>> wrote:
>
> your theory is confirmed - searches that are fine all return results with
> sphinx_internal_class of Story. Searches that I know fail all have one
> result (or maybe more) with a nil value for sphinx_internal_class - now how
> do we stop this from happening?
>
> Thanks for your help so far!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected] <javascript:>.
> To post to this group, send email to [email protected]
> <javascript:>.
> Visit this group at http://groups.google.com/group/thinking-sphinx.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.
