WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Not able to create plugin tables since WP 2.5 (5 posts)

  1. Vincent Mimoun-Prat
    Member
    Posted 6 years ago #

    Hi all,

    I am trying to update my plugin for compatibility with WP 2.5 but I still cannot create the tables at activation.

    Here is the code I use to create the tables:

    // Create the main template table
    	$sql = "CREATE TABLE ".$post_templates_templates_table." (
    		template_id BIGINT(20) NOT NULL AUTO_INCREMENT,
    		type ENUM('page', 'post') NOT NULL,
    		title TEXT NOT NULL,
    		slug VARCHAR(200) NOT NULL,
    		content LONGTEXT NOT NULL,
    		excerpt TEXT NOT NULL,
    		categories TEXT NOT NULL,
    		tags TEXT NOT NULL,
    		password VARCHAR(20) NOT NULL,
    		comment_status ENUM('open', 'closed', 'registered_only') NOT NULL,
    		ping_status ENUM('open', 'closed') NOT NULL,
    		to_ping TEXT NOT NULL,
    		parent BIGINT(20) NOT NULL,
    		PRIMARY KEY  (template_id)
    	); ";
    
    	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
        dbDelta($sql);

    This was working fine with WP 2.3.

    I tried as well to create the tables manually with a $wpdb->query but I have the same effect.

    I got no output message, no way to know why it does not get created. Do I have to commit such a DB modification? If so, how?

    Vincent

  2. harknell
    Member
    Posted 6 years ago #

    Are you using any global variables in your activation function? if so you need to declare them as global *outside* of the function. They made any variables that exist in the activation function non-global (even if you call them as global) unles you specifically declared them as global in the main context of your file.

    So at the start of my plugin I globalize all of my global variables I use in my activation function.

  3. Vincent Mimoun-Prat
    Member
    Posted 6 years ago #

    that was the problem indeed. I should have read more carefully the plugin upgrade document.

    Thanks a lot!

  4. greenpeas
    Member
    Posted 6 years ago #

    I had a working version of ver. 1.2.1 prior to upgrading to WP 2.5; but after, went to post template 2.1.1, and it shows up; but when hitting "templatize" on a post, it takes me to the management page, with no template post. Any ideas?

  5. Vincent Mimoun-Prat
    Member
    Posted 6 years ago #

    An idea: make my life easyer and go to the support forum on http://post-template.vincentprat.info

Topic Closed

This topic has been closed to new replies.

About this Topic