Igiss
08-04-2012, 02:01 PM
It's probably my first post on this board. I'm administering a relatively quiet message board hosted on shared hosting, which is enough for us since we aren't that large or active. However, we do get a lot of spam registrations and we enabled the member moderation queue.
It was not cleared for quite a long time now, several months. Now, any attempts to remove or approve members (either all of them at once, or even a single one) result in this error:
500 Server Error
A misconfiguration on the server caused a hiccup. Check the server logs, fix the problem, then try again.
This probably happens because the shared host doesn't allow to perform performance-intensive operations on the database. I've tried optimizing/fixing database, rebuilding user info and so on, but nothing changes the result of this.
We now need help on how to clear the moderation queue. Even removing all unapproved members would help. We can probably do that via a mysql query (in phpmyadmin, for example, which the host does provide, or in the forum admincp itself), but I'm not sure what the query should be.
Or, alternatively, maybe there's a mod to perform such operation, but then again I tried searching the mods here but found nothing relevant.
Thanks in advance, we'll appreciate any help.
It was not cleared for quite a long time now, several months. Now, any attempts to remove or approve members (either all of them at once, or even a single one) result in this error:
500 Server Error
A misconfiguration on the server caused a hiccup. Check the server logs, fix the problem, then try again.
This probably happens because the shared host doesn't allow to perform performance-intensive operations on the database. I've tried optimizing/fixing database, rebuilding user info and so on, but nothing changes the result of this.
We now need help on how to clear the moderation queue. Even removing all unapproved members would help. We can probably do that via a mysql query (in phpmyadmin, for example, which the host does provide, or in the forum admincp itself), but I'm not sure what the query should be.
Or, alternatively, maybe there's a mod to perform such operation, but then again I tried searching the mods here but found nothing relevant.
Thanks in advance, we'll appreciate any help.