Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

impulsecreations

Pioneers
  • Posts

    13
  • Joined

  • Last visited

Profile Information

  • Real Name
    Dan Wallace

impulsecreations's Achievements

  1. As far as I know, there's always been an option to limit the number of articles to display in the info box. If there weren't, that box would quickly grow out of control in length. The setting that controls this is "Display Box Articles - All Blog Links Limit". there is no "Display Box Articles - New Blog Links Limit" though. I have tried turning off the options to display the other blogs/articles but then only the link to "New Articles" appears. There doesn't seem to be any way to have the individual links to the most recent blog articles appear as was the default before the blog feature was added. Unless I'm missing something, the only article links that the info box can display is "all" and the only order those can display in is alphabetical which means either a list of hundreds of articles which would overwhelm any site visitor or just the first few articles alphabetically which means visitors will never see articles that are higher in the alphabet unless they click on the link to "New Articles" which most visitors will never do. Is there something I'm overlooking or was this display change intentional when the blog feature was added?
  2. Prior to upgrading though, the info box displayed the most recent articles with a configuration setting to limit how many articles are displayed and how long to treat them as "new". I can still edit both of those settings but the info box simply displays all articles (up to the maximum setting) in alphabetical order. This prevents and new articles from displaying unless they happen to be very low alphabetically. How can I get it to display only the newest articles? I'm guessing that this has something to do with the fact that the previous version I had installed simply used articles and the new version has them as blogs but i'm not sure what I need to change to get the previous info box formatting with the blog articles.
  3. I know I've done something wrong but I can't figure out what. When using a coupon, the correct coupon amount and order total appear all the way through checkout but, during payment processing, the coupon amount is treated as being doubled. For example, during checkout, the order shows a subtotal of $20.00, a coupon amount of $2.00, and an order total of $18.00. When the processed though, only $16.00 is charged and the order in the order history shows a subtotal of $20.00, a coupon amount of $2.00, and an order total of $16.00. Does anyone know where I should look for the cause of this?
  4. Okay, I was able to fix the hacking issues but still have another problem. Since upgrading to the latest version of Article Manager, the info box now displays all articles instead of just the most recent ones so the list takes up a lot of space. Does anyone know what code controls what articles are displayed in the info box so I can edit that? Dan Wallace
  5. I've got a problem with my site being hacked and malicious code has been inserted somewhere which is affecting Article Manager. The specific issue that comes up is that clicking on any topic gets flagged as an error (by security software I have installed) due to address information being collected by a honey pot. The articles themselves are fine but I'm having trouble finding where this code has been added. Do you have any idea what specific file or database could be affected which is only called when trying to display a topic page? Dan Wallace
  6. Thanks, Jack. I still must be missing something though since I don't use attributes and my backup of advanced_search_result.php had no reference to "pov.products_options_values_name". the instructions for the latest version of Header Tags SEO said to replace a piece of code that did not include pov.products_options_values_name with a new piece of code that does include that bit. Anyway, I just removed "or ( pov.products_options_values_name like '%" . tep_db_input($keyword) . "%' )" from the code above and everything looks good now. Hopefully, this will help if anyone else should run into this issue. Dan Impulse Creations www.impulsecreations.com
  7. Obviously I missed something but this seems to be where the reference to "pov.products_options_values_name" is coming from: FIND: $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id"; ADD BENEATH: /*** Begin Header Tags SEO ***/ if (HEADER_TAGS_SEARCH_KEYWORDS == 'true') { $from_str .= " left join " . TABLE_HEADERTAGS_SEARCH . " hts on p.products_id = hts.product_id "; } /*** END Header Tags SEO ***/ FIND: $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; REPLACE WITH: /*** Begin Header Tags SEO ***/ if (HEADER_TAGS_SEARCH_KEYWORDS == 'true') { $where_str .= "(((pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%' or hts.keyword like '%" . tep_db_input($keyword) . "%' )"; } else { $where_str .= "(((pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%' )) or ( pov.products_options_values_name like '%" . tep_db_input($keyword) . "%' )"; } /*** End Header Tags SEO ***/ Did I miss some code elsewhere that's supposed to allow this function to work? Thank You, Dan Wallace Impulse Creations www.impulsecreations.com
  8. Thanks, Jack! That fixed that issue but now I'm getting a different search error: 1054 - Unknown column 'pov.products_options_values_name' in 'where clause' select count(distinct p.products_id) as total from ((products p) left join manufacturers m using(manufacturers_id), products_description pd) left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((((pd.products_name like '%marvel%' or p.products_model like '%marvel%' or m.manufacturers_name like '%marvel%' )) or ( pov.products_options_values_name like '%marvel%' )) ) Could this one be something I messed up? Dan Wallace Impulse Creations www.impulsecreations.com
  9. Jack, I just upgraded to the latest version but I had previously been using a version you installed which included some not yet fully functional elements. As a result, some of the upgrade instructions applied and some did not so I may very well have made a mistake somewhere. In any case though, the upgrade has broken the search function in the store. Any search (in this example, a search for "marvel") produces this error: 1054 - Unknown column 'found' in 'field list' update headertags_keywords set counter = counter+1, last_search = now(), found = 1 WHERE keyword = 'marvel' [TEP STOP] Do you know where I might have gone wrong? Thank You, Dan Wallace Impulse creations www.impulsecreations.com
  10. I have a coupon set up to only apply to items in one top level category. However, that category has many subcategories and there are products in those subcategories that are not in the parent category and I don't want the coupon to apply to those products but it is. How can I change the code to apply the coupon to only the category specified for the coupon but not any subcategories of that category? Dan Impulse Creations The Best Online Comic Book Store
  11. Thanks for the tip but I used this one: http://addons.oscommerce.com/info/1681 Its identified as being for MS2.2 and has the code I used. Is the latest version under this contribution actually not for MS2.2? Dan Impulse Creations www.impulsecreations.com
  12. I've installed the latest version of Master Products on MS2.2. My store has been modified so I had to hack up some of the new code and most likely made an error as I'm not able to set up or edit any master/slave products due to this admin error: Fatal error: Call to undefined function tep_draw_button() in /home/xxxxx/public_html/catalog/admin/categories.php on line 1867 The code producing this error is: <!-- Master Products //--> <td align="right" class="smallText"><?php if (sizeof($cPath_array) > 0) echo tep_draw_button(IMAGE_BACK, 'triangle-1-w', tep_href_link(FILENAME_CATEGORIES, $cPath_back . 'cID=' . $current_category_id)); if (!isset($HTTP_GET_VARS['search'])) echo tep_draw_button(IMAGE_NEW_CATEGORY, 'plus', tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&action=new_category')) . tep_draw_button(IMAGE_NEW_MASTER, 'plus', tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&action=new_master')) . tep_draw_button(IMAGE_NEW_PRODUCT, 'plus', tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&action=new_product')); ?> </td> <!-- Master Products EOF //--> As you might expect, none of the product editing buttons appear due to this error. Does anyone have any suggestions about where I might have gone wrong? Dan Impulse Creations www.impulsecreations.com
  13. Some time ago there were some references to adding some functionality to make the Froogle Feed compatible with large product databases. I may have just missed it but I haven't found anything since about that being added to any of the existing versions. Is that out there somewhere? I have over 40,000 products and have tried several versions of this contribution but none seem to work for me. I don't get any error messages though so I'm not certain that the problem is the number of products. I just suspect that it is. When I run the routine to generate the feed the browser just runs for a while (5-10 minutes) and then stops. No new page is displayed. It just says "Done" at the bottom of the browser window the same as it does after correctly loading any regular web page. No file is ever generated though. Is this due to the number of products? If so, is there a fix available? If not, does anyone know what else could be causing the problem? Thanks, Dan
×
×
  • Create New...