Find and Delete Duplicate Post WordPress From PHPMyAdmin

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on telegram
Telegram
Share on whatsapp
WhatsApp
Share on email
Email

Judulnya rada ke-Enggris2-an ….. 😀

Pertama temukan dahulu Duplicate Post tersebut dengan perintah seperti dibawah ini :

SELECT a.ID, a.post_title, a.post_type, a.post_status
FROM wp_posts AS a
   INNER JOIN (
      SELECT post_title, MIN( id ) AS min_id
      FROM wp_posts
      WHERE post_type = 'post'
      AND post_status = 'publish'
      GROUP BY post_title
      HAVING COUNT( * ) > 1
   ) AS b ON b.post_title = a.post_title
AND b.min_id <> a.id
AND a.post_type = 'post'
AND a.post_status = 'publish'

 

Setelah ditemukan Duplicate post tersebut langsung lakukan perintah untuk menghapusnya :

DELETE a.*
FROM wp_posts AS a
   INNER JOIN (
      SELECT post_title, MIN( id ) AS min_id
      FROM wp_posts
      WHERE post_type = 'post'
      AND post_status = 'publish'
      GROUP BY post_title
      HAVING COUNT( * ) > 1
   ) AS b ON b.post_title = a.post_title
AND b.min_id <> a.id
AND a.post_type = 'post'
AND a.post_status = 'publish'

 

 

source : http://wpkrauts.com/2013/find-and-delete-duplicate-posts-in-wordpress/

Menonaktifkan Error.log Apache Pada Webserver

Terkadang tanpa disadari karena kesalahan coding … error.log akan membengkak sehingga menghabiskan space di server sedangkan aplikasi berjalan normal, oleh karena itu demi menghemat space

Instal Panel VPS Dengan Webuzo

Webuzo adalah kontrol panel web hosting tunggal yang dapat Anda gunakan untuk dijadikan host website Anda. Webuzo sangat mudah digunakan dan mempunyai interface yang mudah

Setup Bind9 On Debian

Install bind9 BIND (Berkely Internet Name Domain) is a software for translating domain names into IP addresses. Install it using command: apt-get install bind9 bind9utils