TO HELP THOSE WITH DOWNLOAD PROBLEMS

[Guest]

I appreciate such a quick reponse. Thank you.

 

I went through everything again.... I checked the slash in the code as well. it's there.

The only thing I see that is different is that I have a pdf file rather than a zip file. Could this be causing it? I'll change that and see if it is working. (One file that I was using as a test is actually a txt file. I'll change that one too.)

 

The link just doesn't show up. at all. I also looked in "my account" and it wasn't there either.

 

pam

 

I provide PDF files on my site and they work fine Pam, so I'm guessing it's something else. Sorry I can't help more than that though.

[Guest]

Re: The blank page on the download link. This occurrs when the order status is set to anything but "Delivered", the idea is that you only allow them to download the product once payment has been confirmed, ie Credit Card, PayPal and so on.

 

Therefore what I did was change: /includes/languages/english/checkout_success.php

 

from:

 

define('FOOTER_DOWNLOAD', 'You can download your products at a later time at \'%s\'');

 

to:

 

define('FOOTER_DOWNLOAD', '* You can also download your products at a later time at \'%s\'.<br>* If you paid by EFT, Cheque or Money Order then we will notify you when the link(s) are active!');

 

So that the customer know's why the links are inactive and I also made a similar note at the bottom of each product description so that they know if they pay by Credit Card or PayPal (for example) then they can download them immediately.

 

Hope that helps!

 

If anyone can suggest how to change that blank page with a similar comment that would be great.

[toddarice]

Problem solved. solution

[bodhost.com]

I would like to appreciate cyber2000 for this wonderful posting it really helps me to solve my problem related to this issue.

[pifactory]

Hi... These posts are really useful... so thanks.

 

BUT I'm still struggling to get my download link to appear.

 

I notice in the includes/configure.php file that there's a reference to:

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', '/home/myusername/myurl/catalog/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

Yet in my oscommerce set up I do not have a directory called download_public and my catalog directory sits inside the directory with the name of my site url. Is this a clue?

 

When I run my site I get a message to say that my download directory is not valid, even though it exists and has 755 permissions set.

 

Ideas much appreciated.

 

David Whitfield

[Don_Hartman]

I am having a problem after cc payment.

 

1054 - Unknown column 'comments' in 'field list'

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, last_modified, orders_status, comments, currency, currency_value) values ('7', 'Don Hartman', '', '75 Village', '', 'Cleves', '47002', 'Indiana', 'United States', '513-353-2709', '[email protected]', '2', ' ', '', '', ', '', '', '', '', '', 'Don Hartman', '', '75 Village', '', 'Cleves', '47002', 'Indiana', 'United States', '2', 'Credit Card', 'Visa', 'Don Hartman', '41111******11111', '1207', now(), now(), '2', '', 'USD', '1.00000000')

 

[TEP STOP]

 

 

Where would this be fixed at ? I did not install this module so I am not up to speed with all its changes.

Also we will be selling items that get shipped. How can I get a download purchase only to show the free shipping .

And, if they purchase other items that will be shipped we want the free shipping to hidden from selection. In other words,

if they buy the free item (cd) and then other items, we just want it to calculate 0 weight for the cd (without displaying the free shipping option)

, but charge normal shipping for the remainder of the items. First, I need to fix the problem at the top of the list - error in field list, though.

 

Don

[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.

[[email protected]]

I have seen a similar problem to mine but no solution that hits it on the head.

 

I have both physical products (that are shipped) and virtual products. The virtual products have a file to be downloaded and therefore no shipping.

 

The solution that someone said earlier in the posts was to set weight to zero and remove the shipping module. I can't do that because I ship some of the products.

 

How can I set some products to "Not Shipped" and others to "To Be Shipped"?

 

Anyone?

 

THanks!

 

Rob

[CKENT00369]

Everything with me is working great I have RC2 then only thing that I am having an issue with is that when I select a download product and add to cart then go to check out, it is putting shipping onto it. Like others have said I cant uninstall my shipping module because I do have other products that do ship. I looked at a mod for free shipping if 0 weight but it does not have instructions for editing the file yourself, as i have some other contributions I dont want to mess those up. What can I do?

[F1ReMaN]

First of all thanks for this great post. It helped me a lot today.

I have a music label and I'm usually selling cds.

 

I would like to start selling mp3s.

Now, I have a title (A) - this is the cd

Under the format - the user should be able to choose

a. Download only (cheap)

b. CD (and he gets the mp3s for free)

 

The price on top is for the cd.

 

The question is: I don't want the format prices to be relative. The cd price is +0 but when i put -20 in the mp3 price the user gets a strange price and I would just like to set a proper price for it.

 

Hope you understand.

[jesifra]

Brilliant Cyber2000 many thanks. This was just what I was looking for and it works perfectly.

:)

 

 

I need our help guys Please help. I am still not able to get the download feature working on my website. Can anyone assist me and I will give a donation to that person.

 

Thanks,

[michaelwl]

I've been searching through this forum for help with my problem related to the download but can't find what I'm looking for.

 

My product downloads are working when I have the Credit Card payment module enabled, i.e. when the client checks out the Credit Card payment option appears. If I use any other payment modules they don't appear during checkout.

 

How can I get around this? We don't offer Credit Card purchases on our site.

 

I'd really appreciate some help.

 

Thanks, Michael

[Guest]

Probably the most stupid question (stupidest) that you will see in this post... How much of the filename do you need in the attributes section....? I have checked everything else and it is on target. I just can't get the downlink to show up after paying with paypal.

 

I put the file name only (yourfilename.pdf)

 

do you put... catalog/download/yourfilename.pdf ?

 

or just yourfilename.pdf

or do I have to go the whole route and put everything in.... i'm stuck and have been working on this (and the shipping problems I ve been having for three days.... I need a valium!

 

pam

 

 

Hahaha! Ive been posting questions and reading and posting and reading for days and I think this thread finally answered my question. Thanks to all who have contributed to it. If it doesnt work, wanna share those valiums?????

[Guest]

GRRRRRRRRRRRRRRR I have done everything here...even went as far as to copy and past the code provided, added the "s", changed the redirect to false and I am STILL getting this error:

 

Parse error: syntax error, unexpected T_LNUMBER in /home/XXXXXX/public_html/catalog/download.php on line 23

 

I dont need the valium now, I need a shot or two of Jim Beam and I dont drink anymore!

 

This thread has helped to get the link there though, so I am grateful for that. What am I doing wrong. Here is the code in my file:

 

// Check that order_id, customer_id and filename match

$downloads_query = tep_db_query("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 " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . $customer_id . "' and o.orders_id = '" . (int)$HTTP_GET_VARS['order'] . "' and o.orders_status = '3' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '" . (int)$HTTP_GET_VARS['id'] . "' and opd.orders_products_filename != ''");

" . TABLE_ORDERS_STATUS . " os where o.customers_id = '" . $customer_id . "' and o.orders_id = '" . (int)$HTTP_GET_VARS['order'] . "' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '" . (int)$HTTP_GET_VARS['id'] . "' and opd.orders_products_filename != ''"); and o.orders_status = os.orders_status_id and os.downloads_flag = '1' and os.language_id = '" . (int)$languages_id . "'");

if (!tep_db_num_rows($downloads_query)) die;

$downloads = tep_db_fetch_array($downloads_query);

 

After the code changes you listed after the semicolon, there is nothing else in your post. Should I delete what is there after that was the existing code? Have I missed a semicolon, apostrophe, space, something???? Oh man, hacking code is nerve racking!

 

Your expertise is VERY MUCH APPRECIATED.

Michelle

[Guest]

I too am having this problem. I have changed the code, added the s to orders etc. I did a test run using my wifes CC and everything went well with Paypal. I got the link to take me back to my website on the paypal confirm page and the link was where it is supposed to be under the "download link" heading on my site. It is clickable BUT...when I click on the link, it takes me to an Internal Error page. This is so frustrating as I am so close to launching my site. It is all downloadable items on my site so I need to know how to resolve this.

Anyone have a clue?

Thanks in advance.

Dave.

[Guest]

I too am having this problem. I have changed the code, added the s to orders etc. I did a test run using my wifes CC and everything went well with Paypal. I got the link to take me back to my website on the paypal confirm page and the link was where it is supposed to be under the "download link" heading on my site. It is clickable BUT...when I click on the link, it takes me to an Internal Error page. This is so frustrating as I am so close to launching my site. It is all downloadable items on my site so I need to know how to resolve this.

Anyone have a clue?

Thanks in advance.

Dave.

 

 

I was having that problem when I took the advice of the initial post and changed the name of my download folder. Once I changed it back, it works fine. Make sure in your products attributes that you have the exact name of the file listed in either all uppercase or all lowercase letters and it is a zip file. All of this, however, still does not prevent people from abusing the link. I had a friend and my mom try it all out, they were able to purchase and download, however, my friend paid with an echeck through paypal. What is to stop someone from dl the product and then cancelling their echeck? Very frustrating sometimes getting things right. One answer creates another question. LOL Have you figured out that dilemma and how did you fix it? Hope this helps.

 

Michelle

[Guest]

I was having that problem when I took the advice of the initial post and changed the name of my download folder. Once I changed it back, it works fine. Make sure in your products attributes that you have the exact name of the file listed in either all uppercase or all lowercase letters and it is a zip file. All of this, however, still does not prevent people from abusing the link. I had a friend and my mom try it all out, they were able to purchase and download, however, my friend paid with an echeck through paypal. What is to stop someone from dl the product and then cancelling their echeck? Very frustrating sometimes getting things right. One answer creates another question. LOL Have you figured out that dilemma and how did you fix it? Hope this helps.

 

Michelle

Hi, I haven't got it resolved yet. I have to change virtually all of my zip file names to lower case. Bummer!! Oh well.. Also I am having a problem with paypal who for some unknown reason, disabled my bank account. Am emailing them about it today. Dunno what the deal is there! As for the echeck thing, I am using just credit or debit card payments on my site if and when paypal re-instates my bank account lol. You have a point there about canceling the echeck though.

Trying to get a business online is kinda hard!! Lots of problems arising all the time. Oh well. Once I figure it all out I hope it works out for me and for everyone trying to get an online biz going.

I'll keep yah posted LOL.

Dave.

[Guest]

Hi, I haven't got it resolved yet. I have to change virtually all of my zip file names to lower case. Bummer!! Oh well.. Also I am having a problem with paypal who for some unknown reason, disabled my bank account. Am emailing them about it today. Dunno what the deal is there! As for the echeck thing, I am using just credit or debit card payments on my site if and when paypal re-instates my bank account lol. You have a point there about canceling the echeck though.

Trying to get a business online is kinda hard!! Lots of problems arising all the time. Oh well. Once I figure it all out I hope it works out for me and for everyone trying to get an online biz going.

I'll keep yah posted LOL.

Dave.

 

 

I appreciate it. I ordered "PHP and MySQL for Dummies" tonite...LOL Im gonna figure it all out if it kills me. Will let you know if I find out in the meantime. Ive got this problem posted on another site forum. Waiting for a response/resolution. Will let you know.

 

Michelle

[chris thomas]

I'm actually in the evaluation stages with regards to osCommerce. I currently use a commercial system on my shops host. The main reasons for me wanting to move ships are...

 

* My providers E-Store has not been upgraded in 4 years (!)

* It costs quite a lot in terms of fees

* Their tech support is abysmal (recently I get put through to people who do not even code, let alone know how the store actually works)

 

Now, there is another reason for the move. I run a DVD training business, so we produce training material and ship it to customers via land/air mail. We have been having more and more requests for download delivery instead of physical, and I have to say it does make sense. However, our titles are pretty huge, like between 800mb and 4.5gig per item. And if someone buys all 30 of our titles, thats a LOT of data.

 

The other issue is security. We need to ensure that a customer is the only person that can download our titles (that they have paid for) and that they can only do so once payment has cleared. We need to also watermark our downloads to each customer, so if they give them to their friends, we can track the naughty blighters down :)

 

So, ideally what we need is a system which...

 

* Allows customers to choose either mail delivery or download delivery

* Either type of delivery is only authorized once payment is cleared. Ideally this would be as automated as possible

* For downloads we need to create an order folder for each order

* Item folders are created in each order folder, and the files in those item folders will be simlinked from elsewhere on the server

* A single file per item will be watermarked in some way, and placed in each item folder (this allows for tracking pirated items down the line)

* Once payment is deemed cleared, a link to these items will be mailed to the customer

 

So, pretty complex. We need to use simlinked files for the majority of each customers order to simply keep the storage sizes down on the server. A single order could in theory be 120gb in size, so we need the vast majority of that data to be instanced from elsewhere, with only the "watermarked" files being unique to the order.

 

With this being the case, does anyone have any experience with setting up this kind of system, or have they used a commercial developer for OSC, that has carried out similar work. Push come to shove, I know some PHP and mySQL, but my time is very short (I reallt need to concentrate on making more DVDs...), so paying a developer to do this would certainly be an idea.

 

Any help/ideas welcome.

 

Cheers

 

Chris Thomas

[josy]

Re: The blank page on the download link. This occurrs when the order status is set to anything but "Delivered", the idea is that you only allow them to download the product once payment has been confirmed, ie Credit Card, PayPal and so on.

 

Therefore what I did was change: /includes/languages/english/checkout_success.php

 

from:

 

define('FOOTER_DOWNLOAD', 'You can download your products at a later time at \'%s\'');

 

to:

 

define('FOOTER_DOWNLOAD', '* You can also download your products at a later time at \'%s\'.<br>* If you paid by EFT, Cheque or Money Order then we will notify you when the link(s) are active!');

 

So that the customer know's why the links are inactive and I also made a similar note at the bottom of each product description so that they know if they pay by Credit Card or PayPal (for example) then they can download them immediately.

 

Hope that helps!

 

If anyone can suggest how to change that blank page with a similar comment that would be great.

 

 

 

all of my customers will be paying by paypal so is there anyway i could add a notice to that blank page telling them what paypal requires me to tell them:

 

Example: Thank you for your payment. Your transaction has been completed, and a receipt for your purchase has been emailed to you. You may log into your account at www.paypal.com to view details of this transaction.

and then add a link below to the customers myaccount page, were they can download thier products,

[josy]

:( :o i have my link showing up now but when i click the link its shows this error:

 

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

 

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

 

More information about this error may be available in the server error log.

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

 

instead of giving me the download , can any one please help with this ?

[Guest]

I follow step by step every single instructions here and still the link is not showing on my...

 

I have RC2.2a

 

I'm using CVV module "Credit Card with CVV2 Version v2.2RC2a"

Which I'm starting thinking maybe will be part of the problem..

 

My donwload.php is slight different from the original one:

 

// Check that order_id, customer_id and filename match
 $downloads_query = tep_db_query("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 " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd, " . TABLE_ORDERS_STATUS . " os where o.customers_id = '" . $customer_id . "' and o.orders_id = '" . (int)$HTTP_GET_VARS['order'] . "' and o.orders_status = '3' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '" . (int)$HTTP_GET_VARS['id'] . "' and opd.orders_products_filename != '' and o.orders_status = os.orders_status_id and os.downloads_flag = '1' and os.language_id = '" . (int)$languages_id . "'");

 

So i just inserted the and o.orders_status='3' there (do I have to add any " or _ ???)

 

Any one here is using CVV on their shopping cart AND still have the download working?

 

Thank you

[christiansees]

Hello All,

I am having a problem with the account_history_info.php page while doing the v2.2 RC2 Upgrade. I keep getting an SQL error. The pages that I have problems with are checkout_success.php account_history_info.php and download.php.

 

1054 - Unknown column 'os.orders_status_id' in 'where clause'

 

select o.orders_status, date_format(o.last_modified, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays from orders o, orders_products op, orders_products_download opd where o.customers_id = '2' and o.orders_status >= '2' and o.orders_id = '6213' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != '' and o.orders_status = os.orders_status_id and os.downloads_flag = '1' and os.language_id = '1'

 

[TEP STOP]

What it seems to correspond to is the line 213 of account_history_info.php

  $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' and os.public_flag = '1' order by osh.date_added");

but this doesn't make sense either as TABLE_ORDERS_STATUS . "os," is declared, and not missing also order_status_id is a column in table order_status in the database.

I'm stumped :blink: Any help is much appreciated.

Thanks

Christian

[[email protected]]

I tried your suggestion of changing the "download" folder to be renamed as "product" and updating the configuration file.

 

Unfortunately it then broke the site with the following error. I reinstated the folder name and config file but still have the same error.

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'xxxxx'@'localhost' (using password: NO) in /home/......./includes/functions/database.php on line 19

Unable to connect to database server!

 

Any idea why it might be doing this?

 

Any help appreciated at this point.

[bkjproductions]

I know this is a reply to an OLD post and of course it's been fixed in later versions, but in the event that someone else has just stumbled across this after much head-wall-banging....

There is a typo in that, you probably want

o.orders_status rather than o.order_status

 

In this example we're checking to see if the status is 3 (delivered) OR 4 (allow download)

 

$downloads_query = tep_db_query("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 " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . $customer_id . "' and o.orders_id = '" . (int)$HTTP_GET_VARS['order'] . "' and (o.orders_status = '3' or o.orders_status = '4') and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '" . $id . "' and opd.orders_products_filename != ''");

 

Of course when the person clicks on the download they'll get "Can't find ID 3434" or some number.

So add a little note about payment, a couple of lines later where you see the "DIE" command.

 

if (!tep_db_num_rows($downloads_query)) die( "Can't find ID $id; perhaps the payment for this item has not yet been processed?");

 

It might be more elegant to use a tep_redirect to go to some other page that has a fancier message, of course, but one could argue that if you think someone's trying to steal a download then you're not going to dress up for a burglar.

 

--Brian