Spinx.conf for mediawiki

Problem:

ERROR: index ‘wiki_main’: sql_query: Table ‘db.page’ doesn’t exist (DSN=mysql://:***@localhost:3306/db)’
ERROR: index 'wiki_incremental': sql_query: Table 'db.page' doesn’t exist (DSN=mysql://:***@localhost:3306/db)

Solution:

This comes because in the database the tables being queried have a different name. The name was changed at the creation of the database. An example is the normal table for wiki is ‘page’ but now its ‘your_defined_prefix_page’. You will need to edit the sphinx.conf to call the right database tables. This should be fairly easy.

Before

# main document fetch query - change the table names if you are using a prefix 
sql_query = SELECT page_id, page_title, page_namespace, page_is_redirect, old_id, old_text FROM page, revision, text WHERE rev_id=page_latest AND old_id=rev_text_id

After

# main document fetch query - change the table names if you are using a prefix 
sql_query = SELECT page_id, page_title, page_namespace, page_is_redirect, old_id, old_text FROM vn_page, vn_revision, vn_text WHERE rev_id=page_latest AND old_id=rev_text_id

Comments are closed.