Returning null value when creating table in WordPress

Question

Returning null value when creating table in WordPress

Navigation

#1 by (1 votes)

0

I am creating a Plugin and need to activate it to create the referenced table in the DB, but dbDelta is returning that table was created, but when checking using $wpdb->get_var it returns a null value. That is, the table is not actually being created in DB, I already checked through PHPMyAdmin.

What should be the problem in the following function?

function main(){
    global $wpdb;

    $prefix = $wpdb->prefix;
    $leads = $prefix . 'leads';

    if($wpdb->get_var("SHOW TABLES LIKE $leads") != $leads):
        $query = 
            "CREATE TABLE $leads (
                id int NOT NULL AUTO_INCREMENT, 
                nome varchar(64) NULL, 
                email varchar(64) NULL, 
                telefone varchar(15) NULL, 
                celular varchar(15) NULL, 
                mensagem tinytext NULL
            );";

        // REFERENCE TO upgrade.php FILE
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
        $var = dbDelta($query);
        var_dump($var); // RETORNA = array(1) { ["ic_leads"]=> string(22) "Created table ic_leads" }
    endif;

    var_dump($wpdb->get_var("SHOW TABLES LIKE $leads")); // RETORNA = NULL
}

php mysql wordpress

asked by anonymous 26.03.2014 / 20:24

1 answer

WebService REST request POST error execute / call a page remotely

score 1 · Accepted Answer

I tested the structure of your table directly in the database and returned the following error:

Error Code: 1075. Incorrect table definition; there is only one auto column and it should be defined as a key

In other words, it is necessary to define the primary key of this table and it must be the auto increment field, in the id case.

Leave your table structure like this:

CREATE TABLE $leads (
                id int NOT NULL AUTO_INCREMENT, 
                nome varchar(64) NULL, 
                email varchar(64) NULL, 
                telefone varchar(15) NULL, 
                celular varchar(15) NULL, 
                mensagem tinytext NULL,
                primary key(id)
            );