There is a parsing problem with sphinx search when the server migrates.

contact sphinx for the first time to consult the document, but did not find the relevant answer. Come quickly to think about whether or not to find the answer. I hope that the great gods of sphinx who think no can give some ideas

/ / sphinx.conf

source anhaofour_doctoruser
{

        type            = mysql
        sql_host        = localhost
        sql_user        = ""
        sql_pass        = ""
        sql_db          = ""
        sql_port        = 3306  -sharp optional, default is 3306
        sql_query_pre   = SET NAMES utf8
        -sharpsql_query_pre  = SET SESSION query_cache_type=OFF
        sql_query= SELECT a.`doctoruid`,a.`doctorname`,a.`service_number`,a.`department_name` ,a.`hospital_name`,a.special_signed,c.doclevelname as `doctor_level_name`, b.`specialty`   FROM  `doctor_user` a  left  join `doctor_user_profile` b  on  a.doctoruid=b.doctoruid left join doctor_level c on a.doctor_level=c.doclevelid left join doctor_service d on a.doctoruid=d.doctor_id  WHERE  a.doctoruid>=$start AND a.doctoruid<=$end AND d.type=1 AND d.open=1  AND  a.status=1 and a.authentication_status=1
        sql_query_range = SELECT MIN(doctoruid),MAX(doctoruid) FROM doctor_user
        sql_range_step  = 2000
        sql_attr_uint = doctoruid
        sql_attr_uint=service_number
        sql_field_string = doctorname
        sql_field_string= hospital_name
        sql_field_string=department_name
        sql_attr_string=specialty
        sql_attr_uint=special_signed
        sql_attr_string=doctor_level_name
        sql_ranged_throttle = 0 
        -sharpsql_query_info= SELECT * FROM doctor_user WHERE id=$id
}



index anhaofour_doctoruser
{
        source          = anhaofour_doctoruser
        path            = /data/db/sphinx-3.0.2/anhaofour_doctoruser
        -sharpdocinfo        = extern
        mlock           = 0
        morphology      = none
        min_word_len    = 3
        -sharpcharset_type   = utf-8
        min_prefix_len  = 0
        html_strip      = 1
        charset_table   = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
        ngram_len       = 2
        ngram_chars     = U+3000..U+2FA1F
        preopen         = 1
        -sharpondisk_dict    = 0
        html_remove_elements    = style, script
}

The

index is also generated successfully

sphinx

The

code is sure to be fine. The online server is running normally. After the offline server is migrated, there is such a problem

[message:protected] = > Searching index "anhaofour_doctoruser" for "failed with error" index anhaofour_doctoruser: parse error: unknown column: id ".

Sphinx

Feb.28,2021