[hibernate-dev] Forum database banned emails issue

[Vlad Mihalcea]

Thanks Sanne,

In the Administration Control Panel -> Maintenance, there's the Admin log.
You can see there the emails that I added to the ban, along with the date
they were submitted: Fri Jan 15, 2016 9:16 am

I was thinking of deleting 5k emails from the ban list that were added at
that date.
I hope the DB records the time-stamp info, or at least we can use the Ids.

I added those progressively and when there were 40k/45k entries, the page
was still loading.

Vlad

On Sat, Jan 16, 2016 at 1:25 PM, Sanne Grinovero <sanne at hibernate.org>
wrote:

> It is documented here:
>  - https://developer.jboss.org/wiki/ForumsAdministrationAccess
>
> However as you can see it's not easy to get to. You need to hop around
> several security checks and get authorization from each party.
>
> I can help with this as I already have access - if I remember the
> whole process ;-) - but you'll have to describe what you want me to do
> exactly. Do I need to wipe a large amount of data from a table? And do
> you have some example data to help me make sure I'm wiping the right
> table? Also please let me know if this is urgent: seems like a quite
> delicate matter and since I'm having a bit of fever now I'm afraid I'd
> mess up with the production db :)
>
> Sanne
>
> On 15 January 2016 at 22:09, Steve Ebersole <steve at hibernate.org> wrote:
> > Sorry, I have no idea.  That information is not listed in our private
> wiki
> > area.  For anyone who knows this information, could you also update that
> > resources page?
> >
> > On Fri, Jan 15, 2016 at 4:57 AM Vlad Mihalcea <mihalcea.vlad at gmail.com>
> > wrote:
> >
> >> Hi,
> >>
> >> I tried to import the last 24 hour forum spam emails form
> >> https://www.stopforumspam.com/, which is around 50k email entries.
> >>
> >> The email were imported, but now the banned email page of the forum
> doesn't
> >> load anymore.
> >> The problem is related to how phpBB renders the page since there's a
> >> dropdown where all emails must listed.
> >>
> >> Could someone delete a part of those entries or give me access to the
> DB so
> >> I can remove them myself?
> >>
> >> Vlad
> >> _______________________________________________
> >> hibernate-dev mailing list
> >> hibernate-dev at lists.jboss.org
> >> https://lists.jboss.org/mailman/listinfo/hibernate-dev
> >>
> > _______________________________________________
> > hibernate-dev mailing list
> > hibernate-dev at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/hibernate-dev
>