Hi all,

I intend to sell software products with Drupal5/e-commerce3.0 but for some reason I can't get the file download to work once the payment has been processed and accepted by Paypal.

Once the transaction has been approved by Paypal, I can click on the "Return to merchant" button, which
brings me to the "Order History" node where I can see that my payment has the following status:

payment status = completed
workflow = completed

I then clicked on the "My files" menu to retrieve the download I had just bought, but unfortunately there is nothing to be downloaded at this location.

Question 1: Am I right to expect to find my download under the "My Files" menu?

Question 2: I have stored the file in question in the directory specified under:
Home » Administer » Site configuration » File System (using public download method)
Is this correct?

Question 3: In Home » Administer » E-Commerce configuration
I specify the same directory as in question 2.
Is this correct?

Anybody has any idea why I can't see my file ?

Thanks in advance for any suggestions.
Michel

CommentFileSizeAuthor
#7 file.module.txt20.2 KBesadot
#5 file.diff1.76 KBesadot
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

WisTex’s picture

I have the same problem. I am not suing PayPal however, but still, after completing a transaction, there appears to be no way to download the purchased file.

The problem also exists in 5.x-3.0-dev

Matt-H’s picture

I faced this same problem with COD and CCard: http://drupal.org/node/146808

This issue I think is related to (or the same) as this one: http://drupal.org/node/138013 It it, aaron talks about a way he got around it:

after upgrading from 4.7 to 5.x-3.0 on a production site, my/files returns an empty page. after examining the query & tables for that view, i discovered that the {ec_recurring_expiration} table is empty, even after creating a new transaction. a manual query returns the files properly if i remove JOIN {ec_recurring_expiration} ere ON ere.vid = etp.vid AND ere.txnid = etp.txnid from the query.

Doing what aaron said does seem to help the problem. So new questions arise - why is the {ec_recurring_expiration} table empty, and what should be done about it?

micheldanjou’s picture

Hi Matt,

Thanks for your input on this issue.
Would you remember the name of the file containing the SQL statement you have modified?

As you are on the subject of the recurring expiration, I have noticed that I can create "Expiry Schedules" no problem but I can't see them in the drop box when editing the properties of a product. Maybe this is related.

Best regards,
Michel

ymmatt’s picture

Followed up on a duplicate, sorry for the double post:

Is anything being done on this? Without the ability to download files it pretty much rendors this product type useless.

esadot’s picture

Version: 5.x-3.0 » 5.x-4.0-alpha6
FileSize
1.76 KB

It seems that EC4 is introducing a new identifier - ecid. Please find attached a patch to comply with ecid.

Paypal - transaction status is sill "payment pending", so until that's fixed you'd need to manually change the transaction (admin/store/overview).
COD - I believe this patch is also necessary: http://drupal.org/node/183297#comment-621503.

litebulb1’s picture

Is the attached file (file.diff) used to fix the problem of users not finding their purchased files in the My Files section? If it is how do I apply it because it doest not look to be a typical patch? thanks.

esadot’s picture

FileSize
20.2 KB

litebulb1 - yes, this fix the problem of not finding purchased files in the My Files section.

The above file.diff describes the differences, you should remove the "-" lines and add "+" lines from 5.x-4.0-alpha6 file.module file. Or alternatively you can simply use the attached file.module (remove the suffix .txt) which include the changes.

litebulb1’s picture

I downloaded the file.module and replaced it with the one from 5.x-4.0-alpha6 and it did not seem to fix the problem. I must be missing something because a few weeks ago this was working fine.

esadot’s picture

which payment gateway are you utilizing? if it's COD I believe this patch is also necessary: http://drupal.org/node/183297#comment-621503.

litebulb1’s picture

I am using paypal.

esadot’s picture

I just installed fresh drupal 5.5 + ec 5.x-4.0-alpha6, and purchased files are shown under "My files" directory using paypal. I (store admin) had to manually change transaction to completed though.

You may find it convenient to start with COD as it's easier to debug.

Make sure file's price is not zero, $0.01 will do just fine.

clint.davis’s picture

So This is still an issue with the latest version right???

howcome it has not been fixed?

brmassa’s picture

Guys,

im personally rewriting the entire module. it will rely now on upload module.

And probably no more text field to write the file path. It will bring 3 possible drawbacks:
1* i dont know how to update the data
2* if the file is outside the drupal dir, it will simply not work
3* since it will rely on Private file option on drupal's file settings, it might slow down sites with a lot images (i need to check this)

but i believe, even with these problems, it will become a much more user friendly.

reagards,

massa

clint.davis’s picture

Thanks for the reply Massa

i committed the patch to my latest version and its fixed the issue without any problems (so far).

Re-writing the code will take some time, so I would suggest applying the fix to the DEV version for now, so others can have this fixed as well.

Now all I have to do is find out why it still sets the payment to received and not completed and then I have fixed all of the issues I was having.

Looking forward to your new version of this module
Thanks, Clint

brmassa’s picture

Status: Active » Fixed

Guys,

i just published the new version of this module on eC4 CVS, fixing many of the bugs. take a look.

cheers,

massa

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

Pushkar Gaikwad’s picture

well I am getting the same error (I am using 3.4) so does this mean I have to upgrate to .4.0 alpha 11 ?

Phillip Mc’s picture

Status: Closed (fixed) » Active

I'm having a similar problem. Version 4 isn't ready for a production site yet..although it's close to being ready.

Aanyone found a solution for version 3?

burningdog’s picture

The file download module for e-Commerce 4 is now available at http://drupal.org/project/ec_file

burningdog’s picture

Status: Active » Closed (fixed)

Marking as "closed" since all development for the 4.x version of the file module has now been moved to a new project, ec_file

If this error persists under 5.x-3.x, please re-open under the appropriate 3.x version.