Results 1 to 4 of 4

Thread: Installation issues when InnoDB is the default database engine

  1. #1
    Thread Starter
    Newbie tonycl's Avatar
    Join Date
    Mar 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Installation issues when InnoDB is the default database engine

    I thought this might help others that have experienced the issue noted in the threads listed below:
    http://forums.appthemes.com/empty-table-14327/
    http://forums.appthemes.com/error-no...-14295/page-2/

    If you have your default MySQL database engine set to InnoDB, the "wp_*cp_ad_fields" table will not get populated.

    Although the default WordPress install will run using InnoDB as the engine (may be slower), you can change it after the fact by issuing the following command:
    ALTER TABLE t ENGINE = MYISAM where t is(are) the table name(s)

    The correct fix is for all plugin, theme, and widget developers that create tables to add the engine type to their table create statements.

    In the case of ClassiPress, one of the create statements should look like this:
    (note the engine clause)
    Code:
        $sql = "CREATE TABLE IF NOT EXISTS ". $wpdb->prefix . "cp_ad_forms" ." (
            `id` INT(10) NOT NULL auto_increment,
            `form_name` VARCHAR(255) NOT NULL,
            `form_label` VARCHAR(255) NOT NULL,
            `form_desc` LONGTEXT,
            `form_cats` LONGTEXT NOT NULL,
            `form_status` VARCHAR(255) DEFAULT NULL,
            `form_owner` VARCHAR(255) DEFAULT NULL,
            `form_created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
            `form_modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
            PRIMARY KEY id  (`id`)) ENGINE=MyISAM  $collate;";
    By the way, the error in the ClassiPress install is due to the install-script.php trying to insert an empty string into an integer field (field_req) starting at row 3. This will work in a MyISAM table but not an InnoDB. I don't know if there are other errors, but this is a "show stopper!"

    If you don't want to change your default engine (I don't on my dev system), you can grab the erring insert statement out of the error log and issue it in phpMyAdmin (or the cl) after changing the ClassiPress tables to MyISAM.

    Hope that helps...

    Darrell

  2. #2
    jomarkosabel's Avatar
    Join Date
    Mar 2009
    Location
    Philippines
    Posts
    40,782
    Thanks
    166
    Thanked 3,393 Times in 3,264 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Please help our moderating team work more efficiently by not sending us support questions via PM. You can read more about how AppThemes support works here. However, you can send a PM to follow up and remind me if I missed your support request/thread.

    Thank you and have a nice day.

  3. #3
    Thread Starter
    Newbie tonycl's Avatar
    Join Date
    Mar 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  4. #4
    jomarkosabel's Avatar
    Join Date
    Mar 2009
    Location
    Philippines
    Posts
    40,782
    Thanks
    166
    Thanked 3,393 Times in 3,264 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Please help our moderating team work more efficiently by not sending us support questions via PM. You can read more about how AppThemes support works here. However, you can send a PM to follow up and remind me if I missed your support request/thread.

    Thank you and have a nice day.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search engine results problem
    By sorin09 in forum ClassiPress General Discussion
    Replies: 7
    Last Post: January 30th, 2011, 04:08 AM
  2. Replies: 7
    Last Post: November 21st, 2010, 10:12 PM
  3. Default Map Location: edit = reset to default location
    By hostr in forum Report JobRoller Bugs
    Replies: 1
    Last Post: November 1st, 2010, 07:52 AM
  4. Search Engine Not working/Images not showing
    By tiffany in forum ClassiPress General Discussion
    Replies: 11
    Last Post: April 29th, 2009, 03:57 PM