SmartCJ Support Forum

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1104 (The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay) (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.id as group_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 = '1' LEFT OUTER JOIN ( SELECT gs.thumb_id, gi.sponsor_id, gi.url, gi.crop_profile_id, gi.content_count, gt.thumb_url, gs.total_shows, gs.total_ctr, gd.alt, gd.description FROM rot_gallery_info AS gi JOIN rot_gallery_stats1 as gs on gs.gallery_id = gi.gallery_id JOIN rot_thumbs AS gt ON gt.gallery_id = gi.gallery_id JOIN rot_gall in /data/www/cj/domain.com/folder/includes/db_modules/mysql.php on line 56