imagixx Posted May 1, 2007 Share Posted May 1, 2007 OK, I got that. But when you assign an download to an attribute, I assume the way it works, you should have a scroll list of the files available as previously entered in the FileGroups. Instead of that list, you have only "Group_Files-1" in the box where the name of the file should be. I assume it's trying to call Group_Files-1. There's no choice for a file selection. Works fine if No File Group is the choice. I'll get this. Thanks for you patience. Martin Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted May 1, 2007 Author Share Posted May 1, 2007 The filenames are listed in the Files in Group area, but not listed in the attributes. I don't think it's a good idea to list all files in the group, in the drop down menu where to select the group to be assigned to an attribute. 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...
imagixx Posted May 1, 2007 Share Posted May 1, 2007 I think there's a misunderstanding in communication here. I have a product and want to make a download available for that product. I'm at the admin/products_attributes.php page When I edit the product's attribute, the correct group is there, but the filename indicates: Group_Files-1 The file that I would like to make available within the group is not there; the filename is NOT retrieved and NOT retained when I try to include a download to a product with a group selected. However, if No File Group is elected, a filenanme can be entered, and is properly recalled when I come back to edit. Martin Quote Link to comment Share on other sites More sharing options...
imagixx Posted May 1, 2007 Share Posted May 1, 2007 I think there's a misunderstanding in communication here. I have a product and want to make a download available for that product. I'm at the admin/products_attributes.php page When I edit the product's attribute, the correct group is there, but the filename indicates: Group_Files-1 The file that I would like to make available within the group is not there; the filename is NOT retrieved and NOT retained when I try to include a download to a product with a group selected. However, if No File Group is elected, a filenanme can be entered, and is properly recalled when I come back to edit. Martin Quote Link to comment Share on other sites More sharing options...
imagixx Posted May 1, 2007 Share Posted May 1, 2007 I think there's a misunderstanding in communication here. I have a product and want to make a download available for that product. I'm at the admin/products_attributes.php page When I edit the product's attribute, the correct group is there, but the filename indicates: Group_Files-1 The file that I would like to make available within the group is not there; the filename is NOT retrieved and NOT retained when I try to include a download to a product with a group selected. However, if No File Group is elected, a filenanme can be entered, and is properly recalled when I come back to edit. Martin Quote Link to comment Share on other sites More sharing options...
imagixx Posted May 1, 2007 Share Posted May 1, 2007 Screen Shots Notice Group within filename. Notice proper filename without group TIA Martin Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted May 1, 2007 Author Share Posted May 1, 2007 (edited) That is exactly how the file group works. You got a blank download page when clicking on the download link probably because you didn't apply the modification in checkout_process.php, for the group to be broken into individual files. Please check the orders_products_download table and see what filenames got logged with the order. Please notice that you are not supposed to pick a file from a group to be assigned to a product attribute. When a file group assigned to an attribute, every file in that group will be listed as downloads in that sigle item. Edited May 1, 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...
imagixx Posted May 1, 2007 Share Posted May 1, 2007 As Homer woulds day. DOH! Thanx. Martin Quote Link to comment Share on other sites More sharing options...
Patty Posted May 1, 2007 Share Posted May 1, 2007 Hello. Tks for such a nice contribution. :thumbsup: I'm having a problem trying to install it though: I'm using the Admin Order Sort contribution, which modified file admin/orders.php, making impossible for me to apply the changes for Super Download with just a comparing editor. So could you please give me a hand here by giving me a step-by-step instruction on how to merge the last change in the file? It's after line 359 on the file inside your zip, right after <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> </tr> <?php If it helps, this is how my code looks like for this part: // Admin Order Sort Mod Applied } else { if (isset($HTTP_GET_VARS['viewedSortOrder'])) { $viewedSortOrder = $HTTP_GET_VARS['viewedSortOrder']; tep_session_register('viewedSortOrder'); } if (isset($HTTP_GET_VARS['page'])) { $page = $HTTP_GET_VARS['page']; tep_session_register('page'); } if(!isset($page)) $page = 1; switch ($viewedSortOrder) { case "customer-asc": $order .= "customers_name"; break; case "customer-desc": $order .= "customers_name DESC"; break; case "date-asc": $order .= "date_purchased"; break; case "date-desc": $order .= "date_purchased DESC"; break; case "status-asc": $order .= "orders_status_id"; break; case "status-desc": $order .= "orders_status_id DESC"; break; default: $order .= "orders_id DESC"; } ?> <tr> <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td> <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?> <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('oID', '', 'size="12"') . tep_draw_hidden_field('action', 'edit'); ?></td> </form></tr> <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?> <td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td> </form></tr> </table></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?> <a href="<?php echo "$PHP_SELF?viewedSortOrder=customer-asc"; ?>"><img src="../images/icons/sort_down.gif" border="0" width="18" height="10" alt="Descendente"></a><a href="<?php echo "$PHP_SELF?viewedSortOrder=customer-desc"; ?>"><img src="../images/icons/sort_up.gif" border="0" width="18" height="10" alt="Ascendente"></a></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?><br><a href="<?php echo "$PHP_SELF?viewedSortOrder=date-asc"; ?>"><img src="../images/icons/sort_down.gif" border="0" width="18" height="10" alt="Descendente"></a><a href="<?php echo "$PHP_SELF?viewedSortOrder=date-desc"; ?>"><img src="../images/icons/sort_up.gif" border="0" width="18" height="10" alt="Ascendente"></a></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?><br><a href="<?php echo "$PHP_SELF?viewedSortOrder=status-desc"; ?>"><img src="../images/icons/sort_down.gif" border="0" width="18" height="10" alt="Descendente"></a><a href="<?php echo "$PHP_SELF?viewedSortOrder=status-asc"; ?>"><img src="../images/icons/sort_up.gif" border="0" width="18" height="10" alt="Ascendente"></a></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php if (isset($HTTP_GET_VARS['cID'])) { $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order"; } elseif (isset($HTTP_GET_VARS['status']) && is_numeric($HTTP_GET_VARS['status']) && ($HTTP_GET_VARS['status'] > 0)) { $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "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 " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } else { $orders_query_raw = "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 " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by $order"; } $orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows); $orders_query = tep_db_query($orders_query_raw); while ($orders = tep_db_fetch_array($orders_query)) { if ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) { $oInfo = new objectInfo($orders); How can I merge the changes required by your contribution into this part of the code? I appreciate any help you could give me. Thank you in advance. :) Quote Patty Link to comment Share on other sites More sharing options...
AlexStudio Posted May 1, 2007 Author Share Posted May 1, 2007 Patty, you have 2 options here. The 1st one which I recommended, is to keep your existing sort order contribution and skip the last part in this file came with SDS. The other is to remove that sort order contribution you installed, and so you can apply the modification came with SDS. The sort order part of the code came from the downloads controller v5.3 package, and I didn't remove them because it's kind of handy. Unfortunately it won't work with the Admin Order Sort contribution you have installed. Actually they are doing the same thing in similar methods. 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...
Patty Posted May 1, 2007 Share Posted May 1, 2007 Tks for your quick reply, Alex. :) Yeah, I just realized that. This is what I'm gonna do, I'm removing the admin sort order already. Tks for the hint. And tks for your prompt follow up to your contribution. Really nice of you. :) Quote Patty Link to comment Share on other sites More sharing options...
Patty Posted May 2, 2007 Share Posted May 2, 2007 I was just wondering if you would know why I might still be getting this error: 1136 - Column count doesn't match value count at row 1 insert into products_attributes values ('', '266', '8', '10', '', '+') [TEP STOP] It doesn't seem to be the catalog/admin/products_attributes.php file. As it stands now, I can't add product attributes as a single file or a group. It seems to not write some of the information to the database or something. Any insight would be greatly appreciated. I'm having the same problem: 1136 - Column count doesn't match value count at row 1 insert into products_attributes values ('', '28', '5', '10', '', '+') [TEP STOP] I checked file catalog/admin/products_attributes.php and it's not it, it matches the one from the contribution. This is my table products_attributes: products_attributes_id products_id options_id options_values_id options_values_price price_prefix options_values_weight Also I'm using the Ajax Attributes Manager contribution, but I don't think it altered any tables. So what's wrong here and how can I fix it? TIA for your help. Quote Patty Link to comment Share on other sites More sharing options...
Patty Posted May 2, 2007 Share Posted May 2, 2007 Never mind. It's a leftover from a deleted contribution. Sorry. :( Quote Patty Link to comment Share on other sites More sharing options...
Patty Posted May 2, 2007 Share Posted May 2, 2007 Ops! Spoke too soon! :blush: Actually, I do need that column "options_values_weight". So I do need to include it in the products_attributes.php Could you help me with that? :-" Quote Patty Link to comment Share on other sites More sharing options...
Patty Posted May 2, 2007 Share Posted May 2, 2007 (edited) Fixed. I had to add the Add weight to attribute contribution again. Sorry about so many useless posts, but the edit function is disabled within minutes. Edited May 2, 2007 by Patty Quote Patty Link to comment Share on other sites More sharing options...
samrinroy Posted May 8, 2007 Share Posted May 8, 2007 I already installed osCommerce 2.2 Milestone 2 Update 060817 and it running successfully Then I want to install Super Download Shop 1.1 and I import group_file_for_download.sql. When I try to run filegroup_db_setup.php, it shows the following error " 1146 - Table 'shop.table_products_attributes_download_groups' doesn't exist select * from TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD_GROUPS where download_group_id = 0 and language_id = '1' [TEP STOP] " Please help me to install Download Shop 1.1. Thanks, Bhaskar Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted May 8, 2007 Author Share Posted May 8, 2007 Please try following this post first. 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 May 8, 2007 Share Posted May 8, 2007 HI Alex, After doing the instalation, and double checking everything, I do receive the following error message when trying to enter admin side: 1046 - No Database Selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] Any ideas? BR, J Quote Link to comment Share on other sites More sharing options...
imagixx Posted May 8, 2007 Share Posted May 8, 2007 HI Alex, After doing the instalation, and double checking everything, I do receive the following error message when trying to enter admin side: 1046 - No Database Selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] Any ideas? BR, J I had the same problem setting up a redundant site. I didn't have my database user accessing the database. Go into your phpAdmin, check that ytour user has access to the DB with all permissions. I just clicked adduser to the db, and all worked fine. Imagixx Quote Link to comment Share on other sites More sharing options...
Guest Posted May 8, 2007 Share Posted May 8, 2007 I had the same problem setting up a redundant site. I didn't have my database user accessing the database. Go into your phpAdmin, check that ytour user has access to the DB with all permissions. I just clicked adduser to the db, and all worked fine. Imagixx HI, Did try that, but didn´t help? Is there an issue since I have 2 db´s under my domain and they both have the same uid and password for accessing the db´s? BR, J Quote Link to comment Share on other sites More sharing options...
imagixx Posted May 8, 2007 Share Posted May 8, 2007 HI, Did try that, but didn´t help? Is there an issue since I have 2 db´s under my domain and they both have the same uid and password for accessing the db´s? BR, J I'm not the expert here, just getting by. The same uid and password wouldn't make a difference. It seems to me that your user isn't accessing the proper DB. Recheck your config files. Then make siure the designated user has access and permissions to the right DB. Imagixx Quote Link to comment Share on other sites More sharing options...
b0se Posted May 16, 2007 Share Posted May 16, 2007 Essential plugin, thanks Alex. Is there a simple PayPal plugin that automatically sets order status? Quote Link to comment Share on other sites More sharing options...
b0se Posted May 17, 2007 Share Posted May 17, 2007 (edited) If there was an Ajax file selector instead of having to type the filename in manually, this plugin would reach the next level. Anyone capable of accomplishing this? Is there another plugin that uses this technique that can be used as a base? Either that or make this contrib work with the File Upload plugin. Edited May 17, 2007 by b0se Quote Link to comment Share on other sites More sharing options...
Guest Posted May 20, 2007 Share Posted May 20, 2007 Hi, I've installed this contribution ok but am having a few issues getting the download links to work at checkout_success.php. Am wondering if anyone can help? I've read through all the comments here but no luck in working out the issue yet and the contribution looks really great so I don't want to give up on it! I have 2 items in my download group. When I get to checkout_success only the name of my product appears with no link (rather than the correct two files with links as shown in the screenshots in the docs). Cause I couldn't make the groups work, I then tried selecting 'no file group' in product attributes and entering just the single file name. When I got to checkout success it then gave the name of my product with a link however the link is for 'download.php' instead of my file and looks to be a whole heap of gibberish. I've checked the file names are correct for both options. I am using Ultimate SEO URLs v 2.2.1 however even if I turn this off I get the same results. I am also using Paypal IPN. I've applied the suggested fix in the paypal_ipn.php file and this works fine but doesn't help or change the link issue. Any clues? Help would be greatly appreciated! Thanks, Becdjane Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted May 20, 2007 Author Share Posted May 20, 2007 The latest Ultimate SEO URLs version is 2.1d, and it works fine with Super Download Shop. The v2.2.1 you're using has been removed from the contribution area, and I believe that it is not as stable as v2.1d. 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...
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.