Need help w. "Purchase without Account contrib"

[jcisar]

:blink:

Im in the process of installing the Purchase without Account contributions (pwa_v.082) and need some direction.

Im unfamiliar with installing MYSQL scripts and have never dabbled in the MYSQL backend before.

STEP 3 of the PWA v.082 installation instructions directs that one " go into the servers backend and use a SQL tool such as PHPMYADMIN to run the following scripts. "

I do have PHP MYADMIN, but dont know how to use it.

How would I install the following scripts? :

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 already have a user account setup.

 

Thanks,

jcisar

[Guest]

get into phpmyadmin, make sure you select the database used for your application, and then click on sql, copy and paste the code from the file or browse to it then click go . ..

[jcisar]

get into phpmyadmin, make sure you select the database used for your application, and then click on sql, copy and paste the code from the file or browse to it then click go . ..

<{POST_SNAPBACK}>

 

Thanks for the prompt reply.

Am I supposed to leave the "SELECT * FROM WHERE 1" in the query window, or should it be removed?

[Guest]

remove that. or down below you can click on browse to the file and it will insert it.

[jcisar]

remove that.  or down below you can click on browse to the file and it will insert it.

<{POST_SNAPBACK}>

 

I paste the script in the query box, and hit go. But nothing happens, as if it is locked. What should I expect to see once I submit the script?

 

jcisar