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)
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
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
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.
"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
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)