Announcement

Collapse
No announcement yet.

How To Update Counters or Rebuild Custom Profile Field

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How To Update Counters or Rebuild Custom Profile Field

    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.
    vBulletin 4.2.5 | PHP 7.0.31 | MariaDB 10.2.17

  • #2
    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 `fieldx` = 'NEW_VALUE' WHERE `fieldx` = 'OLD_VALUE'
    * don't forget to add table prefix if you have,
    * 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.

    Former vBulletin Support Staff
    Need Help?, Or P.M. Me

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X