natureguy

Thank you. I think I mixed up the files from admin and includes yesterday. I reloaded the files. After careful file review, I didn't have to make any mods to the files after all, just needed to upload the usps.php files. Thank you very much for the SQL Querry. That did the trick. I am all up and running now. :)

Could you please add the actual general.php and modules.php files in the next update? I would like to use a file comparison program to try to figure out how to modify the files. I tried editing from the text instructions and I got rounding errors that wouldn't allow me to sign in under admin or visit my store. My store has many add-ons and some of the edits didn't work as I couldn't find the specific locations. I am coming from version USPS XML API V3 that stopped working in the past day, so my site is down for shipping. It is hobbling now with very limited shipping. Also, could you please provide better instuctions how to modify the database? I couldn't figure out how to make the couple of small changes. Where is set_function in the configuration table?? I can't find it.

Is there a way to not have the radio button, selecting the shipping option, automatically selected in checkout_shipping.php? Some of my products can not be shipped by the Media Mail option, but it is the least expensive way to ship my CD products. I would like to just have the customer select the option based on my instructions I placed on that page. Having the options automatically selected is too easy for customers to select the wrong shipping method. Is there some code to comment out or change to do this? I am not even sure what page should be changed. Thanks much, Bruce

PayPal Express Payments issues: I have had a store running since March and PayPal Express never worked for downloadble files. It works fine for shippable products. I updated to version 1.1.2, but still have the same problems everyone else is having. The problem appears to be an IPN related issue. It comes back from PayPal to my site saying that the payment selection is not available to the country I reside in, the USA. Another issue is the use of coupon codes doesn't seem to work when using PayPal Express. I am missing lots of MP3 orders since people seem to trust PayPal more than me. ;) Does anyone know of a solution to this yet???? I have been quite patiently waiting. The once great support for this add-on seems to have disappeared.

PayPal Express Payments for downloadable files have not been for me. PayPal express for non-downloadable products is working just fine as is all other functions using PayPal. I am uncertain if it has to do with the Download Shop add-on (I can't get any support from that add-on) or my configuration with PayPal WPP. I was looking at the IPN notification URL in my configuration. It is: http://www.*********.com/catalog/index.php?action=express_checkout_ipn. Should it be a secured site: https://www.*********.com/catalog/index.php?action=express_checkout_ipn ?? What is occurring is that the customer tries to pay for a download file with PayPal Express, it seems to work, but they are just sent back to my site, to the payment page, and no payment is made. Any help would be greatly appreciated. This trouble has been bugging me for months. Thanks, Bruce

Intermitent bug problems: I sell MP3 files and have noticed a bug with this add-on. Very intermitently the customer orders an MP3 file, it shows up in their account order, with the file as available, the number of downloads available, BUT NO DOWNLOAD BUTTON AND LINK shows up. I can order the file under a test account and I have no problems, nor does the majority of customers. Both times this has occured, the customers ordered a number of files, and only one of the files had no download button. I am not sure how often this occurs. Also, I found out that I am not able to add or create an order for an MP3 file or files with no charge as a customer service option. The download button does not show up within the order on the customer's end. Any ideas??? Writing for support for this add-on seems like an exercise in futility, but I got to try. By the way, I still have trouble with MP3 orders when customers use PayPal Express as noted above. Anyone with coding hints????????? Thanks!

I am still waiting for anyone's ideas on this. I had to post a message that PayPal Express is not working as a payment for downloads now on my website. Can someone point me in the right direction on this????

PayPal Express Payments not working for downloads. I am having issues with using PayPal Express Payments for download purchases. PayPal Express is working ok if someone orders CDs or other products on my site, just not downloads. If they pay with a regular credit card, that works for downloads. I use PayPal Pro 1.1.0 by DynamoEffects. What is happening is if someone selects PayPal express to make a payment for a download, it returns them to my site as if they never made a payment, which no payment was processed, even if they already have an account with my website. I noticed on the installation intructions about an issue with PayPal IPN. Does it sound like that is the issue I am having? Suggestions on how I can fix this issue? Any ideas where I might have made an error with the install? I have had a few people emailing about this issue since I made the site live a month ago. Thanks! Bruce

Order Status issues. Another issue was encountered with this add-on and hopefully in the future it will be addressed. I have PDF invoice add-on installed, but this will be an issue with the regular OsCommerce invoice and will have interaction issues with many other add-ons. The order status with this add-on modifies the database with it's own order status, which is outside of normal OsCommerce order status conditions. The issue is that when a customer orders a downloadable product, they won't see or be able to print an invoice because those invoices use the status of "delivered" to provide the link to the invoice within the user account. If I, under administration, update the status to delivered, the download links disappear within the user account, but the user will be able to access the PDF invoice. I will work with this issue for now, but I hope it can be addressed at some point. If anyone has a work around to this issue, I would be very happy to hear about the details.

OK, I figured out this error after much hair pulling! I am using PayPal Web Payments Pro by Dynamoeffects, which has a diagnostics program that found that the old bug in checkout_process.php was partially reverted back to having the bug. By following the instructions in Download Shop, using the very outdated OsCommerce files to file compare and replace, errors were reinserted. Around line 85 of checkout_process.php, just before // BOF: WebMakers.com Added: Downloads Controller $sql_data_array = array('customers_id' => $customer_id, 'customers_name' => $order->customer['firstname'] . ' ' . $order->customer['lastname'], 'customers_company' => $order->customer['company'], Keep the code which would be mostly likely written over: // load the before_process function from the payment modules $payment_modules->before_process(); I am sure this will be a very common issue when installing this add-on. I hope this helps those with similar issues and hope Alex includes it with the instructions for installing this add-on.

Well, I ended up figuring my issue out. I got the idea of running wpp_diagnostics.php just for the heck of it. I didn't think this issue was even related, but it found that the old bug in checkout_process wasn't fixed anymore after installing the Super Download Shop Controller. It was due to poor instructions from that add-on using really old files. I fixed the line of code and all is working great now. Thank God for wpp_diagnostics!!

I am having trouble with credit card orders after I added super download shop add-on. I am not sure if it might be an actual payment issue. I am unable to get any help from the support page for that add-on, and am really stuck. I am hoping since it is payment related, someone on here might understand the issue. It doesn't seem to be related to the download shop add-on files, but I was able to receive credit card orders before I installed the add-on. Upon order confirmation, checkout_process.php comes up with a blank error page with the following: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'paypal_wpp', '', ' at line 18 INSERT INTO orders_status_history_transactions ( `orders_status_history_id`, `transaction_id`, `transaction_type`, `payment_type`, `payment_status`, `transaction_amount`, `module_code`, `transaction_avs`, `transaction_cvv2`, `transaction_msgs` ) VALUES ( 32, '', '', '', '', , 'paypal_wpp', '', '', '' ) [TEP STOP] Just before 'paypal_wpp', there is a blank in between commas, where the value of 'transaction_amount' should be. I have no idea where to even find this line 18 of code to be able to even look at it and change it. Can anyone offer any help where I might find this line of code and what should be between the commas? This error has been driving me crazy for weeks. Thanks!

I am having an error when processing a credit card payment with PayPal that I didn't have before I added Download Shop. Upon confirmation of an order, checkout_process.php comes up with this: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'paypal_wpp', '', ' at line 18 INSERT INTO orders_status_history_transactions ( `orders_status_history_id`, `transaction_id`, `transaction_type`, `payment_type`, `payment_status`, `transaction_amount`, `module_code`, `transaction_avs`, `transaction_cvv2`, `transaction_msgs` ) VALUES ( 32, '', '', '', '', , 'paypal_wpp', '', '', '' ) [TEP STOP] I can see the error that a " is missing between commas just before 'paypal_wpp', but I can not find the file where this line of code is for the life of me. Anyone have any ideas where I can find this code and what should be between the commas? Otherwise the rest of the Download Shop add-on is working great. By the way, I found that I couldn't use Zip files as downloadable files. I changed all my files to individual MP3 and all was well and will work out better. Thanks for any help, this is the last thing holding me up making my shop live.

I guess we have to sometimes answer our own questions. If anyone else has difficulty adding the rows into the orders_status table here is an SQL Query to run to add the rows as described in the Download_Shop instructions. I only used the English language ID, you will have to add more rows for other language ID's. Run this MySQL Query in addition to two others for Download Shop for OsCommerce. I don't know why this was missing for so many years this add-on has been available. INSERT INTO orders_status (orders_status_id,language_id,orders_status_name) VALUES (12,1,"Updated"); INSERT INTO orders_status (orders_status_id,language_id,orders_status_name) VALUES (11,1,"Download Now Available") Now, I just have to figure out how to get the download files to work correctly. I am having trouble with the included instructions, since I previously set up all my downloads before I added this add-on. The files downloaded have 0 bytes, otherwise everything else seems working. Anyone with ideas why that might be happening?????

Thanks Alex. Another question, I am trying to setup the Orders Status within phpMyAdmin. How do I add the new rows, Updated and Download Now Available, to the order_status_id table? My screen isn't showing a way to insert a row like in the instructions. I see a create view, but I don't know how to insert rows into a table within phpMyAdmin. Do you have a sql script for that? English language only needed. Thanks.

Before I add this add-on, I had a couple quick questions. Step #5 of the installation mentions something about OsCommerce Paypal IPN module not working and that it must be manually coded? Are there instructions for that somewhere? I am using PayPal Website Payments Pro by Dynamoeffects, will that work with this add-on, using PayPal IPN to give site paid feedback and allow downloads to proceed? Or do I need an additional add-on to work with PayPal IPN? Thanks.

I have a question about PayPal IPN usage. I am testing my new catalog, part of which sells downloads. All the money transactions using PayPal are working, but I don't seem to be receiving an IPN from PayPal correctly, so the order can be shown as paid and the customer allowed to access their downloads. I ran wpp_diagnostics and that was clear of errors. I am wondering if there might be something I did wrong with this add-on or is there another add-on I need to get PayPal IPN's to work to automatically update that an order that has been paid? I have been searching and haven't really found an answer about the details on how IPN's work with this add-on or with Oscommerce in general. I can see that an ip address from PayPal is trying to access the paypal_ipn.php file. I have PayPal setup to use: https://www.********.com/catalog/index.php?action=express_checkout_ipn, for IPN notifications. Any insight will be greatly appreciated.

Thanks, I couldn't find this in any searches. That did the trick. Thanks for the quick reply. :)

I installed Ultimate SEO URLs 5 a while back and updated to R141 last month. Everything appeared to be functional, until my store is about complete and I was testing the checkout system. I was able to place an order, but when I clicked to confirm order, I got the following error: Fatal Error: Call to private method usu::performance() from context " in home/*****/*****/public_html/catalog/includes/footer-tracker.php on line 39. That line is an add on by SEO URLs 5. Any guesses, suggestions? I am not even sure where to start and am hoping someone else has had this issue. I am using PayPal Pro direct payments & express checkout V1.0.7a as the payment method. I used a credit card transaction in this case. I wasn't able to receive a PayPal IPN back into Oscommerce, but that may be another issue and not an additional issue with this error, so I would like to fix this issue up first. Thanks!

Sam, I tried to modify line 59 of backup_store_files.php to include more folders that are bulky for me, but I am not sure I did this correct. The mod took the file size from 96MB to 8.6MB, which should now allow this to work, but I am still getting errors. My entire catalog folder on my local drive is 24MB, with the images folder minus pub folder and minus the download folder, and yet I am now getting this error: Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 8650752 bytes) in /home/*****/*******/catalog/admin/backup_store_files.php on line 62. If I try to increase the memory size, on line 19, to my host limit of 64MB, I get error: Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 14060980 bytes) in /home/*****/*******/catalog/admin/includes/classes/zip.class.php on line 113. I am not sure why the two bytes tried to allocate are different. Line 59 Mod: if (strpos($arquivo,DIR_FS_BACKUP) === 0 || strpos($arquivo,DIR_FS_CACHE) === 0 || strpos($arquivo,DIR_FS_CATALOG . DIR_WS_IMAGES) === 0 || strpos($arquivo,DIR_FS_CATALOG . DIR_WS_PUB) === 0 || strpos($arquivo,DIR_FS_CATALOG . DIR_WS_DOWNLOAD) === 0)continue; Any ideas or anymore info needed? Are there some settings I need to make within Oscommerce that I am missing? Thanks much.

Thanks for your quick response Sam. Ah, you're correct, there was no IE=EmulateIE7 showing up in the html output. I had your contribution files correct, but I found I needed to add that meta command to my STS templates to make them show up on the actual html output. I am not sure why that happens, but I am not a code expert. Maybe this post will help others with the same issues. I am now able to use <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">. The site now looks and acts the same in both Firefox and IE, except for my rounded corner divs, but IE doesn't use those CSS commands. I think the canonical tag is fixed now too, but I will look into that further. Still a work in progress. Thanks.

What part am I leaving off??? I went through the entire install very carefully, following the instructions, and even used DiffMerge to compare my files with your supplied files. I am not intentionally leaving things out. :( Maybe I am making a mistake somewhere embeding code within other contributions somewhere?

I updated to the newest version, but that didn't help with the IE issues. The only thing that would fix the issue is to use <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">, on both product_info.php and my STS template. That required some work to get the site to look like it did before, and IE still looks a little different than other browsers, but FancyBox Popups are now working. One other thing I noticed. With Internet Explorer the popup window and included pictures are slightly smaller than seen in Firefox. It's not a big deal, but any clue what might be causing that? My link

Hey all, I am having a devil of a time getting this contribution, V1.2, working with IE8. I swear it was working with the default STS template, but now that am working on my own, I can't get the thing to work in IE8. It works fine in Foxfire. All I get is a new IE8 window to open up with the photo. I tried playing around changing the !doctypes, but best I was able to do was to see a the loading image show up, but no photo. I am currently using <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> My site in progress is http://www.natureguystudio.com/catalog/lake-superior-shores-p-28.html, or My catalog I read the posts about IE issues, but they all seemed fixed by the V1.2 I am using. Any ideas? Thanks!

Thanks! I finally figured it out and was able to change the placement of the table. Perfect!