[Chris M]

Open admin/user.php
Find:

PHP Code:

                               avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature
                               FROM user
                               LEFT JOIN signature ON signature.signatureid=user.signatureid
                               LEFT JOIN customsignature ON customsignature.userid=user.userid 


Change to:

PHP Code:

                       avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,
                               signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               LEFT JOIN signature ON signature.signatureid=user.signatureid
                               LEFT JOIN customsignature ON customsignature.userid=user.userid 


Satan