phord

It is interesting that’s always the wp_comments table that gets corrupted. Maybe it’s the most added-to table what with all the spammers. I saw a suggestion that this sort of corruption usually occurs because of an out-of-disk-space condition. This is probably what caused it for me recently.

Interesting: if you google for “Can’t open file: wp_comments.MYD”, the top item is this page. The other 11,000+ items are links to broken WordPress installations.

Man! It happened to me too. I wonder why it hits wp_comments? Possibly related to comment spammers abusing the scripts, but this likely points to a WP-bug.

FWIW – “404 OK” is fine. The text after the code is just for humans. The 404 is the only part a machine should be trying to interpret.

Be careful with XAMPP as it does have NO security to speak of, by default. If your PC is connected to the internet, so is your “private” blog.

I don’t think a web server is *that* much less secure than your PC. Your web server may be more vulnerable than mine, but I have a dedicated server that I control everything on, and no one else has root access.

Here’s what I did for my private journal:
1. Add Basic Auth security for apache to .htaccess:
AuthName “journal”
AuthType Basic
AuthUserFile authusers
require valid-user

2. Create a password for authusers:
htpasswd -c /etc/httpd/authusers myloginname

3. Turned off pinging in WordPress

4. Added a robots.txt to prevent accidental Google caching:
User-agent: *
Disallow: /

5. Make sure phpMyAdmin or similar tools are also locked down (general security practice).

Things I should also do:
Add a cache expiry to WordPress so nothing gets cached locally (on my PC).

Disclaimer: Your mileage may vary. I do not warrant these steps to secure your blog. If a divorce or other financial action is hanging on your thoughts, keep them in your head; don’t write them down. Everything you type is subject to disclosure. Everything you write is subject to disclosure. If you don’t want your grandma to read your words to the police (or vice versa), don’t write them down. Pretend I never wrote this. In fact, I wish I could unwrite it. Caveat emptor.

Removing $more worked for me. I didn’t think it did at first, but I just had some mail delays. Thanks for the tip, and good luck to the rest of you.

The adsense button is added to the edit page with a Javascript function. You may have javascript disabled or you might have an overzealous popup blocker that’s blocking it. (But if javascript is disabled, I think many of the other buttons wouldn’t work… so…?)

Add this code to your wp-admin/quicktags.js file in the same area where you find the other edButtons entries (around line 24):


edButtons[edButtons.length] =
new edButton('Adsense'
,'Adsense'
,'<!--adsense-->'
,''
,''
);


Sorry I haven’t been keeping up with the comments on the blog. I’ve discovered comment notification is broken (!!) and am working on fixing it now.

Adsense inline with WordPress blog posts.

It won’t do the alignment stuff for you, but it will let you drop Adsense inline with your post. Alignment could be handled by adding div or span tags with the right alignment attributes, I think.

On a related note, I have written an Adsense plugin here: Adsense inline with WordPress blog posts. This plugin could be modified to work with non-adsense stuff, but I developed it to let me click an Adsense Quicktag button to insert an Adsense ad block in the middle of a post. It’s not what was asked for here (main page adsense tricks) but when I looked for this plugin, this was the only active thread I could find.

Anyway, I hope it helps someone.

Chris? Is that you?

Strange coincidence… I just wrote a plugin to do this for a friend yesterday. Seems to work a treat. Give it a shot and lemme know how it does for you.