NOTE: Downloads are not available until payment has been confirmed

Ajeh:

There isn't any shipping on Downloads and when setup correctly, you do not see the checkout_shipping page ...

What is the specific products_id to this product that failed and you saw just the 43 on the products_prid?
it is on https://www.koboldquarterly.com, product id 43, this product:
http://www.koboldquarterly.com/KQStore/index.php?main_page=product_info&cPath=2&products_id=43

However, this is not the only products that behave like this just the ones I have a reference to right now.

Also, the product is set up with:
Product is Virtual: No, Shipping Address Required
Always Free Shipping: No, Normal Shipping Rules

Thanks,
Bill

This product has dice plus the download ... how do you propose to give them the dice if you do not get a shipping address? :unsure:

Ajeh:

This product has dice plus the download ... how do you propose to give them the dice if you do not get a shipping address? :unsure:
I have no idea. It is not my store. However, more importantly, does it matter? If it does, I can change the settings to whatever you think will solve the original problems.

To return to the original questions:

1. "NOTE: Downloads are not available until payment has been confirmed". Can we "confirm" the paypal transaction and thus get ZenCart to allow the download? If so, how?

2. When the MAXDAYS is set to 0, why do e-checks once they clear set to some number of days and auto-expire instead of setting to 0? Can we force it to behave properly?

Thanks,
Bill

So, tracking the message to tpl_modules_downloads.php I find this bit of code:

// download is not available yet
if ($downloads_check_query->RecordCount() > 0 and $downloads->RecordCount() < 1) {
?>
 <fieldset><?php echo DOWNLOADS_CONTROLLER_ON_HOLD_MSG ?></fieldset>
<?php
}

What I see looking at the SQL is that there is no easy way to tell the system "Yes, it is confirmed and you should allow the download".

I will continue to dig.

Bill

O.k. So looking over the sequel closely it looks like the orders_products_id need to match up. Looks like the orders_products_id in ORDERS_PRODUCTS = 2696 while in ORDERS_PRODUCTS_DOWNLOAD = 2718....
hmm, that may be it. They seem to need to be the same to allow the $downloads to be greater than 0...

I will check with the user.

So, for the "NOTE: Downloads are not available until payment has been confirmed" the above worked. I am not sure it would be a general solution but the location of the condition combined with the SQL statements tied to it is the key. If you have similar problems look at the SQL and the conditions it checks.

Now, try and figure out why in the world the e-check was implemented as it was for downloads and how to fix it.

Thanks,
Bill