{"id":17822,"date":"2020-12-26T16:37:49","date_gmt":"2020-12-26T09:37:49","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=17822"},"modified":"2023-02-28T15:59:01","modified_gmt":"2023-02-28T08:59:01","slug":"mengatasi-wphm-actionscheduler-actions","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/mengatasi-wphm-actionscheduler-actions\/","title":{"rendered":"Mengatasi ‘wphm_actionscheduler_actions’ Di Plugin Rank Math"},"content":{"rendered":"\n

Kami akan membahas cara mengatasi error ‘wphm_actionscheduler_actions’ di plugin Rank Math SEO. Seperti apa error dan perbaikannya, simak artikel berikut.<\/p>\n\n\n\n\n\n

Mengenal Plugin Rank Math SEO<\/h2>\n\n\n\n

Rank Math SEO<\/a> adalah salah satu plugin WordPress yang dapat Anda gunakan untuk membantu mengoptimasi SEO pada website. Plugin ini menyediakan fitur yang cukup lengkap serta dapat Anda install secara gratis. <\/p>\n\n\n\n

Hasil analisa SEO di plugin Rank Math SEO sangat baik, dengan juga menampilkan informasi score optimasi yang telah Anda lakukan sesuai keyword yang ditargetkan. Tak heran, plugin ini menjadi salah satu plugin yang paling banyak digunakan untuk optimasi SEO pada WordPress<\/a>.<\/p>\n\n\n\n

Namun pada beberapa kasus, anda akan mendapatkan kendala mengenai penggunaan plugin ini sejak pertama kali diaktifkan. Error yang sering terjadi adalah ‘wphm_actionscheduler_actions’ yang disebabkan karena kurang lengkapnya tabel yang diperlukan.<\/p>\n\n\n\n

Karenanya, kami akan membahas solusi untuk mengatasi kendala ‘wphm_actionscheduler_actions’ pada plugin Rank Math SEO berikut.<\/p>\n\n\n\n

Mengatasi error ‘wphm_actionscheduler_actions’<\/h2>\n\n\n\n

Ada 3 step yang akan kita lakukan, untuk mengatasi error tersebut. Berikut langkah-langkahnya. <\/p>\n\n\n\n

Step 1. Menonaktifkan Plugin Rank Math SEO<\/h3>\n\n\n\n

Apabila anda terlanjur mengaktifkan plugin tersebut dan terjadi error, solusi pertama yang bisa Anda lakukan adalah mendisable pluginnya. Disable plugin dapat dilakukan melalui cPanel pada menu File Manager. Berikut langkah-langkahnya:<\/p>\n\n\n\n

    \n
  1. Login ke cPanel hosting Anda.<\/li>\n\n\n\n
  2. Klik menu File manager.<\/li>\n\n\n\n
  3. Klik folder \/public_html\/wp-content\/plugins\/<\/strong>, lalu Anda dapat melakukan rename pada plugin Rank math seperti gambar berikut.<\/li>\n<\/ol>\n\n\n\n
    \"image<\/a>
    seo-by-rank-math_old<\/figcaption><\/figure>\n\n\n\n

    Pada gambar diatas, kami menambahkan _old<\/strong> , sehingga menjadi seo-by-rank-math_old<\/strong><\/p>\n\n\n\n

    Step 2. Download dan Upload Bahan melalui Dashboard Admin<\/h3>\n\n\n\n

    Setelah tahapan diatas selesai dilakukan, Anda dapat login kembali ke dashboard admin WordPress dan mempersiapkan bahan dibawah ini:<\/p>\n\n\n\n

    Silahkan buat satu file dengan nama repair-action-scheduler.php<\/strong> dan inputkan script:<\/p>\n\n\n\n

    <?php \n\ndefined( 'ABSPATH' ) || exit;\n\n\/**\n * Updater class.\n *\/\nclass Repair_Action_Scheduler {\n\n\tconst ACTIONS_TABLE = 'actionscheduler_actions';\n\tconst CLAIMS_TABLE  = 'actionscheduler_claims';\n\tconst GROUPS_TABLE  = 'actionscheduler_groups';\n\tconst LOG_TABLE     = 'actionscheduler_logs';\n\n\t\/**\n\t * Tables and their primary columns.\n\t *\n\t * @var array\n\t *\/\n\tprivate $tables = array();\n\t\n\tprivate $notices = array();\n\n\t\/**\n\t * 1. Check if the actionscheduler tables exist in the DB.\n\t * 2. Check if PRIMARY KEY is set.\n\t *     3. If not set, then rename it and create a new table.\n\t * 4. Check if AUTO_INCREMENT is set.\n\t *     5. If not set, then rename it and create a new table.\n\t *\/\n\tpublic function __construct() {\n\t\tif ( get_option( 'ras_notices' ) === false ) {\n\t\t\t$this->do_repair();\n\t\t\treturn;\n\t\t}\n\n\t\t$this->notices = get_option( 'ras_notices', array() );\n\t\tadd_action( 'admin_notices', array( $this, 'show_notices' ) );\n\t\t\n\t}\n\n\tprivate function add_notice( $message ) {\n\t\t$this->notices[] = $message;\n\t}\n\n\tpublic function show_notices() {\n\t\tif ( empty( $this->notices ) ) {\n\t\t\treturn;\n\t\t}\n\n\t\techo '<div class=\"notice notice-info is-dismissible repair-action-scheduler-notice\">';\n\t\tif ( count( $this->notices ) == 1 ) {\n\t\t\t$this->add_notice( '<em>' . __( 'No actions performed.', 'repair-action-scheduler' ) . '<\/em>' );\n\t\t}\n\n\t\t$this->add_notice( '<em>' . __( 'The Repair Action Scheduler plugin has been automatically deactivated.', 'repair-action-scheduler' ) . '<\/em>' );\n\t\tforeach ( $this->notices as $message ) {\n\t\t\techo '<p>'.$message.'<\/p>';\n\t\t}\n\t\techo '<\/div>';\n\t\tupdate_option( 'ras_notices', array() );\n\n\t\tdeactivate_plugins( plugin_basename( __FILE__ ) );\n\t}\n\n\tprivate function save_data() {\n\t\tupdate_option( 'ras_notices', $this->notices );\n\t}\n\n\tprivate function do_repair() {\n\t\tif ( substr( get_option( 'schema-ActionScheduler_StoreSchema', '' ), 0, 1 ) > 3 ) {\n\t\t\t$this->add_notice( __( 'The Repair Action Scheduler could not run because the repair database schema is obsolete.', 'repair-action-scheduler' ) );\n\t\t\t$this->save_data();\n\t\t\treturn;\n\t\t}\n\n\t\t$this->suffix = '_' . substr( md5( microtime() ), 0, 4 );\n\t\t$this->add_notice( '<strong>' . __( 'The Repair Action Scheduler process is complete.', 'repair-action-scheduler' ) . '<\/strong>' . __( 'The following actions have been performed:', 'repair-action-scheduler' ) );\n\n\t\t$this->tables = array(\n\t\t\tself::ACTIONS_TABLE => 'action_id',\n\t\t\tself::CLAIMS_TABLE  => 'claim_id',\n\t\t\tself::GROUPS_TABLE  => 'group_id',\n\t\t\tself::LOG_TABLE     => 'log_id',\n\t\t);\n\n\t\t$do_reset = false;\n\t\tforeach ( $this->tables as $table => $primary_column ) {\n\t\t\tif ( ! $this->table_exists( $table ) ) {\n\t\t\t\t$this->create_table( $table );\n\t\t\t}\n\n\t\t\tif ( ! $do_reset && ( ! $this->has_primary_key( $table ) || ! $this->has_auto_increment( $table ) ) ) {\n\t\t\t\t$do_reset = true;\n\t\t\t}\n\t\t}\n\n\t\t\/\/ Re-add all the tables, otherwise interlinked IDs might not match.\n\t\tif ( $do_reset ) {\n\t\t\tforeach ( $this->tables as $table => $primary_column ) {\n\t\t\t\t$this->rename_table( $table );\n\t\t\t\t$this->create_table( $table );\n\t\t\t}\n\t\t}\n\n\t\t$this->save_data();\n\t}\n\n\tprivate function has_primary_key( $table ) {\n\t\tglobal $wpdb;\n\t\t$table_name  = $wpdb->prefix . $table;\n\t\t$column_name = $this->tables[ $table ];\n\t\t$has_primary = $wpdb->query( \"SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_KEY = 'PRI' AND TABLE_NAME = '{$table_name}' AND COLUMN_NAME='{$column_name}'\" ); \/\/ phpcs:ignore\n\n\t\treturn (bool) $has_primary;\n\t}\n\n\tprivate function has_auto_increment( $table ) {\n\t\tglobal $wpdb;\n\t\t$table_name  = $wpdb->prefix . $table;\n\t\t$column_name = $this->tables[ $table ];\n\t\t$has_auto_increment = $wpdb->query( \"SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '{$table_name}' AND COLUMN_NAME='{$column_name}' AND EXTRA like '%auto_increment%'\" ); \/\/ phpcs:ignore\n\n\t\treturn (bool) $has_auto_increment;\n\t}\n\n\tprivate function rename_options() {\n\t\t$options = array(\n\t\t\t'schema-ActionScheduler_LoggerSchema' => '3',\n\t\t\t'schema-ActionScheduler_StoreSchema' => '2'\n\t\t);\n\t\tforeach ( $options as $option => $version ) {\n\t\t\tif ( $stored = get_option( $option ) ) {\n\t\t\t\t$value_to_save = (string) $version . '.0.' . time();\n\t\t\t\tupdate_option( $option, $value_to_save );\n\n\t\t\t\t\/\/ Translators: placeholder is the table name wrapped in CODE tags.\n\t\t\t\t$this->add_notice( sprintf( __( 'Renamed option: %1$s to %2$s', 'repair-action-scheduler' ), '<code>' . $option . '<\/code>', '<code>' . $option . $this->suffix . '<\/code>' ) );\n\t\t\t}\n\t\t}\n\t}\n\n\tprivate function table_exists( $table ) {\n\t\tglobal $wpdb;\n\t\t$tables = $wpdb->query( \"SHOW TABLES LIKE '{$wpdb->prefix}{$table}'\" ); \/\/ phpcs:ignore\n\t\treturn (bool) $tables;\n\t}\n\n\tprivate function create_table( $table ) {\n\t\tglobal $wpdb;\n\t\t$wpdb->query( $this->get_table_schema( $table ) ); \/\/ phpcs:ignore\n\t\t\/\/ Translators: placeholder is the table name wrapped in CODE tags.\n\t\t$this->add_notice( sprintf( __( 'Created table: %s', 'repair-action-scheduler' ), '<code>' . $table . '<\/code>' ) );\n\t}\n\n\tprivate function maybe_deactivate_analytics_module() {\n\t\t$modules = get_option( 'rank_math_modules' );\n\t\tif ( ! is_array( $modules ) ) {\n\t\t\treturn;\n\t\t}\n\n\t\t$new_modules = array_values( array_diff( $modules, array( 'analytics', 'search-console' ) ) );\n\t\t$this->add_notice( __( 'Deactivated the Analytics module in Rank Math.', 'repair-action-scheduler' ) );\n\t}\n\n\tprivate function rename_table( $table ) {\n\t\tglobal $wpdb;\n\t\t$wpdb->query( \"ALTER TABLE {$wpdb->prefix}{$table} RENAME TO {$wpdb->prefix}{$table}{$this->suffix};\" ); \/\/ phpcs:ignore\n\t\t\/\/ Translators: placeholder is the table name wrapped in CODE tags.\n\t\t$this->add_notice( sprintf( __( 'Renamed table: %1$s to %2$s', 'repair-action-scheduler' ), '<code>' . $table . '<\/code>', '<code>' . $table . $this->suffix . '<\/code>' ) );\n\t}\n\n\tprivate function get_table_schema( $table ) {\n\t\tglobal $wpdb;\n\t\t$table_name       = $wpdb->prefix . $table;\n\t\t$charset_collate  = $wpdb->get_charset_collate();\n\t\t$max_index_length = 191; \/\/ @see wp_get_db_schema()\n\t\tswitch ( $table ) {\n\n\t\t\tcase self::ACTIONS_TABLE:\n\t\t\t\treturn \"CREATE TABLE {$table_name} (\n\t\t\t\t\taction_id bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t\t\thook varchar(191) NOT NULL,\n\t\t\t\t\tstatus varchar(20) NOT NULL,\n\t\t\t\t\tscheduled_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',\n\t\t\t\t\tscheduled_date_local datetime NOT NULL default '0000-00-00 00:00:00',\n\t\t\t\t\targs varchar($max_index_length),\n\t\t\t\t\tschedule longtext,\n\t\t\t\t\tgroup_id bigint(20) unsigned NOT NULL default '0',\n\t\t\t\t\tattempts int(11) NOT NULL default '0',\n\t\t\t\t\tlast_attempt_gmt datetime NOT NULL default '0000-00-00 00:00:00',\n\t\t\t\t\tlast_attempt_local datetime NOT NULL default '0000-00-00 00:00:00',\n\t\t\t\t\tclaim_id bigint(20) unsigned NOT NULL default '0',\n\t\t\t\t\textended_args varchar(8000) DEFAULT NULL,\n\t\t\t\t\tPRIMARY KEY  (action_id),\n\t\t\t\t\tKEY hook (hook($max_index_length)),\n\t\t\t\t\tKEY status (status),\n\t\t\t\t\tKEY scheduled_date_gmt (scheduled_date_gmt),\n\t\t\t\t\tKEY args (args($max_index_length)),\n\t\t\t\t\tKEY group_id (group_id),\n\t\t\t\t\tKEY last_attempt_gmt (last_attempt_gmt),\n\t\t\t\t\tKEY claim_id (claim_id)\n\t\t\t\t\t) $charset_collate\";\n\n\t\t\tcase self::CLAIMS_TABLE:\n\t\t\t\treturn \"CREATE TABLE {$table_name} (\n\t\t\t\t\t\tclaim_id bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\tdate_created_gmt datetime NOT NULL default '0000-00-00 00:00:00',\n\t\t\t\t\t\tPRIMARY KEY  (claim_id),\n\t\t\t\t\t\tKEY date_created_gmt (date_created_gmt)\n\t\t\t\t\t\t) $charset_collate\";\n\n\t\t\tcase self::GROUPS_TABLE:\n\t\t\t\treturn \"CREATE TABLE {$table_name} (\n\t\t\t\t\t\tgroup_id bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\tslug varchar(255) NOT NULL,\n\t\t\t\t\t\tPRIMARY KEY  (group_id),\n\t\t\t\t\t\tKEY slug (slug($max_index_length))\n\t\t\t\t\t\t) $charset_collate\";\n\n\t\t\tcase self::LOG_TABLE:\n\t\t\t\treturn \"CREATE TABLE {$table_name} (\n\t\t\t\t\t\tlog_id bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\taction_id bigint(20) unsigned NOT NULL,\n\t\t\t\t\t\tmessage text NOT NULL,\n\t\t\t\t\t\tlog_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',\n\t\t\t\t\t\tlog_date_local datetime NOT NULL default '0000-00-00 00:00:00',\n\t\t\t\t\t\tPRIMARY KEY  (log_id),\n\t\t\t\t\t\tKEY action_id (action_id),\n\t\t\t\t\t\tKEY log_date_gmt (log_date_gmt)\n\t\t\t\t\t\t) $charset_collate\";\n\n\t\t\tdefault:\n\t\t\t\treturn '';\n\t\t}\n\t}\n}\n\nregister_deactivation_hook( __FILE__, 'repair_action_scheduler_clean' );\nfunction repair_action_scheduler_clean() {\n\tdelete_option( 'ras_notices' );\n}\n\n$repair_action_scheduler = new Repair_Action_Scheduler();\n\n<\/code><\/pre>\n\n\n\n
    Pastikan tag <\/strong>pembuka PHP ( <?php<\/strong> ) disertakan agar dapat digunakan dengan baik. Selanjutnya, Anda perlu meng-kompresinya menjadi file .zip<\/strong> terlebih dahulu dan di upload melalui Dashboard admin WordPress seperti pada gambar dibawah.<\/p>\n\n\n\n
    \"upload<\/a><\/figure>\n\n\n\n
    Langkah selanjutnya dengan klik tombol “Instal Sekarang”. <\/p>\n\n\n\n
    Jika sudah terinstal, Anda klik tombol “Aktifkan Plugin” maka otomatis plugin yang baru saja diupload dan aktif, akan membuat tabel baru yang diperlukan. Contoh pada gambar dibawah ini<\/p>\n\n\n
    \n
    \"aktifkan<\/a><\/figure>\n<\/div>\n\n\n
    Step 3. Aktifkan Plugin Rank Math SEO<\/h3>\n\n\n\n
    Pada langkah terakhir, Anda hanya perlu mengaktifkan kembali plugin Rank Math SEO melalui halaman Dashboard WordPress Anda.<\/p>\n\n\n\n
    Demikian cara mengatasi error ‘wphm_actionscheduler_actions’ doesn’t exist pada plugin Rank Math SEO WordPress. Semoga bermanfaat. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Kami akan membahas cara mengatasi error ‘wphm_actionscheduler_actions’ di plugin Rank Math SEO. Seperti apa error dan perbaikannya, simak artikel berikut. Mengenal Plugin Rank Math SEO Rank Math SEO adalah salah satu plugin WordPress yang dapat Anda gunakan untuk membantu mengoptimasi SEO pada website. Plugin ini menyediakan fitur yang cukup lengkap serta dapat Anda install secara […]<\/p>\n","protected":false},"author":338,"featured_media":36993,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[463],"tags":[1464,1000,14],"class_list":{"0":"post-17822","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wordpress","8":"tag-plugin-rank-math-seo","9":"tag-tutorial-wordpress","10":"tag-wordpress"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2020\/12\/Banner-Mengatasi-wphm-actionscheduler-actions-Di-Plugin-Rank-Math-SEO.png","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-4Ds","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/17822","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/users\/338"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=17822"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/17822\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/36993"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=17822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=17822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=17822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}