Michael Tiemann

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.

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.

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?

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