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}

 

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.

Just to confirm, this has now been fixed internally and should be in the next release.

Thanks Marc

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.

I can confirm fixed 👍

11 minutes ago, Richard Arch said:

I can confirm fixed 👍

Glad to hear it 🙂