Fixed Error on album delete: "BIGINT UNSIGNED value is out of range"


Well-known member
I saw this error in the error log. coming from a user who tried to delete his album:

XF\Db\Exception: MySQL query error [1690]: BIGINT UNSIGNED value is out of range in '(`db`.`xf_user`.`xfmg_media_count` - ?)'

stack trace shows this query:

                    UPDATE xf_user
                    SET xfmg_media_count = GREATEST(0, xfmg_media_count - ?)
                    WHERE user_id = ?

Might this be a bug in XFMG?

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 XFMG release (2.2.5).

Change log:
Fix potential out-of-range error with adjusting media counts when albums are deleted
There may be a delay before changes are rolled out to the XenForo Community.