Forums structure is very strange

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
vinamarine
Registered User
Posts: 49
Joined: Wed Feb 14, 2007 12:43 pm
Location: Vietnam
Contact:

Forums structure is very strange

Post by vinamarine »

I'm running phpBB 3.0.2.
My forums structure are as below:
Category1
--Forum A
--Forum B
----Sub-Forum1
----Sub-Forum2
Category2
--Forum D
--Forum E
----Sub-Forum4
----Sub-Forum5
Those above display one index page as the same as the the structure above.

But, I found the different structure in the drop box (when using "move topic" function or when create new forum/category in ACP).
Drop box shows the different structure
Drop box shows the different structure
wrong_structure.jpg (26.3 KiB) Viewed 158 times
I was not like that before. I happened after I changed the parent forum of a sub-forum

Please note, Those forum above display correctly on index page as the same as the the structure above. In the drop box, I found that Forum E is a sub-forum of Forum D. It is real wrong.

Anyone know what field of forum table of the database is to decide these? Could anyone help me?
User avatar
jimdunn
Registered User
Posts: 1570
Joined: Tue Mar 25, 2008 11:49 am
Location: Australia

Re: Forums structure is very strange

Post by jimdunn »

Could you please fill out the Support Request Template.

Also please tell us if you get any errors if you try to move a forum in the ACP, and what the error message is, if you do.
vinamarine
Registered User
Posts: 49
Joined: Wed Feb 14, 2007 12:43 pm
Location: Vietnam
Contact:

Re: Forums structure is very strange

Post by vinamarine »

Thank you for your reply. Please find my detailed information as the followings:

My board's URL: http://www.vinamaso.net/forum/
Version of phpBB3: 3.0.2
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? It was upgraded from phpBB 3.0.1
Did you use an automated wizard provided by your host to install phpBB? No, I did not
MODs I have installed: Prime Quick Login, hoteditor_phpbb_mod, Last post tiltle, Prime Link, TS Gallery, LatexRender
When the problem started: When I tried to rearrange forum structure (layout), moving some sub-forums to other forums. It was phpBB 3.0.1 that time. Now the board is phpBB 3.0.2
Mylevel of expertise (be honest): basic PHP & MySQL knowledge

Additionally,
Template(s) used: Prosilver
Language(s) used: Vietnamese, English
Version of PHP used: 5.1.6
Database and version used: MySQL 5.0.22. I'm using MySQLi

By the way, could you please let me know for what the left_id and right_id columns of %_forums table are used?
Thank you a lot!
Last edited by vinamarine on Sun Jul 27, 2008 5:49 am, edited 1 time in total.
vinamarine
Registered User
Posts: 49
Joined: Wed Feb 14, 2007 12:43 pm
Location: Vietnam
Contact:

Re: Forums structure is very strange

Post by vinamarine »

jimdunn wrote: Also please tell us if you get any errors if you try to move a forum in the ACP, and what the error message is, if you do.
I did not get any errors or message when moving a forum in the ACP. But it behaves very strange.
for an example, Forum C and Forum D belong to Category 2. In the index page, Forum C is shown as sub of Forum B in the Category 1. When I delete Forum C, Forum D is display as sub of Forum B in the Category 1 (After deleting, Forum C is replaced with Forum D in the index page).

The structure:
Category 1
--Forum A
--Forum B
Category 2
--Forum C
--Forum D

In the index page
Category 1
--Forum A
--Forum B
----Forum C
Category 2
--Forum D

After deleting Forum C, the index page becomes:
Category 1
--Forum A
--Forum B
----Forum D
Category 2

I hope my explanation is clear, I'm very confused!!! :shock:
Look forwards to your earliest and positive reply...
User avatar
jimdunn
Registered User
Posts: 1570
Joined: Tue Mar 25, 2008 11:49 am
Location: Australia

Re: Forums structure is very strange

Post by jimdunn »

vinamarine wrote:By the way, could you please let me know for what the left_id and right_id columns of %_forums table are used?
Thank you a lot!
They are used to generate the forum "tree" structure, and it does rather sound as though that may be damaged in your case.

I can't guarantee this will help, but here's a link to some instructions and a script that has fixed that problem for a few people, but please note the advice about backing up your database before trying it.
http://www.phpbb.com/community/viewtopi ... 5#p5975935

(if you don't know how to backup your database, look here)
vinamarine
Registered User
Posts: 49
Joined: Wed Feb 14, 2007 12:43 pm
Location: Vietnam
Contact:

Re: Forums structure is very strange

Post by vinamarine »

Thank you!
I have done it.
The script is not 100% perfect for me, I manually had to fix 2 sub-forums. BUT, it is really great script. It save my tone of time.

Thank you, jimdunn! You make my life easier.
I wish to have been able to buy a beer for you :D
User avatar
jimdunn
Registered User
Posts: 1570
Joined: Tue Mar 25, 2008 11:49 am
Location: Australia

Re: Forums structure is very strange

Post by jimdunn »

That's great.
And thank you for the feedback on how it worked out, too - that's useful.

The script actually came from Paul - a member of the MOD team here :)

I was just about to open a beer - so I'll pretend you sent it - thanks ;)
Locked

Return to “[3.0.x] Support Forum”