No announcement yet.

Editing views

  • Filter
  • Time
  • Show
Clear All
new posts

  • Editing views

    I lost data for the last 7 days and trying to reconstuct. I have threads that had 2000 views now showing the new lower number since I replaced them and I would like to restore the higher previous and correct number - I can't figure out where in the database this is. Is there an easy way to do this?

  • #2
    What happened exactly? Did you restore a 7 day old backup? In that case it would be normal for the view counters to revert to their counts from 7 days ago. There is no way to get the newer counts back unless you restore a more recent backup.

    You can manually edit the view counters for threads by querying the thread.views field in the database.


    • #3
      Yes I want to manally edit the counters but I am having trouble finding the field.


      • #4
        Use a program like That makes it easy.


        • #5
          Thanks, I had fished around without success before but I finally found the field involved.

          By the way, i am only editing the views on closed threads so the edited higher number is accurate. I am leaving the numbers alone on open threads because they are accurate for the posts that are showing.
          Last edited by Thierry Martin; Sun 14 Jan '07, 12:52pm.


          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.