Maria’s Guides

Information from Software Update.

This update supports compatibility with Mac OS X 10.5, improves overall stability, and addresses a number of other minor issues.

Information from Software Update.

The 10.5.1 Update is recommended for all users running Mac OS X Leopard and includes general operating system fixes that enhance the stability, compatibility and security of your Mac.

For detailed information on this update, visit http://docs.info.apple.com/article.html?artnum=306907.
For detailed information on security updates, visit http://docs.info.apple.com/article.html?artnum=61798.

Marking it as spam isn’t enough to get rid of it.

One of the things I like about WordPress is that it’s impossible to know everything about it. And today I learned something new.

I learned that the spam comments that I marked as spam had not been deleted from my WordPress database. They were just marked as spam so they wouldn’t appear in posts.

How did I discover this? I had to export all blog posts from An Eclectic Mind to a special WordPress-compatible XML file that contained all blog posts and comments. I had to weed out all the posts and comments I didn’t want to import into my new Maria’s Guides site. And that’s when I found all the nasty spam I’d marked for the past 4 years.

Now don’t think this was all of the spam. It was only the spam that was marked as spam using WordPress’s comment moderation feature. When the comment spam situation got out of control, I enlisted the help of the Bad Behavior and Spam Karma 2 plugins. Bad Behavior prevents potential spambots from posting comments at all. Spam Karma catches 95% of the spam that gets past Bad Behavior. I’m left with less than 10 spam comments a day. Not bad when you consider that Bad Behavior alone caught 17,067 spam attempts in the past seven days. The way I see it, anyone with a relatively well-Googled blog who doesn’t use at least one of these tools is doing a lot more comment moderation than they need to.

So there I was, halfway through the process of deleting non-book-related posts and their comments from an XML file, when I realized that much of the file’s contents was spam that wouldn’t appear when I imported it anyway. And that’s when I started thinking about how much database space was devoted to this spam.

The DB-Manager Plugin

I use Lester ‘GaMerZ’ Chan’s DB-Manager plugin. This plugin puts MySQL database features into the WordPress administration panel. This is a must-use for anyone who needs to get into their database and learn more about it or make changes to it.

So I went into the plugin’s interface and learned that my blog had 1900+ comments. I knew that only 1400+ comments were actually appearing in the blog. That made 500+ spam entries sitting in my database, taking up disk space and making my backups much larger than they needed to be.

(Note: The screenshot here shows the database contents after removing the spam. If I’d known I was going to write about it here, I would have taken more screenshots.)

I wanted them out.

Help on the WordPress Forums

I found help on the WordPress forums. They really can be helpful if you enter the right search phrase.

The topic was Support › deleting over 10,000 spam comments without using moderation page. The story was, this poor soul had left his blog alone for a week and, when he returned, found 10,000 comments on it. He wanted to delete them.

A member named bindanaku came to his rescue with a MySQL query:

DELETE FROM wp_comments WHERE comment_approved='0'

This assumes that you want to delete all comments that haven’t been moderated. This was not the case for me. I wanted to delete all comments that had been moderated as spam. I assumed that the correct query for my situation would be:

DELETE FROM wp_comments WHERE comment_approved='spam'

I was right.

Back to DB-Manager

I went to the DB-Manager administration panel and clicked the Run SQL Query button. That gave me a window where I could enter my query, as shown here. When I clicked Run, I got a message that the query was successful.

Sure enough, when I checked the Database info (see previous screenshot), I could see that 500+ comments had been removed from the database. But the table size was the same.

I used DB-Manager’s Optimize DB feature to optimize the database. That dropped about 400K from the table size.

I should note here that if you’re more familiar with editing a MySQL database, you can do the query with your normal editing tool. I don’t mess with my MySQL database much. I’m always afraid of screwing it up. (Call me a wimp — I don’t care.) That’s why I use DB-Manager.

Conclusion

While all this might seem like a lot of work to get rid of 400K of file size, the situation could be worse on your blog. My blog has about 1500 posts spanning about four years. I’ve been using Bad Behavior and Spam Karma for at least two of those years. So the majority of these old spams were from very old posts. If you don’t use any spam protection software and are manually moderating comments, you could have far more of these spam comments in your database. And since many of them were lengthy listings of porn and ringtone and other URLs, they were quite large in size. If you have a lot of these in your database, it could be taking up a lot of space — perhaps even more than your actual blog posts.

Do I recommend going through this process? It’s up to you.

• Essential OS X DonationWare (my list so far)
  Good list with links for free/donation software for Mac OS users. On Arteliance.
  (tags: software free donation MacOS)

I try an experiment to see if I can stay productive without Microsoft Word.

Last week, in an effort to get my old 12″ PowerBook to run more efficiently, I decided to wipe the hard disk clean and reinstall Tiger with a clean install. After installing it, I got a little crazy and decided to upgrade to Leopard. So far, the machine works fine.

The computer does have a problem, however. Its aged and well-used CD-R/DVD drive has decided to be a bit picky about which CDs and DVDs it recognizes. It liked the Tiger and Leopard install discs, which are both DVDs. But it didn’t seem to like the Office 2004 disc, which is a CD.

(A real Apple fangirl might point out here that the computer has taste. But I wouldn’t dream of making such a statement.)

It’s a Bother

I can get Microsoft Office on the computer by other means. I can insert the disc in another computer and have the PowerBook access the CD via my AirPort network. Or I can create a disk image of the CD, transfer that to the PowerBook over the network, and install from that. Or I can put a disk image of the CD on an 80GB Firewire drive I have sitting around and attach that drive to the PowerBook to install. Any of these methods should work.

Or, if I want to get really radical, I can install the beta of Office 2008 on the PowerBook and let it become my official testing machine.

But let’s face it: it’s a bother. And this morning I began asking myself if it was worth it.

The PowerBook is in semi-retirement these days. It spends much of its time in my kitchen, where I use it to create my morning blog entry. I sometimes use it to look up something on the Internet when I’m doing things around the house. And, of course, I take it traveling with me, primarily because it’s relatively small and lightweight and old enough that I don’t have to feel too bad if it breaks.

But the real question is: Do I need Microsoft Office on it?

An Alternative to Word

I definitely need a Word processor. I’m a writer and I use the computer to write. (I use most of my computers to write.)

But Mac OS X comes with a perfectly good word processor: TextEdit.

Don’t laugh until you’ve tried it. The version of TextEdit that comes with Mac OS X 10.5 Leopard is a kick-butt little word processor. It supports all kinds of formatting, including basic text formatting, tabs, indentation, lists, and even named styles. It has built-in spelling check that can check spelling as you type and supports hyphenation. It can open and read all Word formats — including Word 2007 for Windows with its new file format (which Word 2004 for Mac can’t even do) — and can save to Word formats, Rich Text Format (RTF), and plain text format. That makes it possible to use TextEdit, even when the people you are sharing files with are using Word.

Clearly, this ain’t your father’s SimpleText.

Okay, so it doesn’t support cell tables and Word fields and its support for inserted graphics is rather limited. And there are some Word formatting options that TextEdit might simply choke on.

But do I really need all those Word features? Isn’t the ability to enter and edit text and apply simple text formatting what word processing is all about?

Do We Need All those Bells and Whistles?

And that brings up a point that’s been nagging at me for years — since Microsoft Office 6 for Macintosh came out, in fact.

My first Word book was the Macintosh Bible Guide to Word 6. The Macintosh Bible series of books was a short-lived seris of big fat books about specific software packages. I did one for Word, then did another for Excel.

I clearly remember installing and using the beta of Word 6. My first impression was: this sucks. Microsoft had decided to pack in a lot of new features. And, if I recall correctly, Microsoft had also decided not to use Apple’s built-in routines for drawing windows and dialogs. Instead, they decided to write their own routines to draw their own windows and dialogs. So not only did the computer have to deal with all the programming stuff for word processor operations, but it had to deal with all the extra Microsoft-brand programming for the interface — the same kind of programming that made early versions of Windows so sluggish to DOS fans.

The feature bloat and poor performance of Word 6 — at least in the beta stage; they managed to fix it up a bit for the release version — got me thinking about the features that should be in a word processor. Clearly, Microsoft had gone over the top. (And it continued to do so for most subsequent releases, although I do recall Office 2001 being a very good version.)

Today’s TextEdit is not too far off from Microsoft Word 4, which is the first version of Word I used (back in 1989). And frankly, it did everything I needed it to do to prepare my manuscripts.

And if you’re a Windows user reading this, you have WordPad (I think that’s what it’s called), don’t you? I’m pretty sure that these days that is Word 4.

Compatibility Issues

Today, things are different. Although I write all my Peachpit Press books in InDesign, Adobe’s page layout program, I still write each year’s edition of my Quicken for Windows book in Microsoft Word. My editors make extensive use of Word’s revisions feature, with each of them (and me) marking up the manuscript so it’s nearly impossible to read. I need to use Word to share files with these editors. There’s no way around it.

But that doesn’t mean that I need it on my little PowerBook. And it also doesn’t mean that you need it.

Other Alternatives for Mac Users

And then there’s the iWork suite of products. With the addition of Numbers, a good alternative to Excel, Mac users now have all the pieces they need to replace Office on their Macs. I have iWork around here somewhere, but I haven’t had time to experiment with it. I’d love to get feedback from users; use the Comments link or form below to share your thoughts.

Back to My Original Question

Do I need Microsoft Office on my semi-retired PowerBook?

At this point, I think the answer is no. Let’s see how long I can last without it.

• Peachpit: Peachpit Announces New Line of Mac OS X 10.5 Leopard Books
  Press release from Peachpit Press announcing its line of Leopard books. Guess who made the top of the list?
  (tags: leopard macos book peachpit)
• Are you ready for Leopard?
  Shopping for Leopard-related books? Start here.
  (tags: leopard macos peachpit book)