ZenphotoCMS Forum
error in tag_suggest? - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: Plugins (https://forum.zenphoto.org/forum-6.html)
+--- Thread: error in tag_suggest? (/thread-13353.html)



error in tag_suggest? - Tohin - 15-12-2019

Hello.
When I enable plugin I get error if I not logged in:

USER ERROR: MySQLi Error: ( SELECT DISTINCT `id` FROM `[prefix]images` WHERE `show` = 0 OR `albumid` in () )             failed. 
MySQLi returned the error You have an error in your SQL syntax; check the manual that corresponds to your     
MariaDB server version for the right syntax to use near ')' at line 1 in /zp-core/functions-db-MySQLi.php on line 95

trigger_error called from query (functions-db-MySQLi.php [95])
from getNotViewableImages (functions.php [1583])
from getTagCountByAccess (functions.php [1202])
from getAllTagsUnique (functions.php [1127])
from tagSuggestJS (tag_suggest.php [64])
from tagSuggestJS_frontend (tag_suggest.php [50])
from zp_apply_filter (functions-filter.php [150])
from include (password.php [11])
from include (index.php [130])
from index.php [45]



error in tag_suggest? - acrylian - 16-12-2019

Indeed, there is. It only appears if you have the check tag access option enabled and actually don't have any albums that a normal visitor does not have access to. Fix is the in the support build.