2021-08-09, 08:20 PM
Hello!
I want to thank developers for a great forum engine (which, in fact, is less vulnerable to spam in comparison to VBulletin, SMF, PhpBB and other ones).
Today one of users told me that he can't write me a PM, he saw the white screen.
It happens due to disabled error messages. Inverstigation shows that when user sends a PM to other user, that enabled the e-mail notification, the forum engine tries to insert a new mail into the mailqueue table and fails due to OUT OF RANGE error (mailqueue primary index was 2^32).
I've just truncated the table (it was empty). I'm not sure if this problem was previously reported or already fixed. My website exists for more then 8 years, so this auto_increment may hit the limit during this large time interval.
I just want to hear any advice before I'll add few more lines to my optimize / check cron job (to check if this table has 0 lines and truncate the table if so).
I want to thank developers for a great forum engine (which, in fact, is less vulnerable to spam in comparison to VBulletin, SMF, PhpBB and other ones).
Today one of users told me that he can't write me a PM, he saw the white screen.
It happens due to disabled error messages. Inverstigation shows that when user sends a PM to other user, that enabled the e-mail notification, the forum engine tries to insert a new mail into the mailqueue table and fails due to OUT OF RANGE error (mailqueue primary index was 2^32).
Quote:Out of range value for column 'mid' at row 1
I've just truncated the table (it was empty). I'm not sure if this problem was previously reported or already fixed. My website exists for more then 8 years, so this auto_increment may hit the limit during this large time interval.
I just want to hear any advice before I'll add few more lines to my optimize / check cron job (to check if this table has 0 lines and truncate the table if so).