Jump to content


  • Content count

  • Joined

  • Last visited

Posts posted by olsonsp4c

  1. You are both welcome.


    I think the issue you are experiencing most likely has to do with your browser cache. You can test to see if this is the case:


    1. Open both windows

    2. Disable Testing mode in one window

    3. Click around in the other window (should continue getting the maintenance page)

    4. Now clear the browser cache

    5. Refresh and see if you now can view your store with the red bar at the top reminding you that you are in maintenance mode



  2. After installing Product Sort, 1st 1.4, then 1.6, now 1.7 on rc2a - for some time now, in my product listing in the store, when I click a buy now button - it adds the product to the shopping cart and then changes all the products in the product listing to the same product id. Does anyone else have this issue and a fix?



  3. Hi,


    I'm trying to install Product Sort v1.7 contribution



    and having problem right off the bat.


    When I run the following product_sort.sql,


    ALTER TABLE products ADD `products_sort_order` INT(3);
    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 (263, 'Display Product Sort Order', 'PRODUCT_SORT_ORDER', '0', 'Do you want to display the Product Sort Order column?', 8, 29, '', '', NULL, NULL);


    I get the "#1062 - Duplicate entry '263' for key 1" error message.


    Your help would be greatly appreciated,




    it means there is already an entry in your database for id=263 - just change the id in your sql statement to another number, like 432 or something and you should be fine. alternatively just leave it blank '' and it will pick the next available id.



  4. 2 ideas:


    1. Check catalog/pdf/pdf_datasheet_functions.php:


    require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PDF_DATASHEET);


    make sure these lines are configured properly...


    2. Check catalog/includes/configure.php:


      define('HTTP_SERVER', 'http://www.your-domain.com');
     define('HTTPS_SERVER', 'https://www.your-domain.com');
     define('ENABLE_SSL', true); // if you have SSL (true)
     define('HTTP_COOKIE_DOMAIN', 'www.your-domain.com');
     define('HTTPS_COOKIE_DOMAIN', 'www.your-domain.com');
     define('HTTP_COOKIE_PATH', '/');
     define('HTTPS_COOKIE_PATH', '/');
     define('DIR_WS_HTTP_CATALOG', '/');
     define('DIR_WS_HTTPS_CATALOG', '/');
     define('DIR_WS_IMAGES', 'images/');
     define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
     define('DIR_WS_INCLUDES', 'includes/');
     define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
     define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
     define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
     define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
     define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
     define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
     define('DIR_FS_CATALOG', '/home/yourdomain/www/www/'); // could also be something like /home/yourdomain/www/public_html/
     define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
     define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');


    make sure these are configured properly...


    if this doesn't work, message me with your website address and I'll take a quick look too.



  5. Hi again. After install correctly the product attibutes, it will be for me great to have the attribute cloner. Where can I found the instructions? is it easy? I have more that 500 products and differents sizes and colors for each one so I need it because, if not, I will go crazy. Thank you in advance,




    It is included in v1.8 of product attributes sort order that I submitted today: http://addons.oscommerce.com/info/1822



  6. Change in admin/products_attributes row 76(or somewhere near...)

    tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "','', '".tep_db_input($attributes_sort)."')");


    For some reason the last part was missing....


    Yes, I posted the fix: http://forums.oscommerce.com/index.php?s=&...t&p=1363928


    I'm coming out with a streamlined version in the next hour.



  7. The only suggestion that I could have is that you copy the english files back to your store and see if that effects anything. You can disable the language in your admin, so they don't need to be deleted anyways. As it works on more than 20 stores that I know of personally, and I can not duplicate the issue, it is difficult to further troubleshoot. Is anyone else out there having this issue that can help him?



  8. hello,


    logo is ok, but the line with categorie and product_name is only grey and ">" is on the grey line.




    Well, it works on my site so I can't really give you any pointers there... this is the code that inserts that in pdf\pdf_datasheet_functions.php


    First here:


    	// Header Text
    $path = $this->GetPath($products_id, $languages_id);
    $products_name = $this->ProductsName($products_id, $languages_id);
    $this->SetFillColor($header_color_table[0], $header_color_table[1], $header_color_table[2]);
    $this->Cell(0,6,$path .' > '. $products_name,0,0,'L',1);


    And the queries are later here:


      function GetPath($products_id, $languages_id) {
    $cPath = '';
    $cat_count_sql = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $products_id . "'");
    $cat_count_data = tep_db_fetch_array($cat_count_sql);
    if ($cat_count_data['count'] == 1) {
      $categories = array();
      $cat_id_sql = tep_db_query("select pc.categories_id, cd.categories_name from " . TABLE_PRODUCTS_TO_CATEGORIES . " pc,  " . TABLE_CATEGORIES_DESCRIPTION . " cd where
    							  pc.products_id = '" . $products_id . "' and
    							  cd.categories_id = pc.categories_id and
    							  cd.language_id = '" . $languages_id . "'");
      $cat_id_data = tep_db_fetch_array($cat_id_sql);
      tep_get_parent_categories($categories, $cat_id_data['categories_id']);
      $size = sizeof($categories)-1;
      for ($i = $size; $i >= 0; $i--) {
    	if ($cPath != '') $cPath .= ' > ';
    	$parent_id_sql = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where
    									  categories_id = '" . $categories[$i] . "' and
    									  language_id = '" . $languages_id . "'");
    	$parent_id_data = tep_db_fetch_array($parent_id_sql);
    	$cPath .= $parent_id_data['categories_name'];
      if ($cPath != '') $cPath .= ' > ';
      $cPath .= $cat_id_data['categories_name'];
    return $cPath;
     function ProductsName($products_id, $languages_id) {
    $products_name_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where
    									 products_id = '" . $products_id . "' and
    									 language_id = '" . $languages_id . "'");
    $products_name = tep_db_fetch_array($products_name_query);
    return $products_name['products_name'];


    If you've modified any of the defaults in your store, this would cause an error - I'm sure it could be other things as well, I just don't know what.



  9. I have installed this contribution, and now it seems that I can't delete any product options. When I'm on the product attributes screen, I can delete Option Values, but can't delete Product Options. I'm not sure if this contribution is what broke it, or maybe it's the Mindsparx Admin contribution I installed.


    Anyone else have this issue?




    You are correct - I have the same issue



  10. Great!!! It works!!! Yuhuuuuuuuuu!!! After 4 ó 5 days, I can order my attributes!!! Yuhuuuuuu!!!! THANKS, THANKS, THANKS. The only extrange thing I see is: when I add one attibute, I add to it the order (the number...) but it doesnt get it. I have to search it in the list and change. And now it gets it and works. Why? Cant I do it in the first time? It is a little hard to do because the order in the list is a little caos...

    Also, the next step is: ¿what is the contribution to order the products? Is it easy to install? Thanks to all for the help. I primise I am going to help all I can. Thanks,




    there is an add-on called Product Sort - I've installed v1.6, but it has some problems in the product listing, changing all the buy now button links to the same product number when 1 product is added to the cart when the shop is set not to go directly to the cart when a product is added. I know where the problem is, but not how to fix it - for now, I working around it. It is a little challenging to install, but is helpful - i have not tried 1.7 yet.



  11. Thank you for the contribution.

    I have the following problem. The header of the pdffile is not correct. It is neither the category nor the product name. Everything else is fine.




    did you verify that the logo name you uploaded is in the catalog/images file and that the name is EXACTLY the same in the Admin as the file you uploaded - i.e. logo.jpg NOT logo.JPG that there are no spaces in the name of the logo: my_logo.jpg NOT my logo.jpg ?



  12. New version 1.5 out: http://addons.oscommerce.com/info/5783


    Changes since v1.4


    * Added catalog and admin functions to general.php

    * Added an edit that was missing from all previous versions in modules.php

    * Recoded the entire module to display all USPS domestic and international flat rate shipping methods

    * Updated the Priority Mail Flat Rate Shipping rates links at the top of the admin panel

    * Updated instructions

    * Updated screenshots



  13. Ya because when the window pops up it does include all the menus and is resizable and everything.


    Where else would have have to go change it though??? must be in several different files.


    (I have a few contributions) www.autopartsfirmonline.com


    the easiest way is to just change it in the infobox file... change popupWindow to livesupportpopupWindow and see if that fixes it



  14. Ok this is strange. On the admin side the screen sizes fine. But on the client side like I said the screen comes up almost as a full page and yet I looked up the settings and they are set at 5xx and 400 already, but for some reason it is not following that? wonder if there is an error in the script?


    THis is the script in includes/boxes/live_support.php (I enlarged the sizes a bit as a test)


    <script language="javascript"></script>


    In should read like this with no line break after "res" or after "lef":


    <script language="javascript"><!--
     function phpOnlinePopupWindow() {
     var url = "<?php echo $phpOnline_base_url.'/client.php';?>";


    in this example you gave, the width is 650 and height 450


    you might check your index.php to see if there is another popup script with the same name "popupWindow" - if so, rename that part.



  15. Thanks Scott. Sorry for the question, you must think I am idiot but I only have to change one file to install the attributes module? Is there one step by step instructions that works? The change you tell me, is in the file with the code I wrote in the first post? Thank you very very much for your help. I am 4 days with this and I need help. Thanks. If you are in New York, I would like to invite you to one beer. Or two... Thanks and sorry for my bad english. Thanks.


    The changes I wrote are in admin/product_attributes.php


    Fortunately, v1.6 has step by step instruction; however, what I wrote above must replace one of those steps. Thanks for the kind offer - if I wasn't in Portland, OR, I'd take you up on it. Also, the instructions for 1.6 make the file changes more clear. Also, the database insert is correct in 1.6; however, 1.6 does not include the attribute cloner.



  16. I hate to mention this, but exactly how to fix the parse error mentioned above is mentioned in the "troubleshooting" section of 3.0.2 - it says exactly what Jan mentioned above. I usually try to include this info in an addon installation doc if I know of a particular issue. Thank you to Jan for answering it anyways and providing the SQL statement.



  17. I have this same problem... I think this is the solution:


    	  case 'add_product_attributes':
    	 $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);
    	 $options_id = tep_db_prepare_input($HTTP_POST_VARS['options_id']);
    	 $values_id = tep_db_prepare_input($HTTP_POST_VARS['values_id']);
    	 $value_price = tep_db_prepare_input($HTTP_POST_VARS['value_price']);
    	 $price_prefix = tep_db_prepare_input($HTTP_POST_VARS['price_prefix']);
    	 $attributes_sort = tep_db_prepare_input($HTTP_POST_VARS['attributes_sort']);
    	 tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values (null, '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . (float)tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "', '" . (int)$attributes_sort . "')");


    The last line was not correct in the fileset... I think this one in correct.




    ALSO, I think the Database SQL in incorrect - you only need the following line:


    NOT this:

    ALTER TABLE products_attributes ADD sort_order INT DEFAULT '50' NOT NULL; 
      ALTER TABLE products_attributes ADD COLUMN attribute_sort INT UNSIGNED NOT NULL DEFAULT '0';


    BUT this:


    ALTER TABLE products_attributes ADD COLUMN attribute_sort INT UNSIGNED NOT NULL DEFAULT '0';



  18. You are right. I looked at the source in IE and saved that and opened it in Dreamweaver and the problem is line is in the code from the following:


    			var RecaptchaOptions = {
    			theme : 'clean',
    			tabindex : 3,
    			lang : '<?php if (in_array($language_id['code'] ,array('en', 'nl', 'fr', 'de', 'pt', 'ru', 'es', 'tr'))) {echo $language_id['code']; } else {echo 'en'; } ?>',


    This is the line the problem is in:




    By googling it seems either "," or a ";" is in the wrong place or needs to be removed.


    Also the create account page takes about 10 seconds or so load whereas before it opened instantly before having recaptcha installed. If i remove recaptcha everything works fine and no errors in IE


    Please replace:


    				lang : '<?php if (in_array($language_id['code'] ,array('en', 'nl', 'fr', 'de', 'pt', 'ru', 'es', 'tr'))) {echo $language_id['code']; } else {echo 'en'; } ?>',




    				lang : '<?php if (in_array($language_id['code'] ,array('en', 'nl', 'fr', 'de', 'pt', 'ru', 'es', 'tr'))) {echo $language_id['code']; } else {echo 'en'; } ?>';


    and let me know the results...



  19. Hi Everyone


    I am using v1.4.4 of this great contribution and i have an error appearing when i use IE.


    The error i am getting is:


    Line: 671

    Char: 5

    Error: Expected identifier, string or number

    Code: 0

    URL: https://localhost/shop/catalog/create_accou...osCsid=(SESSION ID)


    The section the error is on is in:


           <td class="main"><b><?php echo ENTRY_SECURITY_CHECK1; ?></b></td>
           <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
             <tr class="infoBoxContents">
               <td><table border="0" cellspacing="2" cellpadding="2">
    			$languages_query = tep_db_query("select code from " . TABLE_LANGUAGES . " where directory = '" . $language . "'");
    			$language_id = tep_db_fetch_array($languages_query);
    			var RecaptchaOptions = {
    			theme : 'clean',
    			tabindex : 3,
    			lang : '<?php if (in_array($language_id['code'] ,array('en', 'nl', 'fr', 'de', 'pt', 'ru', 'es', 'tr'))) {echo $language_id['code']; } else {echo 'en'; } ?>',
    			<td><?php echo recaptcha_get_html(RECAPTCHA_PUBLIC_KEY, null, ($request_type == 'SSL')); ?></td>


    The line the error is on is below the following code:


            <td class="main"><b><?php echo ENTRY_SECURITY_CHECK1; ?></b></td>
           <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
             <tr class="infoBoxContents">
               <td><table border="0" cellspacing="2" cellpadding="2">


    The error line is:




    I am sure it is something simple but i am not too fluent with php .. just know how to follow instructions in the install notes.


    Any help would be appreciated.


    I don't see an error, so I'm wondering if IE is counting lines differently that the program you are using that counts them...



  20. Thank you for the contribution. I have it working 99%.


    First, the code in 1.71 for the link in product_info.php is still buggy... the following is working for me (got rid of IE errors). I think you were just missing a / on a </td>

    <!-- Begin PDF Datasheets //-->				
    			 <td align="center" valign="middle" class="main"><?php echo '<table border="0" cellspacing="0" cellpadding="0"><tr><td valign="middle"><a href="' . tep_href_link(FILENAME_PDF_DATASHEET, 'products_id=' . $product_info['products_id']) .'" target="_blank">' . TEXT_PDF_DOWNLOAD1 . '</a> </td><td valign="middle"><a href="' . tep_href_link(FILENAME_PDF_DATASHEET, 'products_id=' . $product_info['products_id']) .'" target="_blank">' . tep_image('images/pdf.gif',TEXT_PDF_DOWNLOAD2) . '</a></td></tr></table>'; ?></td>	
    <!-- End PDF Datasheets //-->


    The 2 issues I am seeing are:

    1. The top half of product descriptions is not alwsys being included. Sometimes it is, sometimes not. I've read this entire thread and have seen the same issue but no definitive solution. Anyone?

    2. Certain special characters like TM show as & #8442;, and single quotes as & #8221; etc.... Where can I modify the special character handling?


    Thanks for any help or a kick in the right direction.


    the link is fixed in 1.72 - issue 2 is addressed in 1.72 - i've sometimes seen formatting issues IF you don't either have the product name, manufacturer, or model number before the description - one of them must be selected... don't know why it doesn't include part of the description...