Categories and forums not showing on index

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
Brf
Support Team Member
Support Team Member
Posts: 51349
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf » Thu Apr 26, 2018 2:13 pm

Brf wrote:
Wed Apr 25, 2018 6:58 pm
your auto-increment is set to 2, instead of 1.
This means that all of the default group assignments and permissions are being given to the wrong groups.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49557
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Categories and forums not showing on index

Post by stevemaury » Thu Apr 26, 2018 2:37 pm

Yep, it is autoincrementing by two. Those groups should be number 1 through 7.

I started to write some SQL that would renumber the groups, but then I realized that the group_id is used in many tables, including the permissions tables. I think that it could all be patched up by renumbering the groups to their defaults and then changing the group_ids in every table to the defaults, but it would be a job.

New groups being incremented by two should not be a problem. What the effect might be of other autoincrementing values being incremented by two, I do not know.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Thu Apr 26, 2018 2:44 pm

i understand and manual fix would be tough enough
but it is possible nowadays fix this in future release? sql master-master configuration is nothing bad or special and should be supported as well if there are no undesirable consequences

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

Re: Categories and forums not showing on index

Post by david63 » Thu Apr 26, 2018 2:54 pm

x-rated wrote:
Thu Apr 26, 2018 2:44 pm
but it is possible nowadays fix this in future release?
For that to happen it will need to be reported in the Bug Tracker.

As I see it it is not a problem with the numbering as such but the fact that, in this case, group ids are being used and not group names. If I am not mistaken there were similar issues with upgrades from phpBB 2.x with some tables which is why group (or whatever table) names should always be used to "grab" the id if that is what is needed.
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

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51349
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf » Thu Apr 26, 2018 3:13 pm

These are not the only tables that are auto-increment.
Take acl_options and acl_roles for instance . The acl_roles are being filled properly, using the option names, but the acl_users and acl_groups are being filled by number, assuming the acl_roles and forum_ids are incremented by 1.

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Mon Apr 30, 2018 11:13 am

so should i report this in bugtracker? and how exactly to write it? :)

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

Re: Categories and forums not showing on index

Post by Mick » Mon Apr 30, 2018 11:34 am

Just a short précis and link back to this topic.
"The more connected we get the more alone we become" - Kyle Broflovski

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

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51349
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf » Mon Apr 30, 2018 11:36 am

That is not going to help your problem though. You need to find a host that has auto-increment set to 1, like most hosts.

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Mon Apr 30, 2018 12:02 pm

Mick wrote:
Mon Apr 30, 2018 11:34 am
Just a short précis and link back to this topic.
the problem is with sql auto-increment
phpbb for some reason expects auto-increment set to 1, which is impossible with sql master-master configuration

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Wed May 02, 2018 7:11 pm

if i install forum on another webhosting and import its database to forum on webhosting with sql master-master configuration, should this work correctly?
i mean there won't be any other database tables created later on master-master (live) server, right? so no more problems with auto-increments during forums life, everything will be created on another webhosting from before
(as a dirty temporary solution until someone will decide to improve compatibility with such sql configuration)

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: enter a valid email, Heuerman, janus_zonstraal, naamer, Webmasterks and 97 guests