albertotomato

I’ve resolved this issue (NG 1.2.2, WP 2.7.1) with a quick and dirty hack to nextgen-gallery/admin/functions.php. Try to change your check_quota() function (line 712) with this:

function check_quota() {
		// Only for WPMU
			if ((IS_WPMU))
			{
                $ngg_options = get_site_option('ngg_options');
                if($ngg_options['wpmuQuotaCheck'] && $error = upload_is_user_over_quota( false ) ) {
					nggGallery::show_error( __( 'Sorry, you have used your space allocation. Please delete some files to upload more files.','nggallery' ) );
					return true;
				}
			}
			return false;
	}

Don’t know if this fixes your problem, but hope it helps.

Hi burekc, same problem here.
EXPLAIN says that the query is “Using where; Using temporary; Using filesort” – and with large tables this is evil.
My posts table is half yours, but performances are equally poor. These are useful resources:

https://dev.mysql.com/doc/refman/5.0/en/group-by-optimization.html
https://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html

I’m trying to get to the point. Do you have some news?
Thanks.

[gallery] tag is only interpreted if the_content() function is used within the template. I had the same problem until i figured out that i was using echo get_the_content() instead of the_content(). Hope it helps.

Bump. (sorry! ??