WordPress database error

This topic contains 2 replies, has 3 voices, and was last updated by  Stiofan O’Connor 9 years, 9 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • August 19, 2014 at 5:57 pm #12593

    sfamilia
    Buyer
    Post count: 82

    I received the following WordPress database error while adding check box fields to one of my CPTs.

    WordPress database error: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change the column to TEXT or BLOBs]

    and this is followed by a reference to the specific checkbox I just created. The checkboxes do appear on the admin and front end forms but the data is not stored. I tried to add 35 check boxes and received this error on the last 5 or so.

    I do understand that this is not a GD error and most likely a limitation of WP… but I need to offer listers the option to add these 35 yes/no categories to their listing and I want to do this with checkboxes. Is there a work-around for this?

    August 19, 2014 at 6:23 pm #12595

    Simone
    Expired Member
    Post count: 3515

    This is a MYSQL error that happens usually with varchar fields and when a value exceeds the limits. Usually it could be changed to TEXT or BLOBS or LONGTEXT..but let’s listen to Stiofan, maybe something deep (and wrong) is going on.

    August 20, 2014 at 9:08 am #12640

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi sfamilia,

    Can you provide me wp-admin and db access and instructions on how to recreate the error please.

    Thanks,

    Stiofan

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket