Hi - please can someone assist with this problem?

Running j 1.5.9
CB R1.2r4 (and tried R1.2 - same issue)
Data has been migrated from a 1.0 site
All tools for CB have been run
Synchronize Users
Check Community Builder Database
Check Community Builder User Fields Database
Check CB plugins database
Check Users Database

Behaviour
In Edit for a users profile:
message - !DB Function reports no errors
- this pops up in a box when you save the changes.
Obviously an error has occurred though.

[edit 4] - I have reproduced this on the joomla 1.0 site - the error message is slightly different -
DB function failed with error number 0
- The behaviour is different too - the user can log in without an error message, BUT the user does not appear in the "Who's online" list

In 1.5 after this occurs - the joomla message for no login access is displayed all the time in the site, for that user.

Investigation
Have run all the tools available with CB
On Checking Users Datbase it finds:

Checking Users Database:

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=4970 (aro_id=3770).

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.

Other checks-

Yes CB-login is the only module activated (joomla login is off)
In Global setting - Allow user registration is set to yes.

- in phpMyadmin Repaired the three tables - all came out "Repair status ok" and no other messages (never done that before so guessing there were no errors?)

[edit] Not running Jacl or any other core hacks
[edit 2] Have also tried dropping and rebuilding the jos_core_acl_aro_groups as described in this post - has not fixed the error


[edit 3] look at the structure of the db tables


jos_users.gif

jos_core_acl_aro.gif

jos_core_acl_groups_aro_map.gif << this is showing the problem after you try and edit a user profile and save in CB

After running cb tool on user tables - jos_core_acl_groups_aro_map.gif


Please help

J

Post edited by: jay44, at: 2009/03/06 13:28

Post edited by: jay44, at: 2009/03/06 13:40

Post edited by: jay44, at: 2009/03/07 01:22

Post edited by: jay44, at: 2009/03/08 09:17

Post edited by: jay44, at: 2009/03/09 08:01

finally got it to work

used the latest joomla team migrator 1.2 (not mtwmigrator)

Did NOT try to alter the database to UTF8 before migration - the newest migrator1.2 does this for you.

began a new 1.5.9 site, installed CB (1.2 stable) and CB-login from the stable pack - tested it out

No error now.

Probably something to do with the utf8?'

J