WordPress.org

Support

Support » Plugins and Hacks » dbDelta upgrade problem

dbDelta upgrade problem

  • I’m following the tutorial at http://codex.wordpress.org/Creating_Tables_with_Plugins to create and then modify a table for my plugin.

    I was able to create the tables successfully. Now, I have the need to add an extra column to one of the tables.

    I’m using this code:

    // Upgrade table code
       $installed_ver = get_option( "tptn_db_version" );
    
       if( $installed_ver != $tptn_db_version ) {
    
    	$sql = "CREATE TABLE " . $table_name . " (
    		accessedid int NOT NULL AUTO_INCREMENT,
    		postnumber int NOT NULL,
    		cntaccess int NOT NULL,
    		PRIMARY KEY  (accessedid)
    	);";
    
          require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
          dbDelta($sql);
    
    	$sql = "CREATE TABLE " . $table_name_daily . " (
    		accessedid int NOT NULL AUTO_INCREMENT,
    		postnumber int NOT NULL,
    		cntaccess int NOT NULL,
    		dp_date date NOT NULL default CURDATE(),
    		PRIMARY KEY  (accessedid)
    	);";
    
          require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
          dbDelta($sql);
    
          update_option( "tptn_db_version", $tptn_db_version );
      }

    The extra column to add is the dp_date to $table_name_daily.

    However, this hasn’t changed the database structure at all.

    In the past, when I needed to create the second table, the upgrade worked. However, it isn’t altering the tables.

    Any suggestions, workarounds?

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘dbDelta upgrade problem’ is closed to new replies.
Skip to toolbar