Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Bulk delete posts

Started by nizarala, January 12, 2015, 04:59:20 PM

Previous topic - Next topic

Hj Ahmad Rasyid Hj Ismail

Smart solution. +1 Fortytwo.


DO NOT pm me for support!


I noticed since 25 December untill today only spam topics was opened and 400 pages...I need to delete them as bulk,
I want to use PHPMYADMIN for this;  DELETE FROM smf_messages WHERE poster_time BETWEEN 1388534401 AND 1420070399

But I did not understand how to enter BETWEEN ..... AND ......

can you help me please ?


You should not delete messages directly in phpmyadmin - you will screw things up if you do..

The instructions are not to delete the messages directly in the database, but rather to reassign those messages to a single user and then use the INTERNAL FORUM FUNCTION to delete the user and all messages.

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."