Purchase Without Account install??

[dragon5]

The install instructions say:

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;


Where exactly does this need to be installed to?? Root?
Database *****_osc4 running on localhost??
Never had the need for phpmyadmin until now. I don't have a clue!
Thanks
d5

[bleu]

Open PHPMYADMIN in your browser, if you have access to it. Click on the database you have installed for your store to select it.

Click on the SQL link. A text field form will be available. Paste the code in the box and click the GO button.

This will install and/or alter the tables in the proper location.

[bleu]

If you are asking where to install PHPMYADMIN, here is a basic tutorial that will walk you throught the steps.

http://www.ubbcentral.com/resources/PhPMyAdmin.html

[michael_s]

Or you can execute the above mysql commands from an SSH session on your server (if you have access).

From the command prompt, type: mysql and hit enter.

Then type : use *****_osc4 and hit enter (*****_osc4 is the name of your database)

Then type each of the above commands, one to a line and hit enter after each one.

[red_fraggle]

If you are running PLESK on your host, login to plesk, click the domain the database is on, click "databases", click the database in question from the list, click "DBwebadmin", this starts PHPMyadmin, once it loads, click the database name on the left navigation panel, click "SQL", click "browse" and select the SQL file your trying to insert. Make sure to backup your DB first.