AlexStudio Posted October 4, 2007 Author Share Posted October 4, 2007 Did you ever make a download link appear before installing SDS? If the answer is no, I can't do much help. If the answer is yes, but no download link after SDS installed: 1. check if you have set the orders status correctly (follow the instruction carefully). 2. check if you have done the modifications in checkout_process.php 3. check if the filename is spelled correctly (case sensitive), and the file does exist in the right place. Reasons of missing download links: no download filenames logged with the orders. Something's wrong in checkout_process.php the download file cannot be located. Either the filenames are wrong or the files don't exist. orders status value is lower than the downloads controller orders status value. download expired. If the last_modified datetime was not inserted with the order record, which means that the modification in checkout_process.php is missing, download will always be expired. Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
kustomjs Posted October 5, 2007 Share Posted October 5, 2007 hey alex how do I delete the the extra stuff under downloads because I did that group file for downloads.sql 2 many times and now i got 4 Downloads Controller Update Status Value, 4 Downloads Controller Download on hold messages, 4 Downloads Controller Order Status Value, 4 Enable Group File Download? I did 2 many of these and I just one of each. and i get this error: 1146 - Table 'xxxxxxx.products_attributes_download_groups' doesn't exist select download_group_id, download_group_name from products_attributes_download_groups where download_group_id != 0 and language_id = 1 order by download_group_id Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 5, 2007 Author Share Posted October 5, 2007 There are 2 .sql scripts in SDS v1.1 package. You ran downloads_controller_english.sql 4 times, but never ran group_file_for_download.sql successfully ever. To remove the duplicated configuration keys, just drop them from the table configuration. Do it carefully, backup your database first. After then, you need to run group_file_for_download.sql to create the tables for file group feature. Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
shubbert Posted October 5, 2007 Share Posted October 5, 2007 Just out of curiosity, I’m trying to have my customers download their product as soon as they purchase. Is this possible? Also what if I wanted to let them know it takes 7 to 10 business days after they make a purchase? Is there a way to let them know this once they purchase their product? Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 6, 2007 Author Share Posted October 6, 2007 I don't quite follow your questions. Without SDS, downloads are available immediately after the orders created. SDS is to secure pending orders and hold the downloads before payments completed. Setting up SDS to work automatically, it needs payment modules capable of updating orders status when payments completed. With these kind of payment modules, instant downloads can be achieved. Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Dynatech Posted October 7, 2007 Share Posted October 7, 2007 Hi all, Does this contribution als work with osCommerce 2.2 MS2 version 051113? Or only with update 060817? Thanks, Eric :rolleyes: :rolleyes: :rolleyes: Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 7, 2007 Author Share Posted October 7, 2007 It should work with 2.2 MS2 and 051113 patch release. Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Guest Posted October 8, 2007 Share Posted October 8, 2007 My problem was due to not setting the same paypal email address as the one in the sandbox. Once I changed that the script worked a treat .... Donation sent thanks Quote Link to comment Share on other sites More sharing options...
Fredrik.r Posted October 15, 2007 Share Posted October 15, 2007 Hi! Very grateful for some pretty fast help with this; Link expires: Thursday 01 January, 1970 The shop is going live today. Why it sais 1970? Expire days is set to 7. Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 15, 2007 Author Share Posted October 15, 2007 You probably missed the modifications in checkout_process.php, or didn't apply the modifications correctly. Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Jeffrey Huan Posted October 15, 2007 Share Posted October 15, 2007 An error as below occured when I run /catalog/admin/filegroup_db_setup.php. Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/content/j/e/f/jeffreyhuan/html/oscommerce/catalog/admin/includes/database_tables.php:67) in /home/content/j/e/f/jeffreyhuan/html/oscommerce/catalog/admin/includes/functions/sessions.php on line 97 Warning: Cannot modify header information - headers already sent by (output started at /home/content/j/e/f/jeffreyhuan/html/oscommerce/catalog/admin/includes/database_tables.php:67) in /home/content/j/e/f/jeffreyhuan/html/oscommerce/catalog/admin/includes/functions/general.php on line 22 I follow your instructions step by step. Please help find where the problem is. How can I solve it? Thank you very much! Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 15, 2007 Author Share Posted October 15, 2007 What do you have in your /home/content/j/e/f/jeffreyhuan/html/oscommerce/catalog/admin/includes/database_tables.php?? Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
Jeffrey Huan Posted October 15, 2007 Share Posted October 15, 2007 <?php /* $Id: $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2007 osCommerce Released under the GNU General Public License */ // define the database table names used in the project define('TABLE_ADDRESS_BOOK', 'address_book'); define('TABLE_ADDRESS_FORMAT', 'address_format'); define('TABLE_ADMINISTRATORS', 'administrators'); define('TABLE_BANNERS', 'banners'); define('TABLE_BANNERS_HISTORY', 'banners_history'); define('TABLE_CATEGORIES', 'categories'); define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description'); define('TABLE_CONFIGURATION', 'configuration'); define('TABLE_CONFIGURATION_GROUP', 'configuration_group'); define('TABLE_COUNTRIES', 'countries'); define('TABLE_CURRENCIES', 'currencies'); define('TABLE_CUSTOMERS', 'customers'); define('TABLE_CUSTOMERS_BASKET', 'customers_basket'); define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes'); define('TABLE_CUSTOMERS_INFO', 'customers_info'); define('TABLE_LANGUAGES', 'languages'); define('TABLE_MANUFACTURERS', 'manufacturers'); define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info'); define('TABLE_NEWSLETTERS', 'newsletters'); define('TABLE_ORDERS', 'orders'); define('TABLE_ORDERS_PRODUCTS', 'orders_products'); define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes'); define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download'); define('TABLE_ORDERS_STATUS', 'orders_status'); define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history'); define('TABLE_ORDERS_TOTAL', 'orders_total'); define('TABLE_PRODUCTS', 'products'); define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes'); define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download'); define('TABLE_PRODUCTS_DESCRIPTION', 'products_description'); define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications'); define('TABLE_PRODUCTS_OPTIONS', 'products_options'); define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values'); define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options'); define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories'); define('TABLE_REVIEWS', 'reviews'); define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description'); define('TABLE_SESSIONS', 'sessions'); define('TABLE_SPECIALS', 'specials'); define('TABLE_TAX_CLASS', 'tax_class'); define('TABLE_TAX_RATES', 'tax_rates'); define('TABLE_GEO_ZONES', 'geo_zones'); define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones'); define('TABLE_WHOS_ONLINE', 'whos_online'); define('TABLE_ZONES', 'zones'); // BOF Super Download Shop v1.0 mod define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS', 'products_attributes_download_groups'); define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_FILES', 'products_attributes_download_groups_files'); define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS_TO_FILES', 'products_attributes_download_groups_to_files'); // EOF Super Download Shop v1.0 mod ?> Quote Link to comment Share on other sites More sharing options...
pafranklin Posted October 31, 2007 Share Posted October 31, 2007 Hi there, This looks like a greta contribution and having looked at the installation file there do not appear to be any step by step instructions for amending the existing files. Is it possible to provide this please? Many thanks. Paul Quote You will never learn if you don't try. And boy am I trying....! Link to comment Share on other sites More sharing options...
sunshynevideo Posted November 2, 2007 Share Posted November 2, 2007 Tried installing SDS as per instructions. Ran downloads_controller_english.sql and it did just fine Ran group_file_for_download.sql and received the following error Failed to execute SQL : SQL 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 ('', 'Enable Group File Download?', 'DOWNLOADS_CONTROLLER_FILEGROUP_STATUS', 'Yes', 'Do you want to enable group file for download? - Default=Yes', '13', '93', NOW(), NOW(), NULL , 'tep_cfg_select_option(array('\Yes\', '\No\'), '); ALTER TABLE `products_attributes_download` ADD `products_attributes_filegroup_id` INT( 11 ) NULL AFTER `products_attributes_filename` ; CREATE TABLE `products_attributes_download_groups` ( `download_group_id` INT( 11 ) NOT NULL , `download_group_name` VARCHAR( 255 ) NULL , `language_id` INT( 11 ) NOT NULL , PRIMARY KEY ( `download_group_id` , `language_id` ) ) ENGINE = MYISAM ; CREATE TABLE `products_attributes_download_groups_files` ( `download_groups_file_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `download_group_id` INT( 11 ) NOT NULL , `download_group_filename` VARCHAR( 255 ) NOT NULL ) ENGINE = MYISAM ; ALTER TABLE `products_attributes_download_groups_files` DROP PRIMARY KEY , ADD PRIMARY KEY ( `download_groups_file_id` , `download_group_id` ) ; CREATE TABLE `products_attributes_download_groups_to_files` ( `download_groups_file_id` INT( 11 ) NOT NULL , `language_id` INT( 11 ) NOT NULL , `download_group_file_description` VARCHAR( 255 ) NULL , PRIMARY KEY ( `download_groups_file_id` , `language_id` ) ) ENGINE = MYISAM ; failed : 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 '\\Yes\\', '\\No\\'), '); ALTER TABLE `products_attributes_downl Here is the contents from the sql file I ran 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 ('', 'Enable Group File Download?', 'DOWNLOADS_CONTROLLER_FILEGROUP_STATUS', 'Yes', 'Do you want to enable group file for download? - Default=Yes', '13', '93', NOW(), NOW(), NULL , 'tep_cfg_select_option(array('\Yes\', '\No\'), '); ALTER TABLE `products_attributes_download` ADD `products_attributes_filegroup_id` INT( 11 ) NULL AFTER `products_attributes_filename` ; CREATE TABLE `products_attributes_download_groups` ( `download_group_id` INT( 11 ) NOT NULL , `download_group_name` VARCHAR( 255 ) NULL , `language_id` INT( 11 ) NOT NULL , PRIMARY KEY ( `download_group_id` , `language_id` ) ) ENGINE = MYISAM ; CREATE TABLE `products_attributes_download_groups_files` ( `download_groups_file_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `download_group_id` INT( 11 ) NOT NULL , `download_group_filename` VARCHAR( 255 ) NOT NULL ) ENGINE = MYISAM ; ALTER TABLE `products_attributes_download_groups_files` DROP PRIMARY KEY , ADD PRIMARY KEY ( `download_groups_file_id` , `download_group_id` ) ; CREATE TABLE `products_attributes_download_groups_to_files` ( `download_groups_file_id` INT( 11 ) NOT NULL , `language_id` INT( 11 ) NOT NULL , `download_group_file_description` VARCHAR( 255 ) NULL , PRIMARY KEY ( `download_groups_file_id` , `language_id` ) ) ENGINE = MYISAM ; I have read this entire thread and tried removing the ENGINE = MYISAM and still got basically the same error Failed to execute SQL : SQL 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 ('', 'Enable Group File Download?', 'DOWNLOADS_CONTROLLER_FILEGROUP_STATUS', 'Yes', 'Do you want to enable group file for download? - Default=Yes', '13', '93', NOW(), NOW(), NULL , 'tep_cfg_select_option(array('\Yes\', '\No\'), '); ALTER TABLE `products_attributes_download` ADD `products_attributes_filegroup_id` INT( 11 ) NULL AFTER `products_attributes_filename` ; CREATE TABLE `products_attributes_download_groups` ( `download_group_id` INT( 11 ) NOT NULL , `download_group_name` VARCHAR( 255 ) NULL , `language_id` INT( 11 ) NOT NULL , PRIMARY KEY ( `download_group_id` , `language_id` ) ) ; CREATE TABLE `products_attributes_download_groups_files` ( `download_groups_file_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `download_group_id` INT( 11 ) NOT NULL , `download_group_filename` VARCHAR( 255 ) NOT NULL ) ; ALTER TABLE `products_attributes_download_groups_files` DROP PRIMARY KEY , ADD PRIMARY KEY ( `download_groups_file_id` , `download_group_id` ) ; CREATE TABLE `products_attributes_download_groups_to_files` ( `download_groups_file_id` INT( 11 ) NOT NULL , `language_id` INT( 11 ) NOT NULL , `download_group_file_description` VARCHAR( 255 ) NULL , PRIMARY KEY ( `download_groups_file_id` , `language_id` ) ) ; failed : 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 '\\Yes\\', '\\No\\'), '); ALTER TABLE `products_attributes_downl I am currently running latest version of oscommerce while I just d/loaded HTTP Server: Apache/1.3.39 (Unix) PHP/4.4.7 mod_ssl/2.8.30 OpenSSL/0.9.8g PHP Version: 4.4.7 (Zend: 1.3.0) Database: MySQL 4.0.14-standard Any thoughts on this anyone? Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted November 2, 2007 Author Share Posted November 2, 2007 There is a syntax error in your modified script. Here is the original script with ENGINE = MYISAM removed.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 ('', 'Enable Group File Download?', 'DOWNLOADS_CONTROLLER_FILEGROUP_STATUS', 'Yes', 'Do you want to enable group file for download? - Default=Yes', '13', '93', NOW(), NOW(), NULL , 'tep_cfg_select_option(array(\'Yes\', \'No\'), '); ALTER TABLE `products_attributes_download` ADD `products_attributes_filegroup_id` INT( 11 ) NULL AFTER `products_attributes_filename`; CREATE TABLE `products_attributes_download_groups` ( `download_group_id` INT( 11 ) NOT NULL , `download_group_name` VARCHAR( 255 ) NULL , `language_id` INT( 11 ) NOT NULL , PRIMARY KEY ( `download_group_id` , `language_id` ) ); CREATE TABLE `products_attributes_download_groups_files` ( `download_groups_file_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `download_group_id` INT( 11 ) NOT NULL , `download_group_filename` VARCHAR( 255 ) NOT NULL ); ALTER TABLE `products_attributes_download_groups_files` DROP PRIMARY KEY , ADD PRIMARY KEY ( `download_groups_file_id` , `download_group_id` ); CREATE TABLE `products_attributes_download_groups_to_files` ( `download_groups_file_id` INT( 11 ) NOT NULL , `language_id` INT( 11 ) NOT NULL , `download_group_file_description` VARCHAR( 255 ) NULL , PRIMARY KEY ( `download_groups_file_id` , `language_id` ) ); Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
sdreeper Posted November 5, 2007 Share Posted November 5, 2007 Hi Alex, a few months ago i asked for some advice because ordering of elements in the displayed download table is not possible. you answered, that you will implement it in a future release. my questions: will there be a future release? and if not: would it be a big problem to give me some hints, where and what to implement so that i could do it by myself? Greets Stan Quote Link to comment Share on other sites More sharing options...
sunshynevideo Posted November 5, 2007 Share Posted November 5, 2007 Hi Alex and thanks for the quick reply After I wrote the above message the other night I was able to get that other table installed by doing a manual import of the script rather then running a sql query. But the rest of the install went just fine and everything looks great. Just did a test order on the site and everything looks great except there is no link provided anywhere to download the file. so evidently I am missing something and I have to find out the spot to turn off the shipping fields as the shipping fields are still showing up when customer checks out. Contrib looks great. Any tips you have would be great! Quote Link to comment Share on other sites More sharing options...
sunshynevideo Posted November 5, 2007 Share Posted November 5, 2007 Ok found my problem why downloads were not showing up. I had not changed the database values for the download controller Great Add On! Thanks Again Quote Link to comment Share on other sites More sharing options...
Guest Posted November 6, 2007 Share Posted November 6, 2007 I may be a complete bonehead ...but I followed the install instructions to the letter but the new options dont appear under Configuration>>Downloads Looking at the admin/configuration.php i dont see the options as described in the Setup Downloads page. Am I missing something obvious? Thanks A Bonehead Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted November 7, 2007 Author Share Posted November 7, 2007 (edited) You need to run BOTH .sql scripts in phpMyAdmin. Edited November 7, 2007 by AlexStudio Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
nexus rex Posted November 9, 2007 Share Posted November 9, 2007 I have a solution for my problem (see screenshot on previouspage). The error is: Internet Explorer cannot download [file] from [site]. Internet Explorer was not able to open the Internet site. The requested site is either unavailable or cannot be found. Please try again later. Because this is a download via a SSL connection, Internet Explorer enforces any no-cache request. In catalog/download.php: BEFORE: include('includes/application_top.php'); ADD: session_cache_limiter('none'); And comment out these headers: //header("Cache-Control: no-cache, must-revalidate"); //header("Pragma: no-cache"); Thanks to Google and these sites: http://www.thescripts.com/forum/thread554529.html and http://www.openrdf.org/issues/browse/SES-63 Hope this helps others. Thank you very much. This did work for me, but I thought I would mention that I experienced this same problem on a standard connection, no SSL. Travis Cable Quote Link to comment Share on other sites More sharing options...
cktech010 Posted November 14, 2007 Share Posted November 14, 2007 Hi, installed this for use with PayPal IPN! Nearly all works, Paypal notifies that payment has been made, returns customer o the shop, Order status changes to Downloads Available...., but no Shortcuts to the Files appear? Any ideas? Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted November 14, 2007 Author Share Posted November 14, 2007 Did you check this post? Quote Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored. Link to comment Share on other sites More sharing options...
cktech010 Posted November 14, 2007 Share Posted November 14, 2007 I had been looking for that manual mod, as you mentioned it in the install html. have applied it, but still doesn't show the downloads? Quote Link to comment Share on other sites More sharing options...
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.