Support

    You are here:  
  1. Home
  2. Support
  3. Creating custom fields
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (11)

Resolved Error on save "town_lng" field, try to recreate a field!

  1. vinnie
    vinnie
  2. General
  3. Monday, November 26 2018, 11:11 PM
Good evening.
I have 2 gmap fields in the same group. A radio conditionally decides which one to show.
However, if I edit from Joomla backend the second gmap field, which I created last, after the first one, I get the message you see in the title. The field alias is "town", for same reason the message comes up with "town_Ing".
Isn't that maybe I can't have more than one gmap field? What does the error mean?
You can see the error in the attachment.
Attachments (1)
easy_pro.png easy_pro.png
  1. error
Responses (11)
vinnie
vinnie Accepted Answer
Thanks, I deleted some unpublished fields, not it works.
Thank you very much indeed!
Have a good day!
  1. more than a month ago
  2. General
  3. # 1
admin
admin Accepted Answer
Admin
Hi,
see screenshots

- Select table "#__jsn_users"
- Go to "Structure"
- You can convert to TEXT type all column of type VARCHAR (we recommend to convert only Easy Profile text field type), to do this click to "Change" link
- Select new type ("TEXT";)
- Save
Attachments (3)
1.png 1.png
2.png 2.png
3.png 3.png
  1. more than a month ago
  2. General
  3. # 2
vinnie
vinnie Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 3
admin
admin Accepted Answer
Admin
Would it make it some room for further fields?
Yes, Mysql TEXT type is not counted in table length.

Can you clarify this please?
Yes, do you use phpMyAdmin to manage databases? if yes then we can send you some screenshots, otherwise which tool do you use?
  1. more than a month ago
  2. General
  3. # 4
vinnie
vinnie Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 5
admin
admin Accepted Answer
Admin
Yes
  1. more than a month ago
  2. General
  3. # 6
vinnie
vinnie Accepted Answer
Thanks. Does this mean I have too many fields?
  1. more than a month ago
  2. General
  3. # 7
admin
admin Accepted Answer
Admin
Hi,
you have reached MySQL hard limit.
In the Easy Profile user table each field create one or more column. Unfortunately MySQL have a hard limit that not allow you to create infinite columns.

To solve this you can:
1) remove trashed fields (see screenshot)
2) with a tool like phpMyAdmin you can change type of column in the table #__jsn_users from VARCHAR to TEXT (only for columns related to Text field type)
Attachments (1)
Schermata 2018-11-27 alle 12.53.26.png Schermata 2018-11-27 alle 12.53.26.png
  1. more than a month ago
  2. General
  3. # 8
vinnie
vinnie Accepted Answer
I am recreating the field and I am stumbling on the error you see in the attachment. Does it have anything to do with the issue we're dealing with in this thread?
  1. more than a month ago
  2. General
  3. # 9
vinnie
vinnie Accepted Answer
Thanks, I can't. It's offline. I have 2 identical sites and I got this problem only with one of them. Can't get why.
  1. more than a month ago
  2. General
  3. # 10
admin
admin Accepted Answer
Admin
Hi,
can you please post me your site details to check this? if yes then you can use the form below the reply in "Site Details" tab
  1. more than a month ago
  2. General
  3. # 11
  • 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 Online
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.