Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS ...

Постим сюда все найденые ошибки
Post Reply
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS ...

Post by S_Flash »

(c) SmartCJ Pro V 2.1 Your Build 202110270727

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, 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 tested_thumb DESC, gs.total_ctr DESC LIMIT 5580, 180# queryitems)

Note, this is a free version.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS ...

Post by admin »

а что за версия мускла?
попробовал на мускле и мариядб - все ок с такими запросами
Don't forget to run script update
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Re: Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS ...

Post by S_Flash »

admin wrote: Sun Oct 31, 2021 10:32 am а что за версия мускла?
попробовал на мускле и мариядб - все ок с такими запросами
mysql Ver 8.0.25-15 for Linux on x86_64 (Percona Server (GPL), Release 15, Revision a558ec2)

Linux 5.14.12-1.el7.elrepo.x86_64 #1 SMP Tue Oct 12 08:39:58 EDT 2021 x86_64 x86_64 x86_64 GNU/Linux
cat /etc/os-release
NAME="CentOS Linux"
VERSION="7 (Core)"
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS ...

Post by admin »

может быть в перконе конечно что-то свое есть
нагуглить с ходу не удалось
скиньте плз ПМА или шел
Don't forget to run script update
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Re: Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS ...

Post by S_Flash »

Скинул доступ в админку, если я правильно понял ПМА!
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS ...

Post by admin »

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

Re: Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS ...

Post by S_Flash »

Вот такая ещё проблема на другом сайте

Code: Select all

Mysql error 1064: syntax error, unexpected ')', expecting $end (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, 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 ('\')--#' IN BOOLEAN MODE)   ORDER BY  tested_thumb DESC,  gs.total_ctr DESC  LIMIT 0, 150# queryitems)
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Core error: Mysql error 1064: syntax error, unexpected '-' (SELECT SQL_CALC_FOUND_ROWS ...

Post by admin »

это кто-то пытался ломануть через символы в запросе, ему показало что ничего не найдено, а попытку записало в лог
Don't forget to run script update
Post Reply