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

Freakin' Awesome!!! J-Cook is simply awesome - whether you're a highly experienced developer or complete novice whether you're building a small inventory component or a complete community solution! The beauty comes from a fast slick and reliable platform that readily provides developers with everything they'll need to build the backbone of a solid and secure component with wizards for authoring access publishing aliasing created/modified by dates... you name it COOK provides it! J-Cook really surpasses all of the 'competition' as far as MVC tools are concerned! Try love it and get cooking!
learnthrusong (JED)
          

Get Started