DSystem Posted February 19, 2022 Posted February 19, 2022 Hi! The 'Manage Followed Content' page does not work. (I have already disabled all apps and plugins) I have the following error in the logs 👇 The URL of page the error occurred on was https://eletronicabr.com/followed/?type=gallery_image&change_section=1 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=273 AND follow_app='gallery' AND follow_area='image' AND ( gallery_images.image_approved=1 OR ( gallery_images.image_approved=0 AND gallery_images.image_member_id=273 ) ) AND (( FIND_IN_SET(3,core_permission_index.perm_view) OR FIND_IN_SET(17,core_permission_index.perm_view) OR FIND_IN_SET('m273',core_permission_index.perm_view) OR FIND_IN_SET('ca',core_permission_index.perm_view) ) OR core_permission_index.perm_view='*' ) AND ( gallery_images.image_album_id=0 OR gallery_images.image_album_id IN(?) ) AND SELECT album_id FROM `gallery_albums` WHERE ( album_type=1 OR ( album_type=2 AND album_owner_id=? ) ) AND album_hidden=0 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 'SELECT album_id FROM `gallery_albums` WHERE ( album_type=1 OR ( album_type=2 ...' at line 1 (1064) #0 /home/admin/web/eletronicabr.com/public_html/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*admin_forum::...', Array, true) #1 /home/admin/web/eletronicabr.com/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 /home/admin/web/eletronicabr.com/public_html/system/Db/Select.php(370): IPS\Db\_Select->rewind() #3 /home/admin/web/eletronicabr.com/public_html/system/Helpers/Table/Db.php(327): IPS\Db\_Select->first() #4 /home/admin/web/eletronicabr.com/public_html/applications/core/sources/Followed/Table.php(184): IPS\Helpers\Table\_Db->getRows(Array) #5 /home/admin/web/eletronicabr.com/public_html/system/Helpers/Table/Table.php(489): IPS\core\Followed\_Table->getRows(Array) #6 /home/admin/web/eletronicabr.com/public_html/uploads/template_28_6c476385a2a7fac76ac1bb8ed658e957_system.php(1538): IPS\Helpers\Table\_Table->__toString() #7 /home/admin/web/eletronicabr.com/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_core_front_system->followedContent(Array, 'gallery_gallery', 'gallery_image', Object(IPS\core\Followed\Table)) #8 /home/admin/web/eletronicabr.com/public_html/applications/core/modules/front/system/followed.php(115): IPS\Theme\_SandboxedTemplate->__call('followedContent', Array) #9 /home/admin/web/eletronicabr.com/public_html/system/Dispatcher/Controller.php(101): IPS\core\modules\front\system\_followed->manage() #10 /home/admin/web/eletronicabr.com/public_html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #11 /home/admin/web/eletronicabr.com/public_html/index.php(13): IPS\_Dispatcher->run() #12 {main} BACKTRACE #0 /home/admin/web/eletronicabr.com/public_html/init.php(1015): IPS\_Log::log('SELECT count(*)...', 'uncaught_except...') #1 /home/admin/web/eletronicabr.com/public_html/system/Helpers/Table/Table.php(569): IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 /home/admin/web/eletronicabr.com/public_html/uploads/template_28_6c476385a2a7fac76ac1bb8ed658e957_system.php(1538): IPS\Helpers\Table\_Table->__toString() #3 /home/admin/web/eletronicabr.com/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_core_front_system->followedContent(Array, 'gallery_gallery', 'gallery_image', Object(IPS\core\Followed\Table)) #4 /home/admin/web/eletronicabr.com/public_html/applications/core/modules/front/system/followed.php(115): IPS\Theme\_SandboxedTemplate->__call('followedContent', Array) #5 /home/admin/web/eletronicabr.com/public_html/system/Dispatcher/Controller.php(101): IPS\core\modules\front\system\_followed->manage() #6 /home/admin/web/eletronicabr.com/public_html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /home/admin/web/eletronicabr.com/public_html/index.php(13): IPS\_Dispatcher->run() #8 {main} Â
Jim M Posted February 20, 2022 Posted February 20, 2022 Is this happening on an unmodified theme with all third party applications/plugins disabled?Â
DSystem Posted February 20, 2022 Author Posted February 20, 2022 1 hour ago, Jim M said: Isso está acontecendo em um tema não modificado com todos os aplicativos/plugins de terceiros desativados? YES
Solution Stuart Silvester Posted February 20, 2022 Solution Posted February 20, 2022 This is a known issue in the current release, we the issue in our backlog already and it will be addressed in a future release.
DSystem Posted February 20, 2022 Author Posted February 20, 2022 OK. Any idea when the fix will be released?
DSystem Posted March 4, 2022 Author Posted March 4, 2022 Does version 4.6.11 Beta 2 have the fix for this issue?
Randy Calvert Posted March 4, 2022 Posted March 4, 2022 It's not mentioned in the change logs and the updates by Jordan. Â Â
Marc Posted April 5, 2022 Posted April 5, 2022 This issue has been resolved in 4.6.12, which has just been release. Please let us know if you still have any issues once you have upgraded to that release. DSystem 1
DSystem Posted April 5, 2022 Author Posted April 5, 2022 Good Morning! I Updated to version 4.6.12. But the problem is still not solved!
Jim M Posted April 5, 2022 Posted April 5, 2022 32 minutes ago, DSystem said: Good Morning! I Updated to version 4.6.12. But the problem is still not solved! Sorry for the inconvenience. Looks like a new issue popped up with this which we are aware of and working on a fix.
Recommended Posts