Field display error

Suddenly, the phone field in ALL individual accounts is changed to display the account URL instead of the phone numbers. ALL accounts had phone numbers saved, but now they have disappeared! See attachment.

Running J 3.6.5, CB 2.1.0

Any advice

Please me sure to search before posting. This has already been answered below.

www.joomlapolis.com/forum/153-professional-member-support/235727-builds-and-phone-field-phone-has-disappeared?start=6#290045

The code causing this has also already been fixed and won't happen again.

Will now update fix this error automatically?
I'm running CB 2.1.0, if update to the latest version, will that fix it?

No, updating will not fix this issue. It needs to be manually fixed. You can run the below database query to fix it then install latest CB to recreate the alias field.


Note it is important that you replace jos_ with whatever you actual database table prefix is. Typically you'd just run this through phpmyadmin after adjusting the prefix. This will revert alias to cb_phone field. You then need to install CB again for it to recreate the alias field as a new field. Values stored in _comprofiler should be untouched.

Please be sure to be making backups before running any direct database queries.

I did run the above database query, and upgrade to CB 2.1.2, but it didn't fix it
Now, I did try to edit the table manually as you explain it first, but I didn't find the alias within _comprofiler_fields, see attachment.

Please advice, Thank you

The query worked perfectly fine in my tests. I've no idea how you're trying to run the query, but you typically just do so under the SQL tab. Review _comprofiler_fields database table to see if the alias field reverted to cb_phone. It will have a fieldid of 43. Read the below topic for more details.

www.joomlapolis.com/forum/153-professional-member-support/235727-builds-and-phone-field-phone-has-disappeared?start=6#290045