Can´t install 2.0.57.86eed18 on Joomla! 2.5.9

All Installation / Update / Upgrade Issues here.
User avatar
hparr
Newbie
Posts: 14
Joined: Thu Sep 13, 2007 11:58 pm
Joomleague version: 2.0.x
Location: Sweden
Contact:

Can´t install 2.0.57.86eed18 on Joomla! 2.5.9

Postby hparr » Sat Mar 02, 2013 11:17 pm

JoomlaLeuge vill not install, insted I get this information:
____________________________________________________________________________________________________________________________________________________________________________________
JInstaller: :Installera: SQL-fel DB-funktion misslyckades med felnummer 1072
Key column 'user_id' doesn't exist in table SQL=-- ----------------------------------------------------- -- Table `jos_joomleague_person` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `jos_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;
Installera komponent: SQL error i filen DB-funktion misslyckades med felnummer 1072
Key column 'user_id' doesn't exist in table SQL=-- ----------------------------------------------------- -- Table `jos_joomleague_person` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `jos_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;
____________________________________________________________________________________________________________________________________________________________________________________
All the other databases has been created, but JoomLeauge will not show up under Components.
I have tried to install it on both Swedish and English languageversion.

User avatar
hparr
Newbie
Posts: 14
Joined: Thu Sep 13, 2007 11:58 pm
Joomleague version: 2.0.x
Location: Sweden
Contact:

Re: Can´t install 2.0.57.86eed18 on Joomla! 2.5.9

Postby hparr » Sun Mar 03, 2013 1:57 am

When I copied a DB from an another website (1.5) was I abel to install it.

User avatar
Mavinas
Donator
Donator
Posts: 98
Joined: Mon Oct 22, 2012 6:05 pm
Joomleague version: 2.0.x

Re: Can´t install 2.0.57.86eed18 on Joomla! 2.5.9

Postby Mavinas » Sun Mar 03, 2013 8:54 am

Try latest version.


Return to “Installation / Update”

Who is online

Users browsing this forum: No registered users and 3 guests

cron