PWA 1054 error

[Guest]

I recently installed PWA according to the instructions, but I get this error upong checking out:

 

1054 - Unknown column 'purchased_without_account' in 'field list'

 

select customers_id, purchased_without_account, customers_firstname, customers_password, customers_email_address, customers_default_address_id from customers where upper(customers_email_address) = 'ASFASDF@ASDSDF.COM' and upper(customers_firstname) = 'ASD' and upper(customers_lastname) = 'ASDF'

 

[TEP STOP]

 

Not sure where to go from here. Apparently there's a missing field somewhere, but where? Once I find out where, then what?

 

Thanks,

Carl

[mpmeadows]

I recently installed PWA according to the instructions, but I get this error upong checking out:

 

1054 - Unknown column 'purchased_without_account' in 'field list'

 

select customers_id, purchased_without_account, customers_firstname, customers_password, customers_email_address, customers_default_address_id from customers where upper(customers_email_address) = 'ASFASDF@ASDSDF.COM' and upper(customers_firstname) = 'ASD' and upper(customers_lastname) = 'ASDF'

 

[TEP STOP]

 

Not sure where to go from here. Apparently there's a missing field somewhere, but where? Once I find out where, then what?

 

Thanks,

Carl

<{POST_SNAPBACK}>

 

 

 

Hello Carl,

I see there was no reply to your post. Where you able to solve this issue? because I am getting the same error after installing PWA contrib.

TIA.

mm

[wheeloftime]

This most likely means you have not imported this SQL statement in your database

ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id;

and/or this

ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL;

 

For PWA 0.82 these are mentioned in step 3 of the installation instructions

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;

 

HTH

[mpmeadows]

That fixed the problem.

Thank you.