Updated from 5-1.16 to 5.x-1.xdev version to solve a bug and gets a new bug (despite views cache clear) [#455836]

Hi,
I had a problem with the bug on "b" words in views ( http://drupal.org/node/165611 ) so i took the advice there and update views to the 5.x-1.xdev version. I did run update.php.
Then i did clear views cache through the tools tab.
Yet i get bugs on all my views now .
Here is the error message on one of them :


    * user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay query: SELECT count( DISTINCT(node.nid)) FROM node node LEFT JOIN users_roles users_roles ON node.uid = users_roles.uid INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_regionlive ON users.uid = profile_regionlive.uid AND profile_regionlive.fid = '11' LEFT JOIN profile_values profile_nom ON users.uid = profile_nom.uid AND profile_nom.fid = '1' LEFT JOIN profile_values profile_prenom ON users.uid = profile_prenom.uid AND profile_prenom.fid = '2' LEFT JOIN profile_values profile_enddateevs ON users.uid = profile_enddateevs.uid AND profile_enddateevs.fid = '19' LEFT JOIN profile_values profile_cooriginevs ON users.uid = profile_cooriginevs.uid AND profile_cooriginevs.fid = '37' LEFT JOIN profile_values profile_coevs ON users.uid = profile_coevs.uid AND profile_coevs.fid = '35&# in /home/sites/sve-connexion.fr/public_html/includes/database.mysql.inc on line 174.
    * user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay query: SELECT DISTINCT(node.nid), users.name AS users_name, users.uid AS users_uid, profile_nom.value AS profile_nom_value, profile_prenom.value AS profile_prenom_value, profile_enddateevs.value AS profile_enddateevs_value, profile_cooriginevs.value AS profile_cooriginevs_value, profile_coevs.value AS profile_coevs_value, profile_city.value AS profile_city_value, profile_jobstatus.value AS profile_jobstatus_value, profile_whoareyou.value AS profile_whoareyou_value FROM node node LEFT JOIN users_roles users_roles ON node.uid = users_roles.uid INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_regionlive ON users.uid = profile_regionlive.uid AND profile_regionlive.fid = '11' LEFT JOIN profile_values profile_nom ON users.uid = profile_nom.uid AND profile_nom.fid = '1' LEFT JOIN profile_values profile_prenom ON us in /home/sites/sve-connexion.fr/public_html/includes/database.mysql.inc on line 174.

And here is the view's export :

  $view = new stdClass();
  $view->name = 'search_vol_fr_centre';
  $view->description = 'Membres du Centre (Centre, Bourgogne, Limousin, Auvergne)';
  $view->access = array (
  0 => '4',
  1 => '15',
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Trouver des volontaires du Centre (Centre, Bourgogne, Limousin, Auvergne)';
  $view->page_header = '';
  $view->page_header_format = '3';
  $view->page_footer = '';
  $view->page_footer_format = '3';
  $view->page_empty = '';
  $view->page_empty_format = '3';
  $view->page_type = 'views_mail';
  $view->url = 'rechercher/volontaire/centre';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '100';
  $view->menu = TRUE;
  $view->menu_title = 'Membres du Centre';
  $view->menu_tab = FALSE;
  $view->menu_tab_weight = '0';
  $view->menu_tab_default = FALSE;
  $view->menu_tab_default_parent = NULL;
  $view->menu_tab_default_parent_type = 'normal';
  $view->menu_parent_tab_weight = '0';
  $view->menu_parent_title = 'Membres en IDF';
  $view->sort = array(
  );
  $view->argument = array(
  );
  $view->field = array(
    array(
      'tablename' => 'users',
      'field' => 'name',
      'label' => 'Profil',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'profile_nom',
      'field' => 'value',
      'label' => 'Nom',
    ),
    array(
      'tablename' => 'profile_prenom',
      'field' => 'value',
      'label' => 'Prénom',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'profile_enddateevs',
      'field' => 'value',
      'label' => 'Date de fin de SVE',
    ),
    array(
      'tablename' => 'profile_cooriginevs',
      'field' => 'value',
      'label' => 'Pays d\'origine',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'profile_coevs',
      'field' => 'value',
      'label' => 'Pays de SVE',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'profile_city',
      'field' => 'value',
      'label' => 'Ville de résidence',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'profile_jobstatus',
      'field' => 'value',
      'label' => 'Status',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'profile_whoareyou',
      'field' => 'value',
      'label' => 'SVE?',
      'sortable' => '1',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'profile_whoareyou',
      'field' => 'value',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'intéressé par le SVE /interested by EVS',
  1 => 'actuellement en SVE /current EVS',
  2 => 'ex SVE /ex-EVS',
),
    ),
    array(
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'bio',
),
    ),
    array(
      'tablename' => 'users_roles',
      'field' => 'rid',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => '3',
),
    ),
    array(
      'tablename' => 'profile_enddateevs',
      'field' => 'value',
      'operator' => '>',
      'options' => '',
      'value' => array (
  0 => '',
  1 => '',
  2 => '',
),
    ),
    array(
      'tablename' => 'profile_cooriginevs',
      'field' => 'value',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'Allemagne /Germany',
  1 => 'Autriche /Austria',
  2 => 'Belgique /Belgium',
  3 => 'Bulgarie /Bulgaria',
  4 => 'Chypre /Cyprus',
  5 => 'Danemark /Denmark',
  6 => 'Espagne /Spain',
  7 => 'Estonie	/Estonia',
  8 => 'Finlande /Finland',
  9 => 'France /France',
  10 => 'Grèce /Greece',
  11 => 'Hongrie /Hungary',
  12 => 'Irlande	/Ireland',
  13 => 'Islande	/Iceland',
  14 => 'Italie /Italy',
  15 => 'Lettonie /Latvia',
  16 => 'Liechtenstein /Liechtenstein',
  17 => 'Lituanie /Lithuania',
  18 => 'Luxembourg /Luxemburg',
  19 => 'Macédoine (ARYM) /Macedonia (FYROM)',
  20 => 'Malte /Malta',
  21 => 'Norvège /Norway',
  22 => 'Pays Bas /Netherlands',
  23 => 'Pologne	/Poland',
  24 => 'Portugal /Portugal',
  25 => 'République Tchèque /Czech Republic',
  26 => 'Roumanie /Romania',
  27 => 'Royaume-Uni /United-Kingdom',
  28 => 'Slovaquie /Slovakia',
  29 => 'Slovénie /Slovenia',
  30 => 'Suède /Sweden',
  31 => 'Turquie	/Turkey',
  32 => 'Pays voisin /Neighboring country',
  33 => 'Autre pays /Other country',
),
    ),
    array(
      'tablename' => 'profile_coevs',
      'field' => 'value',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'Allemagne /Germany',
  1 => 'Autriche /Austria',
  2 => 'Belgique /Belgium',
  3 => 'Bulgarie /Bulgaria',
  4 => 'Chypre /Cyprus',
  5 => 'Danemark /Denmark',
  6 => 'Espagne /Spain',
  7 => 'Estonie	/Estonia',
  8 => 'Finlande /Finland',
  9 => 'France /France',
  10 => 'Grèce /Greece',
  11 => 'Hongrie /Hungary',
  12 => 'Irlande	/Ireland',
  13 => 'Islande	/Iceland',
  14 => 'Italie /Italy',
  15 => 'Lettonie /Latvia',
  16 => 'Liechtenstein /Liechtenstein',
  17 => 'Lituanie /Lithuania',
  18 => 'Luxembourg /Luxemburg',
  19 => 'Macédoine (ARYM) /Macedonia (FYROM)',
  20 => 'Malte /Malta',
  21 => 'Norvège /Norway',
  22 => 'Pays Bas /Netherlands',
  23 => 'Pologne	/Poland',
  24 => 'Portugal /Portugal',
  25 => 'République Tchèque /Czech Republic',
  26 => 'Roumanie /Romania',
  27 => 'Royaume-Uni /United-Kingdom',
  28 => 'Slovaquie /Slovakia',
  29 => 'Slovénie /Slovenia',
  30 => 'Suède /Sweden',
  31 => 'Turquie	/Turkey',
  32 => 'Pays voisin /Neighboring country',
  33 => 'Autre pays /Other country',
),
    ),
    array(
      'tablename' => 'profile_regionlive',
      'field' => 'value',
      'operator' => 'word',
      'options' => '',
      'value' => 'auvergne limousin bourgogne centre',
    ),
    array(
      'tablename' => 'profile_prenom',
      'field' => 'value',
      'operator' => '=',
      'options' => '',
      'value' => '',
    ),
  );
  $view->exposed_filter = array(
    array(
      'tablename' => 'profile_prenom',
      'field' => 'value',
      'label' => 'Prénom',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '0',
      'single' => '0',
    ),
    array(
      'tablename' => 'profile_whoareyou',
      'field' => 'value',
      'label' => 'Statut de SVE',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '0',
      'single' => '0',
    ),
    array(
      'tablename' => 'profile_enddateevs',
      'field' => 'value',
      'label' => 'Date de fin de SVE',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '0',
      'single' => '0',
    ),
    array(
      'tablename' => 'profile_cooriginevs',
      'field' => 'value',
      'label' => 'Pays d\'origine',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '0',
      'single' => '0',
    ),
    array(
      'tablename' => 'profile_coevs',
      'field' => 'value',
      'label' => 'Pays de SVE',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '0',
      'single' => '0',
    ),
  );
  $view->requires = array(users, profile_nom, profile_prenom, profile_enddateevs, profile_cooriginevs, profile_coevs, profile_city, profile_jobstatus, profile_whoareyou, node, users_roles, profile_regionlive);
  $views[$view->name] = $view;

Any hint ? What shall i do ?
I'd rather get back to 1.16 version with a bug on some views with "b" words than have bugs on ALL my views :-( (er ... actually i'm not even sure how to "downgrade" to the previous version now ...)

Thanks in advance for you help. I feel really hopeless facing such kind of situation while trying to solve a small problem you create a much bigger problem... ooops.

Comments

Comment #1

yolene commented 8 May 2009 at 22:18

Status:

Active

» Closed (duplicate)

Comment #2

yolene commented 10 May 2009 at 00:16

Status:

Closed (duplicate)

» Fixed

actually i found out that it was not a problem with the module but a problem with the database settings, related to SQL_BIG_SELECTS
so i solved it in a way i explained here : http://drupal.org/node/361967

Comment #3

24 May 2009 at 00:20

Status:

Fixed

» Closed (fixed)

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

Updated from 5-1.16 to 5.x-1.xdev version to solve a bug and gets a new bug (despite views cache clear)

Comments

Comment #1

Comment #2

Comment #3

News items

Our community

Documentation

Drupal code base

Governance of community