Manage Followed Content  > Gallery > Images giving this error

The URL of page the error occurred on was https://www.mydomain/forum/followed/?type=gallery_image&change_section=1

SELECT count(*) FROM `inv_core_follow` AS `core_follow`  LEFT JOIN `inv_gallery_images` AS `gallery_images` ON gallery_images.image_id=core_follow.follow_rel_id AND core_follow.follow_app='gallery'  STRAIGHT_JOIN `inv_gallery_categories` AS `gallery_categories` ON gallery_categories.category_id=gallery_images.image_category_id  LEFT JOIN `inv_core_permission_index` AS `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=2 AND follow_app='gallery' AND follow_area='image' AND (( FIND_IN_SET(4,core_permission_index.perm_view) OR FIND_IN_SET(4,core_permission_index.perm_view) OR FIND_IN_SET('m2',core_permission_index.perm_view) OR FIND_IN_SET('ca',core_permission_index.perm_view) OR FIND_IN_SET('cm',core_permission_index.perm_view) OR FIND_IN_SET('c11',core_permission_index.perm_view) OR FIND_IN_SET('c1',core_permission_index.perm_view) OR FIND_IN_SET('c9',core_permission_index.perm_view) OR FIND_IN_SET('c10',core_permission_index.perm_view) OR FIND_IN_SET('c12',core_permission_index.perm_view) OR FIND_IN_SET('cm1',core_permission_index.perm_view) OR FIND_IN_SET('cm9',core_permission_index.perm_view) OR FIND_IN_SET('cm10',core_permission_index.perm_view) OR FIND_IN_SET('cm12',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 MySQL server version for the right syntax to use near '' at line 1 (1064)
#0 /home/media/public_html/forum/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*media_invisio...', Array, true)
#1 /home/media/public_html/forum/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 /home/media/public_html/forum/system/Db/Select.php(370): IPS\Db\_Select->rewind()
#3 /home/media/public_html/forum/system/Helpers/Table/Db.php(327): IPS\Db\_Select->first()
#4 /home/media/public_html/forum/applications/core/sources/Followed/Table.php(184): IPS\Helpers\Table\_Db->getRows(Array)
#5 /home/media/public_html/forum/system/Helpers/Table/Table.php(489): IPS\core\Followed\_Table->getRows(Array)
#6 /home/media/public_html/forum/system/Theme/Theme.php(880) : eval()'d code(1537): IPS\Helpers\Table\_Table->__toString()
#7 /home/media/public_html/forum/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_system->followedContent(Array, 'gallery_gallery', 'gallery_image', Object(IPS\core\Followed\Table))
#8 /home/media/public_html/forum/applications/core/modules/front/system/followed.php(115): IPS\Theme\_SandboxedTemplate->__call('followedContent', Array)
#9 /home/media/public_html/forum/system/Dispatcher/Controller.php(101): IPS\core\modules\front\system\_followed->manage()
#10 /home/media/public_html/forum/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#11 /home/media/public_html/forum/index.php(13): IPS\_Dispatcher->run()
#12 {main}

BACKTRACE

#0 /home/media/public_html/forum/init.php(1015): IPS\_Log::log('SELECT count(*)...', 'uncaught_except...')
#1 /home/media/public_html/forum/system/Helpers/Table/Table.php(569): IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 /home/media/public_html/forum/system/Theme/Theme.php(880) : eval()'d code(1537): IPS\Helpers\Table\_Table->__toString()
#3 /home/media/public_html/forum/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_system->followedContent(Array, 'gallery_gallery', 'gallery_image', Object(IPS\core\Followed\Table))
#4 /home/media/public_html/forum/applications/core/modules/front/system/followed.php(115): IPS\Theme\_SandboxedTemplate->__call('followedContent', Array)
#5 /home/media/public_html/forum/system/Dispatcher/Controller.php(101): IPS\core\modules\front\system\_followed->manage()
#6 /home/media/public_html/forum/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#7 /home/media/public_html/forum/index.php(13): IPS\_Dispatcher->run()
#8 {main}

I need help please?

Invision Version: Invision Community v4.6.12

Thanks

Edited April 5, 20222 yr by media

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.

 

This has now been patched. Please visit support within your admin CP and apply the patch that is showing. If you are not seeing it yet, give it a few minutes

On 4/6/2022 at 5:55 AM, Marc Stridgen said:

This has now been patched. Please visit support within your admin CP and apply the patch that is showing. If you are not seeing it yet, give it a few minutes

Thank you so much.... All good fixed...