Support

    You are here:  
  1. Home
  2. Support
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. 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: Sunday 1:49 pm
Add a reply View Replies (5)

Resolved Cannot create a select user fields which would contain > 5000 items

  1. dr.sus
    dr.sus
  2. Bug Report
  3. Saturday, September 12 2015, 04:34 PM
it works fine with less than 1000 values.
I use the 1|value syntax as required.
Accepted Answer
admin
admin Accepted Answer
Admin
if you can't change database configurations you can do something like this:
- create a DB table with 2 column (value,text)
- put your options in this db table
- Set select field to retrieve info from this table (see screenshot)
Attachments (1)
Schermata 2015-09-14 alle 10.06.14.png Schermata 2015-09-14 alle 10.06.14.png
  1. more than a month ago
  2. Bug Report
  3. # Permalink
Responses (5)
dr.sus
dr.sus Accepted Answer
Yep, was doing exactly that right now, thanks.
  1. more than a month ago
  2. Bug Report
  3. # 1
admin
admin Accepted Answer
Admin
Hi,
could be due to a configuration of MySQL, the database server typically have a size limit for queries. a query to save 5000 options is huge. In any case, even if I could save them then you will have a very very slow page and almost certainly timeout errors (browser and/or server).
  1. more than a month ago
  2. Bug Report
  3. # 2
dr.sus
dr.sus Accepted Answer
Are there any characters that need to be avoided in the options list (like "(", "/", etc.)?
  1. more than a month ago
  2. Bug Report
  3. # 3
dr.sus
dr.sus Accepted Answer
Not sure re timeout error - I cannot save the 5000 options in the Options List (one per line, separate the value from the text with the character '|').
I mean, I paste the options but after I save - they disappear.
  1. more than a month ago
  2. Bug Report
  3. # 4
admin
admin Accepted Answer
Admin
Hi,
this may not be a limit of Easy Profile. if you have a select with 5000 options then webpage is too heavy and you have timeout error.

To use select with 5000+ options is always a bad choice,
  1. more than a month ago
  2. Bug Report
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

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.