Mysql Error
Posted: Tue Jan 22, 2013 3:02 pm
Обнаружил такую ошибку при попытке нажать "list thumbs" чтобы посмотреть все тумбы галлереи:
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 ' 'yes', 'no') as new_thumb, gs.total_ctr as ctr, gs.best_thumb as best_thum' at line 1) in query select g.*, gi.*, if (gs.total_shows < , 'yes', 'no') as new_thumb, gs.total_ctr as ctr, gs.best_thumb as best_thumb, gs.total_shows as casts, gs.total_clicks as clicks from rot_galleries as g JOIN rot_gallery_info as gi ON gi.gallery_md5 = g.gallery_md5 JOIN rot_gallery_stats as gs ON gs.thumb_id = g.id where g.gallery_md5 = 'daaa9ed29b255fb99b556b6b96c2cef1' order by gs.total_ctr desc.
Edit thumb не пашет тоже, выдает пустое окно. Апдейт стоял 49, обновил до 50.
Может есть какой-нить типа manually repair?
Как быть?
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 ' 'yes', 'no') as new_thumb, gs.total_ctr as ctr, gs.best_thumb as best_thum' at line 1) in query select g.*, gi.*, if (gs.total_shows < , 'yes', 'no') as new_thumb, gs.total_ctr as ctr, gs.best_thumb as best_thumb, gs.total_shows as casts, gs.total_clicks as clicks from rot_galleries as g JOIN rot_gallery_info as gi ON gi.gallery_md5 = g.gallery_md5 JOIN rot_gallery_stats as gs ON gs.thumb_id = g.id where g.gallery_md5 = 'daaa9ed29b255fb99b556b6b96c2cef1' order by gs.total_ctr desc.
Edit thumb не пашет тоже, выдает пустое окно. Апдейт стоял 49, обновил до 50.
Может есть какой-нить типа manually repair?
Как быть?