Annette's Acre

Stitching, knitting, reading, life…whatever catches my eye
August 6th, 2007 by Annette

Administrivia

More on Comments:

At this time I plan to leave only the latest post open for commenting 🙂  You would be absolutely amazed at the number of spam comments left on old posts (we’re talking *thousands*).  I’m also requesting “first approval” for new commenters.  Once I approve your first comment, you’re free to comment to your heart’s content an any subsequent post, but in the interest of cutting down on spam…..well, I’m sure you all understand, right?

Thanks all for the advice on rescuing my history!  The challenge I have is not with the database itself (I poke around in data warehouses all day with SQL) but with *connecting* to the thing on my webspace.  If I could figure how to get into the tables, I’d just truncate the blasted comments and be done with it! 

And for some blatant blog fodder stolen from Terri:

You get to answer with one word. (feel free to snag)

  1. Where is your Cellphone? – pocket
  2. Relationship? – married
  3. Your Hair? – grey
  4. Work? – demanding
  5. Your sister? – In-law
  6. Your favorite thing? – palms
  7. Your dream last night? – forgettable
  8. Your favorite drink? – Coke
  9. Your dream car? – Jaguar
  10. The room you’re in? – office
  11. Your shoes? – comfy
  12. Your fears? – loss
  13. What do you want to be in 10 years? – vacationing
  14. Who did you hang out with this weekend? – family
  15. What are you not good at? – waiting
  16. Muffin? – english
  17. One of your wish list items? – yarn
  18. Where you grew up? – Michigan
  19. Last thing you did? – email
  20. What are you wearing? – casual
  21. What aren’t you wearing? – shoes
  22. Your pet? – dogs
  23. Your computer? – Mac
  24. Your life? – busy
  25. Your mood? – quiet
  26. Missing? – daughter
  27. What are you thinking about right now? – relaxing
  28. Your car? – Jeep
  29. Your kitchen? – unused
  30. Your summer? – hot
  31. Your favorite color? – red
  32. Last time you laughed? – today
  33. Last time you cried? – yesterday
  34. School? – no!
  35. Love? – surrounded

Comments

2 Responses to “Administrivia”
  1. Me again 🙂 (With a dicky spacebar, so please excuse if there are any runtogether words here).

    Firstly… if you don’t already, make sure to get a Spam plugin. I use Spam Karma, Akismet is the other big WordPress one. I have only had one false positive with Spam Karma, but then it sounds like you get much more spam than me – you can tinker with the thresholds and whatever to get it working for you.

    Also, even though I don’t like them, you can consider a ‘captcha’ type arrangement. I’ve seen some that are better than others – add two numbers together and type the answer, for example. Hate those image ones, I inevitably get them wrong!

    Lastly… I’d be really surprised if your web host doesn’t have mysqladmin – the GUI for accessing your database. I had to get into mine to drop some tables the other night. Have you emailed them to see if they can help?

    Sorry if I’m still misunderstanding the problem. Email me if you need to.

    Of course, the other alternative is to forget self-hosted and go with a WordPress.com freebie – they take care of the plugins then, and the community feeling is a nice extra. I have an account there but still dithering about putting my blog there.

  2. Akismet has caught 13,548 spam comments for me so far. And I moderate anything with a link, too. Of course, your database problem is waaaaaay out of my league. 😉 Hope you can access things eventually!