imthebest Well-known member Apr 14, 2015 #1 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
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
Mike XenForo developer Staff member Apr 14, 2015 #2 They need to be expired in the UI. You can find them in the xf_warning table. Upvote 0 Downvote
imthebest Well-known member Apr 14, 2015 #3 So it is not safe to expire those with DB queries? Upvote 0 Downvote
Mike XenForo developer Staff member Apr 14, 2015 #4 No, there are many other things which need to be conditionally updated. Upvote 0 Downvote
imthebest Well-known member Apr 14, 2015 #5 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! Upvote 0 Downvote
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!
Mike XenForo developer Staff member Apr 15, 2015 #6 They are the entries that have an expiry_date of 0. Upvote 0 Downvote
imthebest Well-known member Apr 17, 2015 #7 SELECT * FROM xf_warning WHERE expiry_date=0 Is that query ok? Upvote 0 Downvote
