SmartCJ Support Forum

2019-11-14 08:36:32 : Mysql error 1064: index site_tcms_search_index: syntax error, unexpected $end near '' (SELECT id FROM `site_com_tcms_search_index` WHERE MATCH ('"ebony\\"') ORDER BY hits DESC LIMIT 0, 20 OPTION max_matches=20000)

Подскажите как исправить такие ошибки?

на почту пришло письмо

The page at /suggest/?query=sister%20thte%5C () raised an error

0 : &lt;br /&gt;<br>
1 : &lt;b&gt;Warning&lt;/b&gt;: Cannot modify header information - headers already sent by (output started at /home/sites/sites/.com/scj/includes/libs/tpl_tags.php:4363) in &lt;b&gt;/home/sites/sites/.com/scj/tube/index.php(895) : eval()'d code&lt;/b&gt; on line &lt;b&gt;1&lt;/b&gt;&lt;br /&gt;<br>
2 : {
<br>
3 : &quot;query&quot;:&quot;sister thte\\&quot;,
<br>
4 : &quot;suggestions&quot;:
<br>
5 : [
<br>
6 : {&quot;value&quot;:&quot;&quot;,&quot;data&quot;:&quot;&quot;}
<br>
7 :
<br>
8 : ,{&quot;value&quot;:&quot;sister&quot;,&quot;data&quot;:&quot;sister&quot;}
<br>
9 :
<br>
10 : ,{&quot;value&quot;:&quot;step sister&quot;,&quot;data&quot;:&quot;step sister&quot;}
<br>

код страницы саджест

<? header('Content-Type: application/json');?>
{
"query":"<!--ESCAPED_GET_QUERY-->",
"suggestions":
[
{"value":"","data":""}
<thumb search_log=all skip_search_log=true num=1-10 search=GET_QUERY>
,{"value":"<!--ESCAPED_SEARCH_QUERY-->","data":"<!--ESCAPED_SEARCH_QUERY-->"}
</thumb>
]}

Да, спасибо, поправлено

еще почта
The page at /suggest/?query=o%5C (Remote IP 42.29) raised an error

0 : &lt;br /&gt;<br>
1 : &lt;b&gt;Warning&lt;/b&gt;: Cannot modify header information - headers already sent by (output started at /home/sites/sites.com/scj/includes/libs/tpl_tags.php:4363) in &lt;b&gt;/home/sites/sites/.com/scj/tube/index.php(895) : eval()'d code&lt;/b&gt; on line &lt;b&gt;1&lt;/b&gt;&lt;br /&gt;<br>
2 : {
<br>
3 : &quot;query&quot;:&quot;o\\&quot;,
<br>
4 : &quot;suggestions&quot;:
<br>
5 : [
<br>
6 : {&quot;value&quot;:&quot;&quot;,&quot;data&quot;:&quot;&quot;}
<br>
7 :
<br>
8 : ,{&quot;value&quot;:&quot;aletta ocean&quot;,&quot;data&quot;:&quot;aletta ocean&quot;}
<br>
9 :
<br>
10 : ,{&quot;value&quot;:&quot;office&quot;,&quot;data&quot;:&quot;office&quot;}
<br>

Этьо старое пришло думаю , строка совпадает , а она уже поменялась

2019-11-14 16:30:49 : Mysql error 1064: index _com_tcms_index: syntax error, unexpected ')' near ') - Milfs Like It Big'' (SELECT id FROM `_com_tcms_index` WHERE match ('@(alt, custom_var3, description, tags, group_names, group_names) \'Ryan Conner) - Milfs Like It Big\'') LIMIT 0, 54 OPTION max_matches=20000)


2019-11-14 15:43:20 : Mysql error 1064: index _com_tcms_search_index: syntax error, unexpected '"', expecting TOK_KEYWORD or TOK_INT or TOK_FLOAT or '=' near '"/2' (SELECT id FROM `_com_tcms_search_index` WHERE MATCH ('"jasmine jae maa="/2') ORDER BY hits DESC LIMIT 0, 20 OPTION max_matches=20000)

Подскажите как поправить

Все сделано в апе

Mysql error 1064: index _scj_index: query is non-computable (single NOT operator) (SELECT id FROM `_scj_index` WHERE match ('@(alt, custom_var3, description, tags, group_names, group_names) \'- hornynakedcam\'') AND id NOT IN (121174, 127567, 122194, 123677, 110854, 89558, 104678, 115016, 123438, 131722, 122257, 99938, 102105, 129535, 98229, 121684, 124454, 97637, 89323, 100708, 105804, 108112, 109778, 95226) LIMIT 0, 54 OPTION max_matches=20000)

Mysql error 1064: index _tcms_index: syntax error, unexpected ')' near ' ')0'' (SELECT id FROM `_tcms_index` WHERE match ('@(alt, custom_var3, description, tags, group_names, group_names) \')0\'') LIMIT 0, 54 OPTION max_matches=20000)

думаю там ап не проведен был
проверил - экранирует этот вариант