I am currently on 4.10.3, same client actually as the one i was asking for last time. Module has been working great. Yesterday she contacted me and notified me that the sort order is all wierd. Basically what she is trying to do with the user dynamic directory, is have a 2 sort going on. First sort is by Type (custom field). the Types that her users will have are 3 will have Partner, the others will all have a type of broker. She is sorting that DESC, so the partners will show up first. That part is stll working. Next part she wants everything sorted by last name. Looking at the settings, it seems this is as simple as setting sort order 2 as lastname, and we are done.
Not seeing that to be the case. first off, i have no idea what the secondary sort is actually doing, like i said, it is sorting the type correctly, however as for the secondary sort, i am unable to make any sense out of it at all.
It does not seem to keep the secondary sort. If i go into control panel, view the module settings, it is always username, i can change it and set it back to lastname, but when i go back in, it is username again.
Events leading up to this problem. 2 days ago, this was looking the way she wanted it to. It broke yesterday, these are the events that lead up to it breaking.
1) She edited one of the partners (actually instead of deleting the old one and adding a new one and setting that one to partner, she actually edited the partner that was going away, and changed all his information to the new user.
2) She deleted a user(seems like when she deleted this guy, the secondary sort started gettin a little whacky, from what she is reporting to me), atleast that is when she noticed the brokers were no longer sorted the way she was expecting them to be.
3) about 3-4 months ago, we moved the site from an installation that housed many portals, to a new installation that holds only her 3 sites. We then moved her sites to a new physical server. DB is still in the same location as iti was before (we have a dedicated DB server), and the specs on the new webserver are identical to the webserver she came from (windows 2008 r2, iis 7.5 and so on). Just wanted to point that out, in case the actual move is the root of the problem, whcih since it has worked error free for 3 - 4 months i dont expect that to be the case.
OK, so my question is, 1 anyone had a similar problem, how did you fix it? 2 there are some tables in SQL, TEMPDUD*, if i were to trucate or even drop those, would they be recreated? reloaded? Maybe that is the problem? 3 what table are the sort orders being stored? I am curious if my secondary sort is stored and just not reloading on edit or if something squirrly is going on there.
Thanks!
Brian