MyBB Community Forums

Full Version: Data too long for column 'smtperror'
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Running: 
  • MyBB 1.8.36
  • PHP 7.4.33
  • MySQLi 8.0.34

Error: 

The SQL error occurs when the SMTP server rejects the provided password and the error message that is logged (in the System Email Log) is too long for the current column. I suggest increasing smtperror column in the mybb_mailerrors table from VARCHAR(200) to VARCHAR(300).

[attachment=46337]

When using the Gmail SMTP server for example, the following error message was provided which is 261 characters, 61 characters longer than the column allows.

Quote:The SMTP server rejected the supplied SMTP password. Reason: 534-5.7.9 Please log in with your web browser and then try again. Learn more at 534 5.7.9 https://support.google.com/mail/?p=WebLoginRequired i11-20020a633c4b000000b005774e5b0e54sm673304pgn.31 - gsmtp