Customer history for last 10 days error

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.:ohmy:

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?

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

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

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.)

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

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

1. NEVER use an automated upgrade tool again.

2. Run this via phpMyAdmin:```
   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;

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.

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!

In case anyone wants to know. I removed all the SQL queries in the includes/counter.php file and left only the Illegal Access lines (3). This has cause no issues with the cart or any functionality. The reason I did this is because I have a lot of processes running on the server. The counter.php file is loaded each time a page is hit. Each SQL query locks the database until finished. If you have a lot of processes, these queries can get in the way and slow things down. The counter.php file is not needed if you're using something like Google Analytics.