·
Added a discussion

I turned my site notifications module off and on trying to fix a problem but, now my site Notifications module won't show any settings and throws a database error each time I try to turn the module on inside of Studio. The Notifications module is stuck in the off position and my notifications aren't working yet, the email system part of the notifications is sending emails out on the back end; over 5,000 today.

  • 527
Comments
    • Hello @SmokeyMcduff !


      May you please specify what DB error do you get on your site admin email? Smth with the subject like "MySQL error on [site name]".

      • Database error in Veteran Brigades (VB)


        Query:

        INSERT INTO `bx_notifications_handlers` SET `group`=?, `type`=?, `alert_unit`=?, `alert_action`=?, `content`=?, `privacy`=?

        Mysql error:

        Duplicate entry 'bx_albums_object-insert' for key 'handler'

        Location:

        The error was found in query function in the file /home/veteranbrigades/public_html/community/modules/base/notifications/classes/BxBaseModNotificationsDb.php at line 76.

        collation_connection:

        utf8mb4_unicode_ci

        Debug backtrace:

        • Smth was wrong with the previous Albums app installation / deleting. Do you have installed Albums now?

          • Yes I do have albums installed now. I just turned it off so it's not active.

            • I'm getting this error now: Database error in Veteran Brigades (VB)


              Query:

              INSERT INTO `bx_notifications_handlers` SET `group`=?, `type`=?, `alert_unit`=?, `alert_action`=?, `content`=?, `privacy`=?

              Mysql error:

              Duplicate entry 'bx_forum_object-insert' for key 'handler'

              Location:

              The error was found in query function in the file /home/veteranbrigades/public_html/community/modules/base/notifications/classes/BxBaseModNotificationsDb.php at line 76.

              collation_connection:

              utf8mb4_unicode_ci

              Debug backtrace:

              • Please help me, I'm begging. The site is sending out over 5,000 emails a day and my hosting company is getting pissed at me. They said I better get it fixed soon or they'll shut me down. I have over 2,400 users.

                • If you haven't the possibility to reinstall the Albums app then with this error you need to perform the following actions:


                  1) backup the UNA database completely and bx_timeline_handlers and sys_alerts tables also separately.


                  2) run the following query:


                  delete FROM `bx_timeline_handlers` WHERE `group` like 'bx_albums%';


                  3) try to install the Notifications app again


                  4) if you still have the DB errors then run this set of queries:


                  delete FROM `bx_timeline_handlers` WHERE `group` like 'bx_albums%';


                  delete FROM `sys_alerts` WHERE `unit` like 'bx_albums%';


                  delete FROM `bx_notifications_handlers` WHERE `alert_unit` like 'bx_albums%';


                  5) go the Studio Dashboard, clear all caches and then install the Notifications again

                  • I de-installed Notifications and then re-installed it and all is well now.

                    Not logged in users can't 'Comments Post'.
                    Info