Jump to content

Manage Followed Content > Gallery > Images giving this error


Go to solution Solved by Marc,

Recommended Posts

Posted (edited)

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 by media
Posted

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.

 

  • Solution
Posted

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

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

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...