Download link

[petelphil]

Hi all,

 

Can anyone help? We have set up OsCommerce 2.2-MS2 on Linux processing payment through Secure Hosting to allow downloads of video files (.mov and .m4v). It was all working fine until a couple of days ago. Now when we put through a transaction the download text appears, but no link to the downloadable file.

 

Download is enabled

Download by redirect disabled

The product attributes are set up and file permissions on PUB and DOWNLOADS are set to 777 and 755 respectively and those permissions have been applied to the file contents but still the link doesn't show. Been pulling my hair out for two days now. Please help...

 

Thanks

 

Phil

[osmacguy]

Hi all,

 

Can anyone help? We have set up OsCommerce 2.2-MS2 on Linux processing payment through Secure Hosting to allow downloads of video files (.mov and .m4v). It was all working fine until a couple of days ago. Now when we put through a transaction the download text appears, but no link to the downloadable file.

 

Download is enabled

Download by redirect disabled

The product attributes are set up and file permissions on PUB and DOWNLOADS are set to 777 and 755 respectively and those permissions have been applied to the file contents but still the link doesn't show. Been pulling my hair out for two days now. Please help...

 

Thanks

 

Phil

 

this is a very common problem as i have spent 2 days now trying to solve it. i get the filename come up but you cant click it to download it. it worked a few weeks ago. so why not now? i uploaded the real files as before it was one test file and nothing works. no one seems to have a clue. its gettin pretty lame now :(

and if people solve it, post how u did it!!!!!

[osmacguy]

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?

[jd1234]

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.

[baker010]

i also have

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '25'

 

[TEP STOP]

 

on 2 of 3 links, can anyone help me??