Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

"Experienced" member can't get downloads to work


realpascal

Recommended Posts

Damn. First time I've had to ask for help, but here it goes:

The download link doesn't appear for downloadable products.

 

Admin:

Enable download :true   
Download by redirect :true   (Unix host)
Expiry delay (days) :7   
Maximum number of downloads: 3  

Catalog:

download and pub dirs are catalog/download and catalog/pub

configure.php:
define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
 define('DIR_FS_CATALOG', '/home/domain/mydomain.co.uk/html/shop/catalog/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

From the source after checkout:

<!-- downloads //-->
<!-- downloads_eof //-->

 

What am I missing here ? Filename I used is zoe.zip

Link to comment
Share on other sites

Have you properly set the product attributes? A problem I had right away when setting up downloads: filename of download not in proper case. If the filename is uppercase/lowercase/mixed, so must it be in the attributes. Also make sure there are no spaces in the filename in attributes or the actual file in your downloads directory.

 

Staci

Link to comment
Share on other sites

download dir is 755 pub is 777

must have a product

must use product attributes, with a file assigned to the attribute

i use the download controller most times, however the default download app works well

must set status to updated/delivered once payment received

Link to comment
Share on other sites

Have you properly set the product attributes? A problem I had right away when setting up downloads: filename of download not in proper case. If the filename is uppercase/lowercase/mixed, so must it be in the attributes. Also make sure there are no spaces in the filename in attributes or the actual file in your downloads directory.

 

Staci

Yes, product attribs set, only used lower case..

filename plain and simple: zoe.zip

 

Any other suggestions ?

Link to comment
Share on other sites

download dir is 755 pub is 777

must have a product

must use product attributes, with a file assigned to the attribute

i use the download controller most times, however the default download app works well

must set status to updated/delivered once payment received

 

755 and 777 - check

product zoe.zip in download - check

attribute used: check

attribute filename: zoe.zip - check

order status: delivered - check

 

Module you suggested looks great.. but I gotta have this one working first.

Any other suggestions ? :thumbsup:

Link to comment
Share on other sites

look in your server log files, also you can enable sql logging in the admin area  of the store

I've set the SQL logging, but it looks like Chinese to me:

 cd.categories_name, 
                                              c.parent_id 
                                       from categories c, 
                                            categories_description cd 
                                       where c.parent_id = '0' and 
                                             c.categories_id = cd.categories_id and 
                                             cd.language_id='1'
             and sort_order >0 
                                       order by sort_order, cd.categories_name
RESULT Resource id #58 
QUERY select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '29' and pd.products_id = p.products_id and pd.language_id = '1'
RESULT Resource id #64 
QUERY select specials_new_products_price from specials where products_id = '29' and status = '1'
RESULT Resource id #67 
QUERY select products_id, products_price, products_tax_class_id, products_weight from products where products_id = '29'
RESULT Resource id #70 
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '150') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #73 
QUERY select specials_new_products_price from specials where products_id = '29' and status = '1'
RESULT Resource id #76 
QUERY select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '29' and pd.products_id = p.products_id and pd.language_id = '1'
RESULT Resource id #81 
QUERY select specials_new_products_price from specials where products_id = '29' and status = '1'
RESULT Resource id #84 
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '150') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #87 
QUERY select products_id, products_price, products_tax_class_id, products_weight from products where products_id = '29'
RESULT Resource id #90 
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '150') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #93 
QUERY select specials_new_products_price from specials where products_id = '29' and status = '1'
RESULT Resource id #96 
QUERY select startdate, counter from counter
RESULT Resource id #104 
QUERY update counter set counter = '995'
RESULT 1 
QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50'
RESULT Resource id #109 
QUERY select count(*) as total from sessions where sesskey = '1d7d6bb9c8a6f38d3387d03bd49563f5'
RESULT Resource id #113 
QUERY update sessions set expiry = '1125909688', value = 'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:1:{i:29;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:2;s:6:\"weight\";d:0;s:6:\"cartID\";s:5:\"91710\";s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:5:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:2:\"21\";}s:4:\"post\";a:0:{}}i:2;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:5:\"21_22\";}s:4:\"post\";a:0:{}}i:3;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:2:\"29\";s:6:\"action\";s:11:\"add_product\";}s:4:\"post\";a:3:{s:11:\"products_id\";s:2:\"29\";s:1:\"x\";s:2:\"31\";s:1:\"y\";s:2:\"25\";}}i:4;a:4:{s:4:\"page\";s:17:\"shopping_cart.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}customer_id|s:1:\"2\";customer_default_address_id|s:1:\"2\";customer_first_name|s:6:\"Pascal\";customer_country_id|s:3:\"150\";customer_zone_id|s:1:\"0\";' where sesskey = '1d7d6bb9c8a6f38d3387d03bd49563f5'
RESULT 1 
QUERY select value from sessions where sesskey = '1d7d6bb9c8a6f38d3387d03bd49563f5' and expiry > '1125908249'
RESULT Resource id #16 
QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
RESULT Resource id #20 
QUERY select customers_firstname, customers_lastname from customers where customers_id = '2'
RESULT Resource id #27 
QUERY delete from whos_online where time_last_click < '1125907349'
RESULT 1 
QUERY select count(*) as count from whos_online where session_id = '1d7d6bb9c8a6f38d3387d03bd49563f5'
RESULT Resource id #32 
QUERY update whos_online set customer_id = '2', full_name = 'Pascal IJssermans', ip_address = '80.126.187.158', time_last_click = '1125908249', last_page_url = '/shop/catalog/checkout_shipping.php' where session_id = '1d7d6bb9c8a6f38d3387d03bd49563f5'
RESULT 1 
QUERY select banners_id, date_scheduled from banners where date_scheduled != ''
RESULT Resource id #42 
QUERY select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id
RESULT Resource id #45 
QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
RESULT Resource id #49 
QUERY select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, co.countries_id, co.countries_name, co.countries_iso_code_2, co.countries_iso_code_3, co.address_format_id, ab.entry_state from customers c, address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries co on (ab.entry_country_id = co.countries_id) where c.customers_id = '2' and ab.customers_id = '2' and c.customers_default_address_id = ab.address_book_id
RESULT Resource id #56 
QUERY select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '2' and ab.address_book_id = '2'
RESULT Resource id #59 
QUERY select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '2' and ab.address_book_id = '0'
RESULT Resource id #62 
QUERY select ab.entry_country_id, ab.entry_zone_id from address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) where ab.customers_id = '2' and ab.address_book_id = '2'
RESULT Resource id #65 
QUERY select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '29' and pd.products_id = p.products_id and pd.language_id = '1'
RESULT Resource id #68 
QUERY select specials_new_products_price from specials where products_id = '29' and status = '1'
RESULT Resource id #71 
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '150') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #74 
QUERY select tax_description from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '150') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' order by tr.tax_priority
RESULT Resource id #77 
QUERY select products_id, products_price, products_tax_class_id, products_weight from products where products_id = '29'
RESULT Resource id #80 
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '150') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #83 
QUERY select specials_new_products_price from specials where products_id = '29' and status = '1'
RESULT Resource id #86 
QUERY select c.categories_id, 
                                              cd.categories_name, 
                                              c.parent_id 
                                       from categories c, 
                                            categories_description cd 
                                       where c.parent_id = '0' and 
                                             c.categories_id = cd.categories_id and 
                                             cd.language_id='1'
             and sort_order >0 
                                       order by sort_order, cd.categories_name
RESULT Resource id #94 
QUERY select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '29' and pd.products_id = p.products_id and pd.language_id = '1'
RESULT Resource id #100 
QUERY select specials_new_products_price from specials where products_id = '29' and status = '1'
RESULT Resource id #103 
QUERY select products_id, products_price, products_tax_class_id, products_weight from products where products_id = '29'
RESULT Resource id #106 
QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '150') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '1' group by tr.tax_priority
RESULT Resource id #109 
QUERY select specials_new_products_price from specials where products_id = '29' and status = '1'
RESULT Resource id #112 
QUERY select entry_firstname as firstname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from address_book where customers_id = '2' and address_book_id = '2'
RESULT Resource id #119 
QUERY select address_format_id as format_id from countries where countries_id = '150'
RESULT Resource id #122 
QUERY select address_format as format from address_format where address_format_id = '1'
RESULT Resource id #125 
QUERY select countries_name from countries where countries_id = '150'
RESULT Resource id #128 
QUERY select zone_code from zones where zone_country_id = '150' and zone_id = '0'
RESULT Resource id #131 
QUERY select startdate, counter from counter
RESULT Resource id #138 
QUERY update counter set counter = '996'
RESULT 1 
QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50'
RESULT Resource id #143 
QUERY select count(*) as total from sessions where sesskey = '1d7d6bb9c8a6f38d3387d03bd49563f5'
RESULT Resource id #147 
QUERY update sessions set expiry = '1125909689', value = 'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:1:{i:29;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:2;s:6:\"weight\";d:0;s:6:\"cartID\";s:5:\"91710\";s:12:\"content_type\";s:8:\"physical\";}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:6:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:2:\"21\";}s:4:\"post\";a:0:{}}i:2;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:5:\"21_22\";}s:4:\"post\";a:0:{}}i:3;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:2:\"29\";s:6:\"action\";s:11:\"add_product\";}s:4:\"post\";a:3:{s:11:\"products_id\";s:2:\"29\";s:1:\"x\";s:2:\"31\";s:1:\"y\";s:2:\"25\";}}i:4;a:4:{s:4:\"page\";s:17:\"shopping_cart.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:5;a:4:{s:4:\"page\";s:21:\"checkout_shipping.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}customer_id|s:1:\"2\";customer_default_address_id|s:1:\"2\";customer_first_name|s:6:\"Pascal\";customer_country_id|s:3:\"150\";customer_zone_id|s:1:\"0\";sendto|s:1:\"2\";cartID|s:5:\"91710\";' where sesskey = '1d7d6bb9c8a6f38d3387d03bd49563f5'
RESULT 1

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...