MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > error index admin panel setting
Full Version: error index admin panel setting
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

theionix

2021-11-14, 06:11 AM
any ideas about this error!, in the capture explain all, if need more detail ask  Wink
MyBB Version 1.8.27
PHP Version 7.2.31
SQL Engine MySQLi 10.5.12
Server Load 10.45

HLFadmin

2021-11-14, 01:04 PM
If you click on one settings group, does it expand with no settings in it?
That is one you can delete safely.

Hover over the setting group name and view the link to get the gid that corresponds to the empty set.
Then use phpMyAdmin to delete the record in the mybb_settinggroups table which has that gid.

If both groups contain settings, then that is more complicated and will need details before proceeding.

theionix

2021-11-15, 01:37 AM
phpMyAdmin gid sequence normal, not duplicate. you can help?

HLFadmin

2021-11-15, 03:57 AM
Do this instead.

AdminCP / Settings, select Modify Settings tab.

At the top is normal default setting groups and settings, like this

[attachment=44684]

Then, scroll down towards the bottom, where you will see groups and settings created by plugins, etc.
These groups and settings are editable, can be done using the option button on the right hand side. For example,

[attachment=44685]

If your duplicate groups and settings are down there, make sure all the settings in duplicate group occur in the default group. If yes, then click on option button and delete settings first, then click on option button to delete the group.

theionix

2021-11-15, 06:53 PM
button delete group not found, in the option
button delete group not found, in the option

HLFadmin

2021-11-15, 11:23 PM
You could do a step-by-step, or maybe someone with more experience could combine the steps with a better query.

1. Find all duplicate names of setting groups, and make a note of the gid which is the duplicate setting group. The gid of legitimate original groups will be first. The duplicates will occur later since the gid field is autoincrement.

Verify you have all duplicate group settings.
SELECT a.* from `mybb_settinggroups` a join (select name, count(*) FROM `mybb_settinggroups` group by `name` having count(*) > 1 ) b on a.name = b.name order by a.gid

2. Do the same for duplicate settings, making note of the range of sid which is the duplicate settings. Again, the legitimate ones will occur first, the duplicate ones will be later since sid field is autoincrement.

Verify you have all duplicate settings.
SELECT a.* from `mybb_settings` a join (select name, count(*) FROM `mybb_settings` group by `name` having count(*) > 1 ) b on a.name = b.name order by a.sid

3. Verify the duplicate settings in that second query have a gid same as the duplicate settinggroup. Now you know what records to delete. You will have identified the range of duplicate settings, say sid between 79 and 96. Note, this includes 79 and 96. IMPORTANT: MAKE SURE THE RANGE IS CONTINUOUS WITH NO BREAKS IN SEQUENCE. If there's a break, you will need to make sure you don't delete a setting that belongs to another settinggroup.

DELETE from `mybb_settings` WHERE sid between 79 and 96;
Alternatively, WHERE gid = the number of the duplicate group.

You could manually delete the duplicate settinggroup record you identified in the first query.

Note that the DELETE query gives you an option to simulate the query where phpMyAdmin will tell you the number of records found. That number should agree with your expectation. If it does, then execute it.

Someone might suggest to make a backup of your two tables. Your choice.

theionix

2021-11-16, 09:36 PM
error found in, TABLE mybb_settinggroups
thanks your great!!!


export file ".sql" import "phpMyAdmin", with the solution & error


error
-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 16-11-2021 a las 19:13:36
-- Versión del servidor: 10.5.12-MariaDB
-- Versión de PHP: 7.3.32

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de datos: id17817996_dbroot
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla mybb_settinggroups
--

CREATE TABLE mybb_settinggroups (
  gid smallint(5) UNSIGNED NOT NULL,
  name varchar(100) NOT NULL DEFAULT '',
  title varchar(220) NOT NULL DEFAULT '',
  description text NOT NULL,
  disporder smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  isdefault tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla mybb_settinggroups
--

INSERT INTO mybb_settinggroups (gid, name, title, description, disporder, isdefault) VALUES
(1, 'onlineoffline', 'Board Online / Offline', 'These settings allow you to globally turn your forums online or offline, and allow you to specify a reason for turning them off.', 1, 1),
(2, 'details', 'Site Details', 'This section contains various settings such as your board name and url, as well as your website name and url.', 2, 1),
(3, 'general', 'General Configuration', 'This section allows you to manage the general aspects of your board.', 3, 1),
(4, 'server', 'Server and Optimization Options', 'These options allow you to set various server and optimization preferences allowing you to reduce the load on your server, and gain better performance on your board.', 4, 1),
(5, 'datetime', 'Date and Time Formats', 'Here you can specify the different date and time formats used to display dates and times on the forums.', 5, 1),
(6, 'forumhome', 'Forum Home Options', 'This section allows you to manage the various settings used on the forum home (index.php) of your boards such as enabling and disabling different features.', 6, 1),
(7, 'forumdisplay', 'Forum Display Options', 'This section allows you to manage the various settings used on the forum display (forumdisplay.php) of your boards such as enabling and disabling different features.', 7, 1),
(8, 'showthread', 'Show Thread Options', 'This section allows you to manage the various settings used on the thread display page (showthread.php) of your boards such as enabling and disabling different features.', 8, 1),
(9, 'member', 'Login and Registration Options', 'Here you can control various settings with relation to user account registration and login management.', 9, 1),
(10, 'profile', 'Profile Options', 'The options here control the various settings of user profiles around the forums.', 10, 1),
(11, 'posting', 'Posting', 'These options control the various elements in relation to posting messages on the forums.', 11, 1),
(12, 'attachments', 'Attachments', 'Various options related to the attachment system can be managed and set here.', 12, 1),
(13, 'memberlist', 'Member List', 'This section allows you to control various aspects of the board member listing (memberlist.php), such as how many members to show per page, and which features to enable or disable.', 13, 1),
(14, 'reputation', 'Reputation', 'The reputation system allows your users to rate others and leave a comment on the user. This section has settings to disable and change other aspects of the reputation page (reputation.php).', 14, 1),
(15, 'warning', 'Warning System Settings', 'The warning system allows forum staff to warn users for rule violations. Here you can manage the settings that control the warning system (warnings.php).', 15, 1),
(16, 'privatemessaging', 'Private Messaging', 'Various options with relation to the MyBB Private Messaging system (private.php) can be managed and set here.', 16, 1),
(17, 'calendar', 'Calendar', 'The board calendar allows the public and private listing of events and members\' birthdays. This section allows you to control and manage the settings for the Calendar (calendar.php).', 17, 1),
(18, 'whosonline', 'Who\'s Online', 'Various settings regarding the Who is Online functionality (online.php).', 18, 1),
(19, 'userpruning', 'User Pruning', 'User Pruning allows you to remove users from your forum meeting certain criteria. Here you can configure that criteria.', 19, 1),
(20, 'portal', 'Portal Settings', 'The portal page compiles several different pieces of information about your forum, including latest posts, who\'s online, forum stats, announcements, and more. This section has settings to control the aspects of the portal page (portal.php).', 20, 1),
(21, 'search', 'Search System', 'The various settings in this group allow you to make changes to the built in search mechanism for threads, posts and help documents in MyBB.', 21, 1),
(22, 'clickablecode', 'Clickable Smilies and BB Code', 'This section allows you to change how the clickable smilies inserter appears and control the default MyCodes.', 22, 1),
(23, 'cpprefs', 'Control Panel Preferences (Global)', 'This section allows you to set the global preferences for the Admin Control Panel.', 23, 1),
(24, 'mailsettings', 'Mail Settings', 'This section allows you to control various aspects of the MyBB mail system, such as sending with PHP mail or with a off server SMTP server.', 24, 1),
(25, 'contactsettings', 'Contact Settings', 'The various options to change the behaviour of the contact page (contact.php).', 25, 1),
(26, 'purgespammer', 'Purge Spammer', 'This section allows you to change the settings of the Purge Spammer feature.', 26, 1),
(27, 'stopforumspam', 'Stop Forum Spam', 'This section allows you to change the settings used for the integration with StopForumSpam.com', 27, 1),
(28, 'contactdetails', 'Contact Details', 'This section allows you to change the settings of the contact fields feature.', 28, 1),
(29, 'statspage', 'Statistics Page', 'This section allows you to change the settings of the statistics page.', 28, 1),
(30, 'forumteam', 'Forum Team', 'This section allows you to control various aspects of the forum team listing (showteam.php), such as aspects to consider while listing team members, and which features to enable or disable.', 29, 1),
(31, 'onlineoffline', 'Board Online / Offline', 'These settings allow you to globally turn your forums online or offline, and allow you to specify a reason for turning them off.', 1, 1),
(32, 'details', 'Site Details', 'This section contains various settings such as your board name and url, as well as your website name and url.', 2, 1),
(33, 'general', 'General Configuration', 'This section allows you to manage the general aspects of your board.', 3, 1),
(34, 'server', 'Server and Optimization Options', 'These options allow you to set various server and optimization preferences allowing you to reduce the load on your server, and gain better performance on your board.', 4, 1),
(35, 'datetime', 'Date and Time Formats', 'Here you can specify the different date and time formats used to display dates and times on the forums.', 5, 1),
(36, 'forumhome', 'Forum Home Options', 'This section allows you to manage the various settings used on the forum home (index.php) of your boards such as enabling and disabling different features.', 6, 1),
(37, 'forumdisplay', 'Forum Display Options', 'This section allows you to manage the various settings used on the forum display (forumdisplay.php) of your boards such as enabling and disabling different features.', 7, 1),
(38, 'showthread', 'Show Thread Options', 'This section allows you to manage the various settings used on the thread display page (showthread.php) of your boards such as enabling and disabling different features.', 8, 1),
(39, 'member', 'Login and Registration Options', 'Here you can control various settings with relation to user account registration and login management.', 9, 1),
(40, 'profile', 'Profile Options', 'The options here control the various settings of user profiles around the forums.', 10, 1),
(41, 'posting', 'Posting', 'These options control the various elements in relation to posting messages on the forums.', 11, 1),
(42, 'attachments', 'Attachments', 'Various options related to the attachment system can be managed and set here.', 12, 1),
(43, 'memberlist', 'Member List', 'This section allows you to control various aspects of the board member listing (memberlist.php), such as how many members to show per page, and which features to enable or disable.', 13, 1),
(44, 'reputation', 'Reputation', 'The reputation system allows your users to rate others and leave a comment on the user. This section has settings to disable and change other aspects of the reputation page (reputation.php).', 14, 1),
(45, 'warning', 'Warning System Settings', 'The warning system allows forum staff to warn users for rule violations. Here you can manage the settings that control the warning system (warnings.php).', 15, 1),
(46, 'privatemessaging', 'Private Messaging', 'Various options with relation to the MyBB Private Messaging system (private.php) can be managed and set here.', 16, 1),
(47, 'calendar', 'Calendar', 'The board calendar allows the public and private listing of events and members\' birthdays. This section allows you to control and manage the settings for the Calendar (calendar.php).', 17, 1),
(48, 'whosonline', 'Who\'s Online', 'Various settings regarding the Who is Online functionality (online.php).', 18, 1),
(49, 'userpruning', 'User Pruning', 'User Pruning allows you to remove users from your forum meeting certain criteria. Here you can configure that criteria.', 19, 1),
(50, 'portal', 'Portal Settings', 'The portal page compiles several different pieces of information about your forum, including latest posts, who\'s online, forum stats, announcements, and more. This section has settings to control the aspects of the portal page (portal.php).', 20, 1),
(51, 'search', 'Search System', 'The various settings in this group allow you to make changes to the built in search mechanism for threads, posts and help documents in MyBB.', 21, 1),
(52, 'clickablecode', 'Clickable Smilies and BB Code', 'This section allows you to change how the clickable smilies inserter appears and control the default MyCodes.', 22, 1),
(53, 'cpprefs', 'Control Panel Preferences (Global)', 'This section allows you to set the global preferences for the Admin Control Panel.', 23, 1),
(54, 'mailsettings', 'Mail Settings', 'This section allows you to control various aspects of the MyBB mail system, such as sending with PHP mail or with a off server SMTP server.', 24, 1),
(55, 'contactsettings', 'Contact Settings', 'The various options to change the behaviour of the contact page (contact.php).', 25, 1),
(56, 'purgespammer', 'Purge Spammer', 'This section allows you to change the settings of the Purge Spammer feature.', 26, 1),
(57, 'stopforumspam', 'Stop Forum Spam', 'This section allows you to change the settings used for the integration with StopForumSpam.com', 27, 1),
(58, 'contactdetails', 'Contact Details', 'This section allows you to change the settings of the contact fields feature.', 28, 1),
(59, 'statspage', 'Statistics Page', 'This section allows you to change the settings of the statistics page.', 28, 1),
(60, 'forumteam', 'Forum Team', 'This section allows you to control various aspects of the forum team listing (showteam.php), such as aspects to consider while listing team members, and which features to enable or disable.', 29, 1),
(61, 'autorsz_settings', 'Image Auto-Resizer Settings', 'Settings to customise the Image Auto-Resizer plugin', 30, 0),
(62, 'ip_history_logs', 'IP History Settings', 'Adjust the IP History settings', 5, 0);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla mybb_settinggroups
--
ALTER TABLE mybb_settinggroups
  ADD PRIMARY KEY (gid);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla mybb_settinggroups
--
ALTER TABLE mybb_settinggroups
  MODIFY gid smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;



solution
-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1:3306
-- Tiempo de generación: 16-11-2021 a las 19:26:10
-- Versión del servidor: 5.7.31
-- Versión de PHP: 7.3.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de datos: atm002
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla mybb_settinggroups
--

DROP TABLE IF EXISTS mybb_settinggroups;
CREATE TABLE IF NOT EXISTS mybb_settinggroups (
  gid smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  name varchar(100) NOT NULL DEFAULT '',
  title varchar(220) NOT NULL DEFAULT '',
  description text NOT NULL,
  disporder smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  isdefault tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (gid)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla mybb_settinggroups
--

INSERT INTO mybb_settinggroups (gid, name, title, description, disporder, isdefault) VALUES
(1, 'onlineoffline', 'Board Online / Offline', 'These settings allow you to globally turn your forums online or offline, and allow you to specify a reason for turning them off.', 1, 1),
(2, 'details', 'Site Details', 'This section contains various settings such as your board name and url, as well as your website name and url.', 2, 1),
(3, 'general', 'General Configuration', 'This section allows you to manage the general aspects of your board.', 3, 1),
(4, 'server', 'Server and Optimization Options', 'These options allow you to set various server and optimization preferences allowing you to reduce the load on your server, and gain better performance on your board.', 4, 1),
(5, 'datetime', 'Date and Time Formats', 'Here you can specify the different date and time formats used to display dates and times on the forums.', 5, 1),
(6, 'forumhome', 'Forum Home Options', 'This section allows you to manage the various settings used on the forum home (index.php) of your boards such as enabling and disabling different features.', 6, 1),
(7, 'forumdisplay', 'Forum Display Options', 'This section allows you to manage the various settings used on the forum display (forumdisplay.php) of your boards such as enabling and disabling different features.', 7, 1),
(8, 'showthread', 'Show Thread Options', 'This section allows you to manage the various settings used on the thread display page (showthread.php) of your boards such as enabling and disabling different features.', 8, 1),
(9, 'member', 'Login and Registration Options', 'Here you can control various settings with relation to user account registration and login management.', 9, 1),
(10, 'profile', 'Profile Options', 'The options here control the various settings of user profiles around the forums.', 10, 1),
(11, 'posting', 'Posting', 'These options control the various elements in relation to posting messages on the forums.', 11, 1),
(12, 'attachments', 'Attachments', 'Various options related to the attachment system can be managed and set here.', 12, 1),
(13, 'memberlist', 'Member List', 'This section allows you to control various aspects of the board member listing (memberlist.php), such as how many members to show per page, and which features to enable or disable.', 13, 1),
(14, 'reputation', 'Reputation', 'The reputation system allows your users to rate others and leave a comment on the user. This section has settings to disable and change other aspects of the reputation page (reputation.php).', 14, 1),
(15, 'warning', 'Warning System Settings', 'The warning system allows forum staff to warn users for rule violations. Here you can manage the settings that control the warning system (warnings.php).', 15, 1),
(16, 'privatemessaging', 'Private Messaging', 'Various options with relation to the MyBB Private Messaging system (private.php) can be managed and set here.', 16, 1),
(17, 'calendar', 'Calendar', 'The board calendar allows the public and private listing of events and members\' birthdays. This section allows you to control and manage the settings for the Calendar (calendar.php).', 17, 1),
(18, 'whosonline', 'Who\'s Online', 'Various settings regarding the Who is Online functionality (online.php).', 18, 1),
(19, 'userpruning', 'User Pruning', 'User Pruning allows you to remove users from your forum meeting certain criteria. Here you can configure that criteria.', 19, 1),
(20, 'portal', 'Portal Settings', 'The portal page compiles several different pieces of information about your forum, including latest posts, who\'s online, forum stats, announcements, and more. This section has settings to control the aspects of the portal page (portal.php).', 20, 1),
(21, 'search', 'Search System', 'The various settings in this group allow you to make changes to the built in search mechanism for threads, posts and help documents in MyBB.', 21, 1),
(22, 'clickablecode', 'Clickable Smilies and BB Code', 'This section allows you to change how the clickable smilies inserter appears and control the default MyCodes.', 22, 1),
(23, 'cpprefs', 'Control Panel Preferences (Global)', 'This section allows you to set the global preferences for the Admin Control Panel.', 23, 1),
(24, 'mailsettings', 'Mail Settings', 'This section allows you to control various aspects of the MyBB mail system, such as sending with PHP mail or with a off server SMTP server.', 24, 1),
(25, 'contactsettings', 'Contact Settings', 'The various options to change the behaviour of the contact page (contact.php).', 25, 1),
(26, 'purgespammer', 'Purge Spammer', 'This section allows you to change the settings of the Purge Spammer feature.', 26, 1),
(27, 'stopforumspam', 'Stop Forum Spam', 'This section allows you to change the settings used for the integration with StopForumSpam.com', 27, 1),
(28, 'contactdetails', 'Contact Details', 'This section allows you to change the settings of the contact fields feature.', 28, 1),
(29, 'statspage', 'Statistics Page', 'This section allows you to change the settings of the statistics page.', 28, 1),
(30, 'forumteam', 'Forum Team', 'This section allows you to control various aspects of the forum team listing (showteam.php), such as aspects to consider while listing team members, and which features to enable or disable.', 29, 1),
(34, 'autorsz_settings', 'Image Auto-Resizer Settings', 'Settings to customise the Image Auto-Resizer plugin', 30, 0),
(36, 'ip_history_logs', 'IP History Settings', 'Adjust the IP History settings', 5, 0);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
MyBB Community Forums > 1.8 Support > General Support > error index admin panel setting