I have installed Community Builder on my site and changed the login module from the default to CB Login and everything looks fine
But when a new user try to register things are going wrong

1. the user fill in the reg. form
2. a mail is sendt to the user to verify the mail adress
3. when following the link this is what happens

[code:1]SQL-unblock error: DB function failed with error number 1054
Unknown column 'activation' in 'field list' SQL=UPDATE jos_users SET block = 0, activation = '' WHERE id = '127'
SQL =

UPDATE jos_users
SET block = 0, activation = ''
WHERE id = '127'

Your account is now active. You may now login![/code:1]

4. It says in the last line "Your account is now active. You may now login!" but when trying to this happens:

Your login has been blocked please contact the administrator

What has gone wrong

Hey man, I had this problem too.
Seems like the issue is with the differences between the mambo user tables being converted to joomla rather than CB.

The way I fixed it was to go into phpmyadmin, go to the jos_users table add a field called "activation" varchar 100 null with no default and it seemed to fix it.
hope it works for you!

-- makes me wonder what other user problems i'm going to run into along the way.


-- Nathan