Unable to create a new group

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
richxrich
Registered User
Posts: 34
Joined: Mon Nov 21, 2016 9:17 am

Unable to create a new group

Post by richxrich » Tue Dec 05, 2017 4:40 am

I've been trying to create a new group within our forum, but am getting an error (see below). I'm not sure why we're getting this error or how to go about fixing it. Any suggestions would be appreciated. Thanks in advance!

We're are on 3.2.1.
Attachments
phpbb_error.png
Last edited by richxrich on Thu Dec 07, 2017 12:38 am, edited 1 time in total.

User avatar
AmigoJack
Registered User
Posts: 4995
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Unable to create a new group

Post by AmigoJack » Wed Dec 06, 2017 8:38 am

My first suggestion is to use the attachment feature here for your screenshots instead of hosting it elsewhere, especially linked thru a redirector. That way you make sure that everybody can see it and it won't get lost over time.
The worst thing about censorship is ███████████

richxrich
Registered User
Posts: 34
Joined: Mon Nov 21, 2016 9:17 am

Re: Unable to create a new group

Post by richxrich » Thu Dec 07, 2017 12:38 am

AmigoJack wrote:
Wed Dec 06, 2017 8:38 am
My first suggestion is to use the attachment feature here for your screenshots instead of hosting it elsewhere, especially linked thru a redirector. That way you make sure that everybody can see it and it won't get lost over time.
Uploaded as attachment per your suggestion. Thanks. :)

User avatar
AmigoJack
Registered User
Posts: 4995
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Unable to create a new group

Post by AmigoJack » Thu Dec 07, 2017 7:56 am

That error should never occur and indicates that the said database table is not defined the way it should. Fill out the Support Request Template and post back results. If you have access to your database (i.e. thru phpMyAdmin) then execute the query SHOW CREATE TABLE phpbb_groups and post back results, too.
The worst thing about censorship is ███████████

richxrich
Registered User
Posts: 34
Joined: Mon Nov 21, 2016 9:17 am

Re: Unable to create a new group

Post by richxrich » Thu Dec 07, 2017 8:26 am

Support Request Template
What version of phpBB are you using? phpBB 3.2.1
What is your board's URL? http://forum.sfbaaps.org
Who do you host your board with? aplus.net
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.0.12
What extensions do you have installed? Tapatalk, Manage Pages, Topic Preview, Post Numbers, Board Rules, Recent Topics, Donation Extension, Custom Site Logo, Calendar, Advanced BBCode Box, AJAX Registration Check, Auto Db Backup, Auto Groups, Board Announcements, Collapsible Forum Categories, Emoji Picker, Image Upload, Lightbox, Modbreak, NavBarSearch, phpBB Media Embed Plugin, Previous/Next Topic, Private Message Box Status, Remove Subject from Replies, Simple Mentions, Topic Age Day, VigLink
What styles do you currently have installed? ProSilver, Green-Style, green_nature
What language(s) is your board currently using? British English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Users and Groups --> Manage Groups --> Create New Group "2018 Supporting Member" --> Submit on next page with Default values returns error
Please describe your problem. Error when creating new groups and also when trying to install American English language pack.
Generated by SRT Generator

richxrich
Registered User
Posts: 34
Joined: Mon Nov 21, 2016 9:17 am

Post by richxrich » Thu Dec 07, 2017 8:34 am

SQL query result

CREATE TABLE `phpbb_groups` (
`group_id` mediumint(8) unsigned NOT NULL,
`group_type` tinyint(4) NOT NULL DEFAULT '1',
`group_founder_manage` tinyint(1) unsigned NOT NULL DEFAULT '0',
`group_skip_auth` tinyint(1) unsigned NOT NULL DEFAULT '0',
`group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`group_desc` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`group_desc_bitfield` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`group_desc_options` int(11) unsigned NOT NULL DEFAULT '7',
`group_desc_uid` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`group_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
`group_avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`group_avatar_type` tinyint(2) NOT NULL DEFAULT '0',
`group_avatar_width` smallint(4) unsigned NOT NULL DEFAULT '0',
`group_avatar_height` smallint(4) unsigned NOT NULL DEFAULT '0',
`group_rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
`group_colour` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`group_sig_chars` mediumint(8) unsigned NOT NULL DEFAULT '0',
`group_receive_pm` tinyint(1) unsigned NOT NULL DEFAULT '0',
`group_message_limit` mediumint(8) unsigned NOT NULL DEFAULT '0',
`group_max_recipients` mediumint(8) unsigned NOT NULL DEFAULT '0',
`group_legend` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`group_id`),
KEY `group_legend_name` (`group_legend`,`group_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

User avatar
warmweer
Registered User
Posts: 486
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Unable to create a new group

Post by warmweer » Thu Dec 07, 2017 8:44 am

Just in case:I've seen errors like this during my testing of upgrades op 3.0.x boards. In almost all cases it was a database change due to a modification, which didn't hamper the upgrade but did leave something "hanging".

Considering the number op modifications you had, are you certain the database was cleaned completely.

Another thing is that you have many extensions installed: try disabling all of them. If the error is gone then perhaps it's just extension related (or even style-related if the style doesn't inherit from prosilver and the extension depends on the style).

edit :Looking back at the SQL, I think group_id might need an autoincrement.
A bug is a feature that didn't make it to the manual (yet)

User avatar
AmigoJack
Registered User
Posts: 4995
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Unable to create a new group

Post by AmigoJack » Thu Dec 07, 2017 10:01 am

warmweer wrote:
Thu Dec 07, 2017 8:44 am
group_id might need an autoincrement
Of course it needs that. But because of
richxrich wrote:
Thu Dec 07, 2017 8:26 am
Error when creating new groups and also when trying to install American English language pack.
I think we're just doing shotgun debugging here instead of tracking down the culprit. Not to speak of seeing the actual error messages for the second problem.

At a long shot I suppose your database tables were crook with 3.0.12 already, probably thru improper modifications (who'd touch autoincrement columns anyway) and now it just lives on as 3.2.1. You should have had the same problems with 3.0.12 already. The STK's database cleaner only adds missing columns or removes bogus columns, but doesn't test existing columns against their intended definition.
The worst thing about censorship is ███████████

User avatar
warmweer
Registered User
Posts: 486
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Unable to create a new group

Post by warmweer » Thu Dec 07, 2017 12:01 pm

AmigoJack wrote:
Thu Dec 07, 2017 10:01 am
warmweer wrote:
Thu Dec 07, 2017 8:44 am
group_id might need an autoincrement
Of course it needs that. But because of
richxrich wrote:
Thu Dec 07, 2017 8:26 am
Error when creating new groups and also when trying to install American English language pack.
I think we're just doing shotgun debugging here instead of tracking down the culprit. Not to speak of seeing the actual error messages for the second problem.
Agreed, but just having a look at the database tables (preferably even comparing with a clean 3.2.1 install) might shed more light on the nature of the problem.
However, it doesn't take long and there would be no harm in setting group_id to autoincrement and retrying to make the new group (and with a bit of luck the language problem might also be solved in a similar way). (and reverting the change

Sometimes shotgun debugging can avoid having to mobilise the special forces ;)
A bug is a feature that didn't make it to the manual (yet)

User avatar
AmigoJack
Registered User
Posts: 4995
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Unable to create a new group

Post by AmigoJack » Thu Dec 07, 2017 2:57 pm

warmweer wrote:
Thu Dec 07, 2017 12:01 pm
there would be no harm in setting group_id to autoincrement
That is not enough - you also need to set the value, as the AUTO_INCREMENT directive does just that and not something that may be called AUTO_NON_EXISTING_VALUE. That's why for each "broken" column the highest row value needs to be found and used for adjusting the current increment.
The worst thing about censorship is ███████████

richxrich
Registered User
Posts: 34
Joined: Mon Nov 21, 2016 9:17 am

Re: Unable to create a new group

Post by richxrich » Thu Dec 07, 2017 6:50 pm

Thanks for the input, guys. Unfortunately, I'm not well versed in php or sql, so it'll probably take some work for me to get up to speed.

Regarding 3.0.12, neither myself nor the previous Administrator did anything with the tables or did too many modifications, with exception to the extensions that I've installed with 3.2.1. The 3.0.12 board was mostly the vanilla installation. We did get some of these same general errors from time to time in 3.0.12, although it's hard to say when and under what conditions. There's no way to reproduce them at this point.

What are the steps I should take to remedy the problem? How do I figure out which columns are broken and then go about fixing them?

User avatar
AmigoJack
Registered User
Posts: 4995
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Unable to create a new group

Post by AmigoJack » Fri Dec 08, 2017 8:50 am

Open /install/schemas/schema.json and find every occurance of auto_increment, which is given per column. All columns are preceded by its table name. For every table execute the SHOW CREATE TABLE phpbb_x query and then see if the corresponding column(s) have the AUTO_INCREMENT directive. For 3.2.1 it should result in checking these table columns:

Code: Select all

phpbb_acl_options.auth_option_id
phpbb_acl_roles.role_id
phpbb_attachments.attach_id
phpbb_banlist.ban_id
phpbb_bots.bot_id
phpbb_disallow.disallow_id
phpbb_drafts.draft_id
phpbb_extension_groups.group_id
phpbb_extensions.extension_id
phpbb_forums.forum_id
phpbb_groups.group_id
phpbb_icons.icons_id
phpbb_lang.lang_id
phpbb_log.log_id
phpbb_modules.module_id
phpbb_notification_types.notification_type_id
phpbb_notifications.notification_id
phpbb_posts.post_id
phpbb_privmsgs.msg_id
phpbb_privmsgs_folder.folder_id
phpbb_privmsgs_rules.rule_id
phpbb_profile_fields.field_id
phpbb_ranks.rank_id
phpbb_reports.report_id
phpbb_reports_reasons.reason_id
phpbb_search_wordlist.word_id
phpbb_sitelist.site_id
phpbb_smilies.smiley_id
phpbb_styles.style_id
phpbb_teampage.teampage_id
phpbb_topics.topic_id
phpbb_users.user_id
phpbb_warnings.warning_id
phpbb_words.word_id
Reply with a list of all tables + columns that differ.
The worst thing about censorship is ███████████

richxrich
Registered User
Posts: 34
Joined: Mon Nov 21, 2016 9:17 am

Re: Unable to create a new group

Post by richxrich » Fri Dec 08, 2017 5:45 pm

This is what I'm seeing for pretty much all the tables. I don't see auto_increment as part of the data. Where would auto_increment appear?

Code: Select all

phpbb_acl_options
CREATE TABLE `phpbb_acl_options` (
 `auth_option_id` mediumint(8) unsigned NOT NULL,
 `auth_option` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `is_global` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `is_local` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `founder_only` tinyint(1) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`auth_option_id`),
 UNIQUE KEY `auth_option` (`auth_option`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Code: Select all

phpbb_acl_roles	
CREATE TABLE `phpbb_acl_roles` (
 `role_id` mediumint(8) unsigned NOT NULL,
 `role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `role_description` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `role_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `role_order` smallint(4) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`role_id`),
 KEY `role_type` (`role_type`),
 KEY `role_order` (`role_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Code: Select all

phpbb_attachments	
CREATE TABLE `phpbb_attachments` (
 `attach_id` mediumint(8) unsigned NOT NULL,
 `post_msg_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `in_message` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `is_orphan` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `physical_filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `real_filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `download_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `attach_comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `extension` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `mimetype` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `filesize` int(20) unsigned NOT NULL DEFAULT '0',
 `filetime` int(11) unsigned NOT NULL DEFAULT '0',
 `thumbnail` tinyint(1) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`attach_id`),
 KEY `filetime` (`filetime`),
 KEY `post_msg_id` (`post_msg_id`),
 KEY `topic_id` (`topic_id`),
 KEY `poster_id` (`poster_id`),
 KEY `is_orphan` (`is_orphan`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Last edited by richxrich on Sat Dec 09, 2017 7:50 pm, edited 1 time in total.

richxrich
Registered User
Posts: 34
Joined: Mon Nov 21, 2016 9:17 am

Re: Unable to create a new group

Post by richxrich » Fri Dec 08, 2017 5:49 pm

When I ran the query for phpbb_groups, I got this "Error: Token Mismatch" even though the query returned results:
Attachments
phpbb_groups.png

User avatar
warmweer
Registered User
Posts: 486
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Unable to create a new group

Post by warmweer » Fri Dec 08, 2017 6:59 pm

_groups should be:
`group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

AmigoJack is right that you should check all tables where autoincrement is expected.
The autoincrement allows a new row to be inserted without having to specify the id_field (the value is automatically created and insert with the row).
If there are no other changes and there are only standard groups (no self made groups), then the solution (manual) is quite simple. But if you have more groups or other tables with missing AUTOINCREMENT then it is probably a lot more work e.g. the group_id is used in other tables so it is absolutely necessary that the correct group_id is linked in the other tables.
If SQL are necessary then I'll leave that to AmigoJack and others with more experience (and certainly better understanding of phpBB) than myself.
But I have high hopes that your phpBB problems will be solved soon.
A bug is a feature that didn't make it to the manual (yet)

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Christian 2.0, Frank Rizzo, Perrorist, Tim1969 and 113 guests

cron