Question Removing Credits Expiration

[Senkusha]

I recently removed all the Expiration of Credits for all my Earning Events, but I'm still getting notifications that Credits are expiring each day I log in to my site. Is there a query I can run to manually reset the Expiration value for all prior Credits earned?

 

[Fillip H.]

There is no way to remove the expiry date on existing transactions via the UI. If you want to remove ALL expiry dates for all existing transactions, run this SQL query:

UPDATE xf_dbtech_credits_transaction
SET expiry_date = 0

 

[Senkusha]

Thank you!