What does sphinx want from me when updating?

Question

Sphinx

I do data update in rt_index

mysql> UPDATE picneco SET title='Заголовок', article='71-1182' WHERE id = 836;

I am getting an error.

ERROR 1064 (42000): sphinxql: syntax error, unexpected QUOTED_STRING near ''Заголовок', article='71-1182' WHERE id = 836'

What's wrong?

Fields and attributes in the index

rt_field 		= item
  rt_field 		= article
  rt_field 		= title
  rt_field		= description
  rt_field		= properties

  rt_attr_string	= article
  rt_attr_uint	= item_id
  rt_attr_string	= item
  rt_attr_string 	= title
  rt_attr_string 	= description
  rt_attr_string 	= properties
  rt_attr_multi 	= tags
  rt_attr_multi	= right
  rt_attr_multi   = tags

Answer 1

As of version 2.0.2-beta, all attribute types (int, bigint, float, MVA), except for strings and JSON attributes, can be dynamically updated.

Strings cannot be updated, they can be replayed .