There were a number of issues: Can't create table 'elggconfig' (errno: 13) QUERY: CREATE TABLE `elggconfig` (
`name` varchar(32) NOT NULL,
`value` text NOT NULL,
`site_guid` int(11) NOT NULL,
PRIMARY KEY (`name`,`site_guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggentities' (errno: 13) QUERY: CREATE TABLE `elggentities` (
`guid` bigint(20) unsigned NOT NULL auto_increment,
`type` enum ('object', 'user', 'group', 'site') NOT NULL,
`subtype` int(11) NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`site_guid` bigint(20) unsigned NOT NULL,
`container_guid` bigint(20) unsigned NOT NULL,
`access_id` int(11) NOT NULL,
`time_created` int(11) NOT NULL,
`time_updated` int(11) NOT NULL,
`enabled` enum ('yes', 'no') NOT NULL default 'yes',
primary key (`guid`),
KEY `type` (`type`),
KEY `subtype` (`subtype`),
KEY `owner_guid` (`owner_guid`),
KEY `site_guid` (`site_guid`),
KEY `container_guid` (`container_guid`),
KEY `access_id` (`access_id`),
KEY `time_created` (`time_created`),
KEY `time_updated` (`time_updated`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggentity_subtypes' (errno: 13) QUERY: CREATE TABLE `elggentity_subtypes` (
`id` int(11) NOT NULL auto_increment,
`type` enum ('object', 'user', 'group', 'site') NOT NULL,
`subtype` varchar(50) NOT NULL,
class varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY (`type`, `subtype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggentity_relationships' (errno: 13) QUERY: CREATE TABLE `elggentity_relationships` (
`id` int(11) NOT NULL auto_increment,
`guid_one` bigint(20) unsigned NOT NULL,
`relationship` varchar(50) NOT NULL,
`guid_two` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY (`guid_one`,`relationship`,`guid_two`),
KEY `relationship` (`relationship`),
KEY `guid_two` (`guid_two`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggaccess_collections' (errno: 13) QUERY: CREATE TABLE `elggaccess_collections` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`site_guid` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `owner_guid` (`owner_guid`),
KEY `site_guid` (`site_guid`)
) AUTO_INCREMENT=3 ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggaccess_collection_membership' (errno: 13) QUERY: CREATE TABLE `elggaccess_collection_membership` (
`user_guid` int(11) NOT NULL,
`access_collection_id` int(11) NOT NULL,
PRIMARY KEY (`user_guid`,`access_collection_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggobjects_entity' (errno: 13) QUERY: CREATE TABLE `elggobjects_entity` (
`guid` bigint(20) unsigned NOT NULL,
`title` text NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`guid`),
FULLTEXT KEY (`title`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggsites_entity' (errno: 13) QUERY: CREATE TABLE `elggsites_entity` (
`guid` bigint(20) unsigned NOT NULL,
`name` text NOT NULL,
`description` text NOT NULL,
`url` varchar(255) NOT NULL,
PRIMARY KEY (`guid`),
UNIQUE KEY (`url`),
FULLTEXT KEY (`name`,`description`, `url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggusers_entity' (errno: 13) QUERY: CREATE TABLE `elggusers_entity` (
`guid` bigint(20) unsigned NOT NULL,
`name` text NOT NULL,
`username` varchar(128) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`salt` varchar(8) NOT NULL default '',
`email` text NOT NULL,
`language` varchar(6) NOT NULL default '',
`code` varchar(32) NOT NULL default '',
`banned` enum ('yes', 'no') NOT NULL default 'no',
`last_action` int(11) NOT NULL default '0',
`prev_last_action` int(11) NOT NULL default '0',
`last_login` int(11) NOT NULL default '0',
`prev_last_login` int(11) NOT NULL default '0',
PRIMARY KEY (`guid`),
UNIQUE KEY (`username`),
KEY `password` (`password`),
KEY `email` (`email`(50)),
KEY `code` (`code`),
KEY `last_action` (`last_action`),
KEY `last_login` (`last_login`),
FULLTEXT KEY `name` (`name`),
FULLTEXT KEY (`name`,`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elgggroups_entity' (errno: 13) QUERY: CREATE TABLE `elgggroups_entity` (
`guid` bigint(20) unsigned NOT NULL,
`name` text NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`guid`),
KEY `name` (`name`(50)),
KEY `description` (`description`(50)),
FULLTEXT KEY (`name`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggannotations' (errno: 13) QUERY: CREATE TABLE `elggannotations` (
`id` int(11) NOT NULL auto_increment,
`entity_guid` bigint(20) unsigned NOT NULL,
`name_id` int(11) NOT NULL,
`value_id` int(11) NOT NULL,
`value_type` enum ('integer','text') NOT NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`access_id` int(11) NOT NULL,
`time_created` int(11) NOT NULL,
`enabled` enum ('yes', 'no') NOT NULL default 'yes',
PRIMARY KEY (`id`),
KEY `entity_guid` (`entity_guid`),
KEY `name_id` (`name_id`),
KEY `value_id` (`value_id`),
KEY `owner_guid` (`owner_guid`),
KEY `access_id` (`access_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggmetadata' (errno: 13) QUERY: CREATE TABLE `elggmetadata` (
`id` int(11) NOT NULL auto_increment,
`entity_guid` bigint(20) unsigned NOT NULL,
`name_id` int(11) NOT NULL,
`value_id` int(11) NOT NULL,
`value_type` enum ('integer','text') NOT NULL,
`owner_guid` bigint(20) unsigned NOT NULL,
`access_id` int(11) NOT NULL,
`time_created` int(11) NOT NULL,
`enabled` enum ('yes', 'no') NOT NULL default 'yes',
PRIMARY KEY (`id`),
KEY `entity_guid` (`entity_guid`),
KEY `name_id` (`name_id`),
KEY `value_id` (`value_id`),
KEY `owner_guid` (`owner_guid`),
KEY `access_id` (`access_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggmetastrings' (errno: 13) QUERY: CREATE TABLE `elggmetastrings` (
`id` int(11) NOT NULL auto_increment,
`string` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `string` (`string`(50))
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggapi_users' (errno: 13) QUERY: CREATE TABLE `elggapi_users` (
id int(11) auto_increment,
site_guid bigint(20) unsigned,
api_key varchar(40),
secret varchar(40) NOT NULL,
active int(1) default 1,
unique key (api_key),
primary key (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggusers_apisessions' (errno: 13) QUERY: CREATE TABLE `elggusers_apisessions` (
`id` int(11) NOT NULL auto_increment,
`user_guid` bigint(20) unsigned NOT NULL,
`site_guid` bigint(20) unsigned NOT NULL,
`token` varchar(40),
`expires` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY (`user_guid`,`site_guid`),
KEY `token` (`token`)
) ENGINE=MEMORY; Can't create table 'elgghmac_cache' (errno: 13) QUERY: CREATE TABLE `elgghmac_cache` (
`hmac` varchar(255) NOT NULL,
`ts` int(11) NOT NULL,
PRIMARY KEY (`hmac`),
KEY `ts` (`ts`)
) ENGINE=MEMORY; Can't create table 'elgggeocode_cache' (errno: 13) QUERY: CREATE TABLE `elgggeocode_cache` (
id int(11) auto_increment,
location varchar(128),
`lat` varchar(20),
`long` varchar(20),
PRIMARY KEY (`id`),
UNIQUE KEY `location` (`location`)
) ENGINE=MEMORY; Can't create table 'elggusers_sessions' (errno: 13) QUERY: CREATE TABLE `elggusers_sessions` (
`session` varchar(255) NOT NULL,
`ts` int(11) unsigned NOT NULL default '0',
`data` mediumblob,
PRIMARY KEY `session` (`session`),
KEY `ts` (`ts`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggdatalists' (errno: 13) QUERY: CREATE TABLE `elggdatalists` (
`name` varchar(32) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggprivate_settings' (errno: 13) QUERY: CREATE TABLE `elggprivate_settings` (
`id` INT NOT NULL auto_increment,
`entity_guid` INT NOT NULL ,
`name` varchar(128) NOT NULL ,
`value` TEXT NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY ( `entity_guid` , `name` ),
KEY `name` (`name`),
KEY `value` (`value` (50))
) ENGINE = MYISAM DEFAULT CHARSET=utf8; Can't create table 'elggsystem_log' (errno: 13) QUERY: CREATE TABLE `elggsystem_log` (
`id` int(11) NOT NULL auto_increment,
`object_id` int(11) NOT NULL,
`object_class` varchar(50) NOT NULL,
`object_type` varchar(50) NOT NULL,
`object_subtype` varchar(50) NOT NULL,
`event` varchar(50) NOT NULL,
`performed_by_guid` int(11) NOT NULL,
`owner_guid` int(11) NOT NULL,
`access_id` int(11) NOT NULL,
`enabled` enum ('yes', 'no') NOT NULL default 'yes',
`time_created` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `object_id` (`object_id`),
KEY `object_class` (`object_class`),
KEY `object_type` (`object_type`),
KEY `object_subtype` (`object_subtype`),
KEY `event` (`event`),
KEY `performed_by_guid` (`performed_by_guid`),
KEY `access_id` (`access_id`),
KEY `time_created` (`time_created`),
KEY `river_key` (`object_type`, `object_subtype`, `event`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; Can't create table 'elggriver' (errno: 13) QUERY: CREATE TABLE `elggriver` (
`id` INT NOT NULL AUTO_INCREMENT ,
`type` VARCHAR( 8 ) NOT NULL ,
`subtype` VARCHAR( 32 ) NOT NULL ,
`action_type` VARCHAR( 32 ) NOT NULL ,
`access_id` INT NOT NULL ,
`view` TEXT NOT NULL ,
`subject_guid` INT NOT NULL ,
`object_guid` INT NOT NULL ,
`posted` INT NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `type` (`type`),
KEY `action_type` (`action_type`),
KEY `access_id` (`access_id`),
KEY `subject_guid` (`subject_guid`),
KEY `object_guid` (`object_guid`),
KEY `posted` (`posted`)
) ENGINE = MYISAM DEFAULT CHARSET=utf8;;