♥Chris Perkins Posted January 16, 2006 Posted January 16, 2006 I think I've managed to sort out the last problem I had. I've now setup a download product. To test this, I logged on , bought it (paid with cheque) and then via admin I confirmed it as 'sent'. When I log into my test account, I get no link to the product, just this: Download links Test eBook Link expires: Monday 23 January, 2006 5 downloads remaining Any ideas?
Guest Posted January 16, 2006 Posted January 16, 2006 The file must actually be present in your download directory - the order status must be 'delivered' :) Matti
♥Chris Perkins Posted January 16, 2006 Author Posted January 16, 2006 The file is there alright. I don't have a status called 'delivered' so I'll add one now and have a play...
♥Chris Perkins Posted January 16, 2006 Author Posted January 16, 2006 ...OK, setup a new status called 'delivered', bought something, changed it to 'delivered' but it has no effect. There is still no link. Are the order status names simply names, or does the 'delivered' status have to be special in some way so that the system knows to display the link when marked as 'delivered'?
♥Chris Perkins Posted January 16, 2006 Author Posted January 16, 2006 Ignore me!!! Problem solved, I'd spelt the bloody filename of the product a little wrong! I shall slowly slip away in embarrassment now..
osmacguy Posted April 2, 2007 Posted April 2, 2007 Ignore me!!! Problem solved, I'd spelt the bloody filename of the product a little wrong! I shall slowly slip away in embarrassment now.. what path did you use? did you use : https:// or http://www. or just www. ??? i have tried every file name and type under the sun now and mine still cant be clicked on to access the download!!!
osmacguy Posted April 3, 2007 Posted April 3, 2007 what path did you use? did you use : https:// or http://www. or just www. ??? i have tried every file name and type under the sun now and mine still cant be clicked on to access the download!!! ok after 11 hours.... do not put in the full path eg... http//:www.yoursite.com/catalog/downloads/thisbloodyfile.zip just put thisbloodyfile.zip in the product attributes bit! and itll work. but then i have this problem 1054 - Unknown column 'o.order_status' in 'where clause' select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, opd.download_count, opd.download_maxdays, opd.orders_products_filename from orders o, orders_products op, orders_products_download opd where o.customers_id = '3' and o.orders_id = '44' and o.order_status = '3' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '45' and opd.orders_products_filename != '' [TEP STOP] any ideas?
mbuswell Posted May 18, 2007 Posted May 18, 2007 1054 - Unknown column 'o.order_status' in 'where clause' [TEP STOP] any ideas? The order_status process I am not sure if that is standard as I read in one of the download contributions - this works on any site that has the new order status - in any case not to confuse, have a look at the ORDERS table using sql and see if you have the column order_status in that table. If not then you will need to find the right contribution and add it. Sorry I cannot point you to the exact contribution, but hopefully you will be able to see if you have a problem or not. When you do get the order_status in, besure to set the download configuration correctly. the download link will only show if the order's status matches the Downloads Controller Order Status Value which is configurable in the Download section of the store administration. This is the value that says when an order is set to this status allow them to download - ie: if the person has paid and has a status of paid, they get to download.
jd1234 Posted August 19, 2007 Posted August 19, 2007 ALSO -- if you're STILL having problems getting the download link to show up (like i was), i finally realized that the download link will ONLY show if you added the products to the shopping cart from the products DETAIL page. it will NOT work if you use the "buy now" from the product listing page. there may be a contribution for adding the product options to the listing page, which i believe is what you will have to do to get it to work from there.
Guest Posted September 4, 2007 Posted September 4, 2007 ALSO -- if you're STILL having problems getting the download link to show up (like i was),i finally realized that the download link will ONLY show if you added the products to the shopping cart from the products DETAIL page. it will NOT work if you use the "buy now" from the product listing page. there may be a contribution for adding the product options to the listing page, which i believe is what you will have to do to get it to work from there. I followed all the advice in this thread and I still don't see a Download link at the end of the checkout. Where is the "products DETAIL page" exactly? I have looked for it and I don't see it.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.