CiviCRM Community Forums (archive)

Installing civicrm 3.1.3 (had a previous installation of 2.2 and uninstalled it, dropped all the tables using civicrm_drop.mysql - upgrade did not go well so starting over)
Enable FTP is OFF.
Legacy mode is ON (thinking this would help)
Installing from tmp folder. This is the output that I get
==============
Cannot execute CREATE TABLE civicrm_menu ( id int unsigned NOT NULL AUTO_INCREMENT , domain_id int unsigned NOT NULL COMMENT 'Which Domain is this menu item for', path varchar(255) COMMENT 'Path Name', path_arguments text COMMENT 'Arguments to pass to the url', title varchar(255) COMMENT 'Menu Title', access_callback varchar(255) COMMENT 'Function to call to check access permissions', access_arguments text COMMENT 'Arguments to pass to access callback', page_callback varchar(255) COMMENT 'function to call for this url', page_arguments text COMMENT 'Arguments to pass to page callback', breadcrumb text COMMENT 'Breadcrumb for the path.', return_url varchar(255) COMMENT 'Url where a page should redirected to, if next url not known.', return_url_args varchar(255) COMMENT 'Arguments to pass to return_url', component_id int unsigned COMMENT 'Component that this menu item belongs to', is_active tinyint COMMENT 'Is this menu item active?', is_public tinyint COMMENT 'Is this menu accessible to the public?', is_exposed tinyint COMMENT 'Is this menu exposed to the navigation system?', is_ssl tinyint COMMENT 'Should this menu be exposed via SSL if enabled?', weight int NOT NULL DEFAULT 1 COMMENT 'Ordering of the menu items in various blocks.', type int NOT NULL DEFAULT 1 COMMENT 'Drupal menu type.', page_type int NOT NULL DEFAULT 1 COMMENT 'CiviCRM menu type.', skipBreadcrumb tinyint COMMENT 'skip this url being exposed to breadcrumb' , PRIMARY KEY ( id ) , UNIQUE INDEX UI_path_domain_id( path , domain_id ) , CONSTRAINT FK_civicrm_menu_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id) , CONSTRAINT FK_civicrm_menu_component_id FOREIGN KEY (component_id) REFERENCES civicrm_component(id) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: can not create