Delete All Spam Results in Blank Page

yottabit

Joined: 2004-02-25
Posts: 36
Posted: Wed, 2010-01-06 23:39

I'm using Akismet and occasionally spam gets through the filters. I see about 5 spam comments get through per week. Finally today I went to review all comments flagged for moderation and found that I had 3,850 spam comments (77 pages of 50 each).

The problem is that when I click the Delete All Spam button, I very quickly (within 2-3 seconds) just receive a blank page with no source code. I have turned on debugging and there's no difference.

Anyone have ideas of what else I can try to flush out all these spam comments?

My config is below. (And incidentally, I'm running Apache, not Lighttpd... interestingly enough I ran Lighttpd for a while, but it's no longer even on the server... dunno where this information is pulled from... "Server version: Apache/2.2.11 (Ubuntu)".)

Edit: so when I click the Delete All Spam button I do not see any activity in my apache log file, but I do see this in my apache error log:

Can't read dir of '/etc/mysql/conf.d/' (Errcode: 24)
Fatal error in defaults handling. Program aborted

Edit2: I removed the log files in g2data and re-ran system info and now apache is reported. The updated configuration is below.

Gallery URL = http://jacobmcdonald.net/gallery2/main.php
Gallery version = 2.3.1 core 1.3.0.1
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.6-3ubuntu4.4 apache2handler
Webserver = Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.4 with Suhosin-Patch
Database = mysqli 5.0.75-0ubuntu10.2, lock.system=flock
Toolkits = LinkItemToolkit, Thumbnail, Gd, Dcraw, ImageMagick, Ffmpeg, NetPBM, jpegtran, ArchiveUpload, Exif, Getid3
Acceleration = partial/21600, partial/21600
Operating system = Linux eddie 2.6.28-17-server #58-Ubuntu SMP Tue Dec 1 22:13:36 UTC 2009 x86_64
Default theme = siriux
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729)
Rows in GalleryAccessMap table = 103
Rows in GalleryAccessSubscriberMap table = 18890
Rows in GalleryUser table = 6
Rows in GalleryItem table = 18883
Rows in GalleryAlbumItem table = 483
Rows in GalleryCacheMap table = 0
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2010-01-07 17:17

What's your memory limit set at?

And based on what I'm seeing (double-clicking on thumb to get to photo) results in an error. I'm guessing something is not configured just right at the server. Though someone else thinks that particular issue is with Gallery, he did come up with a hack to work around his server issue:
http://gallery.menalto.com/node/90625

I don't know if that'll fix your problem, it may be worth a shot. And I'd start searching google for this Can't read dir of '/etc/mysql/conf.d/' (Errcode: 24)
 and variations on that error message.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
yottabit

Joined: 2004-02-25
Posts: 36
Posted: Thu, 2010-01-07 19:32

You're getting errors browsing my gallery? I am not...

Here are my PHP limits, which you'll see are quite high... the server has plenty of RAM to spare and 4 cores, so I set it high.

max_execution_time	300	300
max_file_uploads	50	50
max_input_nesting_level	128	128
max_input_time	600	600
memory_limit	256M	256M
post_max_size	256M
upload_max_filesize	256M	256M