I recently migrated a Joomla 1.5 site to Joomla 3.2.3. Using SP Upgrade, I migrated my Community Builder 1.9.1 data. The process went very smooth except for one problem. In the Admin area, when I run the "Tools", "Check Community Builder Database", I get the following error message (Note: When I run "Check Community Builder User Fields Database" tool, all lines are green, meaning, OK):
Checking Community Builder Database:
All Community Builder comprofiler_field_values table fieldid rows all match existing fields.
Warning: 6 entries in Community Builder comprofiler_field_values link back to fields of wrong fieldtype.
fieldvalueid=16 fieldtype=text
fieldvalueid=17 fieldtype=text
fieldvalueid=18 fieldtype=text
fieldvalueid=19 fieldtype=text
fieldvalueid=20 fieldtype=text
fieldvalueid=21 fieldtype=text
This one can be fixed in SQL using a tool like phpMyAdmin.
All Community Builder fields from comprofiler_fields are present as columns in the comprofiler table.
A fieldtype was changed from a list type to a text type. This results in the fieldvalues for that field being left behind. You can either ignore it or remove them manually within the _comprofiler_field_values database table.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
