More Issues To Report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SpaceStar
    Senior Member
    • Apr 2005
    • 171

    More Issues To Report

    Hello

    I am afraid there are more issues to report from my side.

    When replying to a post or creating a new topics different errors are displayed. Posting is done nevertheless, needs to be out of the thread and go back in. New topics are not posted.

    Error are shown in pics below.

    Attached Files
  • SpaceStar
    Senior Member
    • Apr 2005
    • 171

    #2
    another error
    Attached Files

    Comment

    • SpaceStar
      Senior Member
      • Apr 2005
      • 171

      #3
      I would also like to mention that I have observed that my database is growing rapidly - it is almost 24GB!! Following are the biggest tables, I wan't to know if this is normal or there is something ODD with my database??

      Attached Files

      Comment

      • Mark.B
        vBulletin Support
        • Feb 2004
        • 24286
        • 6.0.X

        #4
        Can you please run these two queries?

        DELETE FROM cache
        DELETE FROM cacheevent

        NOTE: Do not run DELETE queries on ANY other table - you will break your site.
        MARK.B
        vBulletin Support
        ------------
        My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
        My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

        Comment

        • SpaceStar
          Senior Member
          • Apr 2005
          • 171

          #5
          Originally posted by Mark.B
          Can you please run these two queries?

          DELETE FROM cache
          DELETE FROM cacheevent

          NOTE: Do not run DELETE queries on ANY other table - you will break your site.

          Mark, I read another thread here and used this suggestion from Wayne to truncate these two tables. I did it yesterday but for my surprise they have grown to almost same size inside 1 day!!! Most of the errors are started after that

          Comment

          • Mark.B
            vBulletin Support
            • Feb 2004
            • 24286
            • 6.0.X

            #6
            I would clear them again. They should clear of their accord but something is not right there.

            The first screenshot shows a 500 error which is a server error.....need to find out what that is. It should be in the server error logs.
            MARK.B
            vBulletin Support
            ------------
            My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
            My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

            Comment

            • SpaceStar
              Senior Member
              • Apr 2005
              • 171

              #7
              Yeah it helped Mark. I can post. But the cache and cachevent tables grow rapidly... why?

              This can't be true that I have to invalidate cache every single day???

              Comment

              • Mark.B
                vBulletin Support
                • Feb 2004
                • 24286
                • 6.0.X

                #8
                No it shouldn't be like that. I'm not sure why that is happening, I'll need to see if anyone else has any suggestions on that.

                I've seen sites where it needs manually emptying occasionally, but not every day.
                MARK.B
                vBulletin Support
                ------------
                My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                Comment

                • SpaceStar
                  Senior Member
                  • Apr 2005
                  • 171

                  #9
                  Thanks Mark

                  New topics can be posted. But it took almost over a minut to post a new topic with 2 simple lines in it - It just stood with message WORKING

                  Checked server log - couldn't see anything

                  Comment

                  • Mark.B
                    vBulletin Support
                    • Feb 2004
                    • 24286
                    • 6.0.X

                    #10
                    It seems to be working for me. I've been doing some queries and suchlike, you might have caught it when I was running one.

                    Your cache is filling up at a fairly mad rate.

                    I notice that you have what are probably search engine spiders spidering the site quite extensively. I suspect this might be the cause of the cache issues.

                    Would be worth adding a robots.txt file to slow down spiders.

                    Code:
                    User-agent: *
                    Crawl-delay: 60
                    MARK.B
                    vBulletin Support
                    ------------
                    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                    Comment

                    Related Topics

                    Collapse

                    Working...