By alexander on Saturday, 01 August 2015
Posted in General
Replies 15
Likes 0
Views 762
Votes 0
in the custom fields i added the list of the languages sorted in the alphabet order

Unfortunately on the website some languages went out of order for no reason. In the backend all the languages are still in order what can be an issue?

thank you
Hey Alexander,

Ah okay I think I misunderstood you. I thought you saved the ordering this way and it's not appearing on the advanced search based on the ordering that you mentioned. I have found the issue and it's because of the "data type" on the MySQL column I have fix this by running the following SQL query,


update #__social_fields_options alter column `ordering` INT(11);


Previously it could only store up to a value of 127 and that is why you were noticing this behavior on several options only
·
Thursday, 06 August 2015 13:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Alexander,

What field is this? Is this a dropdown field? These field options are normally unsorted and they are by default sorted by the id of each record.
·
Sunday, 02 August 2015 00:55
·
0 Likes
·
0 Votes
·
0 Comments
·
It's a multi dropdown list

Mark how can find these ids, I really need to rearrange the list it's important for me.

Are they in the file somewhere?
·
Sunday, 02 August 2015 02:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Alexander,

Hm, looks like I am wrong. They are actually sorted by the "ordering" column. By the way, you can actually re-order the field options as shown in my screen shot here, http://screencast.com/t/kBI4r6DPi
·
Sunday, 02 August 2015 13:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

I just realised that the order is only broken in advanced search. In user profile the order is correct in the back end as the front end

Do you know what can be a problem?
·
Sunday, 02 August 2015 15:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Alexander,

Hm, i can't seem to replicate this. See my screen shots below:

Form: http://screencast.com/t/Up4D22a7Qj
Advanced Search: http://screencast.com/t/YjGJAEOf
·
Sunday, 02 August 2015 17:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi guys,
I have spent all day trying to find out what breaks the order. The problem that i need to spend at least 40 mins copy-pasting line by line for each experiment. It seems to be that it goes fine till about 100 lines after that the order breaks. I can be wrong thought, is there a way i don't need to copy past line by line? If i can automate filling in the list i could probably find out what s wrong eventually
·
Monday, 03 August 2015 20:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Alexander,

Hm, I am not really sure what you mean by "line by line" but on my local instance, it works fine so if it isn't working for you, I need to troubleshoot this on your site
·
Monday, 03 August 2015 21:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi

After some experiments I’ve realised that the multi drop down list titles and value go out of order after certain amount of information. In my opinion it happens after about 125 titles (values).
I thought it was formatting of text or national characters or something like that, but when I put simple digits 1, 2, 3,4,5,6 etc then after it’s saved and opened again for editing all the digits were randomly set.

The multi-dropdown list (to test on) is called “languages I'd like to learn” and located in custom fields – additional information tab.
But you can try any other dropdown menus in custom fields – additional information tab they all seem to be broken. Manual dragging doesn’t help.

Please see the screenshot from the advanced search page.

I have shared my details for you to have a look
Thank you very very much.
·
Tuesday, 04 August 2015 08:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Alexander,

I am really sorry for the delay of this reply as I was pretty occupied with huge development work on EasySocial 1.4. We have just released 1.3.30, could you try to update to the latest version and see if the problems persists?
·
Tuesday, 04 August 2015 22:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Mark

I'm sorry but it still exists in 1.3.30 Please have a look when you have time, i've added number 1.2.3.4.5 to another drop down menu and easysocial put them in the middles of the list Maybe there is a config file i can manually rearrange or replace the titiles/values? It seems to be the menu can't handle long lists, but of course i can be wrong.
·
Wednesday, 05 August 2015 06:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Alexander,

I am really sorry for the delay of this reply, been really busy with the development of 1.4. I really have no idea how to reproduce this issue on your end. Take a look at my screen shots below:

Advanced Search: http://screencast.com/t/NXtZfNvIuqf

Profile Fields Editor: http://screencast.com/t/NUNnrQ20Qge0
·
Thursday, 06 August 2015 00:10
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark

What do you mean by "reproducing" this issue on my end? I believe this issue doesn't need to be reproduced on my end because it already exists on my end. Can you please explain what i'm supposed to see on your screneeshots? Don't you see the problem there?
1, 8, 9, 7 6, 5 etc i used digits to show that whatever i put in the menu after "Mongolian" goes in the wrong order (i put them in order initially 1234567 then i saved it). I really need to fix that this is broken and it looks very stupid on the site., the point of having it on site is that the users can find themselves by using these parameters (language they speak and what to learn etc). I;m not asking you to fill in the list on all the languages but can somebody please have a look whey the menu behaves so strange. I know you are busy but maybe somebody else is available? I wish i could fix it myself but what do i need to do? Thank you

ps:

I ve made another menu with titles 1- 135.
the menu list is fine till number 126 then it goes to the different order 135, 134 etc. I thinks that a bug. what do you think?
·
Thursday, 06 August 2015 09:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you very much Mark,

Does it mean that the problem was on my site or was it more like a bug in general?

Just wondering

Thanks again my friend
·
Thursday, 06 August 2015 17:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Alexander,

I believe this is a bug in general and the fix will be included in the next release of easysocial.
·
Thursday, 06 August 2015 17:47
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post