i have this error everytime an image node is open in a browser:

* warning: Invalid argument supplied for foreach() in /var/www/vhosts/wadafoc.com/httpdocs/modules/views/plugins/views_plugin_query_default.inc on line 879.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/wadafoc.com/httpdocs/modules/views/plugins/views_plugin_query_default.inc on line 955.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/wadafoc.com/httpdocs/modules/views/plugins/views_plugin_query_default.inc on line 879.
* user warning: 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 <> 0) AND (node.type in ('image')) ) coun' at line 2 query: SELECT COUNT(*) FROM (SELECT FROM node node WHERE (node.status <> 0) AND (node.type in ('image')) ) count_alias in /var/www/vhosts/wadafoc.com/httpdocs/modules/views/plugins/views_plugin_pager.inc on line 134.
* user warning: 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 <> 0) AND (node.type in ('image')) LIMIT' at line 2 query: SELECT FROM node node WHERE (node.status <> 0) AND (node.type in ('image')) LIMIT 0, 10 in /var/www/vhosts/wadafoc.com/httpdocs/modules/views/plugins/views_plugin_query_default.inc on line 1093.

but there are also other issues associated, when i create a node and if i want to add a image using image assist, i see the popup window with the pager but NO images to click in (see first attached file), another problem i have is that when i click on a gallery, i configured my views to see 20 images per page, but there is no pager under the gallery

the problems appeard just when i update all modules, my current versions are:
Image 6.x-1.1
Image assist 6.x-3.x-dev
Image Attach 6.x-1.1
Image Gallery 6.x-1.1
Image Gallery Management 6.x-1.0-beta6
Image Import 6.x-1.1
ImageMagick Advanced Options 6.x-1.1 A
Views 6.x-3.0-alpha3
Views cloud 6.x-1.2
Views exporter 6.x-3.0-alpha3
Views UI 6.x-3.0-alpha3

i exported the image gallery view:

$view = new view;
$view->name = 'image_gallery';
$view->description = 'The default gallery of image nodes from Image gallery module.';
$view->tag = 'image_gallery';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 3.0-alpha1;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['title'] = 'Galerías de imágenes';
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['submit_button'] = 'Aplicar';
$handler->display->display_options['exposed_form']['options']['reset_button_label'] = 'Reiniciar';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = 24;
$handler->display->display_options['pager']['options']['expose']['items_per_page_label'] = 'Elementos por página';
$handler->display->display_options['pager']['options']['expose']['offset_label'] = 'Desplazamiento';
$handler->display->display_options['style_plugin'] = 'image_gallery';
$handler->display->display_options['row_plugin'] = 'fields';
/* Texto vacío: Global: Text area */
$handler->display->display_options['empty']['text']['id'] = 'area';
$handler->display->display_options['empty']['text']['table'] = 'views';
$handler->display->display_options['empty']['text']['field'] = 'area';
$handler->display->display_options['empty']['text']['label'] = '';
$handler->display->display_options['empty']['text']['empty'] = FALSE;
$handler->display->display_options['empty']['text']['content'] = 'There are no images in this gallery.';
$handler->display->display_options['empty']['text']['format'] = '1';
/* Campo: Imagen: Imagen */
$handler->display->display_options['fields']['image_image']['id'] = 'image_image';
$handler->display->display_options['fields']['image_image']['table'] = 'node';
$handler->display->display_options['fields']['image_image']['field'] = 'image_image';
$handler->display->display_options['fields']['image_image']['label'] = '';
$handler->display->display_options['fields']['image_image']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['image_image']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['image_image']['alter']['trim'] = 0;
$handler->display->display_options['fields']['image_image']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['image_image']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['image_image']['alter']['html'] = 0;
$handler->display->display_options['fields']['image_image']['link_to_node'] = 1;
$handler->display->display_options['fields']['image_image']['image_derivative'] = 'thumbnail';
/* Campo: Nodo: Título */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Criterio de ordenación: Nodo: Título */
$handler->display->display_options['sorts']['title']['id'] = 'title';
$handler->display->display_options['sorts']['title']['table'] = 'node';
$handler->display->display_options['sorts']['title']['field'] = 'title';
/* Criterio de ordenación: Nodo: Fecha de modificación */
$handler->display->display_options['sorts']['changed']['id'] = 'changed';
$handler->display->display_options['sorts']['changed']['table'] = 'node';
$handler->display->display_options['sorts']['changed']['field'] = 'changed';
$handler->display->display_options['sorts']['changed']['order'] = 'DESC';
/* Argumento: Global: Nulo */
$handler->display->display_options['arguments']['null']['id'] = 'null';
$handler->display->display_options['arguments']['null']['table'] = 'views';
$handler->display->display_options['arguments']['null']['field'] = 'null';
$handler->display->display_options['arguments']['null']['default_action'] = 'default';
$handler->display->display_options['arguments']['null']['style_plugin'] = 'default_summary';
$handler->display->display_options['arguments']['null']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['null']['default_argument_options']['argument'] = 'tid';
$handler->display->display_options['arguments']['null']['must_not_be'] = 0;
/* Argumento: Taxonomía: ID del término */
$handler->display->display_options['arguments']['tid']['id'] = 'tid';
$handler->display->display_options['arguments']['tid']['table'] = 'term_node';
$handler->display->display_options['arguments']['tid']['field'] = 'tid';
$handler->display->display_options['arguments']['tid']['default_action'] = 'empty';
$handler->display->display_options['arguments']['tid']['style_plugin'] = 'default_summary';
$handler->display->display_options['arguments']['tid']['title'] = '%2';
$handler->display->display_options['arguments']['tid']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['tid']['validate_type'] = 'numeric';
$handler->display->display_options['arguments']['tid']['break_phrase'] = 0;
$handler->display->display_options['arguments']['tid']['add_table'] = 0;
$handler->display->display_options['arguments']['tid']['require_value'] = 0;
$handler->display->display_options['arguments']['tid']['reduce_duplicates'] = 0;
$handler->display->display_options['arguments']['tid']['set_breadcrumb'] = 1;
/* Filtrar: Nodo: Publicado */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = '1';
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filtrar: Nodo: Tipo */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'image' => 'image',
);
$handler->display->display_options['filters']['type']['expose']['operator'] = FALSE;

/* Display: Gallery page */
$handler = $view->new_display('image_gallery', 'Gallery page', 'image_gallery_1');
$handler->display->display_options['path'] = 'image';

image_gallery_terms:

$view = new view;
$view->name = 'image_gallery_terms';
$view->description = 'The default list of descendant galleries from Image gallery module. Displayed within the image gallery view.';
$view->tag = 'image_gallery';
$view->view_php = '';
$view->base_table = 'term_data';
$view->is_cacheable = FALSE;
$view->api_version = 3.0-alpha1;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['items_per_page'] = 0;
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['submit_button'] = 'Aplicar';
$handler->display->display_options['exposed_form']['options']['reset_button_label'] = 'Reiniciar';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['expose']['items_per_page_label'] = 'Elementos por página';
$handler->display->display_options['pager']['options']['expose']['offset_label'] = 'Desplazamiento';
$handler->display->display_options['style_plugin'] = 'image_gallery_terms';
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['hide_empty'] = 0;
/* Campo: Galería de imágenes: Última imagen */
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['id'] = 'image_gallery_latest_thumbnail_1';
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['table'] = 'term_data';
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['field'] = 'image_gallery_latest_thumbnail';
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['label'] = '';
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['alter']['trim'] = 0;
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['alter']['html'] = 0;
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['link_to_taxonomy'] = 1;
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['depth'] = 'all';
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['descendants'] = 'flat';
$handler->display->display_options['fields']['image_gallery_latest_thumbnail_1']['image_derivative'] = 'thumbnail';
/* Campo: Taxonomía: Término */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'term_data';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['label'] = '';
$handler->display->display_options['fields']['name']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['name']['alter']['text'] = '

[name]

';
$handler->display->display_options['fields']['name']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['name']['alter']['trim'] = 0;
$handler->display->display_options['fields']['name']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['name']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['name']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['name']['alter']['html'] = 0;
$handler->display->display_options['fields']['name']['hide_empty'] = 0;
$handler->display->display_options['fields']['name']['empty_zero'] = 0;
$handler->display->display_options['fields']['name']['link_to_taxonomy'] = 1;
/* Campo: Galería de imágenes: Número */
$handler->display->display_options['fields']['image_gallery_count']['id'] = 'image_gallery_count';
$handler->display->display_options['fields']['image_gallery_count']['table'] = 'term_data';
$handler->display->display_options['fields']['image_gallery_count']['field'] = 'image_gallery_count';
$handler->display->display_options['fields']['image_gallery_count']['label'] = '';
$handler->display->display_options['fields']['image_gallery_count']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['image_gallery_count']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['image_gallery_count']['alter']['trim'] = 0;
$handler->display->display_options['fields']['image_gallery_count']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['image_gallery_count']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['image_gallery_count']['alter']['html'] = 0;
$handler->display->display_options['fields']['image_gallery_count']['link_to_taxonomy'] = 0;
/* Campo: Galería de imágenes: Last updated time */
$handler->display->display_options['fields']['image_gallery_latest_time']['id'] = 'image_gallery_latest_time';
$handler->display->display_options['fields']['image_gallery_latest_time']['table'] = 'term_data';
$handler->display->display_options['fields']['image_gallery_latest_time']['field'] = 'image_gallery_latest_time';
$handler->display->display_options['fields']['image_gallery_latest_time']['label'] = 'Última actualización';
$handler->display->display_options['fields']['image_gallery_latest_time']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['image_gallery_latest_time']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['image_gallery_latest_time']['alter']['trim'] = 0;
$handler->display->display_options['fields']['image_gallery_latest_time']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['image_gallery_latest_time']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['image_gallery_latest_time']['alter']['html'] = 0;
$handler->display->display_options['fields']['image_gallery_latest_time']['link_to_taxonomy'] = 0;
$handler->display->display_options['fields']['image_gallery_latest_time']['depth'] = 'all';
$handler->display->display_options['fields']['image_gallery_latest_time']['descendants'] = 'flat';
/* Campo: Taxonomía: Descripción del término */
$handler->display->display_options['fields']['description']['id'] = 'description';
$handler->display->display_options['fields']['description']['table'] = 'term_data';
$handler->display->display_options['fields']['description']['field'] = 'description';
$handler->display->display_options['fields']['description']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['description']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['description']['alter']['trim'] = 0;
$handler->display->display_options['fields']['description']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['description']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['description']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['description']['alter']['html'] = 0;
$handler->display->display_options['fields']['description']['hide_empty'] = 0;
$handler->display->display_options['fields']['description']['empty_zero'] = 0;
/* Criterio de ordenación: Taxonomía: Peso */
$handler->display->display_options['sorts']['weight']['id'] = 'weight';
$handler->display->display_options['sorts']['weight']['table'] = 'term_data';
$handler->display->display_options['sorts']['weight']['field'] = 'weight';
/* Argumento: Taxonomía: Término padre */
$handler->display->display_options['arguments']['parent']['id'] = 'parent';
$handler->display->display_options['arguments']['parent']['table'] = 'term_hierarchy';
$handler->display->display_options['arguments']['parent']['field'] = 'parent';
$handler->display->display_options['arguments']['parent']['style_plugin'] = 'default_summary';
$handler->display->display_options['arguments']['parent']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['parent']['break_phrase'] = 0;
$handler->display->display_options['arguments']['parent']['not'] = 0;
/* Filtrar: Taxonomía: Vocabulario */
$handler->display->display_options['filters']['vid']['id'] = 'vid';
$handler->display->display_options['filters']['vid']['table'] = 'term_data';
$handler->display->display_options['filters']['vid']['field'] = 'vid';
$handler->display->display_options['filters']['vid']['value'] = array(
'1' => '1',
);
$handler->display->display_options['filters']['vid']['expose']['operator'] = FALSE;

AND $view = new view;
$view->name = 'img_assist_browser';
$view->description = 'This view is used by Image assist for its thumbnail browser.';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 3.0-alpha1;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['title'] = 'Image assist thumbnail browser';
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['submit_button'] = 'Aplicar';
$handler->display->display_options['exposed_form']['options']['reset_button_label'] = 'Reiniciar';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = 6;
$handler->display->display_options['pager']['options']['expose']['items_per_page_label'] = 'Elementos por página';
$handler->display->display_options['pager']['options']['expose']['offset_label'] = 'Desplazamiento';
$handler->display->display_options['style_plugin'] = 'grid';
$handler->display->display_options['style_options']['columns'] = '3';
$handler->display->display_options['row_plugin'] = 'img_assist_thumbnail';
/* Campo: Nodo: Título */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Criterio de ordenación: Nodo: Fecha del envío */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'node';
$handler->display->display_options['sorts']['created']['field'] = 'created';
$handler->display->display_options['sorts']['created']['order'] = 'DESC';
/* Argumento: Usuario: Uid */
$handler->display->display_options['arguments']['uid']['id'] = 'uid';
$handler->display->display_options['arguments']['uid']['table'] = 'users';
$handler->display->display_options['arguments']['uid']['field'] = 'uid';
$handler->display->display_options['arguments']['uid']['style_plugin'] = 'default_summary';
$handler->display->display_options['arguments']['uid']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['uid']['break_phrase'] = 0;
$handler->display->display_options['arguments']['uid']['not'] = 0;
/* Argumento: Taxonomía: ID del término */
$handler->display->display_options['arguments']['tid']['id'] = 'tid';
$handler->display->display_options['arguments']['tid']['table'] = 'term_node';
$handler->display->display_options['arguments']['tid']['field'] = 'tid';
$handler->display->display_options['arguments']['tid']['style_plugin'] = 'default_summary';
$handler->display->display_options['arguments']['tid']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['tid']['validate_type'] = 'numeric';
$handler->display->display_options['arguments']['tid']['validate_fail'] = 'ignore';
$handler->display->display_options['arguments']['tid']['break_phrase'] = 0;
$handler->display->display_options['arguments']['tid']['add_table'] = 0;
$handler->display->display_options['arguments']['tid']['require_value'] = 0;
$handler->display->display_options['arguments']['tid']['reduce_duplicates'] = 0;
$handler->display->display_options['arguments']['tid']['set_breadcrumb'] = 0;
/* Filtrar: Nodo: Tipo */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'image' => 'image',
);
$handler->display->display_options['filters']['type']['expose']['operator'] = FALSE;
/* Filtrar: Nodo: Publicado */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 1;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;

i have been looking in other issues but they are very old or no that complex i think...

any help?

CommentFileSizeAuthor
GrabberRaster 0074.jpg45.35 KBbchinchilla

Comments

bchinchilla’s picture

where it sasys AND $view = new view;
it begins img_assist_browser:

$view = new view;
$view->name = 'img_assist_browser';
$view->description = 'This view is used by Image assist for its thumbnail browser.';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 3.0-alpha1;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

and so on...

joachim’s picture

Nothing in the image package uses Views while on an image node.

What is Image Gallery Management 6.x-1.0-beta6 ?

bchinchilla’s picture

yes, 6.x-1.0-beta6

i uninstalled it and everything is the same, the same error in the head of the image node, no errors in non-image nodes, and no pagers in the galleries...

the weird thing is that the problem only appears if it is related to image module, not with other modules, thats why i posted my issue here and not in the views forum...

joachim’s picture

Can you try disabling modules until you find the one that is causing the problem?
Also, disable all blocks.

Like I say, nothing in image executes views on an image node -- they are only used for galleries.

bchinchilla’s picture

It was a problem with module custom pager, i deactivated the module for testing, but the pager of the gallery view is still lost...i had to add an id for the pager directly in the view....

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['title'] = 'Galerías de imágenes';
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['submit_button'] = 'Aplicar';
$handler->display->display_options['exposed_form']['options']['reset_button_label'] = 'Reiniciar';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '24';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '1';

now the gallery pager looks like this...
http://www.wadafoc.com/image/tid/8?page=0,2

There are no more pagers (since a uninstalled custom pager and erased all custom pager views) so in theory that id it is not necessary...

bchinchilla’s picture

but that image assist pop up window issue persist as shown in the image i attached, the pager is shown but no images...