Announcement

Collapse
No announcement yet.

notification, latest topics, and trending all stopped working

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • notification, latest topics, and trending all stopped working

    OS: centos 8
    mysql: 10.3.17-MariaDB
    vbb version: 5.6.0 to 5.6.1

    I did not patch our vbb from 5.6.0 in time and got hit by CVE-2020-12720. The hacker changed the administrator password and blew away the whole database. I got an email from the person demanding money for the dump of the database. Patch your forums, boys!

    I shut down the site, restored the database from a few minutes before the hacker deleted everything using a previous snapshot. While the site was offline for maintenance, I installed the 5.6.1 security patch 1 and completed the online upgrade all without a problem.

    Site was opened again to the public and all seemed fine. Exact I noticed that the notifications (to the left of the messages / user profile buttons on the top right), and the latest and trending topics on the front page stopped working. You can see old notifications, but nothing new shows up.

    I've verified all the tables in mysql are okay (no errors, at least) and I haven't gotten any sql email errors. I'm not really sure where to look from here...

    Thoughts?

    Thanks,
    liam

  • #2
    Delete your system cache under Maintenance in the AdminCP. If you are using Memcached, you will need to reset that daemon. If you're using Sphinx Search, rebuild the search index on it.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      Done, unfortunately, that didn't seem to make a difference. Also, the liam821 functionality does not notify the end-user as well.

      Comment


      • #4
        Just to add, the notification table in the database has not been updated/touched since I restored the db/upgraded.

        Code:
        MariaDB [mydb]> select notificationid,recipient,sender,FROM_UNIXTIME(lastsenttime),FROM_UNIXTIME(lastreadtime) from notification order by lastsenttime desc limit 20;
        +----------------+-----------+--------+-----------------------------+-----------------------------+
        | notificationid | recipient | sender | FROM_UNIXTIME(lastsenttime) | FROM_UNIXTIME(lastreadtime) |
        +----------------+-----------+--------+-----------------------------+-----------------------------+
        | 36318 | 1195 | 771 | 2020-05-16 12:30:57 | 2020-05-18 05:23:02 |
        | 26529 | 1126 | 771 | 2020-05-16 12:30:57 | 2020-05-17 06:38:54 |
        | 36316 | 689 | 1255 | 2020-05-16 12:30:44 | 1969-12-31 16:00:00 |
        | 36273 | 257 | 1255 | 2020-05-16 12:30:44 | 2020-05-16 23:03:23 |
        | 36315 | 1195 | 771 | 2020-05-16 12:30:02 | 2020-05-18 05:23:02 |
        | 36314 | 63 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36313 | 50 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36312 | 154 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36311 | 854 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36310 | 404 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36309 | 406 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36308 | 522 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36307 | 465 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36306 | 447 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36305 | 256 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36304 | 200 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36303 | 17 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36302 | 178 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        | 36301 | 1163 | 1126 | 2020-05-16 12:21:52 | 2020-05-17 07:30:13 |
        | 36300 | 1219 | 1126 | 2020-05-16 12:21:52 | 1969-12-31 16:00:00 |
        +----------------+-----------+--------+-----------------------------+-----------------------------+

        Comment


        • #5
          This continues, I have not figured out what is wrong yet. I've also noticed that channel permissions in the admincp does not work anymore, you can select tthe channel, and a usergroup, but all the channel permissions are blank.

          Obviously something is wrong. At least from a user perspective things are working normal'ish, except the whole notification thing.

          Comment


          • #6
            All your tables are INNODB? We do not support MariaDB's ARIA table type at all. We do not support MyISAM on tables other than the language, phrase, and usertextfield tables due to limitations in search before MySQL 5.7. MariaDB tends to severely lag on implementing new features from MySQL as well.

            Are there any JavaScript errors in the browser console?
            Last edited by Wayne Luke; Today, 9:08am.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API - Full / Mobile
            Vote for your favorite feature requests and the bugs you want to see fixed.

            Comment


            • #7
              Originally posted by Wayne Luke View Post
              All your tables are INNODB? We do not support MariaDB's ARIA table type at all. We do not support MyISAM on tables other than the language, phrase, and usertextfield tables due to limitations in search before MySQL 5.7. MariaDB tends to severely lag on implementing new features from MySQL as well.

              Are there any JavaScript errors in the browser console?
              All our tables are innodb, they were all created using the standard vbulletin 5 "install" web gui. There aren't any javascript errors in the browser console, we don't have any plug-ins or add-ons, I've run the verify files in the debug options and all files are original except for the png logo.

              Comment

              Related Topics

              Collapse

              Working...
              X