Mysql help

[yluh]

2 days ago 42.000 users registered my forum ( v 3.07 ) and all of them in Users Awaiting Email Confirmation groups i tried delete all via Prune/Move user but i couldnt because there is an eror which says " internal server eror " all of our tries in vain.Now we decide to delete this users by deleting their user id in mysql.But i dont know how to do it...Please explain me that how can i do this.Its really important..

Thank you.

[Andreas]

Internal Server Error sounds bad.

Did you look up in Apache error_log?

[yluh]

Server eror caused from our host, but itsnt our first problem now tries to delete user by their user id for example from 900.........to ......45.000 all of ids dlete from mysql .

How can i do it from .php mysql ?

Please explain me how do it step by step.

[Marco van Herwaarden]

Asuming that they are still in the awaiting email confirmation usergroup, and haven't done anything (posting for example) the following query SHOULD do the trick. Mind that this is not tested. Make sure you backup your database first.

DELETE FROM user AS u, useractivation as ua, userfield as UF, usertextfield as utf
WHERE u.usergroupid = 3
and u.userid=ua.userid
and u.userid=uf.userid
and u.userid=utf.userid;

If you are using a tableprefix, add that before each tablename.

After this is finished, you should optimize these tables:
OPTIMIZE TABLE user, useractivation, userfield, usertextfield

[yluh]

Thank you for your replay i will share your post with my other admin friends.