Why my wp_posts data is so huge?

No, that isn’t normal for 23 posts. Note that “posts” is pretty wide concept in modern WordPress. Many things are posts without being obvious as such, for example parts of navigation menus. While 60k entries does sound excessive for a small site, there is no telling without examining actual data to determine which post types … Read more

Browsing Revisions in Custom Post Types takes me Empty Post Listing

This had to do with the user not having the CPT capabilities access set up properly. I was setting custom capabilities as such: ‘capabilities’ => array( ‘publish_posts’ => ‘publish_’ .$this->type, ‘edit_posts’ => ‘edit_’ .$this->type, ‘edit_others_posts’ => ‘edit_others_’ .$this->type, ‘edit_published_posts’ => ‘edit_published_’ .$this->type, ‘delete_posts’ => ‘delete_’ .$this->type, ‘delete_others_posts’ => ‘delete_others_’ .$this->type, ‘read_private_posts’ => ‘read_private_’ .$this->type, ‘edit_post’ … Read more

Display post changelog in post

There are many ways to do it, without third party plugins: Shortcode Cons: shortcode has to be created, and added to all posts. Child theme template Cons: theme dependent, and right template has to be modified. Child theme functions.php Cons: theme dependent. Plugin in mu-plugins Cons: none. Pros: not theme dependent, easiest to implement. Implementation … Read more

What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?

You can also do it this way – plugin free. Open phpmyadmin, browse over to your wp_posts table and: SELECT * FROM `wp_posts` WHERE post_type=”revision”; to see all the posts, their types and revisions and delete from `wp_posts` WHERE post_type=”revision” Though afraid at first…I did it. And it worked without any impact to the site.

How can I make revisions more extensive?

Looking at the second screenshot, it seems like the question and answer fields are generated by the Advanced Custom Fields (ACF) Plugin with Repeater add-on. The symptom that only the item number is tracked, but not the item contents, reinforces this assumption. The ACF Plugin can either be installed as a plugin, but I think … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)