Fixed Missing index on purchase_request_key for active/expired user upgrades

Xon

Well-known member
Affected version
2.2.9
The column xf_user_upgrade_active.purchase_request_key/xf_user_upgrade_expired.purchase_request_key is used to locate purchase requests in a number of payment providers, but this column doesn't have an index resulting in slower than expected queries.
 

XF Bug Bot

XenForo bug fixer bot
Staff member
Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XF release (2.2.10).

Change log:
Add additional indexes for the active and expired user upgrade tables
There may be a delay before changes are rolled out to the XenForo Community.
 
Top