Don't understand something in PWA

[Lao]

Hi all!

 

I'm having trouble understanding how to solve this thing. As I'm noob at this, I don' know where to start.

 

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!!!

EITHER:

Run the included sql file pwa_install.sql

OR:

Manually run this script:

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;

 

 

This is STEP 4 from Gr8sale's PWA add-on.

 

I don't know how to work with PHPMyadmin. Any other solutions? How do I make the changes manually (step by step) ?

 

Thanks.

[Guest]

um, you need to access your sql database, using whichever software your host provides. phpMyAdmin is the most popular piece of kit, and if you have this, then it is incredibly easy to use - simply go into it, and at the top of your screen you will see a row of tabs across the page. One of them is called SQL - click this, then copy and paste

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;

straight in, and click go. You're away!

[Lao]

With the risk of sounding stupid, but I really don't know how to use phpMyAdmin. :((

 

I downloaded the "last stable version" from phpmyadmin.net and from then on... ??

[Guest]

With the risk of sounding stupid, but I really don't know how to use phpMyAdmin. :((

 

I downloaded the "last stable version" from phpmyadmin.net and from then on... ??

 

is myphpadmin not installed as part of your hosting control panel?

 

I would be v careful about installing myself, i know some hosts may not be happy..

[custodian]

With the risk of sounding stupid, but I really don't know how to use phpMyAdmin. :((

 

I downloaded the "last stable version" from phpmyadmin.net and from then on... ??

 

Yes, unless this is YOUR personal server I wouldn't install anything, contact your host (or look at their help pages), it (or smething like it) should be available to you to use.

[Lao]

I seems I had phpMyAdmin installed.

 

I did the text inserting just like in PWA instructions (and modified all the files mentioned in instructions), but it didn't change anything. It still redirects me to the Signup page when I try to buy something. What am I doing wrong?

[matrix2223]

PWA uses the create_account.php page to get the customers shipping info and does not require them to create a password. To use myphpAdmin login in to your database click the SQL tab on the top of the page, then you will see a large text box and a small txt box, to run the script click browse, point to the sql file that PWA came with then click GO or RUN. After your database has ran you will see at the top of the page My SQL inserted __ tables. If you inserted all of the code that was required go to ur site click checkout there you should see 3 boxes on the login.php page use the bottom checkout button. There you will see all of the changes.

 

Hope this helps