Error Table 'mautic.notifications' doesn't exist in engine (1932)

Product Support
1

Your software
My Mautic version is: 2.15.2.dev
My PHP version is: 7.2

Your problem
My problem is:
i get this error message while execute sql dump…

mysqldump: Couldn’t execute 'show create table notifications': Table ‘mautic.notifications’ doesn’t exist in engine (1932)

These errors are showing in the log:

[2020-09-28 10:44:03] mautic.ERROR: CAMPAIGN: An exception occurred while executing ‘INSERT INTO notifications (type, header, message, date_added, icon_class, is_read, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’ with params [“error”, “Failed to execute campaign event for jheris1770@gmail.com</a>.”, “5 Days Class (evergreen) / Email hari ke-1 (pertama)”, “2020-09-28 10:44:03”, null, 0, 1]: SQLSTATE[42S02]: Base table or view not found: 1932 Table ‘mautic.notifications’ doesn’t exist in engine

Steps I have tried to fix the problem:
mysqldump --skip-lock-tables -u user -pMyPassword mautic > db.sql

2

Try clearing Cache. I saw a similar issue recently and clearing cache seemed to do the trick.