Sphinx search. Indexing error, why can't one of the table fields be seen?

Question

MySQL

Good afternoon. I want to do a search with a filter. I take a simple example: there is a table of posts - posts, in the sphinx config I write the query sql_query = SELECT post_id, post_title, post_content, post_url FROM posts, then using api I make search queries - everything works here. For the filter in the config, I add sql_attr_uint = post_id, and when using api in the script, I add the line $this->sphinxsearch->setFilter('post_id', array(7)); Thus, 1 post should remain in the search results (I checked that the post with id = 7 is displayed without a filter). When starting indexing in the terminal, it writes an error that the post_id field was not found: WARNING: attribute 'post_id;' not found. Tell me what could be the problem?

Answer 1

Дайте таблицу конфиге сфинкса и его версию

Answer 2

Скорее всего сфиксу нужно явно указать поле по кторому он создаст аттрибут

sql_query = SELECT 
             post_id AS 'post_id'
             ,post_title
              ,post_content
               ,post_url 
            FROM posts

Answer 3

Screenshot of the config, I also forgot to say I use CodeIgniter, and for it the sphinx library, the syntax is also in the screenshot.
In the screenshot, where the php code is, if you comment out the 9th line, then the results are displayed, otherwise not.