Ever since upgrading to sparkle, I've had a couple of errors - anyone know how to solve these? Help! html is greek to me!
1. I get this error at the bottom of my blog homepge:
MySQL error!
Duplicate entry '1212405' 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(1156558460), '/', 'invalid', '', '', 1, '75.21.213.255', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)')
2. My RSS feeds stopped working with this error:
<div class="error"><p class="error">MySQL error!</p><p>Duplicate entry '1212405' for key 1(Errno=1062)</p><p class="error">Your query:<br /><code>INSERT INTO evo_hitlog( visitTime, visitURL, hit_ignore, referingURL, baseDomain,
3. My stats stopped updating on the day I upgraded (8/01/2006).
any ideas?
okay, sorry for clogging everyone's attention. if I just knew how to search, I would have found:
http://forums.b2evolution.net/viewtopic.php?t=7695&highlight=1062
essentially, I just repaired my 2 SQL databases and it pretty much cleared up all three problems. my historical stats from before are wiped clean, but everything is working again.