I am getting the following error when trying to launch my app in the sandbox:
JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'address' SQL=CREATE TABLE IF NOT EXISTS `[PREFIX]demo6003_employees` ( `id` int(11) NOT NULL auto_increment, `params` text NOT NULL DEFAULT '', `picture` VARCHAR(255) , `first_name` VARCHAR(25) NOT NULL , `last_name` VARCHAR(25) NOT NULL , `address` VARCHAR(30) , `address` VARCHAR(30) , `city` VARCHAR(25) , `state` VARCHAR(2) DEFAULT 'TX' , `zip` VARCHAR(10) , `date_started` DATE , `home_phone` VARCHAR(255) , `mobile_phone` VARCHAR(255) , `email_address` VARCHAR(255) , `active` TINYINT DEFAULT 1 , `notes` TEXT , `attachments` VARCHAR(255) , `employee_fk` INT(11) , PRIMARY KEY (`id`) );
SQL =
CREATE TABLE IF NOT EXISTS `#__demo6003_employees` (
`id` int(11) NOT NULL auto_increment,
`params` text NOT NULL DEFAULT '',
`picture` VARCHAR(255) ,
`first_name` VARCHAR(25) NOT NULL ,
`last_name` VARCHAR(25) NOT NULL ,
`address` VARCHAR(30) ,
`address` VARCHAR(30) ,
`city` VARCHAR(25) ,
`state` VARCHAR(2) DEFAULT 'TX' ,
`zip` VARCHAR(10) ,
`date_started` DATE ,
`home_phone` VARCHAR(255) ,
`mobile_phone` VARCHAR(255) ,
`email_address` VARCHAR(255) ,
`active` TINYINT DEFAULT 1 ,
`notes` TEXT ,
`attachments` VARCHAR(255) ,
`employee_fk` INT(11) ,
PRIMARY KEY (`id`)
);
Component Install: SQL error file DB function failed with error number 1060
Duplicate column name 'address' SQL=CREATE TABLE IF NOT EXISTS `[PREFIX]demo6003_employees` ( `id` int(11) NOT NULL auto_increment, `params` text NOT NULL DEFAULT '', `picture` VARCHAR(255) , `first_name` VARCHAR(25) NOT NULL , `last_name` VARCHAR(25) NOT NULL , `address` VARCHAR(30) , `address` VARCHAR(30) , `city` VARCHAR(25) , `state` VARCHAR(2) DEFAULT 'TX' , `zip` VARCHAR(10) , `date_started` DATE , `home_phone` VARCHAR(255) , `mobile_phone` VARCHAR(255) , `email_address` VARCHAR(255) , `active` TINYINT DEFAULT 1 , `notes` TEXT , `attachments` VARCHAR(255) , `employee_fk` INT(11) , PRIMARY KEY (`id`) );
SQL =
CREATE TABLE IF NOT EXISTS `#__demo6003_employees` (
`id` int(11) NOT NULL auto_increment,
`params` text NOT NULL DEFAULT '',
`picture` VARCHAR(255) ,
`first_name` VARCHAR(25) NOT NULL ,
`last_name` VARCHAR(25) NOT NULL ,
`address` VARCHAR(30) ,
`address` VARCHAR(30) ,
`city` VARCHAR(25) ,
`state` VARCHAR(2) DEFAULT 'TX' ,
`zip` VARCHAR(10) ,
`date_started` DATE ,
`home_phone` VARCHAR(255) ,
`mobile_phone` VARCHAR(255) ,
`email_address` VARCHAR(255) ,
`active` TINYINT DEFAULT 1 ,
`notes` TEXT ,
`attachments` VARCHAR(255) ,
`employee_fk` INT(11) ,
PRIMARY KEY (`id`)
);
There was an error installing the package