Support

  1. Agape
  2. Support
  3. Monday, July 13 2020, 05:37 PM
  4.  Subscribe via email
Our understanding is that the MariaDB global max row size is 65536 (64K), regardless of the storage engine. We use innodb as our storage engine.

Our innodb_page_size is set to 16K, but InnoDB has a maximum row size that is roughly equivalent to half of this value.

Innodb_strict_mode is OFF, so we're open to warnings without getting halted.

In Joomla, we continued to add fields to EasyProfile until we got the following error:

1118 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 some columns to TEXT or BLOBs

So we backed up the jsn_users table right up to that point just short of 65535 (without the above error) and then dropped the table.

Using PHPMyAdmin, we did an import of the jsn_users table back into Joomla and got a warning about >8126 bytes (1/2 the page size), but the system continued to import because innodb_strict_mode is set to OFF. It doesn't stop on warning. Everything seems to be working and looks good.

We are assuming that EasyProfile checks for the MariaDB global max of 65535 and generates the error within Joomla. Is that correct? If EasyProfile doesn't do the check, it seems we would be at risk and very "unsafe", getting a truncated table without knowing it.

As long as we are less than 65535, are we safe (even though we get an innodb warning using PHPmyAdmin) and can we trust the EasyProfile error message about 65535?
admin Accepted Answer
Admin
Easy profile does not do any check, when you create a field then Easy Profile will create a column in the table. if you go over the maximum row size then the DB server return an error, it does not truncates the table, simply it does not create the column.

About your error, can you please post here the exactly message?

To avoid this you can change the DB column type of all your text field type (Easy Profile field type) from VARCHAR to TEXT (DB column type). TEXT column type does not affect the row size and works like VARCHAR but the performance for search could be a little worse.
  1. 3 weeks ago
  2. Support
  3. # 1
Agape Accepted Answer
Pro
Thank you for your reply. The error we encounter is:

Error Code: 1118
Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

Thanks again!
  1. 3 weeks ago
  2. Support
  3. # 2
Agape Accepted Answer
Pro
Please ignore the above error. I should have given this response:

1118 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 some columns to TEXT or BLOBs

Thank you
  1. 3 weeks ago
  2. Support
  3. # 3
admin Accepted Answer
Admin
Hi,
this happen in phpmyadmin?
  1. 3 weeks ago
  2. Support
  3. # 4
Agape Accepted Answer
Pro
The error is generated within Joomla when we try to create an EasyProfile field.
  1. 3 weeks ago
  2. Support
  3. # 5
admin Accepted Answer
Admin
To avoid this you can change the DB column type of all your text field type (Easy Profile field type) from VARCHAR to TEXT (DB column type). TEXT column type does not affect the row size and works like VARCHAR but the performance for search could be a little worse.
  1. 3 weeks ago
  2. Support
  3. # 6
Agape Accepted Answer
Pro
We changed the size of varchar(255) to varchar(64) which allowed us to complete the form. Thank you!
  1. one week ago
  2. Support
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy ProfileĀ® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.