Simple Machines Community Forum

SMF Support => SMF 2.1.x Support => Topic started by: Lucarella on November 17, 2024, 06:25:38 AM

Title: Topic too long
Post by: Lucarella on November 17, 2024, 06:25:38 AM
If possible, I would also like to solve another error that my forum has had for a while...
Sometimes it happens that some users want to insert a very long post, but this error appears
6986b379470568602e0156785e760783
https://dd-crew.net/forum/index.php?action=post2;start=0;board=273
/home/ddcrewne/public_html/forum/Sources/Stream.php (Line 670)

Database Error: Data too long for column 'extra_1' at row 1

I have already converted the body column of the smf-messages table from text to mediumtext, now also to longtext, but the error always appears.

Do I have to change something else?

Thanks
Title: Re: Topic too long
Post by: Steve on November 17, 2024, 07:14:42 AM
Did you change your maximum allowed post size to zero in Admin -> Topics and Posts?
Title: Re: Topic too long
Post by: Lucarella on November 17, 2024, 07:46:24 AM
Yes of course... I put 0 to have no limits.
Title: Re: Topic too long
Post by: vbgamer45 on November 17, 2024, 07:46:31 AM
Sounds like a mod issue Stream.php and extra1 are not part of SMF default.
Title: Re: Topic too long
Post by: Lucarella on November 17, 2024, 12:58:54 PM
Yes, I think you are right... It is a paid mod but I can't get support because my subscription has expired...
Title: Re: Topic too long
Post by: Steve on November 18, 2024, 07:20:54 AM
Quote from: Lucarella on November 17, 2024, 07:46:24 AMYes of course..
I didn't mean to insult your intelligence but we don't know unless we ask.

You could always uninstall it and see if if the problem goes away. If not, then you could re-install it.

Make backups first.
Title: Re: Topic too long
Post by: Lucarella on November 18, 2024, 12:33:00 PM
No question is stupid in cases like this, otherwise you risk just wasting time
Uninstalling the mod is the last thing I would like to do because with a similar mod by the same author I had problems with the installation and, if this one does it too, I have little time to fix everything. Maybe I will do it when I am freer if I don't find a different solution first.

Thanks
Title: Re: Topic too long
Post by: @rjen on November 18, 2024, 12:54:01 PM
Well , most likely that mod is the cause, so not too many options.

Best to check the SERVER error log to get the details what code is causing the 500 error.
And if it is the mod code...
Title: Re: Topic too long
Post by: GL700Wing on November 18, 2024, 03:47:56 PM
Quote from: Lucarella on November 17, 2024, 06:25:38 AMDatabase Error: Data too long for column 'extra_1' at row 1
I have already converted the body column of the smf-messages table from text to mediumtext, now also to longtext, but the error always appears.
Have you tried finding which table the 'extra_1' column is in and converting that column to mediumtext or longtext?
Title: Re: Topic too long
Post by: Lucarella on November 19, 2024, 12:46:16 PM
Thanks @GL700Wing , you are a hero
I changed to longtext and it works fine now.

Thanks again for the help