Can't get downloads to work

[bico959]

I just can't seem to get digital products to show a dowload availability. Can anyone help?
http://www.irebuildmarantz.com:82/catalog

happy to give admin credentials if that helps.
gladly give company credit to anyone willing to take this one on!
Thanks,
Rob

[bico959]

Please, someone? I've gone through the code as best i can, i'm versed with poking around in MySQL enough to check suggestions... I really want to get this going. Maybe someone could point me in the right area to look. Here is what i have:

i never get the download controller ever. i never see a download now button or anything like it. I can't find where download.php is even ever called.

Aren't you supposed to be able to go to your order history and pull up the item that is downloadable that you purchased? I can't get this ever. I checked that the files are available and they are. There are green checks alowing download for every option, still nothing... The DL section shows them in the drop down menu. I have the date at 7 days and the max downloads at 100. Nada...

PLEASE HELP!!!

[bico959]

Well, thanks for all the help </sarcasm> but i found the problem by looking at configurethat.com's test site

Turns out you must have at least one option created in products atributes or no downloads!! The dl doesn't even come up otherwise.

I've included a screen shot of what i did to get the downloads to work:
www.irebuildmarantz.com/SP32-20090712-120719.jpg

Hope this helps others... Cheers! Rob

[jpf]

<sarcasm>Sending you the support billing in the mail!</sarcasm>

Thanks for posting back that you found the solution and what is was.

Free PEER to PEER support only work if other user actually help. Micheal and myself are only two people of the may excellent people here that provide FREE help. I can only HELP and answer so many. Yes I saw your help request - I created a DOWNLOAD item in the DEMO site because of your posting.... But time slipped and did not get around to answering everyone.


Feel free to answer any other recent request/questions that you may be able to help with.

[bico959]

<sarcasm>Sending you the support billing in the mail!</sarcasm>

Thanks for posting back that you found the solution and what is was.

Free PEER to PEER support only work if other user actually help. Micheal and myself are only two people of the may excellent people here that provide FREE help. I can only HELP and answer so many. Yes I saw your help request - I created a DOWNLOAD item in the DEMO site because of your posting.... But time slipped and did not get around to answering everyone.


Feel free to answer any other recent request/questions that you may be able to help with.

looks like it's stuck in the system...

[pgmarshall]

I too have tried to test this through my demo store.

Oddly I am now getting this sql error when I try to add the Product Attribute ...

1136 - Column count doesn't match value count at row 1

insert into products_attributes values (null, '112', '2', '10', '0', '+')

[TEP STOP]

... although I don't get this using the excellent AJAX bit in the product page. (probably me fiddling with something - ooops!)

I also get a problem if the price of the item is set to zero as it keeps looping me back to the payment information page to select the payment method. (Goes through fine at £0.01)

I have tried this in jpfs demo store but the payment page is blank - html source stops staight after the <!-- Content --> flag ...

So, unfortunately I am unable to help too much with your problem - but we do try - it just takes a while!

regards,

[pgmarshall]

Right! After a bit of googling the TEP error can be fixed like this ...

Find in admin/products_attributes

tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values (null, '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . (float)tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')");

and replace with

tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . "(products_id, options_id, options_values_id, options_values_price, price_prefix)values ('" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')");

I have no idea what this does differently - but it does get rid of the problem.

Hope this helps someone,

Regards,

[pgmarshall]

So, now I have managed to load a fresh download product ...

It seems to work fine for me. I have loaded a test product here.

Checkout through Check/Money Order.

I get the warning at the bottom saying:

NOTE: Downloads are not available until payment has been confirmed

Once the order is confirmed - I go into my account and View the order - I can see the download button and it works. Screenshot here.

So unfortunately it would appear that there is a bug in your install rather than the source code.

Have you checked that the product has: a start date, a stock level, zero weight, length, width, height? Without these it may not work.

Have you been into catalog --> Products Attributes and

1) added a product option eg. Download
2) added a option value eg. file, pdf, documentation, etc.
3) added a product attribute eg. Download, pdf, +£2.50
4) make sure you fill in the download file name in the box at the bottom.
5) make sure you have uploaded the file to the Download folder in the catlog folder.

Confirm you have done all this and then post back if you are still struggling and I will see if I can have a look through your admin.

Good luck,

Regards,

[jpf]

Submit to bug tracker!!!!

As in PLEASE submit it as .....

[bico959]

now if someone can answer the question of what i have to do to get the paypal to work... it appears that cURL is my problem? i've loaded the dll's and enabled the cURL setting in php.ini... error. I'm running easyPHP1.8. Anyone know if this is fixed in easyPHP3?

suggestions, ideas, etc. Thanks!

I appreciate it!
Cheers! ~RB