Search found 78 matches

by ge_rpger
Thu Sep 13, 2012 3:06 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

So, now off to update my php and add all of these Spam Countermeasures!
by ge_rpger
Thu Sep 13, 2012 3:06 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

OK, I went through my posts in phpMyAdmin and manually (with the help of Excel) added up their data size and came up with 4.2MiB, NOT 4.2GiB!!! So, there's something somewhere adding a bunch of zeros but I can't find it. Holy crap Batman!!! Anyway, I'm sitting here trying to figure this massive thin...
by ge_rpger
Tue Sep 11, 2012 9:56 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

Table = phpbb_posts Rows = 2886 Size = 4.2 GiB As I look at my site, I have a "Recent Posts" mod on the top of the forums showing the latest posts, and they're all by someone that has been deleted, if you click on the "Last Post" icon, you get taken to the post, but said poster's...
by ge_rpger
Tue Sep 11, 2012 9:00 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

OK, I cleared out my "phpbb_search_wordmatch" tables and that was like 1.9 GiB, but my "phpbb_posts" table has 4.2 GiB in it with only 2900 posts! That can't be right can it? These are good posts, but apparently there's still something hanging up in the DB there.

Any ideas?
by ge_rpger
Tue Sep 11, 2012 4:08 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

Going through

ACP
Maintenance
Search Index

Gives be a blank page, any suggestions?
by ge_rpger
Tue Sep 11, 2012 3:13 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

OK, it appears that most of the spam is gone as well as the Spammers, but the Topic Counter and the DB size didn't decrease all that much. At the start of this, the topics/posts were relatively close in number over 600,000 each. Now, the Posts Counter reads 2892 yet the Topics Counter says 20179. If...
by ge_rpger
Tue Sep 11, 2012 2:28 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

It's weird, the topics show up under the forum, but when you actually click on it, it gives you the following error The requested topic does not exist. If you look at the forum in question, it says there's 17,000 topics and 17,013 posts. Meaning to me there are 13 good posts there presumably. It's n...
by ge_rpger
Tue Sep 11, 2012 2:03 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

OK, I've deleted about 400,000 posts (and their offending users) in one day through various attempts of MCP, "Manage Users" & "Prune Users" but there's still the question of Topics started by these Super Spammers. I'm I correct in assuming the only way to delete these topics ...
by ge_rpger
Mon Sep 10, 2012 7:09 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

OK, well thanks for the help as it does make it a little easier.

The boards only been neglected for a couple of weeks actually. This one Spammer has about 3000 posts per day! But again, thanks for the help.
by ge_rpger
Mon Sep 10, 2012 6:51 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

OK sorry, I was misunderstanding the previous posts here. I was assuming you could pull up all the posts by a particular user in the MCP and delete them that way. I have about 15 Spammers that have posted about 400,000 posts in the past few weeks and I can't delete them and their posts through the &...
by ge_rpger
Mon Sep 10, 2012 6:36 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

You can delete multiple posts at once using the moderator control panel. Then in the moderator control panel you just choose to mark all at the bottom of the page and delete. OK, I don't see this bit. Where is the mark all/delete button on the MCP? All of these posts are "approved" so the...
by ge_rpger
Mon Sep 10, 2012 5:16 pm
Forum: [3.0.x] Support Forum
Topic: Deleting spammers hangs up my board (and the server).
Replies: 30
Views: 1031

Re: Deleting spammers hangs up my board (and the server).

OK, my site has also been inundated with spammers, yes I know I should have upgraded but I didn't, and I'm trying to delete these guys, but my board hangs up as well. I tried to do it through the MCP, but I can't seem to find the option to delete users posts by page. My host wants me to use phpMyAdm...
by ge_rpger
Tue Mar 10, 2009 1:21 pm
Forum: [3.0.x] MOD Database Releases
Topic: NV recent topics
Replies: 494
Views: 56380

Re: NV recent topics

While I'd still like to change a few things in my use of this MOD, it's a great MOD as it is and thanks to all those who lent a helping hand.
by ge_rpger
Tue Mar 10, 2009 1:17 pm
Forum: [3.0.x] MOD Database Releases
Topic: Front Page News Syndication
Replies: 222
Views: 69916

Re: Front Page News Syndication

chAos, you're awesome thank you so very much!!!
by ge_rpger
Sun Mar 08, 2009 11:29 pm
Forum: [3.0.x] MOD Database Releases
Topic: Front Page News Syndication
Replies: 222
Views: 69916

Re: Front Page News Syndication

OK, well I figured something out. In the lines of code define('FORUM_ID', 61); Whatever you change that number to, is the forum it says you will be replying in, not the actual forum where the post really is. However, after you post, it shows up in the right spot. in the secondary lines of code AND (...

Go to advanced search