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?
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?
What counter are you referring to?
Zen-Venom Get Bitten
The counter in the admin section,,,showing:
Counter History for last 10 recorded days Session - Total
I would guess that your upgrade is not complete/coreect
Checked my upgraded demo install and it functions correctly
Zen-Venom Get Bitten
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..
What's your MySQL version? and PHP version
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.