Thread:Extension talk:SphinxSearch/Navication not working for search results/reply (2)

There were no obvious errors in the Apache error_log, but I don't think I expected to find any. It looks more like a SQL query (presumably one that gets the text where the search term was found) isn't working as expected.

I turned on these settings to show SQL messages and errors: $wgShowDebug = true; $wgShowSQLErrors = true; $wgDebugDumpSql = true;

I got a lot of SQL messages that I can't make sense of. I'll concentrate on the ones after the SphinxSearch query: "search_string"  message since that's presumably where the problem is:

One of these statements appears for each result found:

SQL: SELECT /* SphinxMWSearchResultSet::__construct Michael */ page_id,page_title,page_namespace FROM `page` WHERE page_id = '1964'

By experimenting with queries that found one result or multiple results, I found this sequence of queries that appears to be associated with the display of each found result:

SQL: SELECT /* Revision::fetchFromConds Michael */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest FROM `page`,`revision` WHERE page_namespace = '0' AND page_title = 'Infrastructure/MySQL' AND (rev_id=page_latest) AND (page_id=rev_page) LIMIT 1 SQL: SELECT /* Revision::loadText Michael */ old_text,old_flags FROM `text` WHERE old_id = '8897' LIMIT 1 SQL: SELECT /* LCStore_DB::get Michael */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:internalerror_info' LIMIT 1 SQL: SELECT /* LCStore_DB::get Michael */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:size-kilobytes' LIMIT 1 SQL: SELECT /* LCStore_DB::get Michael */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:search-result-size' LIMIT 1 SQL: SELECT /* LCStore_DB::get Michael */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'datePreferenceMigrationMap' LIMIT 1 SQL: SELECT /* LCStore_DB::get Michael */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'defaultDateFormat' LIMIT 1 SQL: SELECT /* LCStore_DB::get Michael */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:september' LIMIT 1 SQL: SELECT /* Revision::fetchFromConds Michael */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest FROM `page`,`revision` WHERE page_namespace = '0' AND page_title = 'Infrastructure/Web_Hosting' AND (rev_id=page_latest) AND (page_id=rev_page) LIMIT 1 SQL: SELECT /* Revision::loadText Michael */ old_text,old_flags FROM `text` WHERE old_id = '8011' LIMIT 1 SQL: SELECT /* LCStore_DB::get Michael */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:january' LIMIT 1

Does that help? I can provide the entire sequence of messages, but didn't want to do so here unless it was necessary, since there's easily 70-80 lines of messages total.

Thanks!