Sections visually disappeared but still in database/ACP

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
JohnCarer
Registered User
Posts: 6
Joined: Wed Apr 18, 2018 12:12 am

Sections visually disappeared but still in database/ACP

Post by JohnCarer » Wed Apr 18, 2018 12:34 am

Hi,

We are running 3.1.9 version of phpBB with 5.5 mySQL database server. Recently we've come across a problem where after deleting one sub-section and creating another to replace its place would result in a bug that would render the whole section invisible but still accessible via admin control panel link (if user who noticed it had it open otherwise impossible to find). Moreover, the 'lost' section would scrap across random places on the forum and appear in random sections which has no associations with the initial section.

This issue happens from time to time and we have no idea what could be causing it, or how to restore the missing section (with around 7-8 of its sub sections).

User avatar
david63
Jr. Extension Validator
Posts: 14900
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Sections visually disappeared but still in database/ACP

Post by david63 » Wed Apr 18, 2018 6:13 am

Can you explain what you mean by "sections" - are they board categories, board forums, tabs in the UCP or something else.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

JohnCarer
Registered User
Posts: 6
Joined: Wed Apr 18, 2018 12:12 am

Re: Sections visually disappeared but still in database/ACP

Post by JohnCarer » Wed Apr 18, 2018 10:34 am

I've included images to make abbreviations neutral. We have always referred to them as sections.
If it helps, I also noticed an error when this happened saying "this board has no forum" or something in that way. It basically had no ID (https://Censored/forum/viewforum.php?f=ID) or replaced the ID of another section ending up in a mix which couldn't be fixed. Deleting would only make things worse.

Image
Image

David, thanks for your interest in helping out. Looking forward to your reply

JohnCarer
Registered User
Posts: 6
Joined: Wed Apr 18, 2018 12:12 am

Re: Sections visually disappeared but still in database/ACP

Post by JohnCarer » Fri Apr 20, 2018 3:29 pm

Bump

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

Re: Sections visually disappeared but still in database/ACP

Post by Lumpy Burgertushie » Fri Apr 20, 2018 5:16 pm

double check your permissions for the categories and forums that you are dealing with.

if you create a new category and/or forum you must either create permissions or copy permissions from another category or forum so that you can see them on the page.

just to be clear, what you call sections are either catagories or forums and then sub forums under the forums.


helps to use the correct terminology so that we know what you are talking about and so that you know what we are talking about.

robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

JohnCarer
Registered User
Posts: 6
Joined: Wed Apr 18, 2018 12:12 am

Re: Sections visually disappeared but still in database/ACP

Post by JohnCarer » Fri Apr 20, 2018 6:03 pm

Lumpy Burgertushie wrote:
Fri Apr 20, 2018 5:16 pm
double check your permissions for the categories and forums that you are dealing with.

if you create a new category and/or forum you must either create permissions or copy permissions from another category or forum so that you can see them on the page.

just to be clear, what you call sections are either catagories or forums and then sub forums under the forums.


helps to use the correct terminology so that we know what you are talking about and so that you know what we are talking about.

robert
Ok, thank you. Is there any way we can access or return the missing categories? They are nowhere to be found but they are still in database (not deleted, just unassigned).

User avatar
GanstaZ
Registered User
Posts: 565
Joined: Wed Oct 11, 2017 10:29 pm
Location: Zverse

Re: Sections visually disappeared but still in database/ACP

Post by GanstaZ » Fri Apr 20, 2018 6:16 pm

As i understand, the id's of those forums still exist and parent was deleted, before moving sub under new category? If yes and you can see those forums in acp, why not move those under new parent?
"When answer lies in the question,.. question becomes redundant!"

JohnCarer
Registered User
Posts: 6
Joined: Wed Apr 18, 2018 12:12 am

Re: Sections visually disappeared but still in database/ACP

Post by JohnCarer » Fri Apr 20, 2018 11:10 pm

GanstaZ wrote:
Fri Apr 20, 2018 6:16 pm
As i understand, the id's of those forums still exist and parent was deleted, before moving sub under new category? If yes and you can see those forums in acp, why not move those under new parent?
Unfortunately I haven't saved the link (it was only visible through link I had open). The sections aren't visible directly from ACP either. At the time, moving those 'bugged' categories under new ones would result in a same bug appearing with the section where it's moved to, or something worse, like whole forum (a bunch of categories) getting mixed or disappearing.

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

Re: Sections visually disappeared but still in database/ACP

Post by Mick » Sun Apr 22, 2018 8:09 am

Have you looked in your browser history, the link may still be in there?
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.

JohnCarer
Registered User
Posts: 6
Joined: Wed Apr 18, 2018 12:12 am

Re: Sections visually disappeared but still in database/ACP

Post by JohnCarer » Sun Apr 22, 2018 2:44 pm

Mick wrote:
Sun Apr 22, 2018 8:09 am
Have you looked in your browser history, the link may still be in there?
No...it's been weeks since that. Even if I had the link moving the bugged categories anywhere would only result in more bugs as mentioned in my last reply.

User avatar
GanstaZ
Registered User
Posts: 565
Joined: Wed Oct 11, 2017 10:29 pm
Location: Zverse

Re: Sections visually disappeared but still in database/ACP

Post by GanstaZ » Sun Apr 22, 2018 3:35 pm

There's always a method to go back in time with backup. It may not be the best thing to do, but if there is one, made before the problem occurred, then it will solve that problem. Maybe it can be fixed with some sql commands, but i don't know how)
"When answer lies in the question,.. question becomes redundant!"

SlobberySam
Registered User
Posts: 20
Joined: Fri Mar 23, 2018 7:13 pm

Re: Sections visually disappeared but still in database/ACP

Post by SlobberySam » Mon Apr 23, 2018 9:07 pm

Seems the left and right IDs have been misplaced. I too have suffered this, and it does not seem there is currently a way to fix this inline through the ACP. If you have file access to the web server, you can upload fix_ids.php to your main directory. Once uploaded, access the file through your browser and let it run, it will rebuild IDs based on other links. Delete it once done, this works across all 3.0/3.1/3.2 versions affected.

Ensure you take a backup (only the database is necessary, as no files change) prior to performing this.

Locked

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: No registered users and 19 guests