frm
Well-known member
I've gotten the MySQL query to update the varbinary in order to change the field type to appear that the new values will appear in the drop down on the database table (it'll show the new field id name in phpMyAdmin and have the underlying varbinary on edit).
However, even if I enter all of the values that the text boxes had as options in the newly created drop-down in the ACP, they won't appear. They wouldn't even appear prior to that either.
There has to be a way to convert and restore values from a text box input to drop downs without manually doing it for 1000s of items.
I'm not understanding why updating the field id wouldn't display the value at all (pre-creation of values or after the exact values are created).
Would this require custom development or is there a query that I could do to do the conversion?
I did something like this to change the values to link to the new field id (it works and displays correctly in phpMyAdmin):
Is there a way to do this with a query or would I require an add on that groups all the text fields (about 10) to get the exact match used, create a drop down with those options, then retrieve the text entry and apply it to the drop down, and either automatically remove the old textbox field or manually delete it from ACP?
Thanks
However, even if I enter all of the values that the text boxes had as options in the newly created drop-down in the ACP, they won't appear. They wouldn't even appear prior to that either.
There has to be a way to convert and restore values from a text box input to drop downs without manually doing it for 1000s of items.
I'm not understanding why updating the field id wouldn't display the value at all (pre-creation of values or after the exact values are created).
Would this require custom development or is there a query that I could do to do the conversion?
I did something like this to change the values to link to the new field id (it works and displays correctly in phpMyAdmin):
Code:
UPDATE `xf_thread_field_value` SET `field_id` = NEWVALUE AND `xf_thread_field_value`.`field_id` = CAST(OLDVALUE AS BINARY)Is there a way to do this with a query or would I require an add on that groups all the text fields (about 10) to get the exact match used, create a drop down with those options, then retrieve the text entry and apply it to the drop down, and either automatically remove the old textbox field or manually delete it from ACP?
Thanks
