Comment '@Leonids thanks for ...' to 'V14.0.0 - Quick background: Notifications UI was spinning slow on load. Found cron spamming this fatal every minute:'
Comment to V14.0.0 - Quick background: Notifications UI was spinning slow on load. Found cron spamming this fatal every minute:

  • @Leonids thanks for your response man... much appreciated...

    To answer your question: I do not know the exact reason the bx_ntfs_* tables were removed. No deliberate uninstall of the Notifications module was performed on our end. The most likely candidate based on our timeline is a third-party module update applied around March 2025 — that is the only significant change we can trace that aligns with when the issue would have started silently, before traffic volumes escalated and exposed it on 18 March 2026.

    What we know for certain:

    • bx_ntfs_* tables: completely absent (SHOW TABLES LIKE 'bx_ntfs%' returns nothing)

    • sys_cron_jobs: no ntfs entries

    • modules/boonex/notifications/install/sql/: empty — no schema files present

    • Module files: intact and current (Jun 2025)

    • periodic/cron.php line 121: hardcoded call runs regardless of module/table state

    Since the removal appears to be table-only with no data at risk, we are ready to proceed with a manual restore.

    Could you please advise:

    1. The correct source for the bx_ntfs_* table definitions in v14 (since install/sql/ is empty)? GitHub branch, core SQL file, or patch?

    2. Whether the sys_cron_jobs entries for notifications also need to be manually reinserted, and if so the correct values?

    3. Whether the AppStore updates currently showing are safe to apply on our v14 site — or should schema restore come first?

    We have a full snapshot ready and the cron comment fix staged but not yet applied to production. Standing by for your guidance before touching anything.

    Regards Chris

    • From this page https://unacms.com/download-product/notifications you may take the 14.0.8 version. The code for the Cron Jobs looks like

      INSERT INTO `sys_cron_jobs` (`name`, `time`, `class`, `file`, `service_call`) VALUES
('bx_notifications_queue', '* * * * *', 'BxNtfsCronQueue', 'modules/boonex/notifications/classes/BxNtfsCronQueue.php', ''),
('bx_notifications_notify', '* * * * *', 'BxNtfsCronNotify', 'modules/boonex/notifications/classes/BxNtfsCronNotify.php', ''),
('bx_notifications_clean', '0 0 * * *', 'BxNtfsCronClean', 'modules/boonex/notifications/classes/BxNtfsCronClean.php', '');