cdamianou Posted May 16, 2004 Posted May 16, 2004 I have just decided to use this contribution, but it looks like i have a small problem. If someone whants to pay by cheque, tehya re still able to downlaod the product. How can we stop this. I have MS1. Thanks Quote
Guest Posted May 17, 2004 Posted May 17, 2004 Added this module with no problems. Except once I ran a test purchase and went to my control panel to view the order I got: 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 'limit 0, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by limit 0, 20 Did a search in the forum and saw Kylie fixed her problem by using her database backup and reinstalling the downloads.controller.sql in the database again. Did that and it made a slight difference - first time I got an error in sql, this time I didn't. But I'm still getting the 1064 error. Any other ways to overcome this issue? Quote
Guest Posted May 17, 2004 Posted May 17, 2004 Looked over it again. All tables seem to be set up in the right place. Seems to be a problem with the 2nd querty in the module .sql file: INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Download on hold message', 'DOWNLOADS_CONTROLLER_ON_HOLD_MSG', '<BR><font color="FF0000">NOTE: Downloads are not available until payment has been confirmed</font>', 'Downloads Controller Download on hold message', '13', '91', '2003-02-18 13:22:32', '', NULL , NULL); Running the 3 seperately, the 1st and last execute fine, the middle one posted above gives an error when executed. Anyone have any ideas? Tried the 2 fixes listed on this thread but neither worked for me. Still can't see my list of customers or orders on the admin page without getting the 1604 error. Quote
Guest Posted May 17, 2004 Posted May 17, 2004 Thanks a post by TripleCross I figured out the error and it's fixed. But now I open up the order history in the admin panel and all the buttons are missing. Where can I find them? They didn't come with the module. Quote
cdamianou Posted May 18, 2004 Posted May 18, 2004 Im still confused as to why people can download the item even when they pay by cheque. Quote
oml Posted June 23, 2004 Posted June 23, 2004 sunsetwebdesign.... where is TripleCrosses post? Can you copy it into this thread please, it may be usefull for others. Thanks. :) Quote
indian_druid Posted June 23, 2004 Posted June 23, 2004 Im still confused as to why people can download the item even when they pay by cheque. Hi cdadminaou, If you have installed Linda's Download Controller module (Download_Controllev5.3 MS2.2) then in the admin part under the Configuration-> Download section ,you will find a setting called Downloads Controller Order Status . The defualt value of this setting is 2 . The value of 2 is for order status Processing What this setting means is that if any downloadable product is purchased with a payment method whose Order Status is less than 2 (i.e the payment method has a pending or default status) then the product will not be immediately available for download to the customer. Now for your solution.... Go to Modules->Payment->Check/MoneyOrder and set the value of Set Order Status field to either default or Pending. This will not allow the customers to download the product immediately. Once the cheque is cleared you can go to Orders section in admin and update the status of the order so that the customer can donwload the product from his My Account section Quote
cdamianou Posted June 23, 2004 Posted June 23, 2004 Hi I have MS1 You stated Go to Modules->Payment->Check/MoneyOrder and set the value of Set Order Status field to either default or Pending. I do not have this option. Im pulling my hair out here. Thanks Quote
Guest Posted June 30, 2004 Posted June 30, 2004 Thx to a few fixes done in this forum I have been able to sort a lot of my issues, I still have this one though any thoughts here. Any help appreciated, they are images but I cant find them in the folder supplied, if they are stck osc the url must be wrong. Elwyn :unsure: Quote
mattmcb Posted July 5, 2004 Posted July 5, 2004 I've got everything working with this module except for the download link. When I click on the download button it takes me to this URL: http://seekshopping.com/catalog/download.p...jzwu/unreal.zip The file is actually stored in http://www.seekshopping.com/catalog/download/unreal.zip Has anyone come across this type of error or does anyone have any suggestions on how to fix it? Quote
Guest Posted July 11, 2004 Posted July 11, 2004 The file is actually stored in http://www.seekshopping.com/catalog/download/unreal.zip Has anyone come across this type of error or does anyone have any suggestions on how to fix it? Matt this isnt an error, this is the default test download file for the osc feature, when you setup a new download you have to go into the attributes and setup the file to asscoiate with it. Quote
Heraldic Posted July 17, 2004 Posted July 17, 2004 Hi folks, I hope someome may have run across this problem before. Its' got me stumped. I have Downloads Controller v.5.3 on my oscommerce 2.2 milestone 2 at roninarts.com. The contribution was working great and files were downloading smoothly. However, a customer got no download button when he ordered something this morning. This is a new product I had set up the night before and I double-checked to make certain I had spelled the name of the file correctly. I had. I tried setting up another product for a test download.. and guess what? Same result. No download button and no link. However, all the other products uploaded previously were still working fine. The web service had moved us to a new server. The permissions on the pub and download folder were correct. they had moved us to a server with PHPSuexec installed on it. I think that would have interfered with ALL the downloadable products.. not just the new ones. I did notice that the product IDs in product attributes had just hit number 60, though. Has anyone encountered this? ~Keith Quote
geekmom Posted July 19, 2004 Posted July 19, 2004 Hello, I just installed the Downloads Controller at http://www.chippewapublishing.com/catalog and although everything seems to be working on the catalog end (so far, I haven't been able to download anything yet) I'm trying to make changes in the customer orders section to change the status to test the download and it is coming back with Orders Order ID: Status: 1064 - You have an error in your SQL syntax near 'limit 0, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by limit 0, 20 [TEP STOP] ? Customers ? Order Total ? Date Purchased ? Status Action? I made sure the order.php file is the correct one. Any ideas? Thanks, Rebecca Quote
geekmom Posted July 19, 2004 Posted July 19, 2004 Okay, I fixed my problem by using this thread http://www.oscommerce.com/forums/index.php?sho...=0entry393094 But I do not see the download link or image no matter what status the order is at and I've added the status 4, Updated. I'll keep looking but any ideas would be handy. Thanks! Quote
mattmcb Posted August 2, 2004 Posted August 2, 2004 Does anyone know where this setting is located within the admin: Downloads Controller Update Status Value Quote
Guest Posted August 2, 2004 Posted August 2, 2004 have you set the product to have attributes an use the ones that came with osc version type and so on this will work. Quote
Guest Posted December 1, 2005 Posted December 1, 2005 I used the Download Controller V5.3/w free shipping & paymnet. All my downloaded file has to pay before download. Normal payment module I have paypal, Bank transfer or deposit, Cash on pickup and Cash at store (basically same as Cash on pick up only the wording). When my customer purchase the downloadable product, he.she cannot choose the Cash at store/Cash on pickup. The Payment Method only show up the Paypal and Bank Transfer or deposit. How can I get the Cash at store to work on? Quote
hansmignon Posted December 2, 2005 Posted December 2, 2005 I installed it and it isw working fine. Only when you click on the download link i get this: You don't have permission to access /download/.rzcqwyoihkmigvhol/testje.wmv on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. -------------------------------------------------------------------------------- Apache/2.0.51 (Fedora) Server at www.pricebreaker.be Port 80 The permission is correct. Anyone an idee ? Thx, Hans Quote
magicurty Posted February 2, 2008 Posted February 2, 2008 After installation and atributed the product, everything seems working until I get the order to check out... when I click on CHECK OUT button after select the "downloadable" product I got this sintax: Fatal error: Cannot redeclare tep_get_configuration_key_value() (previously declared in catalog/includes/functions/downloads_controller.php:13) in /catalog/includes/functions/downloads_controller.php on line 13 I have checked on the forum about it... nothing.. Does anybody knows about this? I am lay on PHP..Please some heeeelp! Quote
Douglas Adams Posted February 7, 2008 Posted February 7, 2008 Check in the Admin ... Configuration ... Downloads ... and make sure that the Downloads is turned on.Then, go into the Categories/Products ... Product Attributes ... and add the filename for the download to each product. Note: The filename is case sensative and should not contain spaces or extra periods. Zip files are best as they are smaller and easier to download. Then, FTP your download files to the /download folder. Do a chmod on /pub to 777 and /download to 755 Make sure your /includes/configure.php is using the real path to your root and not $DOCUMENT_ROOT in the define. You can get this path in the Admin ... Tools ... System Info ... search for DOCUMENT_ROOT without the $ Linda, Just installed v5.3b_MS2.2 in the hopes of finally being able sell downloadable pdf's with OScom v2.2RC2 I have not been able to get the system to recognise that they are downloadable. But now when I press Add to Cart I get: Fatal error: Cannot redeclare tep_get_configuration_key_value() (previously declared in /home/cosec/public_html/catalog/includes/functions/downloads_controller.php:13) in /home/cosec/public_html/catalog/includes/functions/downloads_controller.php on line 13 can you offer any advise? I cannot believe that downloadable products are not available ot of the box in Oscommerce! Quote
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.