Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

need no account !!! need sum help


sinryder

Recommended Posts

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...