List Thumbs - MassEdit Query

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

List Thumbs - MassEdit Query

Post by S_Flash »

V 1.49 Build 201302131236

То нормально работает, то нажмёшь и получаешь такое сообщение:

Mysql error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' or source_url like '%\\'%' or gd.description like '%\\'%' or g.gallery_sl' at line 1) in query select count(distinct(g.gallery_md5)) as total from rot_galleries as g JOIN rot_gallery_data as gd on gd.gallery_md5 = g.gallery_md5 JOIN rot_gal2group as g2gr on g2gr.gal_id = g.id JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE 1 = 1 and gs.best_thumb = "yes" and ( url like '%\\'%' or source_url like '%\\'%' or gd.description like '%\\'%' or g.gallery_slug like '%\\'%' or gd.alt like '%\\'%' or thumb_url = '\\'' or id = '0' or g.gallery_md5 = '\\'') and g.status IN ( 0,1,2,10) .No items

Помоему это происходит после того как что-то искал Search в опциях List Thumbs
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: List Thumbs - MassEdit Query

Post by admin »

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

Re: List Thumbs - MassEdit Query

Post by S_Flash »

admin wrote:Fixed
в 49й или 50й?
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: List Thumbs - MassEdit Query

Post by admin »

49

в 50 такой пробелмы нет вроде.
Don't forget to run script update
Post Reply