CB User Fields DB Upgrade & Cannot Save

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.

First of all, Thanks for having done the homework and posted a precise report.

My first guess is that your database has structure issues inside MySQL, and to attempt to check and also try repair and optimize all tables from within e.g. phpMyAdmin .

From what I can see, the table jos_comprofiler only "half"-exists in MySQL, being there and not there too.

As next step, if you have a recent backup of a working version, delete and restore jos_comprofiler table or the database.

This should put your MySQL datastructure back into a sane state.

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.

bpluijms wrote:

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.

first try and do a repair on your database tables using phpmyadmin
(backup first!)