- Posts: 25
COMMUNITY FORUM
Changing Extra Field data type to MEDIUMTEXT
- Nathan
- Topic Author
- Offline
- Junior Member
Less
More
9 years 1 month ago #147439
by Nathan
Changing Extra Field data type to MEDIUMTEXT was created by Nathan
Hi,
I'm working on a project where we're making extensive use of the Extra Fields feature in K2 and as I've discovered about a week out from launch the client is publishing volumes of text in to Text Area fields much greater than I'd expected, to the point where it's exceeding the limit for standard MySQL TEXT database fields.
I'm wondering if there would be any problems with me switching the Extra Fields database field to type MEDIUMTEXT so it would allow for the extra data?
Thanks
Nathan
I'm working on a project where we're making extensive use of the Extra Fields feature in K2 and as I've discovered about a week out from launch the client is publishing volumes of text in to Text Area fields much greater than I'd expected, to the point where it's exceeding the limit for standard MySQL TEXT database fields.
I'm wondering if there would be any problems with me switching the Extra Fields database field to type MEDIUMTEXT so it would allow for the extra data?
Thanks
Nathan
Please Log in or Create an account to join the conversation.
- Lefteris
- Offline
- Moderator
Less
More
- Posts: 8743
9 years 1 month ago #147449
by Lefteris
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Lefteris on topic Changing Extra Field data type to MEDIUMTEXT
Hi,
No there should be no problem changing that. Remember to backup the table first.
Let me know about this.
No there should be no problem changing that. Remember to backup the table first.
Let me know about this.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Nathan
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 25
9 years 1 month ago #147452
by Nathan
Replied by Nathan on topic Changing Extra Field data type to MEDIUMTEXT
Thanks Lefteris,
I've backed up the table and made the change.
Have then tested publishing the extra content and it saved correctly.
Everything seems to be working fine, but we'll be publishing content all day tomorrow so I'll see how it goes then.
Will report back if we have any problems.
Cheers
Nathan
I've backed up the table and made the change.
Have then tested publishing the extra content and it saved correctly.
Everything seems to be working fine, but we'll be publishing content all day tomorrow so I'll see how it goes then.
Will report back if we have any problems.
Cheers
Nathan
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 1 month ago #147467
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Changing Extra Field data type to MEDIUMTEXT
Is everything ok Nathan?
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Nathan
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 25
9 years 1 month ago #147469
by Nathan
Replied by Nathan on topic Changing Extra Field data type to MEDIUMTEXT
Hi Krikor,
Thanks for following up... sorry been too flat out today to report back.
But I can happily report that we haven't had any problems today while working on the site so I think everything is ok with the database field type change.
Cheers
Nathan
Thanks for following up... sorry been too flat out today to report back.
But I can happily report that we haven't had any problems today while working on the site so I think everything is ok with the database field type change.
Cheers
Nathan
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 1 month ago #147476
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Changing Extra Field data type to MEDIUMTEXT
Glad to hear this Nathan :)
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.