Баг V.50 RSS - MySQL Error
Posted: Sat Feb 02, 2013 8:30 am
Делаю RSS по инструкции: http://www.smartcj.com/wiki/doku.php?id ... rss_export (шаблон у меня уже есть, не менял)
V 1.50 Build 201301231324
Mysql error: 1054 (Unknown column 'g.rot_content_id' in 'where clause') in query select g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 500, 1, 0) as new_thumb FROM rot_galleries as g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE g.status = 1 AND g.rgroup != 0 and gs.best_thumb = 'yes' and g.rot_content_id != '0' ORDER BY new_thumb ASC, gs.total_ctr DESC LIMIT 0, 1000# queryitems.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mydomain/public_html/scj/includes/db_modules/mysql.php on line 240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mydomain/public_html/scj/includes/db_modules/mysql.php on line 236
http://www.mydomain.com Some Description
Обновился до
V 1.50 Build 201301281332
- не помогло, текст ошибки не изменился.
Кэш 5 секунд, спец-кука стоит. Столбец rot_content_id в rot_galleries действительно отсутствует.
V 1.50 Build 201301231324
Mysql error: 1054 (Unknown column 'g.rot_content_id' in 'where clause') in query select g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 500, 1, 0) as new_thumb FROM rot_galleries as g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE g.status = 1 AND g.rgroup != 0 and gs.best_thumb = 'yes' and g.rot_content_id != '0' ORDER BY new_thumb ASC, gs.total_ctr DESC LIMIT 0, 1000# queryitems.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mydomain/public_html/scj/includes/db_modules/mysql.php on line 240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mydomain/public_html/scj/includes/db_modules/mysql.php on line 236
http://www.mydomain.com Some Description
Обновился до
V 1.50 Build 201301281332
- не помогло, текст ошибки не изменился.
Кэш 5 секунд, спец-кука стоит. Столбец rot_content_id в rot_galleries действительно отсутствует.