Blog & News

Don’t make these stupid mistakes

ID-Ten-T Error
A term often used by tech support operators and computer experts to describe a problem that is due to the user’s ignorance instead of a software or hardware malfunction.

Here is a fun post where I will list out several dumb mistakes I have made with this site since starting it a few weeks ago.

1. Always Backup Your Data

I have been a windows users for probably the past 10 years. Basically since I started using a computer. At the beginning of this year I switched to my first Mac and I love using it however I keep really screwing up my sites when I perform upgrades. :( I have Transmit as the ftp client and when I upgrade I just put all the files and tell it to Replace all the files. This does not achieve the effect I want. Yes it replaces the files but also deletes all the files that are not getting overwritten. So basically I loose important files that would otherwise remain uploaded.

2. Never drop all your database tables

This one is pretty obvious but it caught me. :) While creating the install for 68kb I added this little portion of code to drop all the tables before installing.

$tables = $this->db->list_tables();
foreach($tables as $table)
{
    $sSQL="DROP TABLE IF EXISTS ".$table;
    $this->db->query($sSQL);
}

It seemed fine at the time because I was running on localhost and it didn’t matter if all the tables where removed. I uploaded this to the server and decided to install it in the same database as the site and guess what happened.

I am sure you guessed correct. Everything was gone! :(

The only plus side was Google had a few of the pages and posts cached so I could rebuild what they had.

Now that I have shared my stupid mistakes why don’t you share yours?

November 15, 2007  

0 comments

There are no comments yet...

Kick things off by filling out the form below.

Leave a Comment