Serious security issue detected: Your #__usergroups table includes incorrect

Started by MAD King, February 04, 2025, 20:58:01 PM

Previous topic - Next topic

MAD King

After migrating from J3 to J4, I am getting this error:

QuoteSerious security issue detected: Your #__usergroups table includes incorrect datas and permissions reported at backend might not be same as permissions applied on frontend. Please fix your #__usergroups. Just edit a joomla user group and store it. This should update the table.

Does anyone know what to do?

Joomla 4.4.10
VirtueMart 4.4.0 11095
Joomla! 4.4.5
VirtueMart 4.2.12 11012

Jumbo!

Open the database using phpMyAdmin and run the following SQL query. Before running the query, please replace #__ with your site's actual Database Table Prefix.

TRUNCATE `#__usergroups`;
INSERT INTO `#__usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES
(1, 0, 1, 18, 'Public'),
(2, 1, 8, 15, 'Registered'),
(3, 2, 9, 14, 'Author'),
(4, 3, 10, 13, 'Editor'),
(5, 4, 11, 12, 'Publisher'),
(6, 1, 4, 7, 'Manager'),
(7, 6, 5, 6, 'Administrator'),
(8, 1, 16, 17, 'Super Users'),
(9, 1, 2, 3, 'Guest');