Title: TechnoX's Replies | WordPress.org --- # TechnoX [ ](https://wordpress.org/support/users/technox/) * [Profile](https://wordpress.org/support/users/technox/) * [Topics Started](https://wordpress.org/support/users/technox/topics/) * [Replies Created](https://wordpress.org/support/users/technox/replies/) * [Reviews Written](https://wordpress.org/support/users/technox/reviews/) * [Topics Replied To](https://wordpress.org/support/users/technox/replied-to/) * [Engagements](https://wordpress.org/support/users/technox/engagements/) * [Favorites](https://wordpress.org/support/users/technox/favorites/) Search replies: ## Forum Replies Created Viewing 2 replies - 1 through 2 (of 2 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Photo Gallery, Sliders, Proofing and Themes - NextGEN Gallery] No images were found](https://wordpress.org/support/topic/no-images-were-found-6/) * Thread Starter [TechnoX](https://wordpress.org/support/users/technox/) * (@technox) * [12 years, 4 months ago](https://wordpress.org/support/topic/no-images-were-found-6/#post-4388938) * Okay, I have some more information now, when I enabled the debug output. * **The widget gives:** * > WordPress database error: [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] > SELECT wp_ngg_pictures.* , `wp_options`.`option_value` > AS ‘custom_post_id’, GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS‘ > extras’ FROM `wp_ngg_pictures` LEFT OUTER JOIN `wp_options` ON `wp_options`. > option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid) LEFT OUTER JOIN` > wp_postmeta` ON `wp_postmeta`.`post_id` = `wp_options`.`option_value` WHERE(` > exclude` = 0) AND (`galleryid` IN (3)) GROUP BY wp_ngg_pictures.pid ORDER BY > ABS(`imagedate`) ASC, `imagedate` ASC LIMIT 500 * **The gallery page gives:** * > WordPress database error: [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] > SELECT pid , `wp_options`.`option_value` AS ‘custom_post_id’, > GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS ‘extras’ FROM `wp_ngg_pictures` > LEFT OUTER JOIN `wp_options` ON `wp_options`.option_name = CONCAT(‘wp_ngg_pictures_’, > wp_ngg_pictures.pid) LEFT OUTER JOIN `wp_postmeta` ON `wp_postmeta`.`post_id` > = `wp_options`.`option_value` WHERE (`exclude` = 0) AND (`galleryid` IN (71)) > GROUP BY wp_ngg_pictures.pid ORDER BY ABS(`imagedate`) ASC, `imagedate` ASC > WordPress database error: [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] > SELECT wp_ngg_pictures.* , `wp_options`.`option_value` > AS ‘custom_post_id’, GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS‘ > extras’ FROM `wp_ngg_pictures` LEFT OUTER JOIN `wp_options` ON `wp_options`. > option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid) LEFT OUTER JOIN` > wp_postmeta` ON `wp_postmeta`.`post_id` = `wp_options`.`option_value` WHERE(` > exclude` = 0) AND (`galleryid` IN (71)) GROUP BY wp_ngg_pictures.pid ORDER > BY ABS(`imagedate`) ASC, `imagedate` ASC LIMIT 20 > no images were found * **The album page gives:** * > WordPress database error: [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] > SELECT galleryid, COUNT(*) as counter , `wp_options`.` > option_value` AS ‘custom_post_id’, GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) > AS ‘extras’ FROM `wp_ngg_pictures` LEFT OUTER JOIN `wp_options` ON `wp_options`. > option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid) LEFT OUTER JOIN` > wp_postmeta` ON `wp_postmeta`.`post_id` = `wp_options`.`option_value` WHERE(` > galleryid` IN (27, 26, 21, 19, 25, 39, 34, 40, 56, 57, 61, 62, 70, 71, 72, > 32, 73, 77, 78, 111, 112, 115, 80, 91, 92, 93, 94, 95, 97, 98, 168, 99, 101, > 100, 110, 96)) GROUP BY galleryid, wp_ngg_pictures.pid > Notice: Undefined property: stdClass::$imagedate in /customers/7/9/7/larslofgren. > se/httpd.www/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/ > modules/nextgen_gallery_display/class.displayed_gallery.php on line 795 > [245 > identical rows left out] > WordPress database error: [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] > SELECT galleryid, COUNT(*) as counter , `wp_options`.` > option_value` AS ‘custom_post_id’, GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) > AS ‘extras’ FROM `wp_ngg_pictures` LEFT OUTER JOIN `wp_options` ON `wp_options`. > option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid) LEFT OUTER JOIN` > wp_postmeta` ON `wp_postmeta`.`post_id` = `wp_options`.`option_value` WHERE(` > galleryid` IN (27, 26, 21, 19, 25, 39, 34, 40, 56, 57, 61, 62, 70, 71, 72, > 32, 73, 77, 78, 111, 112, 115, 80, 91, 92, 93, 94, 95, 97, 98, 168, 99, 101, > 100, 110, 96)) GROUP BY galleryid, wp_ngg_pictures.pid > Notice: Undefined property: stdClass::$imagedate in /customers/7/9/7/larslofgren. > se/httpd.www/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/ > modules/nextgen_gallery_display/class.displayed_gallery.php on line 795 > [245 > identical rows left out] * I also contacted my webhost and asked for the MAX_JOIN_SIZE, which is 33 554 432 and cannot be changed. However I think the problem is the SQL query now, because the limit was so high. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Photo Gallery, Sliders, Proofing and Themes - NextGEN Gallery] NGG 2.0.40 [shortcodes] not working](https://wordpress.org/support/topic/ngg-2040-shortcodes-not-working/) * [TechnoX](https://wordpress.org/support/users/technox/) * (@technox) * [12 years, 5 months ago](https://wordpress.org/support/topic/ngg-2040-shortcodes-not-working/#post-4364685) * Hi! * I’ve been using Next Gen Gallery without any problems since 2010, but yesterday when I updated to 2.0.40 I’m getting “no images were found”, both when I’m using the NextGEN Gallery Slideshow widget and also when I use shortcodes on pages, I’ve tried with the following two codes: `[ngg_images album_ids="6" display_type ="photocrati-nextgen_basic_extended_album"]` `[album=7,extend]` * The galleries from the albums are shown (with the preview thumbnail), but when I click on any of them it says “no images were found”. * The site in question is [http://larslofgren.se/photo/foton-2008/](http://larslofgren.se/photo/foton-2008/) ( See the widget partners to the left) Viewing 2 replies - 1 through 2 (of 2 total)