Database error 1064 "Manage Followed Content"

[DSystem]

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]

Is this happening on an unmodified theme with all third party applications/plugins disabled? 

[DSystem]

1 hour ago, Jim M said:

Isso está acontecendo em um tema não modificado com todos os aplicativos/plugins de terceiros desativados? 

YES

[Stuart Silvester]

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]

OK. Any idea when the fix will be released?

[DSystem]

Does version 4.6.11 Beta 2 have the fix for this issue?

[Randy Calvert]

It's not mentioned in the change logs and the updates by Jordan.  

 

[Marc Stridgen]

This is still an open issue at present

[Marc Stridgen]

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]

Good Morning! I Updated to version 4.6.12. But the problem is still not solved!

[Jim M]

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.