Post content cache

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • manixless
    New Member
    • Aug 2014
    • 18
    • 5.0.X

    Post content cache

    Hello team,

    At first apologies for opening to many threats regarding these kind of problem, hope this be temporary. Well, I have migrated the forum from other forum application. Everything works fine, but I these forum had its own quote bbc code. So, I created a php using regex replacing old bbc code with the new one according to vbulletin compliance. This task also work correctly because I have confirm it via mysql.
    The problem
    Just a few posts reflect the changes via browser. Looks like there are some cache that keeps showing post with old bbc quote. Repeat, these posts has has been updated correctly because of post tuple in db's post table is already updated.

    What have I done?
    1. Clearing the system cache form Maintenance area.
    2. Truncate the table postparsed

    How can I force the forum to load/refresh the posts from db?
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    Can you show us an example of the before, and the after, and a picture of what it looks like now?

    Comment

    • manixless
      New Member
      • Aug 2014
      • 18
      • 5.0.X

      #3
      Sure. Let me show step by step each involved element.

      1. Post data in database
      At image below, you can see the quote bbc code in the first lines of pagetext value.

      Click image for larger version

Name:	post-db.png
Views:	57
Size:	126.8 KB
ID:	4129456



      2. Post in web browser

      Could you see the difference from post in db? This post showed below is the original content from the previous forum system. After had completed the migration process I ran a small script that replace the old quotes by the news ones (as first picture data). However, visually the post stills being the same and it should not!

      Click image for larger version

Name:	post-web.png
Views:	58
Size:	38.2 KB
ID:	4129457

      Attached Files
      Last edited by manixless; Mon 25 Aug '14, 10:17am.

      Comment

      • manixless
        New Member
        • Aug 2014
        • 18
        • 5.0.X

        #4
        Hello,

        is there any update on this case? Thank you.


        Update:
        Why the images in previous post were deleted?

        Last edited by manixless; Mon 25 Aug '14, 9:30am.

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          How did you attach them? Did you insert them into the post properly?

          Comment

          • manixless
            New Member
            • Aug 2014
            • 18
            • 5.0.X

            #6
            Originally posted by Zachery
            How did you attach them? Did you insert them into the post properly?
            Yes, last friday the attachement links were working. Now, I have noted that my attachments were deleted from my account. God! I will re-upload again. Please see the edited post. Above.

            Comment

            • manixless
              New Member
              • Aug 2014
              • 18
              • 5.0.X

              #7
              Originally posted by manixless
              Hello team,

              At first apologies for opening to many threats regarding these kind of problem, hope this be temporary. Well, I have migrated the forum from other forum application. Everything works fine, but I these forum had its own quote bbc code. So, I created a php using regex replacing old bbc code with the new one according to vbulletin compliance. This task also work correctly because I have confirm it via mysql.
              The problem
              Just a few posts reflect the changes via browser. Looks like there are some cache that keeps showing post with old bbc quote. Repeat, these posts has has been updated correctly because of post tuple in db's post table is already updated.

              What have I done?
              1. Clearing the system cache form Maintenance area.
              2. Truncate the table postparsed

              How can I force the forum to load/refresh the posts from db?


              Hello? Any update on this case?

              Comment

              • Zachery
                Former vBulletin Support
                • Jul 2002
                • 59097

                #8
                You updated the wrong table. The data in the post table is from vBulletin 3/4, and not used in 5. You need to update the text table.

                Comment

                • manixless
                  New Member
                  • Aug 2014
                  • 18
                  • 5.0.X

                  #9
                  Originally posted by Zachery
                  You updated the wrong table. The data in the post table is from vBulletin 3/4, and not used in 5. You need to update the text table.
                  Cool, you were right. Thank you so much for your help!

                  Comment

                  • Zachery
                    Former vBulletin Support
                    • Jul 2002
                    • 59097

                    #10
                    Not a problem, I didn't notice you were in the vB5 forum to start with, or I would have pointed that out first.

                    Comment

                    Related Topics

                    Collapse

                    Working...