Manage Followed Content > Gallery > Images bug?

[Richard Arch]

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}

 

[Marc]

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.

[Marc]

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

[Richard Arch]

Thanks Marc

[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.

[Richard Arch]

I can confirm fixed 👍

[Marc]

11 minutes ago, Richard Arch said:

I can confirm fixed 👍

Glad to hear it 🙂