VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: MAD King on February 04, 2025, 20:58:01 PM

Title: Serious security issue detected: Your #__usergroups table includes incorrect
Post by: MAD King on February 04, 2025, 20:58:01 PM
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
Title: Re: Serious security issue detected: Your #__usergroups table includes incorrect
Post by: Jumbo! on February 04, 2025, 21:26:59 PM
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');