wrong related record after sorting list

Archived from the Xataface Users forum.

ststoddard — Wed Apr 14, 2010 9:16 am

Hello,

My apologies if this is something that has come up previously.

We just noticed some odd behavior in our implementation. When we go to a table, filter this, and then sort the list *twice* (2 clicks on the heading), upon going into the record and then to a related table via the tabs in the record view, we end up at the wrong related record.

So, for instance, when it works correctly, we should get the following url after 2 clicks:

Code: Select all

https://dengue.ucdavis.edu/db/PD/index.php?-table=House_survey&-action=related_records_list&-cursor=6&-skip=0&-limit=30&-mode=list&Proyecto=%3DMBMI&survey_date=%3D2010-02-09&-sort=location_code+desc&-recordid=House_survey%3Fsid%3D183622&-relationship=coleccion

However, what we get is:

Code: Select all

Index.php?-table=House_survey&-action=related_records_list&-cursor=7&-skip=0&-limit=30&-mode=list&Proyecto=%3DMBMI&survey_date=%3D2010-02-09&-sort=location_code+desc&-recordid=House_survey%3Fsid%3D183622&-relationship=coleccion

So the cursor in this latter case is incorrect and we don’t understand why this is happening. Cursor 7 in this case actually points at record in House_survey sid=183632.

We did find a solution: restart apache.

Steve

---

shannah — Wed Apr 14, 2010 10:10 am

This bug sounds familiar. What version of Xataface are you using?

---

ststoddard — Wed Apr 14, 2010 10:11 am

Xataface 1.2.2

---

shannah — Wed Apr 14, 2010 10:44 am

Oh… so restarting apache solved it??

---

ststoddard — Wed Apr 14, 2010 1:36 pm

Yeah. Cleared right up. For now it is still working fine and the plan is to restart occasionally.