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

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started