Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/exec-php.php on line 22

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/manager.php on line 36

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/manager.php on line 37

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/manager.php on line 38

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/manager.php on line 39

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/admin.php on line 53

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/admin.php on line 56

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/admin.php on line 57

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/admin.php on line 63

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/admin.php on line 64

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/admin.php on line 79

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/cache.php on line 22

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/cache.php on line 39

Deprecated: Assigning the return value of new by reference is deprecated in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/exec-php/includes/ajax.php on line 64

Notice: Use of undefined constant ddsg_language - assumed 'ddsg_language' in /home/netschool/affiliatekouza.com/public_html/wp-content/plugins/sitemap-generator/sitemap-generator.php on line 45
ワードプレス のアーカイブ

ワードプレス | アフィリエイト初心者講座~初心者が最速で月5万円稼ぐ

Notice: Undefined variable: useColumn in /home/netschool/affiliatekouza.com/public_html/wp-content/themes/blog/header.php on line 175
>

ワードプレス承認済みスパムコメントの削除

ワードプレス、便利なので重宝しているのですが
スパムコメントがバンバンくるので削除するのが面倒くさい。

このブログも長期間更新せずに放置しておいたら案の定
スパムコメントが40万件以上も貯まってしまっていました。

コメント一覧から地道に100件ずつ削除しようかと一瞬思いましたけど
4000回以上も同じ作業を繰り返すのはいかがなものかと思いまして
一括削除できる方法はないものかと調べてみました。

やっぱりありましたね。

あっという間に40万件もあったスパムコメントを削除できました。

MySQLからログインしてコメントテーブルのデータをすべて削除するだけです。

もしコマンド打てるならこちらです。
—-
DELETE FROM wp_comments WHERE comment_approved=’1′;
—-

スパムコメント対策で有名なツール「Akismet」も使っていますよ。
でもなぜか長期間放置しておくと承認済みのスパムコメントが
貯まってしまうんですよね。

誰も承認したつもりはないのに。。。

これで一件落着ということでこれから色々と記事を更新していきたいと思います。

メルマガ登録

メルマガ
ネットビジネスに関する最新情報を無料メルマガにてお届けしております! ぜひ登録してください。

メルマガ登録はこちら


Notice: Use of undefined constant columnSelect - assumed 'columnSelect' in /home/netschool/affiliatekouza.com/public_html/wp-content/themes/blog/footer.php on line 5

Notice: Use of undefined constant headImg - assumed 'headImg' in /home/netschool/affiliatekouza.com/public_html/wp-content/themes/blog/footer.php on line 5

Notice: Use of undefined constant column123headTxt - assumed 'column123headTxt' in /home/netschool/affiliatekouza.com/public_html/wp-content/themes/blog/footer.php on line 5

Notice: Use of undefined constant column123headDesc - assumed 'column123headDesc' in /home/netschool/affiliatekouza.com/public_html/wp-content/themes/blog/footer.php on line 5

Notice: Undefined variable: postmeta in /home/netschool/affiliatekouza.com/public_html/wp-content/themes/blog/footer.php on line 15

アフィリエイト初心者講座~初心者が最速で月5万円稼ぐ TOP » ワードプレス