left over remnants!

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
sakm
Registered User
Posts: 545
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

left over remnants!

Post by sakm » Wed Nov 06, 2019 6:48 pm

I have had my forum for around 13 years and as a result of years of mods and updates to extensions the database has left over remnants!

The database is full of old data that could really do with cleaning up!

But as a result of these left over bits I have this issue below
admin perms.jpg
As you can see these are in the permissions>> Admin roles section

Looking through the database these entries look to be in the acl_options table

Would it be safe to just remove them from the table via phpMyAdmin or will I have more issues

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21681
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: left over remnants!

Post by Mick » Wed Nov 06, 2019 6:51 pm

Please fill out the Support Request Template and post it back here to enable us to assist you better.
"The more connected we get the more alone we become" - Kyle Broflovski

User avatar
Lumpy Burgertushie
Registered User
Posts: 66858
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: left over remnants!

Post by Lumpy Burgertushie » Wed Nov 06, 2019 6:55 pm

no, don't do this in the database.
go in your board admin panel, system tab
left menu, at the bottom, module management

go through each of the sections and remove any modules that look like those you see in the permssions.

the ones in all caps with underbard between the words.

you will most likely have to remove the children of some of them.
if the circle icon has a small circle on top of it then it has children.

keep digging down until you get to the one with no children and delete it
then back up each lever deleting the module .

then do the same for the next one you see.
rinse/repeat.

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

sakm
Registered User
Posts: 545
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: left over remnants!

Post by sakm » Wed Nov 06, 2019 7:00 pm

Lumpy Burgertushie wrote:
Wed Nov 06, 2019 6:55 pm
no, don't do this in the database.
go in your board admin panel, system tab
left menu, at the bottom, module management

go through each of the sections and remove any modules that look like those you see in the permssions.

the ones in all caps with underbard between the words.

you will most likely have to remove the children of some of them.
if the circle icon has a small circle on top of it then it has children.

keep digging down until you get to the one with no children and delete it
then back up each lever deleting the module .

then do the same for the next one you see.
rinse/repeat.

robert
Been there and done that already and there is nothing there that shouldn't be!


Support Request Template
What version of phpBB are you using? phpBB 3.2.8
What is your board's URL? www.themotorbikeforum.co.uk
Who do you host your board with? futurehosting
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.2.7
What extensions do you have installed? 24 hour activity stats
Advertisement Management
Board Announcements
Board Rule
External Links Open in New Window
Lightbox
New user default settings
Obscure Contact Us
Pages
PayPal Donation Extension
phpBB Media Embed PlugIn
Quoted Images as Thumbnails
Simple mentions
Thanks for posts
Topic Preview
What styles do you currently have installed? SE Square Left , AllanStyle-SUBSILVER, prosilver
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Not sure when the problem came about I just noticed it today!
Please describe your problem. See first post above as to the issue with image
Generated by SRT Generator

User avatar
Lumpy Burgertushie
Registered User
Posts: 66858
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: left over remnants!

Post by Lumpy Burgertushie » Wed Nov 06, 2019 7:07 pm

well, maybe it would be under permissions tab and under roles since that is what your screen shot is showing.
should be able to edit and/or delete those permissions in the individual roles from there.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

User avatar
warmweer
Registered User
Posts: 3055
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: left over remnants!

Post by warmweer » Wed Nov 06, 2019 7:10 pm

You have
ACL_A_ADS
ACL-A_MODS
ACL_A_GALLERY
etc
These are either due to a MOD (perhaps from 3.0) or from incorrectly installed (or uninstalled) extensions.
The names should ring a bell and tell you which extensions/MOD they originate from.
If they are from extensions, then put back the extensions, clear board cache, disable the extensions, and delete data before removing them.
The year is 2192. The British Prime Minister visits Brussels to ask for an extension of the Brexit deadline. No one remembers where this tradition originated, but every year it attracts many tourists from all over the world.

sakm
Registered User
Posts: 545
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: left over remnants!

Post by sakm » Wed Nov 06, 2019 7:12 pm

Lumpy Burgertushie wrote:
Wed Nov 06, 2019 7:07 pm
well, maybe it would be under permissions tab and under roles since that is what your screen shot is showing.
should be able to edit and/or delete those permissions in the individual roles from there.


robert
That where I headed first but this is all I have under that

Clicking on each one opens up to nothing in there
admin perms.jpg

sakm
Registered User
Posts: 545
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: left over remnants!

Post by sakm » Wed Nov 06, 2019 7:14 pm

warmweer wrote:
Wed Nov 06, 2019 7:10 pm
You have
ACL_A_ADS
ACL-A_MODS
ACL_A_GALLERY
etc
These are either due to a MOD (perhaps from 3.0) or from incorrectly installed (or uninstalled) extensions.
The names should ring a bell and tell you which extensions/MOD they originate from.
If they are from extensions, then put back the extensions, clear board cache, disable the extensions, and delete data before removing them.
Yes they will be from mods from 3.0

Before upgrading I uninstalled all mods and used the STK to remove all unwanted data but I still have some left

sakm
Registered User
Posts: 545
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: left over remnants!

Post by sakm » Wed Nov 06, 2019 10:29 pm

Fixed

I backed up the acl_options table via phpMyAdmin then went ahead and deleted the relevant parts

all the above issues are gone with no affects that I have seen!

User avatar
warmweer
Registered User
Posts: 3055
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: left over remnants!

Post by warmweer » Wed Nov 06, 2019 10:44 pm

sakm wrote:
Wed Nov 06, 2019 10:29 pm
Fixed

I backed up the acl_options table via phpMyAdmin then went ahead and deleted the relevant parts

all the above issues are gone with no affects that I have seen!
:thumbsup: It's probably something I would have tried also but I'ld have done a table compare with a clean table first (including field definitions).

Editing the database should generally only be done if you really understand the implications (and never without having a database backup).
In your case (I had a look at your phpBB history ;)) I don't think there was any risk involved so (even if it hadn't worked) it was probably the right thing to try.

So ... glad it worked out well but it shouldn't be considered as a recommendation for others with (in a more or less similar situation).
The year is 2192. The British Prime Minister visits Brussels to ask for an extension of the Brexit deadline. No one remembers where this tradition originated, but every year it attracts many tourists from all over the world.

sakm
Registered User
Posts: 545
Joined: Sun Jan 21, 2007 8:14 pm
Location: Hull, uk
Name: Stu
Contact:

Re: left over remnants!

Post by sakm » Wed Nov 06, 2019 10:57 pm

warmweer wrote:
Wed Nov 06, 2019 10:44 pm
sakm wrote:
Wed Nov 06, 2019 10:29 pm
Fixed

I backed up the acl_options table via phpMyAdmin then went ahead and deleted the relevant parts

all the above issues are gone with no affects that I have seen!
:thumbsup: It's probably something I would have tried also but I'ld have done a table compare with a clean table first (including field definitions).
Yup I also did that :lol:

Sometimes its the only way to see what will happen by giving it a go! providing you make a back up first everything can be undone if it goes wrong

Normally I would create a direct copy of the database and run a copy of the files in a separate environment but with the back up and alterations being so small it can easily and quickly be reversed :)

Post Reply

Return to “[3.2.x] Support Forum”