After updating views from 7.x-3.0-beta3 to the latest 7.x-3.3. I can't edit views who based on taxonomy.

I got the Error message:

PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "" LINE 4: WHERE (td.tid IN ('', '', '4')) ^: SELECT td.* FROM {taxonomy_term_data} td WHERE (td.tid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2)) ; Array ( [:db_condition_placeholder_0] => [:db_condition_placeholder_1] => [:db_condition_placeholder_2] => 4 ) in views_handler_filter_term_node_tid->admin_summary() (Zeile 342 von /data/drupal/SITENAME/sites/all/modules/views/modules/taxonomy/views_handler_filter_term_node_tid.inc).

The output of the views did not work.

what did this mean and how can i fix it?

Drupal System: Drupal 7.10
Host System: Linux
Database: postgresql

CommentFileSizeAuthor
#1 1489518-filter.patch1.14 KBdawehner

Comments

dawehner’s picture

Status: Active » Needs review
StatusFileSize
new1.14 KB

What about this patch, it would be cool if you could try it out

dawehner’s picture

Status: Needs review » Fixed

Just committed the first part to 7.x-3.x

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.