Richard Arch Posted October 7, 2021 Share Posted October 7, 2021 Hi, I think this is a bug and would appreciate if someone else could check if they get the same error when trying to view images that they may be following. I'm seeing this error on a bare local install (v4.6.7) and my live forum (v4.6.6). Thanks Quote SELECT count(*) FROM `core_follow` LEFT JOIN `gallery_images` ON gallery_images.image_id=core_follow.follow_rel_id AND core_follow.follow_app='gallery' STRAIGHT_JOIN `gallery_categories` ON gallery_categories.category_id=gallery_images.image_category_id LEFT JOIN `core_permission_index` ON core_permission_index.app='gallery' AND core_permission_index.perm_type='category' AND core_permission_index.perm_type_id=gallery_categories.category_id WHERE follow_member_id=1 AND follow_app='gallery' AND follow_area='image' AND (( FIND_IN_SET(4,core_permission_index.perm_view) OR FIND_IN_SET('m1',core_permission_index.perm_view) OR FIND_IN_SET('cm',core_permission_index.perm_view) ) OR core_permission_index.perm_view='*' ) AND IPS\Db\Exception: 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 (1064) #0 H:\wamp64\www\ips\forums\system\Db\Select.php(388): IPS\_Db->preparedQuery('/*wvamorgu_ips:...', Array, true) #1 H:\wamp64\www\ips\forums\system\Db\Select.php(446): IPS\Db\_Select->runQuery() #2 H:\wamp64\www\ips\forums\system\Db\Select.php(370): IPS\Db\_Select->rewind() #3 H:\wamp64\www\ips\forums\system\Helpers\Table\Db.php(327): IPS\Db\_Select->first() #4 H:\wamp64\www\ips\forums\applications\core\sources\Followed\Table.php(184): IPS\Helpers\Table\_Db->getRows(Array) #5 H:\wamp64\www\ips\forums\system\Helpers\Table\Table.php(489): IPS\core\Followed\_Table->getRows(Array) #6 H:\wamp64\www\ips\forums\system\Theme\Theme.php(860) : eval()'d code(1537): IPS\Helpers\Table\_Table->__toString() #7 H:\wamp64\www\ips\forums\system\Theme\SandboxedTemplate.php(61): IPS\Theme\class_core_front_system->followedContent(Array, 'gallery_gallery', 'gallery_image', Object(IPS\core\Followed\Table)) #8 H:\wamp64\www\ips\forums\applications\core\modules\front\system\followed.php(115): IPS\Theme\_SandboxedTemplate->__call('followedContent', Array) #9 H:\wamp64\www\ips\forums\system\Dispatcher\Controller.php(101): IPS\core\modules\front\system\_followed->manage() #10 H:\wamp64\www\ips\forums\system\Dispatcher\Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #11 H:\wamp64\www\ips\forums\index.php(13): IPS\_Dispatcher->run() #12 {main} Link to comment Share on other sites More sharing options...
Marc Posted October 8, 2021 Share Posted October 8, 2021 Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release. Link to comment Share on other sites More sharing options...
Marc Posted October 8, 2021 Share Posted October 8, 2021 Just to confirm, this has now been fixed internally and should be in the next release. Link to comment Share on other sites More sharing options...
Richard Arch Posted October 8, 2021 Author Share Posted October 8, 2021 Thanks Marc Link to comment Share on other sites More sharing options...
Solution Marc Posted November 3, 2021 Solution Share Posted November 3, 2021 This has been resolved in the latest 4.6.8 release. Please upgrade to get the latest release, and let us know if you see any further issues. Link to comment Share on other sites More sharing options...
Richard Arch Posted November 3, 2021 Author Share Posted November 3, 2021 I can confirm fixed 👍 Jim M 1 Link to comment Share on other sites More sharing options...
Marc Posted November 3, 2021 Share Posted November 3, 2021 11 minutes ago, Richard Arch said: I can confirm fixed 👍 Glad to hear it 🙂 Link to comment Share on other sites More sharing options...
Recommended Posts