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)
Подскажите как исправить такие ошибки?
Mysql error 1064
Re: Mysql error 1064
на почту пришло письмо
код страницы саджест
The page at /suggest/?query=sister%20thte%5C () raised an error
0 : <br /><br>
1 : <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/sites/sites/.com/scj/includes/libs/tpl_tags.php:4363) in <b>/home/sites/sites/.com/scj/tube/index.php(895) : eval()'d code</b> on line <b>1</b><br /><br>
2 : {
<br>
3 : "query":"sister thte\\",
<br>
4 : "suggestions":
<br>
5 : [
<br>
6 : {"value":"","data":""}
<br>
7 :
<br>
8 : ,{"value":"sister","data":"sister"}
<br>
9 :
<br>
10 : ,{"value":"step sister","data":"step sister"}
<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>
]}
Re: Mysql error 1064
еще почта
The page at /suggest/?query=o%5C (Remote IP 42.29) raised an error
0 : <br /><br>
1 : <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/sites/sites.com/scj/includes/libs/tpl_tags.php:4363) in <b>/home/sites/sites/.com/scj/tube/index.php(895) : eval()'d code</b> on line <b>1</b><br /><br>
2 : {
<br>
3 : "query":"o\\",
<br>
4 : "suggestions":
<br>
5 : [
<br>
6 : {"value":"","data":""}
<br>
7 :
<br>
8 : ,{"value":"aletta ocean","data":"aletta ocean"}
<br>
9 :
<br>
10 : ,{"value":"office","data":"office"}
<br>
The page at /suggest/?query=o%5C (Remote IP 42.29) raised an error
0 : <br /><br>
1 : <b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/sites/sites.com/scj/includes/libs/tpl_tags.php:4363) in <b>/home/sites/sites/.com/scj/tube/index.php(895) : eval()'d code</b> on line <b>1</b><br /><br>
2 : {
<br>
3 : "query":"o\\",
<br>
4 : "suggestions":
<br>
5 : [
<br>
6 : {"value":"","data":""}
<br>
7 :
<br>
8 : ,{"value":"aletta ocean","data":"aletta ocean"}
<br>
9 :
<br>
10 : ,{"value":"office","data":"office"}
<br>
Re: Mysql error 1064
Этьо старое пришло думаю , строка совпадает , а она уже поменялась
Don't forget to run script update
Re: Mysql error 1064
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)
Подскажите как поправить
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)
Подскажите как поправить
Re: Mysql error 1064
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)
Re: Mysql error 1064
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)
Re: Mysql error 1064
думаю там ап не проведен был
проверил - экранирует этот вариант
проверил - экранирует этот вариант
Don't forget to run script update