Announcement

Collapse
No announcement yet.

last post information not updated

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

  • last post information not updated

    Hi, i have an issue with the last post information displayed for a topic on several pages :

    On the main page (/forum here) i have the following info, which are accurate :
    Click image for larger version  Name:	main.jpg Views:	1 Size:	111.8 KB ID:	4377142

    Now on the channel view of "forum principal" i have this, the avatar is the one of the last user who posted, but the login and the date & time are from another post, also, the "go to las post" button leads to this earlier post instead of the last one :
    Click image for larger version  Name:	12-09-2017 13-54-51.jpg Views:	1 Size:	190.5 KB ID:	4377143

    Finally, in a search results "today topics", i have the same wrong info (but the date use to sort by last post date is the right one...) :
    Click image for larger version  Name:	search.jpg Views:	1 Size:	186.9 KB ID:	4377144

    It goes away on its own without me knowing why, so i believe there might be some routine task to update it.
    Is there any way i could fix this, or at least make the routine task more frequent so it wouldn't last almost 24 hours.

    Best regards,
    Matthieu.

  • #2
    Click image for larger version

Name:	Capture+_2017-09-12-14-16-10-1.png
Views:	48
Size:	36.6 KB
ID:	4377147
    https://www.vbulletin.com/forum/foru...re-waiting-for

    Comment


    • #3
      i am on linux and apache so i did not turn on this option.
      But i will try it

      Edit : Well it is the same with this option turned on.

      Comment


      • #4
        That option shouldn't affect the data and will increase your bandwidth with little benefit. It is a hold over from old servers.

        Can you clear your cache, cacheevent, and searchlog tables?
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment


        • #5
          Do i just truncate the tables ?

          I emptied the cache form the admincp, it seems to solve the problem temporarily but it comes back after a while, on random topics and it goes on its own at least once a day.
          Last edited by plongeur.com; Thu 14 Sep '17, 1:18am.

          Comment


          • #6
            Yes truncate those three tables. (No other tables obviously!)
            MARK.B | vBULLETIN SUPPORT

            TalkNewsUK - My vBulletin 5.6.4 Demo
            AdminAmmo - My Cloud Demo

            Comment


            • #7
              OK i did truncate the 3 tables.
              I'll keep you posted if the issue comes up again.

              Comment


              • #8
                Originally posted by Wayne Luke View Post
                That option shouldn't affect the data and will increase your bandwidth with little benefit. It is a hold over from old servers.

                Can you clear your cache, cacheevent, and searchlog tables?
                it's not obligatory to enable it?
                It's true that it causes a high load on the server
                When I turn it off I do not see the newest in the forum without using F5 on the browser
                https://www.vbulletin.com/forum/foru...re-waiting-for

                Comment


                • #9
                  Originally posted by saiff View Post

                  it's not obligatory to enable it?
                  It's true that it causes a high load on the server
                  When I turn it off I do not see the newest in the forum without using F5 on the browser
                  It is not necessary on 99% of all servers. It increases the load of the server because browser-side caching is turned off.

                  With a properly configured server and the latest versions of modern browsers it isn't necessary. If you're using an out of date browser like IE8-10, then you could have problems.
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud demonstration site.
                  vBulletin 5 API

                  Comment


                  • #10
                    thanks for your availability and clarification.
                    https://www.vbulletin.com/forum/foru...re-waiting-for

                    Comment


                    • #11
                      well, as i feared, it came back.

                      Click image for larger version

Name:	18-09-2017 09-09-36.jpg
Views:	48
Size:	153.9 KB
ID:	4377469

                      Would scheduling a daily truncate of said table be a viable option ? or would it have a bad impact on site perf ?

                      Comment


                      • #12
                        What OPCode cache are you using? Are you using an external system like Cloudflare or Varnish? How long does it take to update the last post information?

                        Deleting the cache tables will impact performance as they are rebuilt from page views. Depending on the traffic of your site, this may not be noticeable.
                        Translations provided by Google.

                        Wayne Luke
                        The Rabid Badger - a vBulletin Cloud demonstration site.
                        vBulletin 5 API

                        Comment


                        • #13
                          I am not using any external caching system or OPcache (as far as i know).
                          Well i would say it take 2 or 3 days to go wrong again and it usually goes back to normal in less than 24hours, but goes wrong again on random topics.

                          I have around 9000 page views per day, and the server seems pretty idle so i don't think the load would be an issue, i saw big and got a 12CPU / 24 Go RAM VPS .

                          Comment

                          Related Topics

                          Collapse

                          Working...
                          X