syntax error, unexpected FTS_TEXT, expecting FTS_TERM or FTS_NUMB or '*'

[fanera 27]

В полное вставляется к примеру:

* " Etiam viverra dapibus vulputate. Morbi non mollis urna, a scelerisque nulla. "

* "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed lacinia lorem. Nam ullamcorper pretium mauris, eu eleifend augue volutpat eget. Suspendisse vitae ex tincidunt ante laoreet bibendum. "

или исходным кодом:

<p>* " Etiam viverra dapibus vulputate. Morbi non mollis urna, a scelerisque nulla. "</p>
<p>* "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed lacinia lorem. Nam ullamcorper pretium mauris, eu eleifend augue volutpat eget. Suspendisse vitae ex tincidunt ante laoreet bibendum. "</p>

Если у новости нет похожих (список id пуст, проще через добавить проверить), то при переходе к посту падает ошибка:

MySQL Error!
MySQL error in file: engine/modules/show.full.php at line 1472
Error Number: 1064
The Error returned was:
syntax error, unexpected FTS_TEXT, expecting FTS_TERM or FTS_NUMB or '*'
SQL query:

SELECT id, date, short_story, xfields, title, category, alt_name, MATCH (title, short_story, full_story, xfields) AGAINST ('Test * \" Etiam viverra dapibus vulputate. Morbi non mollis urna, a scelerisque nulla. \"\n* \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed lacinia lorem. Nam ullamcorper pretium mauris, eu eleifend augue volutpat eget. Suspendisse vitae ex tincidunt ante laoreet bibendum. \"') as score FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('4')) c ON (p.id=c.news_id) WHERE title <> '' AND MATCH (title, short_story, full_story, xfields) AGAINST ('Test * \" Etiam viverra dapibus vulputate. Morbi non mollis urna, a scelerisque nulla. \"\n* \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed lacinia lorem. Nam ullamcorper pretium mauris, eu eleifend augue volutpat eget. Suspendisse vitae ex tincidunt ante laoreet bibendum. \"') AND id != 10880 AND approve=1 AND date < '2025-04-30 18:12:56' ORDER BY score DESC LIMIT 5

Проблема всплывает как и на старых DLE, так и на актуальной, используется InnoDB

"\n* = баг
"* = баг
"\r\n* = не баг

Этот баг не всплывает на Windows при использовании Openserver к примеру, но всплывает на сервере

Сервер:
SELECT id, date, short_story, xfields, title, category, alt_name, MATCH (title, short_story, full_story, xfields) AGAINST ('123 * \" Etiam viverra dapibus vulputate. Morbi non mollis urna, a scelerisque nulla. \"\n* \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed lacinia lorem. Nam ullamcorper pretium mauris, eu eleifend augue volutpat eget. Suspendisse vitae ex tincidunt ante laoreet bibendum. \"') as score FROM dle_post WHERE category = '1' AND MATCH (title, short_story, full_story, xfields) AGAINST ('123 * \" Etiam viverra dapibus vulputate. Morbi non mollis urna, a scelerisque nulla. \"\n* \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed lacinia lorem. Nam ullamcorper pretium mauris, eu eleifend augue volutpat eget. Suspendisse vitae ex tincidunt ante laoreet bibendum. \"') AND id != 623 AND approve=1 AND date < '2025-04-30 08:26:41' ORDER BY score DESC LIMIT 5

Windows (openserver):
SELECT id, date, short_story, xfields, title, category, alt_name, MATCH (title, short_story, full_story, xfields) AGAINST ('123 * \" Etiam viverra dapibus vulputate. Morbi non mollis urna, a scelerisque nulla. \"\r\n* \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed lacinia lorem. Nam ullamcorper pretium mauris, eu eleifend augue volutpat eget. Suspendisse vitae ex tincidunt ante laoreet bibendum. \"') as score FROM dle_post WHERE category = '1' AND MATCH (title, short_story, full_story, xfields) AGAINST ('123 * \" Etiam viverra dapibus vulputate. Morbi non mollis urna, a scelerisque nulla. \"\r\n* \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed lacinia lorem. Nam ullamcorper pretium mauris, eu eleifend augue volutpat eget. Suspendisse vitae ex tincidunt ante laoreet bibendum. \"') AND id != 622 AND approve=1 AND date < '2025-04-30 08:24:31' ORDER BY score DESC LIMIT 5

Если сравнить эти запросы, то в Windows подставляется \r и все нормально, а на Linux сервере такое не происходит и ломается

Изменено 6 часов назад пользователем fanera

[celsoft 6 173]

Принято. Спасибо. Проблема будет исправлена в следующей версии.