Customer history for last 10 days error

**rdsbaker** · 5 Sep 2010, 01:52 AM

After upgrade to 1.3.9f, the history on the Admin page will show data from today on all 10 days. Each date will show todays data. Not a biggie but I am annoyed a little that it is not right.

**DrByte** · 5 Sep 2010, 01:55 AM

PHP version?
MySQL version?
What process did you use to upgrade?
Any errors encountered in upgrade process?
Any warnings during the zc_install database-upgrade steps?

**rdsbaker** · 5 Sep 2010, 01:55 AM

actually, each date is todays date! Each of the 10 slots duplicate todays data

**rdsbaker** · 5 Sep 2010, 02:02 AM

SQL version is 5.1.47 community log
Php version is 5.2.13

Used Simple Scripts to upgrade

yes, had a few probs, but were actually easily solved with help from forum.

warning at upgrade was only that I had not re-named admin folder

**DrByte** · 5 Sep 2010, 02:10 AM

They (the automated upgrade tool you used) probably broke your counter-history table.
You'll likely have to dump it, losing all the data, and then recreate it again to catch new data correctly.

(We always recommend NOT using automated upgrade tools, since they typically break things badly.)

**rdsbaker** · 5 Sep 2010, 02:15 AM

Ok, what are the steps I need to take to accomplish this?

**rdsbaker** · 5 Sep 2010, 09:07 PM

Again, I ask.....how do I reset counter history?

**DrByte** · 5 Sep 2010, 10:41 PM

1. NEVER use an automated upgrade tool again.

2. Run this via phpMyAdmin:

Code:

DROP TABLE IF EXISTS counter_history;
CREATE TABLE counter_history (
  startdate char(8) default NULL,
  counter int(12) default NULL,
  session_counter int(12) default NULL,
  PRIMARY KEY  (startdate)
) ENGINE=MyISAM;

If your database is using some sort of table-prefix, insert that before "counter_history" in both places, before running it.

**Shara** · 12 Apr 2011, 08:46 PM

I just wanted to know if this fixed the problem? I have 3 stores that have been upgraded to 1.3.9f and they all have the same problem.

**joepixel** · 18 Apr 2011, 04:25 PM

I use Google Analytics for measuring visits, etc. Are there any ramifications if I simply comment out the require(DIR_WS_INCLUDES . 'counter.php'); line in the includes/application_top.php file?

This query is causing issues with locking the database each time it makes a query and is causing MySQL issues. I'm running a lot of other processes on the server and this may help speed things up.

Please let me know if commenting this line would affect anything else that I'm not aware of.

Thank you!