Support

    You are here:  
  1. Home
  2. Support
  3. Badges
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Tuesday 6:09 pm
Add a reply View Replies (7)

Resolved Error 1118: Is there a limit in the number of fields?

  1. ggaillet
    ggaillet
  2. Support
  3. Friday, June 30 2017, 05:37 PM
It kinda looks like I am hitting a limit or something. Any field I am trying to add now is giving me the following error message:

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 SQL=ALTER TABLE #__jsn_users ADD `t2126` VARCHAR(255)

Help please.
Responses (7)
admin
admin Accepted Answer
Admin
Hi,
you have reached MySQL hard limit, try to read here for more info and possible solution: https://www.easy-profile.com/support/mysql-issue-that-no-one-i-know-has-ever-uncounted.html#reply-4666

Also, you can try to remove trashed fields.
  1. more than a month ago
  2. Support
  3. # 1
ggaillet
ggaillet Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
Yes, but keep in mind that fields like checkboxes store value in JSON format, so for example:
in easy-profile.com we have a checkbox field called "Interests" with these options:
- music|Music
- movie|Movie
- art|Art
- design|Design
the maximum value can be ["music","movie","art","design"] (max 32 chars).

So I can reduce the column from 255 to 32.
  1. more than a month ago
  2. Support
  3. # 3
ggaillet
ggaillet Accepted Answer
Thanks. I don't understand the way you are reducing the size with your example. Where do you define those maximum values?
All my checkboxes have these possible values:
0|NIL
1|KA50
2|MI8
3|UH1
4|SA342
5|BO105
6|MI24

How do I reduce this to ["NIL","KA50","MI8","UH-1","SA342","BO105","MI24"]? Do I have to change the type? Or do I have to use this second list instead of the first one in the options list?
  1. more than a month ago
  2. Support
  3. # 4
ggaillet
ggaillet Accepted Answer
In other words, how can I reduce the length of a given column to a customized value different than the default 255?
  1. more than a month ago
  2. Support
  3. # 5
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply, it's too late and our offices are closed.

if you select all checkbox in your field the value will be ["0","1","2","3","4","5","6"] (29 chars), so you can change column length from 255 to 29 (50 is better because you can add some other option without problems).

How to edit column length?
- you need to use some tools like phpMyAdmin, normally all hosting provider provide some tool like this.
- search table called prefix_jsn_users
- for each field you will have a column with same name of field's alias
- edit the column, from VARCHAR(255) to VARCHAR(50)
Attachments (1)
phpMyAdmin.jpg phpMyAdmin.jpg
  1. more than a month ago
  2. Support
  3. # 6
ggaillet
ggaillet Accepted Answer
Content Protected
  1. more than a month 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
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

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.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.