database error: [Row size too large]

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

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

Open Support Ticket
  • Author
    Posts
  • #433811

    Mohanraj Thirumalai
    Expired Member
    Post count: 26

    I created a new custom type trainers and I am editing the fields in the trainers custom type listing form.

    I am adding RADIO fields to the form and after I add a few radio fields I get this error

    * WordPress database 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]
    * ALTER TABLE

    wp_geodir_gd_personal_trainers_detail

    ADD

    geodir_box

    VARCHAR( 254 ) NULL

    and cant add any more RADIO fields to the form.

    Thanks in advance.

    #433894

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    this error is uncommon and usually database specific (the reason for the error itself) but can usually be fixed by changing the data type from VARCHAR to TEXT in the database, perhps via phpMyAdmin.

    #433915

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Please provide wp-admin details and i will take a look.

    Stiofan

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
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount