Thread

I originally posted this in the Tech Support forum over the Thanksgiving holiday. Now, it no longer exists (even though there was a message that said it would be back in full force on Monday).

Anyway, here’s the issue:

I’ve seen a number of threads that have this issue related to the Comments module, but my issue is slightly different:

I’m trying to delete 500,000+ spam registrations – all of them in the Pending group – and I’m getting the following error:

A Database Error Occurred
Error Number: 1146

Table ‘database_name.exp_message_listed’ doesn’t exist

DELETE FROM `exp_message_listed` WHERE `listed_member` IN ([query])

Filename: models/member_model.php

Line Number: 582

I’ve gone through the bug reports and the resolutions all seem to be Comments module-specific.

Can anyone please help with this?

Thanks,

ty

v2.4.0 - Build: date 20120123

Hi ty,

Login to your db via phpMyAdmin or the like and check to make sure you see the ‘exp_message_listed’ table. If it’s not there then this is your issue. If it is there check it to make sure it’s not corrupted.

Cheers,

Mike

I knew the table doesn’t exist. It shouldn’t exist, because there are no messaging functions being used within the site – or if it did, it shouldn’t be populated.

I added a blank table called exp_message_listed, and that seems to have done the trick.

Now, I just need to figure out a way to delete 500,000 pending members without having to go page by page. I added

&perpage=5000

to the end of the query string, but it’s still time-consuming.