MySQL error!
Duplicate entry '2701' for key 1(Errno=1062)
Your query:
INSERT INTO evo_hitlog( visitTime, visitURL, hit_ignore, referingURL, baseDomain, hit_blog_ID, hit_remote_addr, hit_user_agent ) VALUES( FROM_UNIXTIME(1148935442), '/index.php?blog=7&c=1&page=1&more=1&title=daniel_island&tb=1&pb=1&disp=single', 'invalid', '', '', 7, '64.203.208.146', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.11) Gecko/20050728')
I have had this error for some time, it wasnt there when i first installed the blog. I think i was mucking around with some plugin and created this error for myself.
Does anybody know what i can do to alleviate this issue?
regards,
I think this has happened to people before and if I recall correctly a root cause has not been found. What I would do if I were you is (a) drink a lot and (b) empty the hitlog table. That way your hitlog will start from 1 all over again. If that is an unacceptable answer (due perhaps to actually wanting the stats data for some reason) then you might want to browse your hitlog table via phpmyadmin or some such in that area and see if you can figure out why it claims a duplicate entry is happening.