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

TOPIC:

[CLOSED] Duplicate column name in DB 08 Dec 2011 01:58 #678

  • patlee
  • patlee's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 1
  • Thank you received: 0
Hi

Trying out COOK but I receive the following error when I download the component and install it ( on Joomla 1.7 localhost )

JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'cop' SQL=CREATE TABLE IF NOT EXISTS `mjh_abccopipschools_cutoffpointstable` ( `id` int(11) NOT NULL auto_increment, `params` text NOT NULL default '', `school` VARCHAR(80) , `cop_band` VARCHAR(15) , `median_tscore_year` VARCHAR(15) , `mean_cop` INT(11) , `cop` INT(11) , `cop_1` INT(11) , `cop` INT(11) , `cop_2` INT(11) , `projected_cop` INT(11) , `ip_batch_year` VARCHAR(18) , `programme` VARCHAR(60) , `more_info` TEXT , PRIMARY KEY (`id`) );
SQL =

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

Duplicate column name in DB 08 Dec 2011 20:35 #682

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
You have the field 'cop' which exist in double !!!

How did you do this ??
Cook is protected against this. It should not hapens !

Means also this issue in the sandbox, no ?

Well.
Return to the builder an remove the concerned field.

Regenerate.
Coding is now a piece of cake

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

Last edit: by admin.
  • Page:
  • 1
Time to create page: 0.071 seconds

I've evaluated lots of other Joomla Component Dev tools such as Shell Manager (J)enesis Danny's Joomla! 1.5 MVC Component Code Generator Marco's Component Maker and I must admit that I love what I see on your site! Lots of potential... Otherwise Great Job and keep up the good work!!!
Clifton (forum)

Get Started