Welcome, Guest
Username: Password: Remember me

TOPIC: [CLOSED] Duplicate column name in DB

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

  • patlee
  • patlee's Avatar
  • Offline
  • New Member
  • Posts: 1
  • Karma: 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 =
The administrator has disabled public write access.

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

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
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
Last Edit: 08 Dec 2011 20:38 by admin.
The administrator has disabled public write access.
Time to create page: 0.064 seconds

Get Started