Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / Hit counter issue after upgrade

Hit counter issue after upgrade

Views: 873

Results 1 to 6 of 6
25 May 2011, 11:17 PM
#1
eaperformanceparts avatar

eaperformanceparts

Zen Follower

Join Date:
Jun 2009
Posts:
100
Plugin Contributions:
0

Hit counter issue after upgrade

I upgraded from 1.3.8 to 1.3.9 and now my hit counter for the last 10 days shows the same date and hits. It has been close to a month since the change. Any way to get the counter to show the recorded last 10 days and not just the current day?

25 May 2011, 11:23 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Hit counter issue after upgrade

What counter are you referring to?

25 May 2011, 11:55 PM
#3
eaperformanceparts avatar

eaperformanceparts

Zen Follower

Join Date:
Jun 2009
Posts:
100
Plugin Contributions:
0

Re: Hit counter issue after upgrade

The counter in the admin section,,,showing:

Counter History for last 10 recorded days Session - Total

26 May 2011, 12:02 AM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Hit counter issue after upgrade

I would guess that your upgrade is not complete/coreect

Checked my upgraded demo install and it functions correctly

19 Jul 2011, 12:33 PM
#5
gertzy avatar

gertzy

New Zenner

Join Date:
Feb 2010
Posts:
40
Plugin Contributions:
0

Re: Hit counter issue after upgrade

I can give some extra info for this error... I had the same upgrading from 1.3.7 to 1.3.9.... last 10 dates were all today and same numbers...

I looked into the SQL table (in PHPMySQL )called 'counter_history'... It showed over 100 entries with a date for each day over the past 10 days since I have done the upgrade....

Clearly it should not have duplicates and I could see the none of the 3 fields was indexed... I tried to index the field, but obviously would not let me because there were already some fields in the database with duplicate entries... I went through the table and removed all them duplicates manually.. Then I placed a primary index on the 'startdate' field... Went and did some test on the site... and now it works...

It seems that when there was no primary index on the startdate field, if a visitor visited the site, instead of increasing the numbers for todays date, it was adding extra rows of data... When the primary index was added, that CANNOT happen any more and therefore increses the existing number by 1...

I dunno, but was the previous versions not indexed, and, did the upgrade fail to index the field because of the already duplicated data..?? I dunno, but, I know how I fixed it..

19 Jul 2011, 5:35 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Hit counter issue after upgrade

What's your MySQL version? and PHP version