If you create a Views Content Pane with a contextual filter, where the filter argument is set to "Taxonomy-> Term name of all terms". When displaying the panel page with this content pane displaying tagged with taxonomy, the following PDO exception occurs:
PDOException: 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 ''4794', '4789', '4834', '4846', '4953', '5140', '5132', '5081', '5555'' at line 1: SELECT tid, name FROM {taxonomy_term_data} WHERE tid IN :tids_0, :tids_1, :tids_2, :tids_3, :tids_4, :tids_5, :tids_6, :tids_7, :tids_8; Array ( [:tids_0] => 4794 [:tids_1] => 4789 [:tids_2] => 4834 [:tids_3] => 4846 [:tids_4] => 4953 [:tids_5] => 5140 [:tids_6] => 5132 [:tids_7] => 5081 [:tids_8] => 5555 ) in ctools_context_terms_convert() (line 84 of /var/www/html/drupal7/sites/sitename/modules/contrib/ctools/plugins/contexts/terms.inc).
Comments
Comment #1
spotzero commentedThis patch corrects the SQL error for me.
Comment #2
robwithhair commentedYep, I did the same thing to fix at my end before I found this bug report. Missing brackets. I'm using the 7.x-1.0-rc1
Comment #3
merlinofchaos commentedCommitted and pushed.