When I load the custom plugin and the datatables again from the scratch I receive an error below:

[22-Apr-2017 10:19:55 UTC] WordPress database error Multiple primary key defined for query ALTER TABLE wpjg_subscribers CHANGE COLUMN id id int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY

Here is the DB Migration function

private function runDbMigration_19() {
    $sql = "CREATE TABLE " . WSWEB_DB_TABLE_PREFIX . "subscribers (
    id int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,     
    name tinytext NOT NULL,
    active int(1) UNSIGNED NOT NULL DEFAULT 0,
    UNIQUE KEY id (id)
)" . $this->CHARSET_COLLATE . ";";
    return $this->calldbDelta($sql);
}

Please help me to resolve this.

Read more here: Database error "Multiple primary key" defined when installing the plugin from scratch


Solution:

If you know the solution of this issue, please leave us a reply in Comment section, to update the question.


Wordpress related questions and answers: