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: 53398
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf »

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: 52768
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 »

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.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
x-rated
Registered User
Posts: 36
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated »

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
Registered User
Posts: 20646
Joined: Thu Dec 19, 2002 8:08 am

Re: Categories and forums not showing on index

Post by david63 »

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!

I now no longer support any of my extensions but they will start to become available here
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53398
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf »

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: 36
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated »

so should i report this in bugtracker? and how exactly to write it? :)
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26502
Joined: Fri Aug 29, 2008 9:49 am

Re: Categories and forums not showing on index

Post by Mick »

Just a short précis and link back to this topic.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53398
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf »

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: 36
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated »

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: 36
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated »

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”