TechnoX

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.