When a new user signs up and tries to confirm the email, the site returns the following:
You are not authorized to view this page! You need to log in.
Within the CB config I have the following:
Allow User Registration: Same as global "allow registration" site setting
Require Email Confirmation: Yes
URL for first login visit: blank
Within the Joomla global config we have the following:
Allow User Registration: Yes
New User Registration Type: Yes
New User Account Activation: Yes
Front-end User Parameters: Hide
Now here's were we find some problems which I think pertain to this...
When I go to Joomla backend > Components > CB > Tools > Check Users Database > It shows the following error:
Warning: 5 entries in the core_acl_aro table without corresponding core_acl_groups_aro_map table rows.
Following entries of core_acl_aro table are missing in core_acl_groups_aro_map table: user id=112 (aro_id=60), user id=127 (aro_id=75), user id=128 (aro_id=76), user id=129 (aro_id=77), user id=130 (aro_id=78).
This one can be fixed by first backing up database then by clicking here.
When I click the link to fix it, it then returns the error:
SQL error DB function failed with error number 1054
Unknown column 'section_value' in 'field list' SQL=INSERT INTO jos_core_acl_groups_aro_map (aro_id,section_value,group_id) SELECT a.id AS aro_id, '', 18 AS group_id FROM jos_core_acl_aro a LEFT JOIN jos_core_acl_groups_aro_map g ON g.aro_id = a.id WHERE g.aro_id IS NULL
SQL =
INSERT INTO jos_core_acl_groups_aro_map (aro_id,section_value,group_id) SELECT a.id AS aro_id, '', 18 AS group_id FROM jos_core_acl_aro a LEFT JOIN jos_core_acl_groups_aro_map g ON g.aro_id = a.id WHERE g.aro_id IS NULL
Any ideas how to fix this?
