sinryder Posted June 21, 2004 Posted June 21, 2004 hello every one , i am trying to install PWA_0.71 contribution so the buyers will have a choice of checking out with out the account. i have gone through with all the steps but this is where i am having lil difficutly. STEP 3:Go into your server's backend and use a SQL tool such as PHPMYADMIN to run the following SQL scripts. Make sure you have backed up your database first: ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id; ALTER TABLE customers ADD INDEX (purchased_without_account); INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1); INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON','true','Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; now what i am doing is adding this in phpmyadmin - SQL - this is the code i am entring in SQL ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id;ALTER TABLE customers ADD INDEX (purchased_without_account); INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1); INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON','true','Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; and this is the error i am getting Error SQL-query : ALTER TABLE customers ADD purchased_without_account TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id MySQL said: #1060 - Duplicate column name 'purchased_without_account' any help is greatly appreciated thankyou
Recommended Posts
Archived
This topic is now archived and is closed to further replies.