Error saving form : "Row size too large(…)"

  • Resolved jls

    (@jls)


    13 years, 9 months ago

    First I must say that this is a great plug-in!!!

    I’m using version 1.5.9 on 3.1.2 WordPress site.

    When saving a new form with more than 22 fields I get the following error:
    “Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs”

    Is there any way around this issue?

    Best regards,

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author hoffcamp

    (@hoffcamp)

    Thanks! I’ll see what I can do. If you have access to your database you could change the column types yourself, but I’ll add something to the form settings that lets you modify this for the next update.

    Plugin Author hoffcamp

    (@hoffcamp)

    I have a temporary fix for you. The ‘text area’ type uses TEXT, so you could make some of your fields text areas with a height of 20px or so.

    Plugin Author hoffcamp

    (@hoffcamp)

    In 1.5.10 there is a section under ‘advanced’ in the forms editor called ‘submission data’, which lets you change the column type via a MySQL column definition. If you want to change the max length of the data stored, say to 50 characters, you would just the VARCHAR(1000) part to VARCHAR(50) and not worry about the rest. You could also put in “TEXT NOT NULL”, which is a perfectly valid column definition all by itself, and that would also solve your problem.

    Thread Starter jls

    (@jls)

    Thank you Hoffcamp!

    You are doing a great job with this plug-in.

    Best regards,

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error saving form : "Row size too large(…)"’ is closed to new replies.