mysql_error.log
Posted: Tue Jan 14, 2014 8:10 pm
Откуда берутся подобные ошибки и стоит ли бороться за чистоту кода, чтоб не выкатило что-то непоправимо, что перекосит всю базу?
Новый сайт (пустая база, добавлял для теста импорта 5 - 10 галерей и удалял):
Не новый сайт:
Новый сайт (пустая база, добавлял для теста импорта 5 - 10 галерей и удалял):
Code: Select all
2014-01-14 14:50:10 : 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 ')' at line 3) in query SELECT thumb_id, group_id, current_index, current_shows, current_clicks, current_points, total_shows FROM rot_gallery_stats
WHERE current_shows > '150'
AND thumb_id IN (0,)
2014-01-14 14:50:10 : 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 ')' at line 1) in query SELECT id, gallery_md5 FROM rot_galleries WHERE id IN (0,)
2014-01-14 15:07:10 : 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 ')' at line 3) in query SELECT thumb_id, group_id, current_index, current_shows, current_clicks, current_points, total_shows FROM rot_gallery_stats
WHERE current_shows > '150'
AND thumb_id IN (0,)
2014-01-14 15:07:10 : 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 ')' at line 1) in query SELECT id, gallery_md5 FROM rot_galleries WHERE id IN (0,)
Code: Select all
2013-12-10 20:22:27 : Mysql error: 1054 (Unknown column '1621208ffc5451ff45f65fb012b9a9bfc3f3ed' in 'where clause') in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = 1621208ffc5451ff45f65fb012b9a9bfc3f3ed THEN current_clicks + 1 WHEN thumb_id = 16212 THEN current_clicks + 1 END, current_points = CASE WHEN thumb_id = 1621208ffc5451ff45f65fb012b9a9bfc3f3ed THEN current_points + 1572 WHEN thumb_id = 16212 THEN current_points + 1572 END WHERE thumb_id IN (1621208ffc5451ff45f65fb012b9a9bfc3f3ed,16212)
2013-12-10 20:22:27 : Mysql error: 1054 (Unknown column '1621208ffc5451ff45f65fb012b9a9bfc3f3ed' in 'where clause') in query UPDATE LOW_PRIORITY rot_gallery_stats SET
total_shows = current_shows + shows0 + shows1 + shows2 + shows3 + shows4 + shows5 + shows6 + shows7 + shows8 + shows9,
total_clicks = current_clicks + clicks0 + clicks1 + clicks2 + clicks3 + clicks4 + clicks5 + clicks6 + clicks7 + clicks8 + clicks9,
total_points = current_points + points0 + points1 + points2 + points3 + points4 + points5 + points6 + points7 + points8 + points9,
total_ctr = (current_points + points0 + points1 + points2 + points3 + points4 + points5 + points6 + points7 + points8 + points9)/(current_shows + shows0 + shows1 + shows2 + shows3 + shows4 + shows5 + shows6 + shows7 + shows8 + shows9)/1000
WHERE thumb_id IN (1621208ffc5451ff45f65fb012b9a9bfc3f3ed,16212)
2013-12-10 20:22:27 : Mysql error: 1054 (Unknown column '1621208ffc5451ff45f65fb012b9a9bfc3f3ed' in 'where clause') in query SELECT thumb_id, current_index, current_shows, current_clicks, current_points, total_shows FROM rot_gallery_stats
WHERE current_shows > '2000'
AND thumb_id IN (1621208ffc5451ff45f65fb012b9a9bfc3f3ed,16212)
2013-12-10 20:22:27 : Mysql error: 1054 (Unknown column '1621208ffc5451ff45f65fb012b9a9bfc3f3ed' in 'where clause') in query SELECT id, gallery_md5 FROM rot_galleries WHERE id IN (1621208ffc5451ff45f65fb012b9a9bfc3f3ed,16212)