Core error:

igor
Posts: 85
Joined: Sun Oct 28, 2018 10:37 am

Core error:

Post by igor »

появилась ошибка такая в админке

Warning, you have following CORE errors (You have to fix it and delete those messages from Home - Script Messages after that)

Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT `search_query` , `gal_id`, SUM(hits) as hits, items_found, max(date) as date FROM rot_search_queries as rs WHERE 1 = 1 and items_found >= 1 and rs.search_query != 'japanese-milf---xhimex' and MATCH (search_query) AGAINST ('japanese-milf---xhimex*' IN BOOLEAN MODE ) GROUP BY rs.search_query, rs.gal_id ORDER BY hits DESC LIMIT 0, 50)

админам хости отписал - они перенаправили сюда

... напишите ему. Проблема в запросе связанная с символом "-"

форма для посика на сайте такая

<form id="search_form" method="POST" target="_self" onsubmit="if(document.getElementById('search_input').value!=''){document.getElementById('search_form').action='/<?=$searchPartURL?>/'+encodeURI(document.getElementById('search_input').value.split(' ').join('+'))+'/';}else{document.location.href='/';}" itemprop="potentialAction">
<input id="search_input" class="search-input" type="search" autocomplete="off">
<input class="search-submit" type="submit" value="Search">
</form>


сайт pinkporn.pro

что делать ?
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Core error:

Post by admin »

а какая это верси мускла? у мен без проблем проходит такой запрос
Don't forget to run script update
igor
Posts: 85
Joined: Sun Oct 28, 2018 10:37 am

Re: Core error:

Post by igor »

в углу админки
PHP version 7.3.14 Mysql Version: 5.7.27-30
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Core error:

Post by admin »

лучше узнать у админа, может быть перкона или еще какой-то интереснй билд
Don't forget to run script update
igor
Posts: 85
Joined: Sun Oct 28, 2018 10:37 am

Re: Core error:

Post by igor »

[root@HS0230 ~]# php -v
PHP 7.3.14 (cli) (built: Jan 21 2020 09:59:50) ( NTS )



[root@HS0230 ~]# rpm -qa | grep -i percona
Percona-Server-client-57-5.7.27-30.1.el7.x86_64
percona-release-1.0-13.noarch
Percona-Server-shared-compat-57-5.7.27-30.1.el7.x86_64
Percona-Server-shared-57-5.7.27-30.1.el7.x86_64
Percona-Server-server-57-5.7.27-30.1.el7.x86_64

Server version: 5.7.27-30 Percona Server (GPL), Release 30, Revision 8916819



[root@HS0230 ~]# nginx -V
nginx version: nginx/1.18.0



[root@HS0230 ~]# apachectl -V
Server version: Apache/2.4.6 (CentOS)
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Core error:

Post by admin »

ситуация такая:
на мускле прсто и мария дб этот запрос проходит без проблем

вижу был баг на эту тему
https://bugs.mysql.com/bug.php?id=72605

варианты решения вопроса
1. апгруйд перкона
сейчас уже 8я версия
https://www.percona.com/doc/percona-ser ... index.html

2.если админ знает как править обрабатывать для перконы - могу поправить с его слов

3. если нет - скидывайте шел, я проверю методом тыка что конкретно оно хочет в этой версии
Don't forget to run script update
igor
Posts: 85
Joined: Sun Oct 28, 2018 10:37 am

Re: Core error:

Post by igor »

забили на это короче
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Core error:

Post by admin »

ok
Don't forget to run script update
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Re: Core error:

Post by S_Flash »

Похожая ситуация на Mysql Version: 8.0.25-15

Database check - OK
Warning, you have following CORE errors (You have to fix it and delete those messages from Home - Script Messages after that)
Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS gs.gallery_id, gs.thumb_id, gi.sponsor_id, gi.content_count, gi.content_type, gs.total_shows, gs.total_clicks, gs.total_ctr, gt.thumb_url, gt.source_thumb_url, gd.*, gi.content_count, gi.crop_profile_id, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery FROM rot_gallery_stats1 as gs FORCE INDEX (group_activationdate) JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id WHERE 1 = 1 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id = 0 and MATCH ( gd.`alt` , gd.`description` ) AGAINST ('!--SEARCH_QUERY-->' IN BOOLEAN MODE) ORDER BY activation_date DESC LIMIT 0, 180# queryitems)
Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS gs.gallery_id, gs.thumb_id, gi.sponsor_id, gi.content_count, gi.content_type, gs.total_shows, gs.total_clicks, gs.total_ctr, gt.thumb_url, gt.source_thumb_url, gd.*, gi.content_count, gi.crop_profile_id, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery FROM rot_gallery_stats1 as gs JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id WHERE 1 = 1 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id = 0 and MATCH ( gd.`alt` , gd.`description` ) AGAINST ('!--SEARCH_QUERY-->' IN BOOLEAN MODE) ORDER BY gi.rating DESC LIMIT 0, 180# queryitems)
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Core error:

Post by admin »

мускл не разрешает искать если сделать

--keyword

что и есть в этом примере

можно просто удалить
Don't forget to run script update
Post Reply