Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help installing module with phpmyAdmin?


rockstar

Recommended Posts

Posted

hi, i'm trying to install the module "purchase without account v0.71" and in the installation instructions, it tells me to do this:

 

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;

 

I have phpmyadmin installed and functioning on my server, but am unfamiliar with mysql or really even php for that matter. can someone tell me how do i carry out these instructions please? do i click on the table name "customers" then just cut and paste these codes somewhere? one at a time?

 

thanks for the hand-holding.

Posted

Golden Rule: Before adding any contributions always backup everything, especially if the database if you are making modifications there. Search the forums for help backing up your database.

 

With that said, you will need to go to phpmyadmin and select your database on the left side. Then go to the SQL tab, copy those lines of code, paste them into the little text box there, and click ok. All done.

Archived

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

×
×
  • Create New...