SQL syntax error

I believe that is due to my use (mis-use is probably more accurate), of the db_rewrite_sql() function. From what I have been able to determine, it is supposed to be used in circumstances such as when you are doing a node listing, when other conditions need to be tested as well. For instance, the node module modifies queries for node listings to filter nodes protected by access fields. So basically what that means is that you would use db_rewrite_sql() if you were producing a listing of nodes but some of those nodes should only be shown to certain users. db_rewrite_sql()'s usage would ensure that those access rules were observed.

I believe the particular error above is due to calling db_rewrite_sql() with the wrong number of arguments. Those arguments are apparently needed when certain other modules are actually performing a rewrite of the sql. But as I think about it, I realize that I do not need to use that function, a simple db_query_range() would work just fine. The documentation for the database abstraction layer says regarding db_rewrite_sql() 'Use it for listing queries'. That's not what I am doing. db_query_range() is better suited since it 'runs a limited-range query in the active database'.

I was able to recreate an error very similar on another site. Applying this patch seemed to clear up the problem.

Awesome... I uploaded a .patch file. Let's try again with a .zip

Ok, nope that didn't work either. Something I should know about uploading files here?

Tim

there we go. It was the '#' in the name. I should have known.

I think actually you just need to use capital letters with your SQL commands (order by csid desc vs ORDER BY csid DESC). But yes, you should not be using db_rewrite_sql() unless you know that it's a query that should be using it (like on nodes, taxonomy terms, etc).