How To Update Counters or Rebuild Custom Profile Field

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pocket Aces
    Member
    • Mar 2007
    • 99
    • 4.2.x

    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
  • AliMadkour
    Senior Member
    • Dec 2004
    • 1588
    • 6.X

    #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 `field[B]x[/B]` = 'NEW_VALUE' WHERE `field[B]x[/B]` = '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...