Solve a “Submit For Review” issue on WordPress

Lately, I couldn’t publish any more articles on my WordPress instance. Instead of the “Publish” button, I only got “Submit For Review”. As I upgraded WordPress recently, I thought this might be either a new feature or some permissions that were dropped ; but I just couldn’t find any.

After a few dig&read on the Internet, most of this behavior seemed to reveal a problem with the database. And I recently had a few bunch of crashes on the infrastructure ; thanks to my electric power provider…

Continue reading “Solve a “Submit For Review” issue on WordPress”

Add a Table of Contents in WordPress articles

I use to have TOCs in articles when this site ran DokuWiki. But by default, WP doesn’t provide this ability. After a few Googling, I found the Table of Contents Plus plugin.

I choose this one for two main reasons:

  • it can automatically insert a TOC in WP since “X or more headings are present” ;
  • it has various looks embedded to match your theme.

You can have a look at a rendered example here.

Hope it helps.

Manually change WordPress’ home and siteurl in MySQL

In my tidy process, I had to copy WordPress from one host to another, then access it from various URLs so that the production and the development versions were both accessible from the same public IP. To duplicate the data in a fast manner, I dumped the SQL data and tarred the WWW directory. The problem is that WordPress’ home and siteurl are kept the same between those instances. And since you try to access the administration zone, you’re redirected to the original location… To modify the duplicated instance, you can configure WordPress straight from MySQL.

Here are the directions:
Continue reading “Manually change WordPress’ home and siteurl in MySQL”