Jump to content

Database error 1064 "Manage Followed Content"


Go to solution Solved by Stuart Silvester,

Recommended Posts

Posted

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}

 

  • 2 weeks later...
  • 1 month later...
Posted
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.

  • Recently Browsing   0 members

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