error code on checkout_success.php-page

[sami]

I'm having this problem with catalog. Basic idea is to offer only downloadable products for customers. Therefore I have installed "free shipping" and "free download"-modules.

 

Now I'm getting this error code (which you can see below). And this one comes when customer reaches /checkout_success.php -page..

 

So basicly customer should be able to download the product he/she just has bought but now he/she can't..

 

Have I forgot to update MySQL-base or what is the problem?

 

Thanks for your help.

 

Sami

 

and here's the code I'm getting:

 

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



SELECT DATE_FORMAT(DOWNLOAD_AVAILABLE_DATE, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays FROM orders o, orders_products op, orders_products_download opd WHERE customers_id = '6' AND o.orders_status >= DOWNLOADS_AVAILABLE_STATUS AND o.orders_id = '6' AND op.orders_id = '6' AND opd.orders_products_id=op.orders_products_id AND opd.orders_products_filename<>''



[TEP STOP]

[Guest]

Verify the the entry within the mysql database table for this item. I have a feeling something is misspelled. Sometimes this happens when doing manual insertions into the database.

 

-Good Luck.

 

-R

[Bondo]

I'm bumping this thread to the top again because I encountered the same error message. It appears at the top of my account_history_info.php page.

 

I can successfully follow through the checkout process when I test my store, but the download isn't available for me to download anywhere.

 

What am I missing?

 

Bondo