[SOLVED] Fatal error: Uncaught exception - CB 2.0 J2.5.27

When going to the My Profile menu item, I get this: (tested on 2 different users)
Fatal error: Uncaught exception 'JDatabaseException' with message 'Unknown column 'city' in 'field list' SQL=SELECT city FROM jos_comprofiler, jos_users WHERE user_id=47' in ***\libraries\joomla\database\database\mysql.php:555 Stack trace: #0 ***\libraries\joomla\database\database.php(1164): JDatabaseMySQL->execute() #1 ***\modules\mod_pro_complete\helper.php(75): JDatabase->loadResult() #2 ***\modules\mod_pro_complete\mod_pro_complete.php(41): modProCompleteHelper->getItems(Object(JRegistry)) #3 ***\libraries\joomla\application\module\helper.php(173): include('***...') #4 ***\libraries\joomla\document\html\renderer\module.php(107): JModuleHelper::renderModule(Object(stdClass), Array) #5 ***\libraries\joomla\document\html\renderer\modules.php(39): JDocumentRendererModule->render(Object(stdClass), Array, NULL) #6 ***\lib in ***\libraries\joomla\database\database\mysql.php on line 555

I've run all the database tools, and everything comes up ok.
If a user is logged in, and goes to the "My Profile" menu link, it comes up a blank page. If I enable debug, that's the error I get.
This first started after I went into the fields in the backend to enable the ajax editing, and when exiting the fields, it changed them to add "cb_" in front - so, "city" became "cb_city".
The same error comes up if I view the member list and click on any member to view their profile.
It seems to me that it is somehow still looking for the old "city" field instead of the new "cb_city" field. I tried to change it back, but everytime I exit the field it adds the "cb_" to the front of whatever I put in there.
Any clue on how to fix this?

BrianLisle wrote: When going to the My Profile menu item, I get this: (tested on 2 different users)
Fatal error: Uncaught exception 'JDatabaseException' with message 'Unknown column 'city' in 'field list' SQL=SELECT city FROM jos_comprofiler, jos_users WHERE user_id=47' in ***\libraries\joomla\database\database\mysql.php:555 Stack trace: #0 ***\libraries\joomla\database\database.php(1164): JDatabaseMySQL->execute() #1 ***\modules\mod_pro_complete\helper.php(75): JDatabase->loadResult() #2 ***\modules\mod_pro_complete\mod_pro_complete.php(41): modProCompleteHelper->getItems(Object(JRegistry)) #3 ***\libraries\joomla\application\module\helper.php(173): include('***...') #4 ***\libraries\joomla\document\html\renderer\module.php(107): JModuleHelper::renderModule(Object(stdClass), Array) #5 ***\libraries\joomla\document\html\renderer\modules.php(39): JDocumentRendererModule->render(Object(stdClass), Array, NULL) #6 ***\lib in ***\libraries\joomla\database\database\mysql.php on line 555

I've run all the database tools, and everything comes up ok.
If a user is logged in, and goes to the "My Profile" menu link, it comes up a blank page. If I enable debug, that's the error I get.
This first started after I went into the fields in the backend to enable the ajax editing, and when exiting the fields, it changed them to add "cb_" in front - so, "city" became "cb_city".
The same error comes up if I view the member list and click on any member to view their profile.
It seems to me that it is somehow still looking for the old "city" field instead of the new "cb_city" field. I tried to change it back, but everytime I exit the field it adds the "cb_" to the front of whatever I put in there.
Any clue on how to fix this?

Suspecting that one of your CB 1.9.1 userlists did not migrate properly.

Suggest you unpublish your existing lists and create new ones in CB 2.0 List Management area.

See if this helps.

I unpublished the member list, cleared the cache on the site, logged off the user from the front end, logged back in, went to My Profile, same error.

This first started after I went into the fields in the backend to enable the ajax editing, and when exiting the fields, it changed them to add "cb_" in front - so, "city" became "cb_city".

Have you updated all your plugins to these versions?

www.joomlapolis.com/cb-20-addon-status

All plugins are current, except for Events Booking - but that one is no longer published as they haven't updated it yet for CB 2.0
The only ones I installed in addition to what came with 2.0 are these:
CB Core Fields Ajax 2.0
CB Footer 1.0
CB Gravatar Field 2.0
CB Progress Field 3.0
CB Reconfirm Email 4.0

BrianLisle wrote: All plugins are current, except for Events Booking - but that one is no longer published as they haven't updated it yet for CB 2.0
The only ones I installed in addition to what came with 2.0 are these:
CB Core Fields Ajax 2.0
CB Footer 1.0
CB Gravatar Field 2.0
CB Progress Field 3.0
CB Reconfirm Email 4.0

Please send me a private message with backend superadmin access and I will take a look.