Re: Function sequence error

[Eddie Stuart]

I have just upgraded from 4.0 to 4.1 and now get this error on just one SQL read statement in an ASP application.

It works fine on my test server and other SQL (even in the same page) work fine on the production box, apart from this one.

It isn't even consistent - I select 5 records at a time using LIMIT and some groups of 5 work fine, others don't.

Confusion therefore reigns - if it always worked I would have somewhere to start.

The SQL is:-
SELECT SQL_CALC_FOUND_ROWS * FROM ClassAds WHERE CategID="16" AND CategTyp="Sell" AND Visible="Yes" AND Starts<=Now() AND Expires>Now() ORDER BY TimeLogged DESC LIMIT 0, 5;

Any ideas?

TIA,

Eddie Stuart