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.086 seconds

Awards for the best Joomla app. This product is gonna win an award for this amazing job. Cook Self Service is the the best application from all over the Joomla universe ! It brings Joomla to a professional level really advanced for developers. It is a real fun to develop with it. The ACL part and security checks implementation are just... so much hours saved. I can now concentrate myself more on the design part and the creative works. Thank you so much. Guys I offer you all my congratulation ! Keep up the works because Joomla is needing it to increase the quality of extensions availables on the JED. I also learned a lot because I can see how to code at the proper place and I found all my answers reading the forum.
lack_hanson (JED)
          

Get Started