Thread

Just started getting this error whenever I try to edit or post new content to channels after upgrading from 2.3.1 to 2.5.1:

A Database Error Occurred
Error Number: 3

Error writing file '/dev/shm/MYjOUCng' (Errcode: 28)

SELECT `exp_members`.`member_id`, `exp_members`.`group_id`, `exp_members`.`username`, `exp_members`.`screen_name`, `exp_members`.`in_authorlist` FROM (`exp_members`) JOIN `exp_member_groups` ON `exp_member_groups`.`group_id` = `exp_members`.`group_id` WHERE (exp_members.in_authorlist = "y" OR exp_member_groups.include_in_authorlist = "y") AND `exp_members`.`group_id` = exp_member_groups.group_id AND `exp_member_groups`.`site_id` = '1' ORDER BY `exp_members`.`screen_name` ASC, `exp_members`.`username` ASC

Filename: models/member_model.php

Line Number: 940

Interestingly, while troubleshooting I accidentally reverted to my 2.3.1 system folder and the forms started working again. Error code says it’s a disk space problem, but so far troubleshooting that hasn’t gotten me anywhere.

Hi Seamus,

I do empathize with your frustration.

The accidental rollback is interesting because the line the error points to is a deprecated function in 2.4 Which means in 2.3.1 line 940, or the method that is called when you publish/edit content, is different.

Have you checked with your host to ask about the disk space issue? How many members/authors does the site have?

Cheers,

Thanks for the feedback Dan. Not too frustrated, just how things roll sometimes. It does look like it’s that new get_authors function that was breaking the site. Overloading the memory trying to build the author drop down menu.

Root problem is 315K members, 90% spam registrations (tables totaling 250 MB). So first I trimmed down the query in get_authors to not check member_groups to allow members to show up in the drop down menu and just check their profile. That got us back online until EngineHosting was able to install more memory and temporarily resolve the problem.

The fun continues and now I’m tasked with figuring out how to identify and purge the vast sea of garbage clogging up the database (we’ve suspended further signups & neutered profiles to remove the incentive). I’ve looked high and low for some advice on writing a query to delete pending members (50K, all crap), but still haven’t found much. Before I attempt to roll my own, is there anything you’ve come across to help with this type of problem?

Hi Seamus,

I’m glad to see we were able to sleuth out a direction.

I haven’t come across any utilities to make this easy. But, if you are confident that all members in the Pending group are trash, you can get rid of them based on the group_id

Not elegant, but effective.

Is there anything else I can assist you with?

Cheers,

That’s what I was expecting. I’m good for now. Thanks for your assistance Dan.

Hi Seamus,

My pleasure!

If there’s anything else you need, please just let us know.

Cheers!