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

[nocte]

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` - ?)'
src/XF/Db/AbstractStatement.php:230

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?

 

[nocte]

Might this be a bug in XFMG?

Seems so:

Fixed - User Alert decrementing below zero errors (_postDelete/_postSave)

MySQL query error [1690]: BIGINT UNSIGNED value is out of range in '(`xenforo`.`xf_user`.`alerts_unread` - 1)' This is caused by this; $this->db()->query(" UPDATE xf_user SET alerts_unread = GREATEST(0, alerts_unread - 1) WHERE user_id = ? ", $this->alerted_user_id); The required...

xenforo.com

 

[XF Bug Bot]

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.