wrong related record after sorting list

A place for users and developers of the Xataface to discuss and receive support.

wrong related record after sorting list

Postby 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
S. T. Stoddard
ststoddard
 
Posts: 56
Joined: Mon Nov 05, 2007 4:10 pm
Location: Davis, CA

Re: wrong related record after sorting list

Postby shannah » Wed Apr 14, 2010 10:10 am

This bug sounds familiar. What version of Xataface are you using?
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: wrong related record after sorting list

Postby ststoddard » Wed Apr 14, 2010 10:11 am

Xataface 1.2.2
S. T. Stoddard
ststoddard
 
Posts: 56
Joined: Mon Nov 05, 2007 4:10 pm
Location: Davis, CA

Re: wrong related record after sorting list

Postby shannah » Wed Apr 14, 2010 10:44 am

Oh... so restarting apache solved it??
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: wrong related record after sorting list

Postby 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.
S. T. Stoddard
ststoddard
 
Posts: 56
Joined: Mon Nov 05, 2007 4:10 pm
Location: Davis, CA


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 1 guest

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved