Glitch with column sort

Not sure what's gone wrong with a column sort I've done for a page. The columns appear to sort correctly when I click on the column heading, but when I click the links at the bottom of the page to go to page 2, the sort order gets reversed.

I've attached a copy of the page.

Its in an admin section of the site - see PM below.

Further info below.

Not sure what I've done to cause the error that is now showing:

Unknown column 'CompanyUserID' in 'order clause'

Wasn't there a moment ago, and annoyingly is still there after I restored the file from a backup yesterday....

EDIT - very weird - I deleted ',Company' from the Order Clause, and added it back, and it least that's back!

the navigation passes the sort URL variable.

in the sort behavior, you have the "Toggle Sort On Subsequent Visits" option enabled. Since the navigation passes the sort URL variable, it is considered a subsequent visit, so the order is toggled.

disable that option to prevent the the order from toggling.

Thanks Jason - where do I access that behavioiur to edit it? I don't see it in the server behaviours panel?

if you had hand edited some of the code, that could cause the server behavior to not display on the list,

change the following code:
$WADA_Sort_1->ToggleOn = true;

to:
$WADA_Sort_1->ToggleOn = false;

Thanks Jason - I was just going to post that I changed that.

I don't know if you logged in and had a look at the pages, or just looked at the code, but all the pages under Products with sorts seem to work just fine with that line as

$WADA_Sort_1->ToggleOn = true;

yes, it will sort fine the first time around.

but the problem you reported in the initial post was using the navigation caused the sort order to reverse, this is because of the toggle setting being set to true.

That's what I mean though - the pages under Products all work OK even when you use the navigation, with that toggle set to true.

If you go back to the site and click on View Full Product List, it all works as it should.

I've attached that page - although its working OK, so this is only really out of interest now.

the navigation on the product pages does not pass the sort URL variable.

the navigation for the users pages does.