Create table on activation problem

  • Hello to everyone,

    I want my plugin to create a table when it is activated. Could anyone, please, tell me what I am doing wrong here?

    MY CODE:

    function TagRank_Activate()
    {
    $tags_ratings = $wpdb->prefix . “tags_ratings”;

    if ($wpdb->get_var(“SHOW tables LIKE ‘$tags_ratings'”) != $tags_ratings)
    {
    $sql = “CREATE table” . $tags_ratings . “(
    id mediumint(9) NOT NULL AUTO_INCREMENT,
    post_id mediumint(9) NOT NULL,
    tag_id mediumint(9) NOT NULL,
    rating bigint(11) DEFAULT ‘0’ NOT NULL,
    UNIQUE KEY id (id)
    );”;
    require_once(ABSPATH . ‘wp-admin/upgrade-functions.php’);
    dbDelta($sql);
    }
    }

    add_action(‘activate_tagrank.php’, ‘TagRank_Activate’);

    My plugin is stored at wp-content/plugins/tagrank.php.

    Thank you very much.

Viewing 1 replies (of 1 total)

  • I know it’s old here, but thought I would reply, since this is the number one listing for “create table problem” and I didn’t see the solution posted anywhere else.

    This code doesn’t work, because you need backticks around your table name and table columns in your sql query. I can’t even post the correct code here, because the editor keeps stripping them out no matter what I do. I would guess that’s why the solution is so elusive… no one can get it to post. ??

    Anyway, backticks are the little apostrophe-looking things all the way to the left hand side of your keyboard on the numbers row… so, it goes…

    3… 2… 1… backtick…

    Not the squiggly one, which is a tilde… just the apostrophe-looking one. That’s it…

    Put those around the quotations around tablename and around the column ids… i.e. id, post_id, etc… and you’ll be good to go.

    I banged my head against the wall for a day trying to figure this out… it wasn’t till I stumbled onto an obscure video that the author mentioned this.

    I’m not sure why it’s not mentioned in the codex, but it probably should be.

    Thanks!!
    John

Viewing 1 replies (of 1 total)
  • The topic ‘Create table on activation problem’ is closed to new replies.