Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Can't Delete Members: Error Code 1146

November 24, 2012 1:54pm

Subscribe [1]

#1 / Nov 24, 2012 1:54pm

tylonius
4 posts

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