[Show Slideshow] doesn’t, but [Show Thumbnails] does

@michaeltiemann – Although slow loading the slideshow is working on the URL you shared.

Also to note, there are a couple of console messages that might be pointing to a possible issue with using the IP address versus the TLD, you might consider using the Reset Option under Gallery > Other Options in NextGEN Gallery as well to help things along.

Thanks!

– Cais.

Thanks! I’m trying to hunt down the numberical IP addresses and change to TLD. Can you share with me how to read those console messages so I can do that. I do see the Reset Option, but I’d like to do that as a last resort.

I do now see the slideshow, which is definitely progress. I also see these lines from my php error log:

[12-May-2018 16:08:24 UTC] WordPress database error 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 ‘ASC ASC’ at line 1 for query SELECT DISTINCT pid , GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS ‘extras’ FROM wplk_ngg_pictures LEFT OUTER JOIN wplk_postmeta ON wplk_postmeta.post_id = extras_post_id WHERE (exclude = 0) AND (galleryid IN (7)) GROUP BY wplk_ngg_pictures.pid ORDER BY ASC ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/x/template-blank-4.php’), x_get_view, X_View_Router::render, include(‘/themes/x/framework/views/ethos/template-blank-4.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, call_user_func_array, C_NextGen_Shortcode_Manager->parse_content, C_NextGen_Shortcode_Manager->execute_found_shortcode, call_user_func, M_Gallery_Display->display_images, C_Displayed_Gallery_Renderer->display_images, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Renderer->display_images, C_Displayed_Gallery_Renderer->render, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_NextGen_Basic_Album_Routes->render, Mixin->call_parent, ExtensibleObject->call_method, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Renderer->render, C_Display_Type_Controller->index_action, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_NextGen_Basic_Gallery_Controller->index_action, Mixin->call_parent, ExtensibleObject->call_method, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_NextGen_Basic_Thumbnails_Controller->index_action, C_Displayed_Gallery->get_entity_count, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Queries->get_entity_count, C_Displayed_Gallery->_get_image_entities, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_I18N_Displayed_Gallery_Translation->_get_image_entities, Mixin->call_parent, ExtensibleObject->call_method, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Queries->_get_image_entities, C_Image_Mapper->run_query, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, C_CustomTable_DataMapper_Driver_Mixin->run_query

[12-May-2018 16:08:24 UTC] WordPress database error 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 ‘ASC ASC LIMIT 500’ at line 1 for query SELECT DISTINCT wplk_ngg_pictures.* , GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS ‘extras’ FROM wplk_ngg_pictures LEFT OUTER JOIN wplk_postmeta ON wplk_postmeta.post_id = extras_post_id WHERE (exclude = 0) AND (galleryid IN (7)) GROUP BY wplk_ngg_pictures.pid ORDER BY ASC ASC LIMIT 500 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/x/template-blank-4.php’), x_get_view, X_View_Router::render, include(‘/themes/x/framework/views/ethos/template-blank-4.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, call_user_func_array, C_NextGen_Shortcode_Manager->parse_content, C_NextGen_Shortcode_Manager->execute_found_shortcode, call_user_func, M_Gallery_Display->display_images, C_Displayed_Gallery_Renderer->display_images, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Renderer->display_images, C_Displayed_Gallery_Renderer->render, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_NextGen_Basic_Album_Routes->render, Mixin->call_parent, ExtensibleObject->call_method, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Renderer->render, C_Display_Type_Controller->index_action, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_NextGen_Basic_Gallery_Controller->index_action, Mixin->call_parent, ExtensibleObject->call_method, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_NextGen_Basic_Thumbnails_Controller->index_action, C_Displayed_Gallery->get_included_entities, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Queries->get_included_entities, C_Displayed_Gallery->get_entities, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Queries->get_entities, C_Displayed_Gallery->_get_image_entities, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, A_I18N_Displayed_Gallery_Translation->_get_image_entities, Mixin->call_parent, ExtensibleObject->call_method, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, Mixin_Displayed_Gallery_Queries->_get_image_entities, C_Image_Mapper->run_query, ExtensibleObject->__call, ExtensibleObject->_exec_cached_method, ReflectionMethod->invokeArgs, C_CustomTable_DataMapper_Driver_Mixin->run_query

• This reply was modified 6 years, 6 months ago by Michael Tiemann. Reason: added some missing details

@michaeltiemann – Depending on your browser it will have a “Developer” option which will then allow you to see among other things page source, element inspection, etc. Once one of these panels is opened you should also a “tab” for the Console where the errors can be seen.

As to error_Logs entries, although as far as we know there are no conflict with the X theme it does appear one may have cropped up under the conditions of your site but unfortunately, these entries alone are not enough to determine what or if that is the case.

Thanks!

– Cais.

Very helpful! Now, looking at the page source, I don’t understand why ngg is returning all 172 images from my gallery when I only wanted the first 20 (randomly picked). What is the right way to get a restricted set of random images from a single gallery?

Fixing the issues on my side, I see that there’s some auto-generated stuff that’s coming in from the css files related to thumbnail generation of ngg. But I don’t see where that css file is stored within the file system in order to fix it. I’m now running 3.0.0, which is perhaps out of sync with the online documentation. There’s no ngg_styles directory being created within wp-content.

Nevermind…found a way to flush the right cache and that problem is now fixed. I’ll start a new thread if I have more troubles.