Пара глюков в List thumbs
Posted: Wed Aug 21, 2013 9:02 am
1. Перестали удаляться тумбы, даже если чекаю по одной и жму Delete selected.
2. Поиск по Gallery ID ничего не находит и выдает ошибку
Mysql error:: 1052 (Column 'gallery_md5' in where clause is ambiguous) (db_link) in query select SQL_CALC_FOUND_ROWS g.id, gs.total_ctr as max_ctr, gs.total_shows as casts, gs.total_clicks as clicks, g.priority as gs_priority FROM rot_galleries as g JOIN rot_gallery_data as gd on gd.gallery_md5 = g.gallery_md5 JOIN rot_gallery_info as gi on gi.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 g.rgroup != 0 and sponsor_id IN ('8') and gallery_md5 like '%133310%' and g.status IN ( 1) group by g.gallery_md5 order by date desc limit 0, 30.
в запросе условие gallery_md5 like '%133310%' - цифра это как раз айди галеры которую искал
Build 201308201353
2. Поиск по Gallery ID ничего не находит и выдает ошибку
Mysql error:: 1052 (Column 'gallery_md5' in where clause is ambiguous) (db_link) in query select SQL_CALC_FOUND_ROWS g.id, gs.total_ctr as max_ctr, gs.total_shows as casts, gs.total_clicks as clicks, g.priority as gs_priority FROM rot_galleries as g JOIN rot_gallery_data as gd on gd.gallery_md5 = g.gallery_md5 JOIN rot_gallery_info as gi on gi.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 g.rgroup != 0 and sponsor_id IN ('8') and gallery_md5 like '%133310%' and g.status IN ( 1) group by g.gallery_md5 order by date desc limit 0, 30.
в запросе условие gallery_md5 like '%133310%' - цифра это как раз айди галеры которую искал
Build 201308201353