No announcement yet.

Reset on Profile Fields?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Jake Bunce
    A quick way to wipe all profile fields is to delete all userfield records and then update your counters. First run this query to delete all userfield records:

    DELETE FROM userfield WHERE userid<>your userid

    Replace your userid with the userid of your admin account. You can't update your counters afterwards if your profile is broken! This will exclude your userfield record from being deleted. Also, if you use table prefixes in your database then change userfield to include the prefix.

    You can run this query in your:

    Admin CP -> Import & Maintenance -> Execute SQL Query

    Backup first!

    Then go to your:

    Admin CP -> Import & Maintenance -> Update Counters -> Fix broken user profiles

    Perform that action. This will recreate userfield records for your users. They will all be blank now.

    Leave a comment:

  • sugoikawaii
    started a topic Reset on Profile Fields?

    Reset on Profile Fields?


    I was wondering if anyone knew how to batch reset all profile fields using sql query? I'd like for my users to change their stats.

    Thanks in advance,

Related Topics


  • rnedelkow
    SQL query tables
    by rnedelkow

    I'm looking for sql queries that can fetch info like :

    - user posts including content/body
    - nodes (channels) and sub-nodes(sub-channels)
    - user profile attributes...
    Wed 24 Oct '18, 7:54am