Home > Programming > Solve the method with discontinuous ID of WordPress 2.6 log

Solve the method with discontinuous ID of WordPress 2.6 log

2008-09-08 00:00 williamlong Edit Leave a comment Go to comments

The WordPress 2.6 edition that has issued has very disgusting function, it is Post Revisions (the version of the article is controlled) , below acquiescent circumstance, the ID of the log will no longer successive, use ID will see the WordPress with a more and more confused address as the user of Permalink structure, I give an ID that solves WordPress discontinuous method now.

According to the method of this article, a Define('WP_POST_REVISIONS' increases in Wp-config.php file, false) , at the same time installation “ bans the plug-in unit ” that saves automatically with WordPress, this plug-in unit is enabled in WordPress tiring-room.

Notice these two operations are short of please one cannot, if do not enable “ to ban the plug-in unit ” that saves automatically with WordPress, so every text can appear a record that saves automatically.

Additional, for the WordPress user that has ” of “ clean addiction to the database, the likelihood wants to delete the rubbish information inside the watch that brings about as a result of Post Revisions, ID at the same time the setting is successive, the script of a paragraph of SQL that I write is below, use in Phpmyadmin please.

Deleting is information of Post Revisions rubbish, carry out please:

Delete From Wp_posts Where Post_type = 'revision';

ID new setting is successive, this is more troublesome, install an ID to be about 4 SQL statement, I cite a case merely, repair ID instead ID for the article of 59 for 58, need carries out the following statement.

Update Wp_posts Set Id = 58 Where Id = 59;Update Wp_term_relationships Set Object_id = 58 Where Object_id = 59;Update Wp_postmeta Set Post_id = 58 Where Post_id = 59;Update Wp_comments Set Comment_post_ID = 58 Where Comment_post_ID = 59;

The article that if the user needs,amends is more, need batch is duplicate, revise and carry out above 4.

Categories: posite Tags: Solve,the,method,with,disconti
  1. No comments yet.
  1. No trackbacks yet.