SmartCJ Support Forum

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column 'group_type' in 'where clause') (ext_db_link) in query SELECT * FROM rot_groups as gr, rot_groups_data as gr_data WHERE gr.id = gr_data.group_id and gr_data.site_id = '13' AND group_type = 'rotation' ORDER BY gr_data.status desc, name. (porn.com) ' in /home/user/www/porn.com/scj/includes/db_modules/mysql.php:62 Stack trace: #0 /home/user/www/porn.com/scj/includes/db_modules/mysql.php(75): db_error('SELECT * FROM r...', 1054, 'Unknown column ...', 'ext_db_link') #1 /home/user/www/porn.com/scj/includes/libs/rot_functions.php(0): db_query() #2 /home/user/www/porn.com/scj/admin/files/rot_cms.php(0): get_rot_groups() #3 /home/user/www/porn.com/scj/admin/index.php(0): unknown() #4 {main} thrown in /home/user/www/porn.com/scj/includes/db_modules/mysql.php on line 62
err

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column 'gr.group_type' in 'where 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 = '13' 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_stats13 as gs on gs.thumb_id = g.id JOIN rot_gallery_data13 AS gd ON gd.gallery_md5 = g.gallery_md5 WHERE gi.url != 0 and gi.source_url = '13' ) as tmp ON tmp.url = gr.id WHER in /home/user/www/porn.com/scj/includes/db_modules/mysql.php on line 62