I'm running joomla 1.5.21 and CB 1.3.1 and I can't find the global setting or CMS feature that is causing CB to enforce unique email addresses. I want to be able to have users that share email. I ran into this issue this morning when I was running CB 1.2.3 so I upgraded to CB 1.3.1 thinking it would solve my problem but alas, no joy.

tia,
-skip

nant wrote:
This is a Joomla issue - it requires unique email addresses and usernames.

Thanks for the quick reply! So when the help text in the CB > Configuration > Registration Tab says:

"If "yes", users cannot share the same email address. This is a CMS global setting for the site, or a CMS feature. CB adapts automatically to this setting/feature."

Does that mean that while the version of Joomla/Mambo/other_CMS that I am using does not support shared (non-unique) email but there may be others that do? Or have I just not found the switch in Joomla 1.5.21 (I guess I'm now posting off topic big time!)

Thanks for your help!
-skip

In their wisdom, the Joomla experts have decided that this is not something that people should be able to do.

What you want is possible, but it requires a "hack".

For Joomla 1.5, find the file: libraries/joomla/database/table/user.php

In this file, you will find the following code starting at line 182:

// check for existing email
$query = 'SELECT id'
. ' FROM #__users '
. ' WHERE email = '. $this->_db->Quote($this->email)
. ' AND id != '. (int) $this->id
;
$this->_db->setQuery( $query );
$xid = intval( $this->_db->loadResult() );
if ($xid && $xid != intval( $this->id )) {
$this->setError( JText::_( 'WARNREG_EMAIL_INUSE' ) );
return false;
}
/

Replace the above with the following code:

// check for existing email
$query = 'SELECT id'
. ' FROM #__users '
. ' WHERE email = '. $this->_db->Quote($this->email)
. ' AND id != '. (int) $this->id
;
$this->_db->setQuery( $query );
$xid = intval( $this->_db->loadResult() );
/** if ($xid && $xid != intval( $this->id )) {
* $this->setError( JText::_( 'WARNREG_EMAIL_INUSE' ) );
* return false;
*}
*/

I have done this on my site, it works fine.