Announcement

Collapse
No announcement yet.

Accidently deleted profile field2

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

  • Accidently deleted profile field2

    The one that is used for 'location' is gone.

    How can I restore it, when I try to make a new one it gets another ID and I would like it to have the one in the templates 'field2'

    Thanks

  • #2
    You can create it directly in phpMyAdmin.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      How do I create that in phpMyAdmin?

      What is the correct query to do that please?

      Thank you.

      Comment


      • #4
        Add a field in your AdminCP.
        Then, run these two queries:

        UPDATE profilefield SET profilefieldid = 2 WHERE profilefieldid = X;
        ALTER TABLE userfield CHANGE fieldX field2 MEDIUMTEXT NULL DEFAULT NULL;

        Replace both instances of X with the profilefieldid of the new field.
        Best Regards
        Colin Frei

        Please don't contact me per PM.

        Comment


        • #5
          Thank you sir, that worked perfectly

          Comment

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