Announcement

Collapse
No announcement yet.

Editing views

Collapse
X
 
  • 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?
    http://www.cramersmadmoney.com

  • #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.

    Comment


    • #3
      Yes I want to manally edit the counters but I am having trouble finding the field.
      http://www.cramersmadmoney.com

      Comment


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

        Comment


        • #5
          Thanks, I had fished around www.phpmyadmin.net 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, 11:52am.
          http://www.cramersmadmoney.com

          Comment

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