We have custom profile field with Single-Selection Menu (user will select one from 5 preset values). We edited the values, but after saving the new values, the old values still show in postbit and profile page.
How To Update Counters or Rebuild Custom Profile Field
Collapse
X
-
How To Update Counters or Rebuild Custom Profile Field
vBulletin 4.2.5 | PHP 7.0.31 | MariaDB 10.2.17Tags: None -
I think there is no option to do that, But you can run manual query to update it ( How to run manual query from admincp? )
First take a full backup from your database (SUPER IMPORTANT)
run a query like that
Code:UPDATE `userfield` SET `field[B]x[/B]` = 'NEW_VALUE' WHERE `field[B]x[/B]` = 'OLD_VALUE'
* replace x in (fieldx) to your custom user field id
* replace your old and new value,
AGAIN don't forget to take a full database backup before running manual queries.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment