Solved: 2 Years, 1 Month, 2 Weeks ago The message is too long
#1
Solved: 2 Years, 1 Month, 2 Weeks ago
Hi

I have not used MyBB in a very long time and now I wonder about this message when to post a number of pictures.

How do I remove condition? That is to say unlimited.

I have had phpBB and there be no problem. There you could have obgränsat with pictures.

Have changed during dashboard page but it does not help.

Uses the latest version of MyBB.


[Image: yEFJMHd.png]

[Image: oPje21H.png]

[Image: EIZXBjQ.png]
Reply
#2
Solved: 2 Years, 1 Month, 2 Weeks ago
The description says it all. If you wanna allow users to post more than 65535 characters in their message you need to manually alter message field type in your database.

MySQL users (max: 65535) can change message field type manually from TEXT to MEDIUMTEXT (16777215) or LONGTEXT (4294967295) to obtain enhanced limit.
Reply
#3
Solved: 2 Years, 1 Month, 2 Weeks ago
SQL query can be like this
ALTER TABLE `mybb_posts` MODIFY COLUMN `message` MEDIUMTEXT

[SQL queries related guidance]
Reply
#4
Solved: 2 Years, 1 Month, 2 Weeks ago
(2019-05-01, 09:09 AM)effone Wrote: The description says it all. If you wanna allow users to post more than 65535 characters in their message you need to manually alter message field type in your database.

MySQL users (max: 65535) can change message field type manually from TEXT to MEDIUMTEXT (16777215) or LONGTEXT (4294967295) to obtain enhanced limit.

Ok, where do I change this if it is now manually under the database?
Reply
#5
Solved: 2 Years, 1 Month, 2 Weeks ago
^ you can do it manually or by using a SQL query.
Reply
#6
Solved: 2 Years, 1 Month, 2 Weeks ago
I want to do this manually but I don't know where this is. Can you write down where this is located?
Reply
#7
Solved: 2 Years, 1 Month, 2 Weeks ago
^ assuming that you have phpMyAdmin at your hosting panel, see above suggested SQL queries related guidance

you have to navigate to structure of the posts table, find message field & modify it
Reply
#8
Solved: 2 Years, 1 Month, 2 Weeks ago
Thanks. M.

Is this what you mean? What do you need to fill in for tasks? And yes, I have read through the link you sent but for me this is Greek    Shy

[Image: JyMzgke.png]

(2019-05-01, 09:14 AM).m. Wrote: SQL query can be like this
ALTER TABLE `mybb_posts` MODIFY COLUMN `message` MEDIUMTEXT

[SQL queries related guidance]

Såja, now I solved this. Thanks. M. for your reply
Reply
#9
Solved: 2 Years, 1 Month, 2 Weeks ago
(2019-05-01, 11:06 AM).m. Wrote: ^ assuming that you have phpMyAdmin at your hosting panel,  see above suggested SQL queries related guidance

you have to navigate to structure of the posts table, find message field & modify it

I am wondering something here...

Can this be done in the AdminCP, too?

Look at the screenshot.

[Image: d3a4ae94d6182ed6903dac80207d5090.png]
I'm Serpius and You're Not    ¯\_(ツ)_/¯
Deaf Golf
Reply
#10
Solved: 2 Years, 1 Month, 2 Weeks ago
^ increasing the field value at forum admin panel might not be sufficient.
maximum length of a database field basically depends on the type of the field
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)