Возникают систематически такие ошибки в логе:
2026-02-13 12:58:23 :: 1064 :: sphinxql: syntax error, unexpected '(' near '(tag_ids) in (2328) LIMIT 1000' :: SELECT * FROM `sitedb_new_index` WHERE ANY(tag_ids) in (2328) LIMIT 1000
/home/ftpaccess/site.com/www/tcms/includes/db_modules/mysql.php (228) <= /home/ftpaccess/site.com/www/tcms/includes/db_modules/mysql.php (377) <= /home/ftpaccess/site.com/www/tcms/admin/files/main.php (479) <= /home/ftpaccess/site.com/www/tcms/admin/index.php (320) <=
Array
(
[operation] => main
)
гпт пишет:
В SphinxQL формируется запрос
WHERE ANY(tag_ids) IN (...)
Это не поддерживается.
Нужно заменить на tag_ids IN (...)
Ошибка: 1064 sphinxql syntax error
Your Build 202602021638 (Current build: 202602021638 ) PHP version 7.4.23 Mysql Version: 8.0.36
sphinxql: syntax error
Re: sphinxql: syntax error
случайно не пишет что старый sphinx на серваке?
Don't forget to run script update
Re: sphinxql: syntax error
Server version: 3.7.1-dev (commit da9f8a4e7)
Copyright (c) 2000, 2025, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT * FROM main_site_index WHERE ANY(tag_ids) in (123) LIMIT 1000;
+------+----------+------------+-----------+-------------+--------------+------------+------------------------+-----------------------------+
| id | duration | sponsor_id | total_ctr | total_shows | content_type | date | tag_ids | categories |
+------+----------+------------+-----------+-------------+--------------+------------+------------------------+-----------------------------+
| 1476 | 488 | 1 | 0 | 10876 | 4 | 1536652879 | 51,123,848,849 | 1,14,20,56,60,74,94 |
| 1542 | 488 | 1 | 0 | 5182 | 4 | 1536519325 | 51,123,848,849 | 1,14,20,60,74,94,98 |
| 1543 | 488 | 1 | 0 | 9496 | 4 | 1536519325 | 3,55,123,839,850 | 1,14,20,23,37,60,94,98 |
| 1824 | 649 | 1 | 0 | 10140 | 4 | 1536519326 | 16,123,277,797,1130 | 1,4 |
| 4938 | 634 | 1 | 0 | 6010 | 4 | 1641365851 | 25,52,123,867 | 1,4,29,39,60,79 |
| 4943 | 704 | 1 | 0 | 10168 | 4 | 1641384091 | 123,375,546,547 | 1,20,54,60,79,89 |
| 4972 | 928 | 1 | 0 | 10310 | 4 | 1641490051 | 16,40,123,223,241,843 | 1,9,13,15,16,46,60,85,87,89 |
| 5000 | 1136 | 1 | 0 | 10274 | 4 | 1641592171 | 52,97,104,123,228,1725 | 1,14,15,20,33,60,88 |
+------+----------+------------+-----------+-------------+--------------+------------+------------------------+-----------------------------+
8 rows in set (0.00 sec)
Copyright (c) 2000, 2025, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT * FROM main_site_index WHERE ANY(tag_ids) in (123) LIMIT 1000;
+------+----------+------------+-----------+-------------+--------------+------------+------------------------+-----------------------------+
| id | duration | sponsor_id | total_ctr | total_shows | content_type | date | tag_ids | categories |
+------+----------+------------+-----------+-------------+--------------+------------+------------------------+-----------------------------+
| 1476 | 488 | 1 | 0 | 10876 | 4 | 1536652879 | 51,123,848,849 | 1,14,20,56,60,74,94 |
| 1542 | 488 | 1 | 0 | 5182 | 4 | 1536519325 | 51,123,848,849 | 1,14,20,60,74,94,98 |
| 1543 | 488 | 1 | 0 | 9496 | 4 | 1536519325 | 3,55,123,839,850 | 1,14,20,23,37,60,94,98 |
| 1824 | 649 | 1 | 0 | 10140 | 4 | 1536519326 | 16,123,277,797,1130 | 1,4 |
| 4938 | 634 | 1 | 0 | 6010 | 4 | 1641365851 | 25,52,123,867 | 1,4,29,39,60,79 |
| 4943 | 704 | 1 | 0 | 10168 | 4 | 1641384091 | 123,375,546,547 | 1,20,54,60,79,89 |
| 4972 | 928 | 1 | 0 | 10310 | 4 | 1641490051 | 16,40,123,223,241,843 | 1,9,13,15,16,46,60,85,87,89 |
| 5000 | 1136 | 1 | 0 | 10274 | 4 | 1641592171 | 52,97,104,123,228,1725 | 1,14,15,20,33,60,88 |
+------+----------+------------+-----------+-------------+--------------+------------+------------------------+-----------------------------+
8 rows in set (0.00 sec)
Don't forget to run script update
Re: sphinxql: syntax error
вот пример как работает синтаксис
есть вероятность что у вас sphinx 2.2 который вышел 10 лет назад, уже актуальна версия 3 давно
полагаю так же что на Home пишет что версия старая
есть вероятность что у вас sphinx 2.2 который вышел 10 лет назад, уже актуальна версия 3 давно
полагаю так же что на Home пишет что версия старая
Don't forget to run script update