[Done v1.3.9a] Duplicate Counter History for last 10 recorded days Session - Total

[bonarhya]

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8 [2008-04-18 19:58:08] (Fresh Installation)

I logged in to my admin area today 14 March 2009 and noticed that the "Counter History for last 10 recorded days Session - Total" section was showing the same record twice (the current days totals) ans when I opened the actual site to increase the counter both of the entries changed, so they are both live just duplicating. This is the first time it has done this.

No work has been done on the site for about 5 months and all has been working perfectly normal.

The site has been up and running since May 2008.

[Ajeh]

Check your table counter_history via phpMyAdmin ...

You should have 1 record per day in there ...

[bonarhya]

Hi
Thanks for the reply.

I had a look at the counter_history using phpmyadmin and to be honest I didn't really have a clue what I was looking at.

I have attached a Screen Print of the problem so you can see exactly what I am trying to describe.

Thank you for your help.

[Ajeh]

Did you recently do something to alter your date format?

[sword]

Similar thing here. I have 4 repetitions of the last, 7/28/2009, record in my counter history. Didn't play with ZenCart settings recently. The only thing I rutinely do is a manual update of currency exchenge rates.

Cheers!

[CarolineBogart]

I got a triplication of the lines. Changes were adding Google Base Feeder and coupons. CounterHistory has 3 entries for the triplicated date. The USA as a zone was added but I'm pretty sure that was after the records triplicated.

[Ajeh]

I have seen this a few times but have not been able to duplicate how it is happening ...

Other than cleaning the duplicates out of the database manually, I don't really have a solution to this at this time ...

[CJPinder]

The problem is caused by a race condition in includes/counter.php , in particular the logic for adding new daily records if a record does not already exist.

If the code is called twice at approximately the same time two records will be created. One trigger is Yahoo which will often launch multiple spiders on a site at exactly the same time. If this happens just after midnight you can end up with multiple counter records.

Regards,
Christian.

[jasmel]

... so is there a "fix" for this? During the past week I have two sets of duplicate "Counter History for last 10 recorded days".

Some sort of code to clean up the duplicate(s) if it was to happen by a multiple Yahoo spider or Googlebot?

[Iggy73]

Hey there everyone. I just ran into this issue today as well... and was wondering as the poster above me did if there was any more traction on this?

Thanks,
~Iggy

EDIT:
For anyone else that has this problem, I just wanted to say that deleting just one of the duplicate rows via phpMyAdmin was easy and took care of this "anomaly" for us.