Data too long for column 'smtperror'
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

Data too long for column 'smtperror'
Data too long for column 'smtperror'

  • MyBB 1.8.36
  • PHP 7.4.33
  • MySQLi 8.0.34


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).

  Screenshot 2023-09-18 173900.png (Size: 46.95 KB / Downloads: 21)

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 i11-20020a633c4b000000b005774e5b0e54sm673304pgn.31 - gsmtp

Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Sign in
Already have an account? Sign in here.

Forum Jump:

Users browsing this thread:
1 Guest(s)