WordPress: Comments are closed (???)

My wife has a blog as well. And she’s get comments on hers (not jealous, not me *sigh*).

Problem was all her post said “Comments closed”. It couldn’t be solved with setting any “Discussion” settings, turning off all plugins. Nothing helped. So she called the resident geek.

After some searching, head-scratching and a lot of speed-reading on a Google-search. I found this topic on WordPress Support.

For me the gems here a bit down the page. A few SQL’s to change comment status.

I’m dumping the here so I don’t forget them:

  • Globally enable comments for all users:
    UPDATE wp_posts SET comment_status = ‘open’;
  • Globally disable comments for all users:
    UPDATE wp_posts SET comment_status = ‘closed’;
  • Globally enable comments for registered users only:
    UPDATE wp_posts SET comment_status = ‘registered_only’;
  • Globally enable pingbacks/trackbacks for all users:
    UPDATE wp_posts SET ping_status = ‘open’;
  • Globally disable pingbacks/trackbacks for all users:
    UPDATE wp_posts SET ping_status = ‘closed’;

Hope you find them useful as well.

Posted in Software development | Leave a comment

Site open for comments

I thought I was being clever…

I had added a plugin to WordPress – that should allow people to use their logins from other socials sites to login for commenting. But, but, but … when testing it wasn’t clear that this was possible.

So I’ve removed the plugin as well as the requirement to login to leave a comment.

Comments still need approval and Askimet is active as well.

Posted in Uncategorized | Leave a comment

Oracle JDeveloper 11.1.2 or 11.1.1.6

In Sten Vesterli’s post the question the question of whether one should go for JDev 11.1.2 or JDev 11.1.1.6 (lastest R1).

Chris Muir answers this in the comments: 11.1.2 is for JSF 2.0 only. In 11.1.2 the bug-fixes will be back-ported from 11.1.1.6 as this is the version Oracle is using for their Fusion Applications development effort.
Continue reading

Posted in Software development | Tagged , | Leave a comment

Oracle database: schema versioning

When working on a project where the data model isn’t completely stable, you want to be able to run scripts changing one or more database schemas. But how do you make sure that all updates run successfully. And how do you avoid running the same update script twice one a schema.

One a project some years back I had the opportunity to work out a way to handle this.
Continue reading

Posted in Software development | Tagged , | Leave a comment

Installing git on Oracle Linux 5 (or install git from source)

In this post I’ll tell you how to install git onto Oracle Linux. It’s a standard install from source. But since I always have to lookup how this is done – I’ll drop it here for future reference.

For those of you who don’t like installs from source: don’t worry – it’s easy.

edit: I’ve found an easier way. Described here
Continue reading

Posted in Software development | Tagged , | 9 Comments