Fresh when it gets here from
Julie Barrett
Monday, November 3, 2014
Big first aid on the web site today. I'd been noticing some craziness in my links and some other database-driven items, but I'd chalked it up to some bad SQL code. Today I thought I'd take ten minutes to dig into things and discovered that almost every single database table had all the data duplicated - sometimes twice. Removing the data wasn't difficult except for the Journal, where I had over 3,000 duplicates in the table.
I think it happened when I tried a backup last April. To make matters worse, many of the duplicate entries in the Journal table were corrupt and I couldn't know they were corrupt until I tried to delete them. So, yeah. Lotsa fun.
Let me know if you see any problems.
I also went in and cleaned up the links on the journal. Lost a day of work, but this needed to be done.
Now it's time to go forage for something for dinner...