Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By zwhalen on
Hello,
My main Drupal site is currently experiencing a problem that I'm hoping someone can help me diagnose. What's happening is that for certain users, pages like the default front page (mysite.org/node) are listing node contents in what appears to be random, or possibly ascending order. So rather than listing the most recent content first, it's starting in 2004.
I haven't made any changes to code lately (I'm still on 4.6), and this problem appeared without warning last night. I've narrowed it down enough to tell that it only affects users with permission to administer nodes. There's only three of us, so while this is an annoying problem, it's not mission-critical and I can take my time to sort it out properly.
The only thing that I can figure changed is our PHP and MySQL versions, which our host (Site5) was supposed to be upgrading this week. Currently we're on PHP 4.4.3 and MySQL 4.1.10, but I can't imagine what differences either of those would have across an upgrade that would cause such a narrow and specific problem.
Has anyone else seen anything like this or experienced similar problems with a PHP / MySQL upgrade? Any idea how to go about isolating it in my Drupal install?
Comments
narrowing ...
Well, I've narrowed it down to the db_rewrite_sql function. It seems that when that function is used to process a query, as in something like $sql = pager_query(db_rewrite_sql("SELECT blah blah SORT BY n.created DESC")), it loses track of the DESC argument. And again, this only seems to happen for users with permission to administer nodes.
I'm about to start picking through database.inc, but I'd really appreciate some pointers if this rings a bell for anyone.
join the thread
over here
http://drupal.org/node/79150
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
Sorry?
Where is that? You provided a link back to my post; unless I'm misunderstanding something . . .
bad copy
SHould be the right link
http://drupal.org/node/78642
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide