Stately

Barrett Manor

Julie Barrett is a freelance writer and photographer based in Plano, TX.

Blog Housekeeping

Fresh (almost) daily from Julie Barrett




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

Tags: Technology   Life

Filed under: Techology   Life         
11/3/2014 4:06:02 PM
C'mon, leave a comment. Make with the clicking, already!
Comments so far: 0 |
Permalink





Search the Journal:

  

Search Tags:




Events and Appearances:
SoonerCon 27
6/7/2019  - 6/9/2019
________
SoonerCon 27
6/7/2019  - 6/9/2019
________
FenCon XVI
9/20/2019  - 9/22/2019
________
All