1054-Unknown column 'guest_account' in 'where clause'

[consultpci2]

Setting up v 2.1, upon trying to buy a product on my site I get the following error, 1054-Unknown column 'guest_account' in 'where clause' select count(*) as total from customers where customers_email_address = 'consultpci2@msn.com' and guest_account!='1' any ideas anyone.

[michael_s]

You need to run the PWA sql. The latest update has PWA installed, but the sql is not committed in the installer:

ALTER TABLE `customers` ADD COLUMN `guest_account` TINYINT NOT NULL DEFAULT '0' AFTER `customers_newsletter`;

ALTER TABLE `customers` MODIFY COLUMN `customers_password` VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE `orders` ADD COLUMN `customers_dummy_account` TINYINT UNSIGNED NOT NULL AFTER `customers_address_format_id`;