Mysql error 1064

Постим сюда все найденые ошибки
ulan
Posts: 1437
Joined: Fri Nov 23, 2018 2:49 pm

Mysql error 1064

Post by ulan »

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)

Подскажите как исправить такие ошибки?
ulan
Posts: 1437
Joined: Fri Nov 23, 2018 2:49 pm

Re: Mysql error 1064

Post by ulan »

на почту пришло письмо
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>
]}
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064

Post by admin »

Да, спасибо, поправлено
Don't forget to run script update
ulan
Posts: 1437
Joined: Fri Nov 23, 2018 2:49 pm

Re: Mysql error 1064

Post by ulan »

еще почта
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>
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064

Post by admin »

Этьо старое пришло думаю , строка совпадает , а она уже поменялась
Don't forget to run script update
ulan
Posts: 1437
Joined: Fri Nov 23, 2018 2:49 pm

Re: Mysql error 1064

Post by ulan »

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)

Подскажите как поправить
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064

Post by admin »

Все сделано в апе
Don't forget to run script update
ulan
Posts: 1437
Joined: Fri Nov 23, 2018 2:49 pm

Re: Mysql error 1064

Post by ulan »

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)
ulan
Posts: 1437
Joined: Fri Nov 23, 2018 2:49 pm

Re: Mysql error 1064

Post by ulan »

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)
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064

Post by admin »

думаю там ап не проведен был
проверил - экранирует этот вариант
Don't forget to run script update
Post Reply