Mysql error 1064: syntax error, unexpected '-'

Post all bugs here
Post Reply
S_Flash
Posts: 1788
Joined: Mon Mar 08, 2010 9:04 am
Contact:

Mysql error 1064: syntax error, unexpected '-'

Post by S_Flash »

Your Build 201907040722 (Current build: 201907040722 ) PHP version 7.2
Message

2019-07-08 02:16:26 : 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<br> JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id<br> JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id <br> 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 ('milflesbianorderby210--tiok' IN BOOLEAN MODE) ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 88# queryitems)

2019-07-08 00:41:21 : 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<br> JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id<br> JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id <br> 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 ('milf lesbian order by 440-- llhw' IN BOOLEAN MODE) ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 88# queryitems)

2019-07-07 07:34:50 : 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<br> JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id<br> JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id <br> 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 ('milflesbianorderby120--ptoi' IN BOOLEAN MODE) ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 88# queryitems)

2019-07-06 11:26:10 : 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<br> JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id<br> JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id <br> 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 ('milflesbianorderby640--mccm' IN BOOLEAN MODE) ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 88# queryitems)

2019-07-04 23:13:04 : 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<br> JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id<br> JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id <br> 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 ('milflesbianorderby790--lzrz' IN BOOLEAN MODE) ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 88# queryitems)

2019-07-04 12:55:10 : 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<br> JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id<br> JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id <br> 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 ('milflesbianorderby530--eelu' IN BOOLEAN MODE) ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 88# queryitems)

...
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error 1064: syntax error, unexpected '-'

Post by admin »

у меня на эти запросы не ругается, попробовал мускл 7 и мариа дб 10.2

скидывайте плз шел и данные базы, попробую там

или ПМА
Don't forget to run script update
Post Reply