SmartCJ Support Forum

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column 'gi.gallery_md5' in 'on clause') (ext_db_link) in query SELECT gr.name as category_name, gr_data.custom_name as category_custom_name, gr_data.description as category_description, gr.id as category_id, gr_data.group_keywords, gr_data.group_custom_var1, gr_data.group_custom_var2, gr_data.group_custom_var3, gr_data.status as group_status, gr.parent_id, tmp.* FROM rot_groups AS gr JOIN rot_groups_data AS gr_data ON gr_data.group_id = gr.id and gr_data.site_id = '15' LEFT OUTER JOIN ( SELECT gi.url, g.*, gs.total_shows, gs.total_ctr, gd.alt, gd.description FROM rot_gallery_info AS gi JOIN rot_galleries AS g ON g.gallery_md5 = gi.gallery_md5 and g.rgroup = 0 and g.sponsor_id = 0 and content_type = '0' JOIN rot_gallery_stats15 as gs on gs.thumb_id = g.id JOIN rot_gallery_data AS gd ON gd.gallery_md5 = g.gallery_md5 WHERE gi.url != 0 and gi.source_url = '15' ) as tmp ON tmp.url = gr.id WHERE gr in /patch/domain.com/scj/includes/db_modules/mysql.php on line 62