Republicizing a Jetpack post

If you find you need to republicize a blog post through Jetpack which for some reason couldn’t be sent the first time it was published, you can quickly fix it with some database tweaking.

First of all, you need to know the id of the post. Edit the post through the admin section, and the post id will be a number in the url bar, after “post=”. Next you set the status of the post to Draft, and update the post. This will make it disappear from the site for a second.

Now you need to goin database diving. With the post id at hand, you need to run a query like the below, raplceing the post_id with the one you found eariler.

MariaDB [database]> select * from wp_postmeta where post_id=144 and meta_key="_wpas_done_all";
| meta_id | post_id | meta_key                | meta_value   |
|     293 |     144 | _wpas_done_all          | 1            |
1 row in set (0.00 sec)

The next phase is to update the the value so that it reads a zero instead of 1, which will then allow you to republish the page. The mysql for this is as follows, only this time you have to set the correct meta_id to the one listed in the output you received. In my case, this is 293.

MariaDB [database]> update wp_postmeta set meta_value=0 where meta_id=293;

Finally, head back to the post editing page and publish the page again.