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?
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.
Top Bottom