Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Running dev versions of ctools, views, date and entity with caches flushed x2. Apart from having the ungrouped bug on summary views (#1207540: Inappropriately ungrouped display summary of content date field. ), I am now also getting this error.
Notice: Undefined property: date_views_argument_handler_simple::$name_alias in views_handler_argument->summary_sort() (line 853 of /var/www/sites/all/modules/views/handlers/views_handler_argument.inc).
Debug: 'Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'FROM
node node
WHERE (( (node.status = \'1\') AND (node.type IN (\'abstracts_n_po\' at line 1'
in views_plugin_query_default->execute() (line 1388 of /var/www/sites/all/modules/views/plugins/views_plugin_query_default.inc).
I have traced it to changes done during this particular commit for #1147620: Multi-day events don't show up on day view of spanned days. as the dev tree prior to this processes as per normal.
Comment | File | Size | Author |
---|---|---|---|
#10 | date_1227350.patch | 753 bytes | grendzy |
Comments
Comment #1
pwaak CreditAttribution: pwaak commentedI am getting this error with PHP 5.2.17.
Comment #2
KarenS CreditAttribution: KarenS commentedThe commit adds "@TODO Need to write a custom query here, the parent query won't work." in the summary_query() function, so yes, this needs to be fixed.
Comment #3
KarenS CreditAttribution: KarenS commentedFixed in latest dev.
Comment #4
Fajan CreditAttribution: Fajan commentedThanks! Can confirm that both problems are fixed.
Comment #6
stockliasteroid CreditAttribution: stockliasteroid commentedThis appears to be broken again in -dev as of 2011-Sep-08. I'm getting the exact same errors above for my summary block view.
Comment #7
idmacdonald CreditAttribution: idmacdonald commentedI am also getting this error, using the 7.x-2.x-dev version of the module from 2011-09-08. Seems like there must have been a regression somewhere.
Comment #8
idmacdonald CreditAttribution: idmacdonald commentedI can confirm that rolling back date_views_argument_handler_simple.inc to the version from commit 0756269 (2011-07-24) seems to solve the problem. So, it looks like there has been some regression since then.
Comment #9
grendzy CreditAttribution: grendzy commentedHere is the commit that introduce the regression:
http://drupalcode.org/project/date.git/commitdiff/f2e8fdbf479e0798be72c0...
Comment #10
grendzy CreditAttribution: grendzy commentedI think that summary_query() should not call date_forbid() at all - since by definition the summary is only invoked when no argument is present.
Comment #11
KarenS CreditAttribution: KarenS commentedI agree with your assessment. Fixed. Thanks!