Hi There,
I have a CB install 1.3.1 which I have just upgraded.

I cannot save whe creating a "New User" or editing an "Existing User" from the backend logged in as Super Admin.

Checking the Community Builder User fields database it comes back with some errors which I attempt to fix (after backing up my database)

CB fields data storage Database structure differences:
Table jos_comprofiler does not exist
Table jos_comprofiler does not exist
Table jos_comprofiler does not exist
Table jos_comprofiler does not exist
Table jos_comprofiler does not exist
Table jos_comprofiler does not exist
Table jos_comprofiler does not exist
Table jos_comprofiler does not exist
Table jos_comprofiler does not exist

After Clicking "Fix(adjust" all CB fields data storage differences above I get:
CBSQLupgrader::createTableof Table jos_comprofiler failed with SQL error: Table 'jos_comprofiler' already exists SQL=CREATE TABLE `jos_comprofiler` ( `cb_nickname` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_nickname` 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_position` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_position` 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_address` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_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` ( `cb_city` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_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` ( `cb_pu` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_pu` 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_dob` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_dob` 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_initials` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_initials` 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_secondaryemail` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_secondaryemail` 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_mobile` varchar(255) DEFAULT NULL )ENGINE=MyISAM
CREATE TABLE `jos_comprofiler` ( `cb_mobile` varchar(255) DEFAULT NULL )ENGINE=MyISAM

I have looked through the forums checked the stuff in the "Help us to help you" section.

My Joomla details are:
Database Version: 5.1.53
Database Collation: utf8_general_ci
PHP Version: 5.2.14
Web Server: Apache/2
Joomla! Version: Joomla! 1.5.22 Stable.

I have spent hours trying to fix this but to no avail. The biggest problem is that I cannot save. Any help would be appreciated.

Thanks Beat,
I have deleted the jos_comprofiler table and restored it with a slightly out of date one and it has fixed the problem with a few edits to bring it up to date.

Thanks for the help, much appreciated.

Hello BEAT,

I've got exactly the same problem as described below.

I have a recent backup, but I don't know how to restore only that table.

Is it enough to just do the following steps, or am I missing something:
1. open phpmyadmin
2. delete jos_comprofiler table
3. restore it with the table from my backup.

Is this right?
Just checking before I lose al my data.