Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Sandbox Error 22 Sep 2012 17:03 #3853

  • sdm7001
  • sdm7001's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 20
  • Thank you received: 0
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 `vs4go_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 `vs4go_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

Please Log in or Create an account to join the conversation.

Last edit: by admin.

Re: Sandbox Error 22 Sep 2012 17:28 #3856

  • JoomGuy
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
I think you have 2 fields in your employees table called address according to your error "... `address` VARCHAR(30) , ..."
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!
The following user(s) said Thank You: sdm7001

Please Log in or Create an account to join the conversation.

Re: Sandbox Error 22 Sep 2012 17:36 #3858

  • sdm7001
  • sdm7001's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 20
  • Thank you received: 0
Thanks again!

Please Log in or Create an account to join the conversation.

Re: Sandbox Error 23 Sep 2012 04:25 #3871

  • VeCrea
  • VeCrea's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Absolute JCook fan
  • Posts: 473
  • Thank you received: 100
Don't forget about profile plugin, native joomla plugin that allows to extend the user infos.
www.inmotionhosting.com/support/edu/joom...profile/view-profile
It has been requested that cook integrates this one.
www.j-cook.pro/forum/12-new-functionalit...-profile-plugin#3790
Or you can go further with this :
docs.joomla.org/Creating_a_profile_plugin

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.085 seconds

Les générateurs de code je les connais presque tous pour les avoir essorés en long en large et en travers ... mais celui ci c'est vraiment un outil formidable de simplicité et d'efficacité !
Marc. (liubov - Forum)

Get Started