Clearing System Cache - which tables?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • TwinsForMe
    Senior Member
    • Oct 2004
    • 130
    • 4.0.0

    Clearing System Cache - which tables?

    Our discussion forum has ground to a halt due to the "Last Post" column not updating in real time but by being cached. Our solution is to manually clear the system cache via the admincp but to continue doing this is absurd.

    Two questions, please:

    #1 - Is there a way for the Last Post column to be updated in real time?

    #2 - If Question #1 is not possible, I'll have to set up a cron job to truncate the cache tables every 5 minutes or so. Besides the cache and the cacheevent tables in the database, are there any others that need to be truncated?

  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    1. No, there is not a default option to do that.

    2. It is just the cache and cacheevent tables that need to be truncated.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

    • TwinsForMe
      Senior Member
      • Oct 2004
      • 130
      • 4.0.0

      #3
      Thanks for the reply.

      Comment

      • chriske
        Senior Member
        • Oct 2008
        • 466
        • 5.6.3

        #4
        I want to make a cronjob removing the cache every day: I inderstand how to maken one @ Add New Scheduled Task.
        But what goes in the php file?
        Please vote for:
        - Lightbox for all uploads
        - Attachment permissions for unregistered users

        Comment

        • Trevor Hannant
          vBulletin Support
          • Aug 2002
          • 24325
          • 5.7.X

          #5
          I'd suggest checking the current files in /core/includes/cron as these are the ones that run by the default scheduled tasks.

          If you need any further help creating your own, please post on our customisation site, www.vbulletin.org
          Vote for:

          - Admin Settable Paid Subscription Reminder Timeframe (vB6)
          - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

          Comment

          Related Topics

          Collapse

          Working...