I want to delete a category with more than 100 topics.. How can i do it? :D
If someone hav a good sql comand.. :P
Um, you can do it through the normal SMF 2 system.
Admin section -> 'Forum' menu -> 'Boards' tab -> 'Modify Boards' tab -> Click 'Modify' for the relevant category, and then click "Delete Category".
You will then be asked if you want to delete the boards or not, check this setting to delete all the data in that category.
Quote from: LHVWB on June 26, 2008, 05:30:15 PM
Um, you can do it through the normal SMF 2 system.
Admin section -> 'Forum' menu -> 'Boards' tab -> 'Modify Boards' tab -> Click 'Modify' for the relevant category, and then click "Delete Category".
You will then be asked if you want to delete the boards or not, check this setting to delete all the data in that category.
I tryed.. but i get this error:
Got a packet bigger than 'max_allowed_packet' bytes
File: /home/********/public_html/********/********/Sources/RemoveTopic.php
Line: 278
So i need to hide for normal users this category.. the problem is just with db because is bigger.. :(
that would be an error the server is generating. Its saying that the server's restricting you from sending PHP that much data, basically.
i could give you a sql query to delete the boards in that category but that would cause errors within your install (such as all the now orphaned topics), log entries, etc.
have you tried using quick moderation to remove/move some of the topics to a new board/trash bin, thus cutting down on passing too much data to the server?
Quote from: metallica48423 on June 30, 2008, 01:59:28 AM
that would be an error the server is generating. Its saying that the server's restricting you from sending PHP that much data, basically.
i could give you a sql query to delete the boards in that category but that would cause errors within your install (such as all the now orphaned topics), log entries, etc.
have you tried using quick moderation to remove/move some of the topics to a new board/trash bin, thus cutting down on passing too much data to the server?
Yes.. I have tried "Remove Old Posts " option but i get this error "Unable to verify referring url. Please go back and try again. "
And i tried also "Move Topics", and he said that finish but any topic was moved..
:(
If you want to delete the category and it wont allow you to do the whole thing. Firstly do you have the 'trash bin' on for deleted posts? Turn that off. Then make sure you have checkbox moderation on and delete the messages in batches, say of 50. This should reduce server load. Then once it's empty or less post in that category, then try to do a blanket deletion of that category.