JInstaller: :Install: Ошибка SQL Ошибка базы данных с номером 1072
Key column 'user_id' doesn't exist in table SQL=-- ----------------------------------------------------- -- Table `ds3xa_joomleague_person` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `ds3xa_joomleague_person` ( `id` INT(11) NOT NULL AUTO_INCREMENT , `contact_id` INT(11) NULL DEFAULT NULL , `firstname` VARCHAR(45) NOT NULL DEFAULT '' , `lastname` VARCHAR(45) NOT NULL DEFAULT '' , `nickname` VARCHAR(45) NOT NULL DEFAULT '' , `alias` VARCHAR(90) NOT NULL DEFAULT '' , `country` VARCHAR(3) NULL DEFAULT NULL, `knvbnr` VARCHAR(10) NOT NULL DEFAULT '' , `birthday` DATE NOT NULL DEFAULT '0000-00-00' , `deathday` DATE NOT NULL DEFAULT '0000-00-00' , `height` INT(3) NULL DEFAULT NULL , `weight` INT(3) NULL DEFAULT NULL , `picture` VARCHAR(128) NOT NULL DEFAULT '' , `show_pic` TINYINT(1) NOT NULL DEFAULT '1' , `show_persdata` TINYINT(1) NOT NULL DEFAULT '1' , `show_teamdata` TINYINT(1) NOT NULL DEFAULT '1' , `show_on_frontend` TINYINT(1) NOT NULL DEFAULT '1' , `info` VARCHAR(255) NOT NULL DEFAULT '' , `notes` TEXT NOT NULL , `phone` VARCHAR(20) NOT NULL DEFAULT '' , `mobile` VARCHAR(20) NOT NULL DEFAULT '' , `email` VARCHAR(50) NOT NULL , `website` VARCHAR(250) NOT NULL , `address` VARCHAR(100) NOT NULL DEFAULT '' , `zipcode` VARCHAR(10) NOT NULL DEFAULT '' , `location` VARCHAR(50) NOT NULL DEFAULT '' , `state` VARCHAR(50) NOT NULL DEFAULT '' , `address_country` VARCHAR(3) NULL DEFAULT NULL, `extended` TEXT NULL , `position_id` INT(11) NULL, `published` TINYINT(1) NOT NULL DEFAULT '0' , `ordering` INT(11) NOT NULL DEFAULT '0' , `checked_out` INT(11) NOT NULL DEFAULT '0' , `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified` DATETIME NULL , `modified_by` INT NULL , PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `position_id` (`position_id`) ) ENGINE = MyISAM DEFAULT CHARSET = utf8;
SQL =
-- -----------------------------------------------------
-- Table `#__joomleague_person`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `#__joomleague_person` (
`id` INT(11) NOT NULL AUTO_INCREMENT ,
`contact_id` INT(11) NULL DEFAULT NULL ,
`firstname` VARCHAR(45) NOT NULL DEFAULT '' ,
`lastname` VARCHAR(45) NOT NULL DEFAULT '' ,
`nickname` VARCHAR(45) NOT NULL DEFAULT '' ,
`alias` VARCHAR(90) NOT NULL DEFAULT '' ,
`country` VARCHAR(3) NULL DEFAULT NULL,
`knvbnr` VARCHAR(10) NOT NULL DEFAULT '' ,
`birthday` DATE NOT NULL DEFAULT '0000-00-00' ,
`deathday` DATE NOT NULL DEFAULT '0000-00-00' ,
`height` INT(3) NULL DEFAULT NULL ,
`weight` INT(3) NULL DEFAULT NULL ,
`picture` VARCHAR(128) NOT NULL DEFAULT '' ,
`show_pic` TINYINT(1) NOT NULL DEFAULT '1' ,
`show_persdata` TINYINT(1) NOT NULL DEFAULT '1' ,
`show_teamdata` TINYINT(1) NOT NULL DEFAULT '1' ,
`show_on_frontend` TINYINT(1) NOT NULL DEFAULT '1' ,
`info` VARCHAR(255) NOT NULL DEFAULT '' ,
`notes` TEXT NOT NULL ,
`phone` VARCHAR(20) NOT NULL DEFAULT '' ,
`mobile` VARCHAR(20) NOT NULL DEFAULT '' ,
`email` VARCHAR(50) NOT NULL ,
`website` VARCHAR(250) NOT NULL ,
`address` VARCHAR(100) NOT NULL DEFAULT '' ,
`zipcode` VARCHAR(10) NOT NULL DEFAULT '' ,
`location` VARCHAR(50) NOT NULL DEFAULT '' ,
`state` VARCHAR(50) NOT NULL DEFAULT '' ,
`address_country` VARCHAR(3) NULL DEFAULT NULL,
`extended` TEXT NULL ,
`position_id` INT(11) NULL,
`published` TINYINT(1) NOT NULL DEFAULT '0' ,
`ordering` INT(11) NOT NULL DEFAULT '0' ,
`checked_out` INT(11) NOT NULL DEFAULT '0' ,
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`modified` DATETIME NULL ,
`modified_by` INT NULL ,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `position_id` (`position_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8;
Установка компонента: Файл ошибок SQL Ошибка базы данных с номером 1072
Key column 'user_id' doesn't exist in table SQL=-- ----------------------------------------------------- -- Table `ds3xa_joomleague_person` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `ds3xa_joomleague_person` ( `id` INT(11) NOT NULL AUTO_INCREMENT , `contact_id` INT(11) NULL DEFAULT NULL , `firstname` VARCHAR(45) NOT NULL DEFAULT '' , `lastname` VARCHAR(45) NOT NULL DEFAULT '' , `nickname` VARCHAR(45) NOT NULL DEFAULT '' , `alias` VARCHAR(90) NOT NULL DEFAULT '' , `country` VARCHAR(3) NULL DEFAULT NULL, `knvbnr` VARCHAR(10) NOT NULL DEFAULT '' , `birthday` DATE NOT NULL DEFAULT '0000-00-00' , `deathday` DATE NOT NULL DEFAULT '0000-00-00' , `height` INT(3) NULL DEFAULT NULL , `weight` INT(3) NULL DEFAULT NULL , `picture` VARCHAR(128) NOT NULL DEFAULT '' , `show_pic` TINYINT(1) NOT NULL DEFAULT '1' , `show_persdata` TINYINT(1) NOT NULL DEFAULT '1' , `show_teamdata` TINYINT(1) NOT NULL DEFAULT '1' , `show_on_frontend` TINYINT(1) NOT NULL DEFAULT '1' , `info` VARCHAR(255) NOT NULL DEFAULT '' , `notes` TEXT NOT NULL , `phone` VARCHAR(20) NOT NULL DEFAULT '' , `mobile` VARCHAR(20) NOT NULL DEFAULT '' , `email` VARCHAR(50) NOT NULL , `website` VARCHAR(250) NOT NULL , `address` VARCHAR(100) NOT NULL DEFAULT '' , `zipcode` VARCHAR(10) NOT NULL DEFAULT '' , `location` VARCHAR(50) NOT NULL DEFAULT '' , `state` VARCHAR(50) NOT NULL DEFAULT '' , `address_country` VARCHAR(3) NULL DEFAULT NULL, `extended` TEXT NULL , `position_id` INT(11) NULL, `published` TINYINT(1) NOT NULL DEFAULT '0' , `ordering` INT(11) NOT NULL DEFAULT '0' , `checked_out` INT(11) NOT NULL DEFAULT '0' , `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified` DATETIME NULL , `modified_by` INT NULL , PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `position_id` (`position_id`) ) ENGINE = MyISAM DEFAULT CHARSET = utf8;
SQL =
-- -----------------------------------------------------
-- Table `#__joomleague_person`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `#__joomleague_person` (
`id` INT(11) NOT NULL AUTO_INCREMENT ,
`contact_id` INT(11) NULL DEFAULT NULL ,
`firstname` VARCHAR(45) NOT NULL DEFAULT '' ,
`lastname` VARCHAR(45) NOT NULL DEFAULT '' ,
`nickname` VARCHAR(45) NOT NULL DEFAULT '' ,
`alias` VARCHAR(90) NOT NULL DEFAULT '' ,
`country` VARCHAR(3) NULL DEFAULT NULL,
`knvbnr` VARCHAR(10) NOT NULL DEFAULT '' ,
`birthday` DATE NOT NULL DEFAULT '0000-00-00' ,
`deathday` DATE NOT NULL DEFAULT '0000-00-00' ,
`height` INT(3) NULL DEFAULT NULL ,
`weight` INT(3) NULL DEFAULT NULL ,
`picture` VARCHAR(128) NOT NULL DEFAULT '' ,
`show_pic` TINYINT(1) NOT NULL DEFAULT '1' ,
`show_persdata` TINYINT(1) NOT NULL DEFAULT '1' ,
`show_teamdata` TINYINT(1) NOT NULL DEFAULT '1' ,
`show_on_frontend` TINYINT(1) NOT NULL DEFAULT '1' ,
`info` VARCHAR(255) NOT NULL DEFAULT '' ,
`notes` TEXT NOT NULL ,
`phone` VARCHAR(20) NOT NULL DEFAULT '' ,
`mobile` VARCHAR(20) NOT NULL DEFAULT '' ,
`email` VARCHAR(50) NOT NULL ,
`website` VARCHAR(250) NOT NULL ,
`address` VARCHAR(100) NOT NULL DEFAULT '' ,
`zipcode` VARCHAR(10) NOT NULL DEFAULT '' ,
`location` VARCHAR(50) NOT NULL DEFAULT '' ,
`state` VARCHAR(50) NOT NULL DEFAULT '' ,
`address_country` VARCHAR(3) NULL DEFAULT NULL,
`extended` TEXT NULL ,
`position_id` INT(11) NULL,
`published` TINYINT(1) NOT NULL DEFAULT '0' ,
`ordering` INT(11) NOT NULL DEFAULT '0' ,
`checked_out` INT(11) NOT NULL DEFAULT '0' ,
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`modified` DATETIME NULL ,
`modified_by` INT NULL ,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `position_id` (`position_id`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8;