Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
media Posted April 5, 2022 Posted April 5, 2022 (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 April 5, 2022 by media
Marc Posted April 5, 2022 Posted April 5, 2022 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. media 1
Solution Marc Posted April 6, 2022 Solution Posted April 6, 2022 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
media Posted April 7, 2022 Author Posted April 7, 2022 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... Marc 1
Recommended Posts