[SOLVED] Maximum length of an article form

gaekwad · 2013-08-23 06:41:13

I’ve come up against what I think is an upper limit for the length of an article form. i’m trying to save a ~70,000 character default form and I get this:

Internal error "Data too long for column 'Form' at row 1".

and then:

I’m sorry. I’m afraid I can’t do that; form form_save is an unsafe operation.

Short of splitting the default form into smaller forms, is there anything I can (safely) change on my database to allow a larger form? The table is txp_form, the field is Form, the type is TEXT and the length is not set.

Thanking you in advance, sirs and ma’ams.

Last edited by gaekwad (2013-08-23 07:00:32)

gaekwad · 2013-08-23 06:50:05

OK, so it looks like TEXT is limited to 64k, which explains the flub at ~70,000 characters.

Switching the type to MEDIUMTEXT should fix it. I’m going to find out how to switch and report back.

gaekwad · 2013-08-23 07:00:19

I switched the field type to MEDIUMTEXT and this upped the limit from 64k to 16mb. Form saved, error resolved.

Textpattern CMS

Textpattern CMS support forum

#1 2013-08-23 06:41:13

[SOLVED] Maximum length of an article form

#2 2013-08-23 06:50:05

Re: [SOLVED] Maximum length of an article form

#3 2013-08-23 07:00:19

Re: [SOLVED] Maximum length of an article form

Board footer