SQL error when saving field in CB 2.0.7

Trying to save the cb_company field I get this error:

Duplicate column name 'cb_company' SQL=ALTER TABLE `j17_comprofiler` CHANGE `company` `cb_company` varchar(255)

I looked in that table and there is no duplicate cb_company field though

ThePiston wrote: Trying to save the cb_company field I get this error:

Duplicate column name 'cb_company' SQL=ALTER TABLE `j17_comprofiler` CHANGE `company` `cb_company` varchar(255)

I looked in that table and there is no duplicate cb_company field though

Hmm, looks like some of the reserved field ids have been misused.

Kyle will have to give some feedback here on how to fix.

I think you will need to do some database changes for the conflicting ids - but Kyle has chime in.

Our old sample data incorrectly created fields. They didn't include cb_ and they reserved IDs. This is no longer the case with CB 2.x. The new sample data begin with cb_ and don't use any specific ID anymore. You should have no issues migrating this by simply resaving the fields or leaving them as is, but it looks like you ran the sample data which created the new ones that are prefixed with cb_ so you likely have 2 company fields in CB > Field Management. I recommend deleting the new cb_ ones created by the sample data then simply editing then saving your existing sample data fields as needed.

It's possible I used sample data, but that would have been lloooong ago. Didn't CB come with a "company" field in the past as standard?

This site is old though and has come from an old version of both Joomla and CB - has been through multiple migrations and versions.

I'll backup DB and delete those fields in CB

It's possible I used sample data, but that would have been lloooong ago. Didn't CB come with a "company" field in the past as standard?

Those were generated by CB 1.x sample data tool. I guess it's possible in an extremely old version back to Mambo/Joomla 1.x days it installed them by default, but I don't recall.