1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 Warnings without expiration

Discussion in 'XenForo Questions and Support' started by imthebest, Apr 14, 2015.

  1. imthebest

    imthebest Formerly Super120

    Hi,

    I have some old warnings applied to my members that never expire. Their expiration time is being displayed as N/A.

    Could you please provide a query to find all those warnings and expire them now?

    Thanks,
    Super120
     
  2. Mike

    Mike XenForo Developer Staff Member

    They need to be expired in the UI. You can find them in the xf_warning table.
     
  3. imthebest

    imthebest Formerly Super120

    So it is not safe to expire those with DB queries?
     
  4. Mike

    Mike XenForo Developer Staff Member

    No, there are many other things which need to be conditionally updated.
     
  5. imthebest

    imthebest Formerly Super120

    Okay, but I need a query to find all those currently never expiring warnings (those that have their expiration time displayed as N/A).

    Please provide the query. Thanks!
     
  6. Mike

    Mike XenForo Developer Staff Member

    They are the entries that have an expiry_date of 0.
     
  7. imthebest

    imthebest Formerly Super120

    SELECT * FROM xf_warning WHERE expiry_date=0

    Is that query ok?
     

Share This Page