There is a typo in the function mysite_update_5() inside of the mysite.install file. Replace the function with:

/**
 * Second update to v. 5.x.2
 */
function mysite_update_5() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      $ret[] = update_sql("ALTER TABLE {mysite_content} ADD format smallint(6) default NULL;");
      $ret[] = update_sql("ALTER TABLE {mysite_content} ADD base varchar(255) default NULL;");
      $ret[] = update_sql("ALTER TABLE {mysite_content} ADD xml varchar(255) default NULL;");
      $ret[] = update_sql("ALTER TABLE {mysite_content} ADD INDEX (title);");
      $ret[] = update_sql("ALTER TABLE {mysite_data} ADD settings text;");
      break;
    case 'pgsql':
      $ret[] = update_sql("ALTER TABLE {mysite_content} ADD format integer default NULL;");
      $ret[] = update_sql("ALTER TABLE {mysite_content} ADD base varchar(255) default NULL;");
      $ret[] = update_sql("ALTER TABLE {mysite_content} ADD xml varchar(255) default NULL;");
      $ret[] = update_sql("CREATE INDEX {mysite_content}_title_idx ON {mysite_content} (title);");
      $ret[] = update_sql("ALTER TABLE {mysite_data} ADD settings text;");
      break;
  }
  return $ret;
}

This has been fixed in HEAD.

Comments

agentrickard’s picture

Status: Fixed » Closed (fixed)

rolled into beta3.