Row size too large notification

  • Hi Roland,

    PDB notification/error?: Row size too large

    Case
    – Added a new field: news_letter
    – Removed the field
    – Added a new field: newsletter

    This error notification appeared:
    Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

    The newsletter field was created through.

    Can you please enlighten me about this notification.
    I am available to conduct more tests if needed.

    Thanks

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

    (@xnau)

    That is unusual, and I’m not sure I know what it means. I’d suggest you ask your web host, this may have something to do with your database configuration.

    Thread Starter IT247365

    (@it247365)

    Thanks, Roland,

    The reason for the notification can be seen here (innodb_page_size): https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_page_size

    My web-host claim they use the default value of 16K, but I have no possibility to check this. The web-host do not offer to change their setting.

    As I am probably one of the users of PDB that use the plugin(s) to the fullest, my case might be special, but as the popularity of your plugin(s) increase day by day I thought it would make sense for you to give it some architectural thoughts.

    In my case, I temporarily have to make a clean-up of the database and live with the host limitation for a while, i.e. no more new fields, as far as I can figure out.

    ANY suggestions are welcome

    Plugin Author xnau webdesign

    (@xnau)

    OK, I don’t know the exact reason for this, but what you can do about it really depends on the circumstances under which it is happening.

    Dividing your fields up into more, smaller groups will probably help if this is happening when trying to save the field definitions. If you’re running into this on frontend submissions, you can use a multi-page form so that the whole form is not saved at once.

    Thread Starter IT247365

    (@it247365)

    I have solved the problem temporarily by cleaning-up leftover fields not used anymore using phpMyAdmin. The 16k default database settings can be a general limitation using PDB on non-dedicated servers

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Row size too large notification’ is closed to new replies.