Fatal Error foreach() on User List after Upgrading

Review the SQL in your screenshot you'll see _comprofiler is added twice. I've no idea what's causing the "_comprofiler as t1", but something is adding it. Please disable 3rd party CB plugins 1 by 1 until resolved as it's likely a conflict of some sort. I've searched all of CB and no such "as t1" is found so has to be something that is/was installed.

I don't have any 3rd party CB plugins installed.

The only thing that comes close is the component Event Booker by JoomDonation, which has a feature called "User Registration Integration" that offers Community Builder user registration integration.

I turned that integration Off. But the problem persists.

Please PM backend super administrator login credentials and will take a look.

Cool.

Just sent them to you.

Thanks, Kyle!

--Matthew

Have reviewed your install and it's because you're using CB 1.8. Latest is CB 1.8.1, please upgrade and issue should resolve.

Thanks Kyle!

Just upgraded to 1.8.1 and ran the CB Tools check. Everything was good until the CB user fields database check: all red errors. It said repeatedly:

"Table jos_comprofiler does not exist"

So I backed up the site with Akeeba, and then ran the "Fix (adjust) all CB fields data storage database differences listed above".

It returned more errors highlighted in red:

CB fields data storage Database adjustments errors:

CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_expirationdate` date DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_expirationdate` date DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_referredby` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_referredby` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_businesstype` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_businesstype` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `company` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `company` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `website` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `website` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `address` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `address` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `city` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `city` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `state` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `state` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `zipcode` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `zipcode` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `phone` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `phone` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `fax` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `fax` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `occupation` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `occupation` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `interests` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `interests` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `country` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `country` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_profile` mediumtext )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_profile` mediumtext )ENGINE=MyISAM