1

Topic: db_update.php "Data too long for column 'message'"

The error occurred on line 1806 in admin\db_update.php
Database reported: Data too long for column 'message' at row 1 (Errno: 1406).

Message have max size =64k.
There are also longer messages.
For them the field in a database sets to mediumtext, but the script of updating ignores this fact sad

Re: db_update.php "Data too long for column 'message'"

Message size may increase because "preparse_bbcode" function can add extra bb-codes to the message body (1806 line).

We'll try to reproduce this bug. What database version do you use?

Re: db_update.php "Data too long for column 'message'"

Do you still have this problem?

Re: db_update.php "Data too long for column 'message'"

So anyone can run the db_updater.php when we update the forum?

Re: db_update.php "Data too long for column 'message'"

Actually yes. But db_updater.php will say that there is nothing to update.

You may delete db_updater.php after updating. And do not forget to turn Maintenance mode on before start updating.

Re: db_update.php "Data too long for column 'message'"

parpalak wrote:

Actually yes. But db_updater.php will say that there is nothing to update.

You may delete db_updater.php after updating. And do not forget to turn Maintenance mode on before start updating.

I successfully ran db_updater.php a while ago here on this forum when you guys were updating.

Re: db_update.php "Data too long for column 'message'"

I forgot to turn Maintenance mode on. However, seems like everything is OK smile