Keyword

Changing Extra Field data type to MEDIUMTEXT

  • Nathan
  • Nathan's Avatar Topic Author
  • Offline
  • Junior Member
More
9 years 2 weeks ago #147439 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

Please Log in or Create an account to join the conversation.

More
9 years 2 weeks ago #147449 by Lefteris
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.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Nathan
  • Nathan's Avatar Topic Author
  • Offline
  • Junior Member
More
9 years 2 weeks ago #147452 by Nathan
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

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 1 week ago #147467 by Krikor Boghossian
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
  • Nathan's Avatar Topic Author
  • Offline
  • Junior Member
More
9 years 1 week ago #147469 by Nathan
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

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 1 week ago #147476 by Krikor Boghossian
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.


Powered by Kunena Forum