I’ve just recently began a project using osCommerce and needed to streamline the checkout process. I wanted to allow the purchaser the options of navigating directly to payment, instead of having to first login or create an account. I found the osCommerce contribution “Purchase Without Account” to be the answer:
http://www.oscommerce.com/community/contributions,355/page,8
Downloading and installing v2.2rc.2a was simple enough. However, the following error was thrown when attempting a login:
Unknown column ‘customers_block’ in ‘field list’
My initial fix for this was to open the login.php file and edit the following line:
select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, customers_block, guest_account from ” . TABLE_CUSTOMERS . ” where customers_email_address = ‘” . tep_db_input($email_address). “‘ and guest_account=’0’
All I ended up doing was remove the the filed “customers_block” from the query above. Since I see this field name/parameter nowhere in the osCommerce catalog and because it’s nowhere to be found in any of the sql update files of the contribution, I’m thinking it should do the trick.