[SOLVED] Required Query field; edit not recognised

Have reviewed your install. I'm not sure why, but seams to be an issue specifically with those fields. I created a new test query select field with same usage as your country field and it worked fine. Were these query fields some other fieldtype at some point? Changing a fields type can sometimes mess up the data storage for them. Suggest recreating your two query fields.

I noticed when looking at the comprofiler table in the database that the field type for both fields was Text rather than INT, which is the data type of the field being read from the countries/zones table ; changing these datatypes does not seem to have solved the problem.
The fields certainly underwent some major manipulation when I realised that the J2Store customer address tables needed varchar(255) which is why I changed the comprofiler field datatype to Text (in error, of course; it should have been varchar, though I can't see that this would interfere with storing the data in the comprofiler fields) changing these datatypes to INT(11) does not seem to have solved the problem.


So following your suggestion,
If I create new fields. is there an easy way to transfer the data or do I need to do it via SQL in the database
I presume that saving a copy of these two fields will probably not be enough?

The columns should be text. Suggest just recreating them as my test field worked fine with your exact query setup on your site. In the future please do not alter CBs database structure.

If I create new fields. is there an easy way to transfer the data or do I need to do it via SQL in the database

Yes, you can do a simple update query ran directly on your database to move the data. Example as follows.


Be sure to of course replace new_field_name and old_field_name as needed as well as the jos_ prefix with whatever your table prefix is.

Many thanks for solving this; I've replaced the fields and copied the data and the front-end profile required fields can now be updated.
To anyone else viewing this, remember that if you create a new state query field that depends on a new country query fied you will have to update both the query, and the 'update from' fields in the state field!