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?
| Comment | File | Size | Author |
|---|---|---|---|
| GrabberRaster 0074.jpg | 45.35 KB | bchinchilla |
Comments
Comment #1
bchinchilla commentedwhere 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...
Comment #2
joachim commentedNothing in the image package uses Views while on an image node.
What is Image Gallery Management 6.x-1.0-beta6 ?
Comment #3
bchinchilla commentedyes, 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...
Comment #4
joachim commentedCan 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.
Comment #5
bchinchilla commentedIt 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...
Comment #6
bchinchilla commentedbut that image assist pop up window issue persist as shown in the image i attached, the pager is shown but no images...