Fax Field becomes Accept Terms & Conditions field on upgrade

Hi,

I have the same issue as was report here: www.joomlapolis.com/forum/147-potential-bug/231943-field-fax-transformed-to-acceptedterms#274110 . I upgraded my CB 1.9.1 Joomla 3 site to CB 2.0.14. The old fax field is now of type Terms and Conditions instead of a Text field. We are using the Fax field and we use Terms and Conditions. This problem was reported over 6 months ago and is still an issue.

How is the best way to handle this problem? Can we change the Fax field to be a text field in the database somehow and add a new Terms & Conditions field?

Right now when you go to edit your profile, the Fax field doesn't show up, so you can add/edit your fax number. People need to be able to add or change their fax number on the site.

Thank you.

That field was most likely using a reserved field id. To fix it you need to make a new fax field. It's not common for a reserved field id to be used and generally only happens when the database was altered somehow and the auto increment value was reset. Believe the old sample data fields also created a bit wonky, but now properly creates normal managed fields. We're looking into ways we can do the system fields without having to reserve their ids for CB 3.x and onwards.

Hi Kyle,

Making a new fax field doesn't solve the problem. We have over 800 members in the system with many of them having information in the old fax field. We need a way to 'fix' the database so old fax field is still a fax field and the new Terms field uses a new field. Or a script that can be used to copy the info from the old fax field to the new fax field and fix the Terms field to it's proper valid.

Thank you.

You can copy 1 field to another with a simple update query. Example as follows.


The above copies FIELD_NAME_1 value to FIELD_NAME_2 in CBs user table (_comprofiler). Replace jos_ with whatever your database table prefix is.

The field id is reserved so you must create a new fax field then copy the value over. If you started with a CB 1.x install that had sample data ran early in its release then this is most likely the cause of your fax field using a reserved field id.