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.

Incoming search terms:

• 1054 - unknown column c customers_payment_allowed in field list
• Account & Purchase database
• customers_default_address_id
• download purchase without account oscommerce
• inurl:oscommerce/catalog
• oscommerce custome create account without database changes
• oscommerce unknow database

Related posts:

1. Increase Number of Joomla Home Page Items
2. MySQL Search Across Columns with Concat