Icy Phoenix

Hello, this is my first topic in here :D and like the title says, i would like to know how to modify the maximum Length of the messages in the icy phoenix system. As far as i know the this maximum is 32000 characters in one message, but i would like to change this.

Thank you for your time :mrblue:

PD: I used the "search" tool, but i couldn't find an answer :?

So anyone? If this is not allowed just tell me so i cant stop searching if this can be done. :wink:

The limit is set by the text type (TEXT) used in MySQL and is more like 65000 characters not 32000.
There are other text types that allow for more characters ... MEDIUMTEXT allows for 16 million and LONGTEXT can store 4 billion.

I no expert by any means and you should always back up your data before making changes to your database, but it would seem logical to me that you could just change the field type for post_text and post_text_compiled in the posts_text table

Thank you very much, i´ll give it a try ^^.

EDITED: :mrblue: this worked, i changed it to MediumText and now its all good. Thanx again :wink:

postanime wrote: [View Post]

Thank you very much, i´ll give it a try ^^.

EDITED: :mrblue: this worked, i changed it to MediumText and now its all good. Thanx again :wink:

I am very interesting in this.
postanime, can you give more details.

Thank you

xmenfile wrote: [View Post]

postanime wrote: [View Post]

Thank you very much, i´ll give it a try ^^.

EDITED: :mrblue: this worked, i changed it to MediumText and now its all good. Thanx again :wink:

I am very interesting in this.
postanime, can you give more details.

Thank you

Oh yes of course. It is really simple.

1. Go to your database manager (E.g. Phpmyadmin) and login to your Icyphoenix database.

2. Backup your database with your control panel (Optional but i suggest it)

3. Go to the table posts_text, and change the field Type of post_text and post_text_compiled from Text to MediumText. Save changes and exit.

4. Make a test topic of more than 65000 characters and if it is fully shown then you're set :v: .

Remember that if you already have a topic with more than 65000 characters in your forum, you have to edit it and resubmit it, so the changes can be seen.