Hello Joomlianer
thanks for the new CB

I have had a Joomla 1.0x Website with CB 1.1. And I've used an Core-Hack Component (-> JACL Plus). So but now I upgraded to Joomla 1.5.8 and CB 1.2 RC4 without "JACL Plus". The Upgrade was successfull. I can see the members in the Joomla-Backend Userlist and in CB-Userlist.

But now my problem:
No new user can register on my site! Every gets the Javascript-Error: DB function reports no errors
And the visitor is redirected to the Register-Form. I can't fix this problem.

I see then in my phpMyAdmin (SQL). And the new user-entry is in these tables: jos_comprofiler & jos_users. But not in these: jos_core_acl_aro & jos_core_acl_groups_aro_map.

When i go to the Joomla-Backend to CB-Tools, then all "checks" are good (all is green ). Only the "Check Users Database" has problems!

If i click on this "Check Users Database", it will come:
[code:1]
All Community Builder comprofiler table rows have links to user table.

All users table rows have links to comprofiler table.

users table has no zero id row.

comprofiler table has no zero id row.

All rows in comprofiler table have user_id columns identical to id columns.

All users table rows have ACL entries in core_acl_aro table.

All ACL core_acl_aro table rows have corresponding entries in users table.

Warning: 1 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=320 (aro_id=269).

This one can be fixed by first backing up database then by clicking here.

All core_acl_aro table rows have ACL entries in core_acl_groups_aro_map table.
[/code:1]

If i click than to this link, the core will be okay for this new user. so this works^^
But i must do this by every new registered user. Is this a bug? Or is perhaps my Joomla-Core-Table bad?


Link to my site: www.straubing-live.de/index.php?option=com_comprofiler&task=registers
Info about PHP: www.straubing-live.de/phpinfo.php


If you want, i can show you my sql-database.


Kind regards,
videoandfun


P.S: perhaps this user has the same problem: www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,78951/catid,64/

Post edited by: videoandfun, at: 2008/12/08 21:20

i have only activated the cb-register (joomla-register is off).
and perhaps the problem is here, because i used before joomla 1.5 & cb 1.2 rc4 the version j1.0.15 & CB 1.1 with JACL Plus.

can someone help me to fix my database with me?

if i debugg my joomla, this will come after sending registration:

JDatabaseMySQL::query: 1054 - Unknown column 'value' in 'where clause' SQL=SELECT id FROM jos_core_acl_aro_groups WHERE value='Registered'

P.S: In this table is no value, but there is a name. Is this perhaps a change in Joomla 1.5?

Post edited by: videoandfun, at: 2008/12/09 18:04

i have the solution!!!!!
jos_core_acl_aro_groups is defect!

Please delete this table and insert a total new jos_core_acl_aro_groups table.

Now the CB-Register will work