Running

D7
Views 7.x-3.x-dev (2011-May-08)
Chaos tool suite 7.x-1.x-dev (2011-May-06)

the following debug message is displayed on every page:

'Exception: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)'

in views_plugin_query_default->execute() (line 1362 of /usr/www/users/pminty/clients/niin/sites/all/modules/views/plugins/views_plugin_query_default.inc).

Comments

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Postponed (maintainer needs more info)

Can you try to find out which view causes this problem and post it here?

Additional the full sql query would help, foo.

It's hard to fix such problems if you can't give us informations how to reproduce it.

drupalboy001’s picture

drupalboy001 commented

More details.

The debug message is on every page of the website (even the login page). It appeared after upgrading to the DEV versions of Ctools, Views, Date and Calendar. No view was re-configured after the upgrade. This bug does not appear to be associated with any specific view. Clearing all Caches has no effect.

Turning on DEVEL tracking gives the following information for the site home page:

    Operating in maintenance mode. Go online.
    Debug:

    'Exception: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)'

    in views_plugin_query_default->execute() (line 1362 of /usr/www/users/pminty/clients/niin/sites/all/modules/views/plugins/views_plugin_query_default.inc).
    page =>
        ... (Array, 10 elements)
        Krumo version 0.2.1a
        | http://krumo.sourceforge.net
        Called from /usr/www/users/pminty/clients/niin/includes/module.inc, line 1002

and

Executed 208 queries in 674.27 ms. Queries exceeding 5 ms are highlighted.
ms
#
where
ops
query
target
0.98
4
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_bootstrap.cid AS cid, cache_bootstrap.data AS data, cache_bootstrap.created AS created, cache_bootstrap.expire AS expire, cache_bootstrap.serialized AS serialized FROM cache_bootstrap cache_bootstrap WHERE (cache_bootstrap.cid IN (:db_condition_placeholder_0))
default
13.75
4
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_bootstrap.cid AS cid, cache_bootstrap.data AS data, cache_bootstrap.created AS created, cache_bootstrap.expire AS expire, cache_bootstrap.serialized AS serialized FROM cache_bootstrap cache_bootstrap WHERE (cache_bootstrap.cid IN (:db_condition_placeholder_0))
default
1.35
4
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_bootstrap.cid AS cid, cache_bootstrap.data AS data, cache_bootstrap.created AS created, cache_bootstrap.expire AS expire, cache_bootstrap.serialized AS serialized FROM cache_bootstrap cache_bootstrap WHERE (cache_bootstrap.cid IN (:db_condition_placeholder_0))
default
1.07
1
drupal_lookup_path
P A E
SELECT source FROM url_alias WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
30.67
6
DrupalDatabaseCache::getMultiple
P A E
SELECT cache.cid AS cid, cache.data AS data, cache.created AS created, cache.expire AS expire, cache.serialized AS serialized FROM cache cache WHERE (cache.cid IN (:db_condition_placeholder_0))
default
1.25
1
ctools_export_load_object
P A E
SELECT t__0.* FROM page_manager_pages t__0
default
1.02
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
9.6
4
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_bootstrap.cid AS cid, cache_bootstrap.data AS data, cache_bootstrap.created AS created, cache_bootstrap.expire AS expire, cache_bootstrap.serialized AS serialized FROM cache_bootstrap cache_bootstrap WHERE (cache_bootstrap.cid IN (:db_condition_placeholder_0))
default
1.32
1
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_path.cid AS cid, cache_path.data AS data, cache_path.created AS created, cache_path.expire AS expire, cache_path.serialized AS serialized FROM cache_path cache_path WHERE (cache_path.cid IN (:db_condition_placeholder_0))
default
6.75
1
drupal_lookup_path
P A E
SELECT source, alias FROM url_alias WHERE source IN (:system_0, :system_1, :system_2, :system_3, :system_4, :system_5, :system_6, :system_7, :system_8, :system_9, :system_10, :system_11, :system_12) AND language IN (:language, :language_none) ORDER BY language ASC, pid ASC
default
0.56
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.88
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.35
1
PagerDefault::execute
P A E
SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM node n WHERE (promote = :db_condition_placeholder_0) AND (status = :db_condition_placeholder_1) ) subquery
default
3.71
1
PagerDefault::execute
P A E
SELECT n.nid AS nid, n.sticky AS sticky, n.created AS created FROM node n WHERE (promote = :db_condition_placeholder_0) AND (status = :db_condition_placeholder_1) ORDER BY sticky DESC, created DESC LIMIT 10 OFFSET 0
default
4.6
6
DrupalDatabaseCache::getMultiple
P A E
SELECT cache.cid AS cid, cache.data AS data, cache.created AS created, cache.expire AS expire, cache.serialized AS serialized FROM cache cache WHERE (cache.cid IN (:db_condition_placeholder_0))
default
2.4
1
DrupalDefaultEntityController::load
P A E
SELECT revision.vid AS vid, base.uid AS uid, revision.title AS title, revision.log AS log, revision.status AS status, revision.comment AS comment, revision.promote AS promote, revision.sticky AS sticky, base.nid AS nid, base.type AS type, base.language AS language, base.created AS created, base.changed AS changed, base.tnid AS tnid, base.translate AS translate, revision.timestamp AS revision_timestamp, revision.uid AS revision_uid FROM node base INNER JOIN node_revision revision ON revision.vid = base.vid WHERE (base.nid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3))
default
2.09
6
DrupalDatabaseCache::getMultiple
P A E
SELECT cache.cid AS cid, cache.data AS data, cache.created AS created, cache.expire AS expire, cache.serialized AS serialized FROM cache cache WHERE (cache.cid IN (:db_condition_placeholder_0))
default
5.39
3
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_field.cid AS cid, cache_field.data AS data, cache_field.created AS created, cache_field.expire AS expire, cache_field.serialized AS serialized FROM cache_field cache_field WHERE (cache_field.cid IN (:db_condition_placeholder_0))
default
5.99
1
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_field.cid AS cid, cache_field.data AS data, cache_field.created AS created, cache_field.expire AS expire, cache_field.serialized AS serialized FROM cache_field cache_field WHERE (cache_field.cid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3))
default
3.56
1
comment_node_load
P A E
SELECT nid, cid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count FROM node_comment_statistics WHERE nid IN (:comments_enabled_0, :comments_enabled_1, :comments_enabled_2, :comments_enabled_3)
default
1.12
4
location_load_locations
P A E
SELECT l.lid AS lid FROM location_instance l WHERE (vid = :db_condition_placeholder_0)
default
0.69
4
location_load_locations
P A E
SELECT l.lid AS lid FROM location_instance l WHERE (vid = :db_condition_placeholder_0)
default
0.75
4
location_load_locations
P A E
SELECT l.lid AS lid FROM location_instance l WHERE (vid = :db_condition_placeholder_0)
default
0.74
4
location_load_locations
P A E
SELECT l.lid AS lid FROM location_instance l WHERE (vid = :db_condition_placeholder_0)
default
0.79
1
user_node_load
P A E
SELECT uid, name, picture, data FROM users WHERE uid IN (:uids_2, :uids_6, :uids_96, :uids_195)
default
3.79
1
DrupalDefaultEntityController::load
P A E
SELECT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, v.machine_name AS vocabulary_machine_name FROM taxonomy_term_data base INNER JOIN taxonomy_vocabulary v ON base.vid = v.vid WHERE (base.tid IN (:db_condition_placeholder_0))
default
2.59
3
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_field.cid AS cid, cache_field.data AS data, cache_field.created AS created, cache_field.expire AS expire, cache_field.serialized AS serialized FROM cache_field cache_field WHERE (cache_field.cid IN (:db_condition_placeholder_0))
default
6.84
6
DrupalDatabaseCache::getMultiple
P A E
SELECT cache.cid AS cid, cache.data AS data, cache.created AS created, cache.expire AS expire, cache.serialized AS serialized FROM cache cache WHERE (cache.cid IN (:db_condition_placeholder_0))
default
1.36
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
1.16
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
11.61
6
DrupalDatabaseCache::getMultiple
P A E
SELECT cache.cid AS cid, cache.data AS data, cache.created AS created, cache.expire AS expire, cache.serialized AS serialized FROM cache cache WHERE (cache.cid IN (:db_condition_placeholder_0))
default
1.85
1
_block_load_blocks
P A E
SELECT b.* FROM block b WHERE (b.theme = :db_condition_placeholder_0) AND (b.status = :db_condition_placeholder_1) ORDER BY b.region ASC, b.weight ASC, b.module ASC
default
1.74
1
block_block_list_alter
P A E
SELECT module, delta, rid FROM block_role
default
1.82
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.71
1
node_block_list_alter
P A E
SELECT module, delta, type FROM block_node_type
default
1.08
1
menu_local_tasks
P A E
SELECT menu_router.* FROM menu_router menu_router WHERE (tab_root = :db_condition_placeholder_0) AND (context <> :db_condition_placeholder_1) ORDER BY weight ASC, title ASC
default
1.1
2
block_block_view
P A E
SELECT body, format FROM block_custom WHERE bid = :bid
default
1.15
6
DrupalDatabaseCache::getMultiple
P A E
SELECT cache.cid AS cid, cache.data AS data, cache.created AS created, cache.expire AS expire, cache.serialized AS serialized FROM cache cache WHERE (cache.cid IN (:db_condition_placeholder_0))
default
1.1
2
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_filter.cid AS cid, cache_filter.data AS data, cache_filter.created AS created, cache_filter.expire AS expire, cache_filter.serialized AS serialized FROM cache_filter cache_filter WHERE (cache_filter.cid IN (:db_condition_placeholder_0))
default
0.83
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
5.08
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
0.87
1
menu_tree_check_access
P A E
SELECT n.nid AS nid FROM node n WHERE (n.status = :db_condition_placeholder_0) AND (n.nid IN (:db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9))
default
0.84
1
ctools_export_load_object
P A E
SELECT t__0.* FROM views_view t__0 WHERE (name IN (:db_condition_placeholder_0))
default
0.83
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.73
1
views_load_display_records
P A E
SELECT * FROM views_display WHERE vid IN (:vids_0) ORDER BY vid, position
default
6.11
3
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_views.cid AS cid, cache_views.data AS data, cache_views.created AS created, cache_views.expire AS expire, cache_views.serialized AS serialized FROM cache_views cache_views WHERE (cache_views.cid IN (:db_condition_placeholder_0))
default
1.66
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.73
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.85
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.52
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.91
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.4
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.18
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.27
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.81
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.21
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.24
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
13.82
3
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_views.cid AS cid, cache_views.data AS data, cache_views.created AS created, cache_views.expire AS expire, cache_views.serialized AS serialized FROM cache_views cache_views WHERE (cache_views.cid IN (:db_condition_placeholder_0))
default
0.86
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.54
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.59
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.01
3
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_field.cid AS cid, cache_field.data AS data, cache_field.created AS created, cache_field.expire AS expire, cache_field.serialized AS serialized FROM cache_field cache_field WHERE (cache_field.cid IN (:db_condition_placeholder_0))
default
0.91
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.72
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.47
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.42
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.46
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.8
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.89
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.42
1
date_sql_handler::set_db_timezone
P A E
SET @@session.time_zone = '+00:00'
default
1.59
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.23
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.38
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.32
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.98
3
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_views.cid AS cid, cache_views.data AS data, cache_views.created AS created, cache_views.expire AS expire, cache_views.serialized AS serialized FROM cache_views cache_views WHERE (cache_views.cid IN (:db_condition_placeholder_0))
default
0.84
1
DrupalDatabaseCache::clear
P A
DELETE FROM cache_views WHERE (cid = :db_condition_placeholder_0)
default
0.79
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.33
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.13
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.27
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.81
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.13
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.55
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.12
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.39
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.19
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.6
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
10.75
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.06
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.04
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.03
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.15
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.08
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.53
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.87
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.67
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.29
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.19
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.61
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.25
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.71
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.87
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.61
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.58
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.67
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.81
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.2
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
9.96
1
dblog_watchdog
P A
INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9)
default
1.71
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
7.08
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.88
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
9.28
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.64
2
block_block_view
P A E
SELECT body, format FROM block_custom WHERE bid = :bid
default
14.3
2
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_filter.cid AS cid, cache_filter.data AS data, cache_filter.created AS created, cache_filter.expire AS expire, cache_filter.serialized AS serialized FROM cache_filter cache_filter WHERE (cache_filter.cid IN (:db_condition_placeholder_0))
default
0.58
1
DrupalDatabaseCache::set
P A
SELECT 1 AS expression FROM cache_filter cache_filter WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.91
1
DrupalDatabaseCache::set
P A
INSERT INTO cache_filter (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
8.16
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
9.4
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
9.44
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
5.79
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
4.22
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.63
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.98
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
4.57
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
6.23
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.77
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
9.52
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
5.75
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.08
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.79
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
10.58
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
13.26
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
7.67
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.9
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.77
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
5.46
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
6.12
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.73
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.75
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
9.23
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
9.74
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.99
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
7.18
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.71
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.87
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.38
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.94
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
6.73
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
11.58
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.61
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.72
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
9.29
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.48
97
_registry_check_code
P A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.13
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
2.05
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
2.36
1
menu_tree_check_access
P A E
SELECT n.nid AS nid FROM node n WHERE (n.status = :db_condition_placeholder_0) AND (n.nid IN (:db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5))
default
6.3
1
shortcut_current_displayed_set
P A E
SELECT s.set_name AS set_name FROM shortcut_set s INNER JOIN shortcut_set_users u ON s.set_name = u.set_name WHERE (u.uid = :db_condition_placeholder_0)
default
4.68
1
shortcut_set_load
P A E
SELECT ss.* FROM shortcut_set ss WHERE (set_name = :db_condition_placeholder_0)
default
3.1
1
menu_load_links
P A E
SELECT ml.* FROM menu_links ml WHERE (ml.menu_name = :db_condition_placeholder_0) ORDER BY weight ASC
default
3.34
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
9.28
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
16.46
3
menu_contextual_links
P A E
SELECT m.* FROM menu_router m WHERE (tab_parent = :db_condition_placeholder_0) AND (context <> :db_condition_placeholder_1) AND (context <> :db_condition_placeholder_2) ORDER BY weight ASC, title ASC
default
6.95
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
0.82
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
15.64
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
2.44
1
menu_tree_check_access
P A E
SELECT n.nid AS nid FROM node n WHERE (n.status = :db_condition_placeholder_0) AND (n.nid IN (:db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, :db_condition_placeholder_10))
default
2.99
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
1.6
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.65
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.69
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.68
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.68
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.7
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.69
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.7
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.86
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.85
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
12.99
3
menu_contextual_links
P A E
SELECT m.* FROM menu_router m WHERE (tab_parent = :db_condition_placeholder_0) AND (context <> :db_condition_placeholder_1) AND (context <> :db_condition_placeholder_2) ORDER BY weight ASC, title ASC
default
2.76
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
2.46
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
1.33
3
menu_contextual_links
P A E
SELECT m.* FROM menu_router m WHERE (tab_parent = :db_condition_placeholder_0) AND (context <> :db_condition_placeholder_1) AND (context <> :db_condition_placeholder_2) ORDER BY weight ASC, title ASC
default
0.76
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
1.71
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
4.15
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
0.54
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.71
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
1.04
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
0.6
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.72
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
1.09
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
0.6
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.73
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.51
23
drupal_lookup_path
P A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
1.05
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
1.55
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
0.84
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
1.12
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
23.02
1
toolbar_get_menu_tree
P A E
SELECT * FROM menu_links WHERE menu_name = :menu_name AND module = :module AND link_path = :path
default
2.53
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
1.66
1
menu_link_get_preferred
P A E
SELECT ml.*, m.*, ml.weight AS link_weight FROM menu_links ml LEFT OUTER JOIN menu_router m ON m.path = ml.router_path WHERE (ml.menu_name IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3)) AND (ml.link_path IN (:db_condition_placeholder_4))
default
0.82
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
2.12
25
DrupalDatabaseCache::getMultiple
P A E
SELECT cache_menu.cid AS cid, cache_menu.data AS data, cache_menu.created AS created, cache_menu.expire AS expire, cache_menu.serialized AS serialized FROM cache_menu cache_menu WHERE (cache_menu.cid IN (:db_condition_placeholder_0))
default
0.74
1
_drupal_session_write
P A
SELECT 1 AS expression FROM sessions sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ) FOR UPDATE
default
0.92
1
_drupal_session_write
P A
UPDATE sessions SET uid=:db_update_placeholder_0, cache=:db_update_placeholder_1, hostname=:db_update_placeholder_2, session=:db_update_placeholder_3, timestamp=:db_update_placeholder_4 WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) )
default
3.27
2
DrupalDatabaseCache::set
P A
SELECT 1 AS expression FROM cache_bootstrap cache_bootstrap WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
2.09
2
DrupalDatabaseCache::set
P A
UPDATE cache_bootstrap SET serialized=:db_update_placeholder_0, created=:db_update_placeholder_1, expire=:db_update_placeholder_2, data=:db_update_placeholder_3 WHERE ( (cid = :db_condition_placeholder_0) )
default
0.81
2
DrupalDatabaseCache::set
P A
SELECT 1 AS expression FROM cache_bootstrap cache_bootstrap WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
2.15
2
DrupalDatabaseCache::set
P A
UPDATE cache_bootstrap SET serialized=:db_update_placeholder_0, created=:db_update_placeholder_1, expire=:db_update_placeholder_2, data=:db_update_placeholder_3 WHERE ( (cid = :db_condition_placeholder_0) )
default
esmerel’s picture

esmerel commented
Status: Postponed (maintainer needs more info) » Active
merlinofchaos’s picture

merlinofchaos commented
Status: Active » Postponed (maintainer needs more info)

You need to figure out which view is doing that and paste the query available in the view preview. You may need to enable showing the query in the settings. Unfortunately we are not going to be able to sift through all the queries on a page and figure out which one might or might not have been generated when that error was printed. Worse, if the query wasn't actually executed it may not appear in the list anyway.

stephane bouillet’s picture

stephane bouillet commented

Hello

as for me (same problem), I've just gone in the edit page of my different views, and check some filters (no double for ex.), and gone in some filter, re-reccord ("apply") the filter, reccord the view, and check if it works.
It usually works for me after this.

[EDIT]= for me, it was the filter applied on the date (working with the date module) that needed to be reccorded one time.

esmerel’s picture

esmerel commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)
mgifford’s picture

mgifford
he/him
Primary language English
commented

I'm getting multiple queries with SELECT filename FROM registry WHERE name = :name AND type = :type when looking at devel's query display.

I don't know where the problem lies, but finding it quite difficult to track down the loops.

How many times should one see code like I've included be loaded in a single page? I'd hope only once or twice.

JThan’s picture

JThan commented
Issue summary: View changes
Status: Closed (cannot reproduce) » Active

I am getting this error, too.

I have node type with a list field. The list field has the values 1,2,3,4. I added an exposed grouped filter, where one can choose between showing the results for value 1 or the results for values 2, 3 and 4. Only if you choose the second option, the above error is shown.

The relevant SQL Part is WHERE field_data_field_number.field_number_value = '2', '3', '4'

Guessing:
Should this be rewritten to
WHERE field_data_field_number.field_number_value IN ('2', '3', '4')

ylys’s picture

ylys commented

I am getting this error too.

... AND (field_data_field_projectstatus.field_projectstatus_tid = '4', '5', '6', '7', '8', '9', '32', '10', '11', '12', '13') ...

JThan offers a good solution. but where we have to change it?

m1n0’s picture

m1n0 commented

I had the same issue as described in #8 and #9, but I just had to enable "allow multiple selections", save the view, disable that option again, save the view and the query is now correctly using "IN" operator. Seems like when the filter was created something went wrong.

eugis’s picture

eugis commented

#10 solution worked for me, thanks!

mlzr’s picture

mlzr
Location Zutphen
commented

yes, #10 solution worked for me, thanks!!

viveksr2’s picture

viveksr2 commented

I am having the same issue, however i am having this while 'Allow Multiples' is enabled. I tried #10 but no luck. Also my issue is inconsistent i.e. sometimes it works perfectly fine and sometimes it throws errors. I have not put any query_alter hooks in my code.

Any help is appreciated!!

risforrocket’s picture

risforrocket commented

#10 worked for me!

nitheesh’s picture

nitheesh commented

#10 works fine for me.