Jump to content

bhbilbao

Members
  • Content count

    308
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by bhbilbao


  1. Yes changing the URI format to standard the language seo works fine, for example:

    http://www. myweb. com/product_info.php/en/bugs-life-p-8

     

    it loads right.

     

    The .htaccess is the main archive in catalog folder.

     

    Im trying replacing:

     

     

    # If you are getting errors you may need to comment this out like ..
    # Options +FollowSymLinks
    Options +SymLinksIfOwnerMatch
    <IfModule mod_rewrite.c>
    # ErrorDocument 404 http://www. myweb .com/sitemap.php
    ErrorDocument 404 /sitemap.php
     RewriteEngine On
    rewritecond %{http_host} ^myweb .com [nc]
    rewriterule ^(.*)$ http://www. myweb .com/$1 [r=301,nc]
    
     RewriteBase / 
    
     RewriteRule ^([a-z0-9/-]+)-p-([0-9]+).html$ product_info.php [NC,L,QSA]
     RewriteRule ^([a-z0-9/-]+)-c-([0-9_]+).html$ index.php [NC,L,QSA]
    ...

     

    to

     

     

    # If you are getting errors you may need to comment this out like ..
    Options +FollowSymLinks
    # Options +SymLinksIfOwnerMatch
    <IfModule mod_rewrite.c>
    # ErrorDocument 404 http://www. myweb .com/sitemap.php
    ErrorDocument 404 /sitemap.php
     RewriteEngine On
    # rewritecond %{http_host} ^myweb .com [nc]
    # rewriterule ^(.*)$ http://www. myweb .com/$1 [r=301,nc]
    
     RewriteBase / 
    
     RewriteRule ^([a-z0-9/-]+)-p-([0-9]+).html$ product_info.php [NC,L,QSA]
     RewriteRule ^([a-z0-9/-]+)-c-([0-9_]+).html$ index.php [NC,L,QSA]
    ...


  2. Hi again Robert,

     

    this is my configuration:

     

    Enable SEO URLs 5? true

    Enable the cache? true

    Enable multi language support? true

    Output W3C valid URLs? true

    Select your chosen cache system? file

    Set the number of days to store the cache. 7

    Choose the uri format rewrite

    Choose how your product link text is made up p

    Filter Short Words 2

    Add category parent to beginning of category uris? true

    Remove all non-alphanumeric characters? true

    Add cPath to product URLs? false

    Enter special character conversions. (Better to use the file based character conversions)

    Turn performance reporting on true/false. false

    Turn variable reporting on true/false. false

    Force www.mysite.com/ when www.mysite.com/index.php false

    Reset USU5 Cache

     

     

    My problem is with the seo url languages.

    English (predefined)

    Deusch

    Espanol

     

     

    Going to the main landing page is ok. Example:

     

    www. mypage .com

     

    the I change the language clicking on the flag icon and it goes right to:

     

    www. mypage .com/index.php/de

     

    but then if I click on any category or product ( for example link to: http://www. mypage . com/de/bugs-life-p-8.html)

    it gets a broken link 404. not found.

     

    Other extrange thing. When modifing the .htaccess witch the rewrite rules i cannot enter again in the administration page; entering the loging and password the page says that the password is incorrect. If I delete the .htaccess archive I can enter again.

     

    php 5.2.17


  3. Congratulations Robert,

    finally working with this new version.

     

    Questions:

     

    Enable SEO URLs 5? false

    if I put to false, the USU5 continues working, and the rewrites also continues working.

     

    Enable the cache? true

    Select your chosen cache system?

    Where does SQlite and MySQL stores the data.??

    For the moment I use File and all goes right.

    Are the SQLite or MySQL faster?

     

    Enable multi language support? true

    This doesnt work for me.

    There is no www. myshop. com/en/ or www. myshop . com/en/product...

    I only have 1 language. But I need the multilanguage to work. Is that right?

     

    How can I manage the 404 errors?

    When it gets an error appears the logo of my host.

    How can I modify ir to include a sitemap???

    I modified .httpps to include:

    # ErrorDocument 404 http://www. myshop .com/sittemap.php

    ErrorDocument 404 /sitemap.php

     

    Choose the uri format path_rewrite

    Add category parent to beginning of category uris? true

    ../clothes/levis-c-928_288.html

     

    It seems to work, but in some categories it gets an 404 error.

     

    I must change the uri format to rewrite

    ../clothes-levis-c-928_288.html

     

    and working.

     

     

    In .httpps ¿how to include rewrites for other contribs?

    faqdesk_info.php

    pollbooth.php

    links.php

     

    For sitemaps /usu5_sitemaps/index.php

    Also didnt worked for me. It gets a white-blank page. I have more than 50000products. Shared host. Could be this??

     

     

    In the last update I see that there is not an old folder.(removed?)

    catalog/includes/modules/ultimate_seo_urls5/classes/

     

    I copied it inside from the old version. This is right?

     

    You said:

    "To fix this simply modify it to use the standard osc link coding and it will work with usu5." related to sitemap an HeaderTags.

    where is the link to such information?

    All my sitemaps are generated with Dinamic Sitemap contribution, but the urls are type:

    http://www. myshop .com/product_info.php?products_id=34509

     

    Then in webmaster tools:

    "URLs not followed When we tested a sample of URLs from your Sitemap, we found that some URLs redirect to other locations. We recommend that your Sitemap contain URLs that point to the final destination (the redirect target) instead of redirecting to another URL."

     

    Force www.mysite.com/ when www.mysite.com/index.php false

    Why this??

    If I turned on I gets that the "Page is not indexable" because it has a Canonical Link to "www. mysite .com/index.php"

    How to avoid or correct this??


  4. After clicking "Print Invoice" on checkout_success.php it opens a white page with empty data.

     

    ref:

     

     

    <?php //begin add receipt// ?>
    <td><div style="float:left"><a href="javascript:popupPrintReceipt('<?php echo tep_href_link(FILENAME_ORDERS_PRINTABLE2, 'oID=' . $last_order); ?>')"><?php echo tep_image_button('button_print_order.gif', IMAGE_BUTTON_PRINT_ORDER) . '</a>'; ?></div><div style="float:right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></div>
           </td>
    <?php //end add receipt// ?>


  5. Other question:

     

    I need to send email notifications all days, and need the cron not to delete the product from table PRODUCTS_NOTIFICATIONS.

    I commented this line:

    // tep_db_query("delete from " . TABLE_PRODUCTS_NOTIFICATIONS . " where products_id = '" . $value['products_id'] . "' and customers_id = '" . $value['customers_id'] . "' ");

     

    Here the problem is a customer with diferent products,.. the cron always send the same product, not all products customer has in his list.


  6. Need help with this contribution from 6 Nov 2006.

     

    http://addons.oscommerce.com/info/4641

     

    I searched for the original post , but there is nothing:

    http://forums.oscommerce.com/index.php?showtopic=235395

     

    The problem is when sending emails. Sends all Requested products to all customers, independent that the customer select it or not.

     

    The problem are queries, i don´t know how could be the correct maner.

     

          case 'email':
      $purchase_customer_query = tep_db_query("select distinct customers_id from purchase where notify=0");
           while ($purchase_customer = tep_db_fetch_array($purchase_customer_query)){
    
    $purchase_query = tep_db_query("select pch.purchase_id, pch.customer_name, pch.language, pch.products_id, pch.product_model, pch.product_name, pch.quantity from purchase pch left join products p using (products_id) where pch.notify = '0' and p.products_quantity >= pch.quantity and p.products_status = '1'");
    
               $purchase_count_query = tep_db_query("select count(*) as item_no from purchase pch left join products p using (products_id) where pch.notify = '0' and p.products_quantity >= pch.quantity and p.products_status = '1'");
    
               $purchase_count = tep_db_fetch_array($purchase_count_query);
    
               $customer_email_query = tep_db_query("select customers_email_address from customers where customers_id='".$purchase_customer['customers_id']."'");
    
               $customer_email = tep_db_fetch_array($customer_email_query);
    
               $purchase = tep_db_fetch_array($purchase_query);


  7. In my case, the product quantity field can´t be modified. It shows the quantities, but there isn´t any box to change them.

     

    Ref:

    $product_query = tep_db_query("select p.products_id, p.products_model, pd.products_name, pd.products_description, " . ($short ? 'pd.short_desc, ' : '') . "p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_tax_class_id, p.products_weight" . ($flaged ? ', pd.discount_description, p.products_discount_point, p.products_discount, p.products_deposit' : '') . " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . $pID . "' and p.products_id = pd.products_id");
    

     

    ...

     $sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']),
        											'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),
                             'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']),

     

    ...

     

              <tr>
               <td class="main"><?php echo TEXT_PRODUCTS_QUANTITY; ?></td><td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . ($edit_quantity ? tep_draw_input_field('products_quantity', $pInfo->products_quantity, 'size="10"') : $pInfo->products_quantity .  tep_draw_hidden_field('products_quantity', $pInfo->products_quantity)); ?></td>
             </tr>
             <!-- <tr>
       <td class="main">Products Condition:</td>


  8. With the original sitemap.class.php file:

     

    1054 - Unknown column 'customers_email_address' in 'where clause'
    
    SELECT products_id as pID, products_date_added as date_added, products_last_modified as last_mod, products_ordered
    		    FROM products
    			WHERE products_status='1' and customers_email_address = '' and quotes_email_address = ''
    			ORDER BY products_ordered DESC
    
    [TEP STOP]

     

    So that i read the instructions and used sitemap.class_Alternate.php renaming it to sitemap.class.php (for avoid problems with fopen) and making changes to the line i described in the post before.

     

    The Script only generates the xml for index, manufacturers and categories. Error for products, and withe for the rest.

     

    Could be problem of the more of 50000products on the shop???

    At the end of the log says ..".. out of memory.."


  9. A bit of history:

    When I wrote the Dynamic Sitemap contribution, I didn't include an option to create sitemaps since I knew there would be a compatibility issues and Chemo had already written Google XML Sitemap, which this one is based on. The purpose of the Dynamic Sitemap contribution was to provide an on-site site map while this one provides an off-site site map (both are needed for best SEO results). When someone added the option to Dynamic Sitemap to submit sitemaps, the problems started. I abandoned it at that point and wrote Sitemap SEO, which is superior to Dynamic Sitemap in all ways.

     

    So I recommend replacing Dynamic Sitemap with Sitemap SEO and then use this contribution to create your sitemaps.

     

    Im trying it also. But it gets an error.

    The script don´t generates the xml for products(error), specials(empty) and standard pages(empty).

     

    I had problems with fopen and renamed to sitemap.class.php, and replaced code to $this->savepath = '/homepages/6/xxxxxxx/htdocs/';

     

    ERROR: Google Product Sitemap Generation FAILED!
    
    Write /home/www/mysite.com/sitemapcategories.xml
    Generated Google Category Sitemap Successfully
    
    Write /home/www/mysite.com/sitemapmanufacturers.xml
    Generated Google Manufacturers Sitemap Successfully
    
    Write /home/www/mysite.com/sitemapspecials.xml
    Generated Google Specials Sitemap Successfully
    
    Write /home/www/mysite.com/sitemapindex.xml
    Generated Google Sitemap Index Successfully
    
    Fatal error:  Out of memory (allocated 26214400) (tried to allocate 710 bytes) in /homepages/6/xxxxxxx/htdocs/googlesitemap/sitemap.class.php on line 630


  10. Hi Kymation,

     

    I need a similar contribution like this. But I need the downloable documentes attached to orders (like invoices, picking lists, RMAS, issues, etc). This because I created them with othe software outside oscommerce admin.

     

    Can you suggest me a contibution that makes that.

     

    Thanks in advance.


  11. Need help with Header Tags SEO V 3

     

    In the admin section i marked X Canonical.

     

    Then if I visit the main page www . myweb . com a pluging of firefox says that "The page is not indexable because this page has a canonical URL set to www . myweb .com / index.php."

     

    I dont know if this is rigth.

     

     

    If I enter www . myweb .com / index.php , the firefox pluging says that is right.

     

    suggestion?


  12. Need help for this issue.

     

    Now, sometimes when clicking on product i get this url:

    www myweb com/productname-p-3730.html?manufacturers_id=3

     

    and i want the canonical URL:

    www myweb com/productname-p-3730.html

     

    I dont want the final "?manufacturers_id=3"

     

    where can i modify this??

    is something I changed in code but Im going crazy finding it.


  13. Yes, tell us what is not working.

     

    For the moment I got the name_trail working with this code:

    // add the products model to the breadcrumb trail KISSMT
     if (isset($HTTP_GET_VARS['products_id'])) {
       $name_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' AND language_id=" . (int)$languages_id . "");
       if (tep_db_num_rows($name_query)) {
         $name = tep_db_fetch_array($name_query);
         $breadcrumb->add($name['products_name'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id']));
       }
     }

     

     

    But I dont know how to integrate the sppc code, specially the followith code:

     

    ref:

    // BOF SPPC Hide products and categories from groups
    //    $model_query = tep_db_query("select p.products_model from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0");
    // EOF SPPC Hide products and categories from groups

     

    I need a name_query not the model_query. What could be the coorect code for this??


  14. Sppc Breadcrumb trail help

     

    original code:

    // add the products model to the breadcrumb trail
    //  if (isset($HTTP_GET_VARS['products_id'])) {
    // BOF SPPC Hide products and categories from groups
    //    $model_query = tep_db_query("select p.products_model from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0");
    // EOF SPPC Hide products and categories from groups
    //    if (tep_db_num_rows($model_query)) {
    //      $model = tep_db_fetch_array($model_query);
    //      $breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id']));
    //    }
    //  }

     

     

    working:

    // add the products name to the breadcrumb trail
    if (isset($HTTP_GET_VARS['products_id'])) {
    
      $crumb_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . $languages_id . "'");
    
    if (tep_db_num_rows($crumb_query)) {
      $crumb = tep_db_fetch_array($crumb_query);
       $breadcrumb->add($crumb['products_name'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id']));
      }
     }

     

    not working:

    // add the products name to the breadcrumb trail sppc
     if (isset($HTTP_GET_VARS['products_id'])) {
    // BOF SPPC Hide products and categories from groups
       $crumb_query = tep_db_query("select p.products_model, p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " .  TABLE_PRODUCTS_DESCRIPTION . " pd  left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0");
    // EOF SPPC Hide products and categories from groups
     if (tep_db_num_rows($crumb_query)) {
       $model = tep_db_fetch_array($crumb_query);
         $breadcrumb->add($crumb['products_name'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id']));
      }
    }

     

    some suggestion?


  15. Need help with this error in dynamic_sitemap.php

     

    1052 - Column 'categories_status' in where clause is ambiguous

     

    select * from categories c, categories_description cd where parent_id = '0' and c.categories_id = cd.categories_id and categories_status = 1 and cd.language_id = '3' order by sort_order, cd.categories_name

     

    [TEP STOP]

     

    The code:

    $category_status_check = '';
    $check_query = tep_db_query("select * from " . TABLE_CATEGORIES);
    $check = tep_db_fetch_array($check_query);
    if (isset($check['status_categ'])) { // skip if this is not set to avoid SQL error
     $category_status_check = ' and status_categ = 1';
    } elseif (isset($check['categories_status'])) { // [b]skip if this is not set to avoid SQL error[/b]
     $category_status_check = ' and categories_status = 1';
    }
    function getFileName($file, $define)        //retrieve the defined filename
    { 
      $fp = file($file);
      for ($idx = 0; $idx < count($fp); ++$idx)
      {
         if (!(strpos($fp[$idx], $define) === FALSE))
         {
             $parts = explode("'", $fp[$idx]);   
             return $parts[3];     
         }
      }    
      return NULL;
    }

×