Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount! Get 20% off now with code SPOOKY-2024!

New Users Can't Confirm Registration Email

  • davet
  • davet
  • OFFLINE
  • Posts: 2
  • Thanks: 0
  • Karma: 0
13 years 7 months ago #156483 by davet
We are using Joomla 1.5.22 and CB 1.4.

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?

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum