I have a Views 1.5 view that uses the Node: Posted Full Date argument. When I upgrade to Views 1.6, the query text DATE_FORMAT(FROM_UNIXTIME(node.created+$timezone), '%Y%m%%d') apparently gets passed to _db_query_callback() too many times because the %%d turns into 0. I can try to track this down further if it will help but I'll wait until asked in case you know immediately what the problem is.

Comments

BrianKlinger’s picture

BrianKlinger commented

I'm having the same issue.

mmorris’s picture

mmorris commented

Also ran into this. Any ideas on a patch? This problem is breaking a couple of our views.

BrianKlinger’s picture

BrianKlinger commented

I'm not sure if this is the "right way" to do it, but I needed a fix so I messed around with some things and found that if I put a \ in front of the d in %%d (so it looks like %%\d), everything parsed correctly. Change all 3 occurrences of %Y%m%%d to %Y%m%%\d and hopefully it'll fix all of yours like it appears to have fixed mine.

Sepulman’s picture

Sepulman commented

I used the patch posted here to solve this problem;
http://drupal.org/node/165611#comment-590536

bjaspan’s picture

bjaspan commented

It does look to me like http://drupal.org/node/165611 is the same bug as I reported here. I will test that patch soon-ish and mark this issue duplicate if that patch fixes it. For now, I'm leaving this issue as active until I confirm it is the same bug (though I am pretty sure it is).

BrianKlinger’s picture

BrianKlinger commented

I applied the patch and took out my earlier fix and everything works correctly, so this patch fixed my problem with the date.

bjaspan’s picture

bjaspan commented
Status: Active » Closed (duplicate)

Duplicate of http://drupal.org/node/165611.