Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mvanderhoff

Pioneers
  • Posts

    80
  • Joined

  • Last visited

Posts posted by mvanderhoff

  1. Okay, need some help.

     

    I was given a new site to look at today and it was coded by someone who did not know what they were doing.

     

    It still uses the Header Tags SEO v3.2.5 and the Currently Viewing shows the item title, like it should but the Title of the page is showing a URL. Any suggestions on what the hell is wrong?

     

    I did download the v3.2.5 full install contrib and going line by line but almost everything matches. Making me go crazy.

     

    Oh and there is no backups SMH!

  2. Question.

     

    Is it possible to have both pages of links (say 20 links per page) and also have the ability to View All or Show All the links.

     

    I tried the php function of "display=all" and that did not work.

     

    Thanks in advance.

  3. Also on products getting this error:

     

    1054 - Unknown column 'popt.products_options_order' in 'order clause'

     

    select distinct popt.products_options_id, popt.products_options_name, popt.products_options_type, popt.products_options_length, popt.products_options_comment from products_options popt, products_attributes patrib where patrib.products_id='879' and patrib.options_id = popt.products_options_id and popt.language_id = '1' order by popt.products_options_order, popt.products_options_name

     

    [TEP STOP]

  4. Using osCommerce 2.3.1

     

     

    Installed and for some reason not working.

     

    Appears to be an issue with the SQL file

     

    1054 - Unknown column 'products_options_value_text' in 'field list'

     

    select products_options_id, products_options_value_id, products_options_value_text from customers_basket_attributes where customers_id = '1' and products_id = '732{8}34{7}0'

     

    and

     

    Unknown column 'popt.products_options_order' in 'order clause'

  5. Thank you Jack!

     

    I uploaded and all seems okay just have to fill the header tags out now, but one problem I am having is with Main Category's. When I click on them its blank, but actual Products and Sub-Categories are fine.

     

    Thoughts?

     

    Thanks in advance!!

     

    Figured it out, nevermind!

  6. Thanks jmoll but still getting this error:

     

    Write /home/<name>/public_html/sitemapproducts.xml
    Generated Google Product Sitemap Successfully
    1054 - Unknown column 'c.categories_status' in 'where clause'
    SELECT c.categories_id as cID, c.date_added, c.last_modified as last_mod
       FROM categories c left join categories_description cd on c.categories_id = cd.categories_id
    	   where c.categories_status = '1'
       ORDER BY c.parent_id ASC, c.sort_order ASC, c.categories_id ASC
    

  7. You can leave out whatever code you want, in most cases. It just means you lose some feature of Header Tags. Template designers routinely delete sections of code like that. It isn't possible to support the changes here since there are too many possibilites.

     

    Thank you Jack!

     

    I uploaded and all seems okay just have to fill the header tags out now, but one problem I am having is with Main Category's. When I click on them its blank, but actual Products and Sub-Categories are fine.

     

    If you can please take a look and see what I did wrong that would be great.

     

    Click on Cooking and see that is only shows text, but nothing else.

     

    Thoughts?

     

    Thanks in advance!!

  8. I am following the instructions to add/replace code in the Index.php file in the /CATALOG/ folder but my Index.php file only has 98 lines and does not have the following code when searching:

     

    FIND (Around line 207)
    
       $catname = HEADING_TITLE;
       if (isset($HTTP_GET_VARS['manufacturers_id'])) {
      $image = tep_db_query("select manufacturers_image, manufacturers_name as catname from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
      $image = tep_db_fetch_array($image);
      $catname = $image['catname'];
       } elseif ($current_category_id) {
      $image = tep_db_query("select c.categories_image, cd.categories_name as catname from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");
      $image = tep_db_fetch_array($image);
      $catname = $image['catname'];
       }
    ?>
    <h1><?php echo $catname; ?></h1>
    REPLACE WITH:
       /*** Begin Header Tags SEO ***/
       if (isset($HTTP_GET_VARS['manufacturers_id'])) {
      $image = tep_db_query("select manufacturers_image, manufacturers_name as catname from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
      $image = tep_db_fetch_array($image);
      $db_query = tep_db_query("select manufacturers_htc_title_tag as htc_title, manufacturers_htc_description as htc_description from " . TABLE_MANUFACTURERS_INFO . " where languages_id = '" . (int)$languages_id . "' and manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
       } elseif ($current_category_id) {
      $image = tep_db_query("select c.categories_image, cd.categories_name as catname from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");
      $image = tep_db_fetch_array($image);
      $db_query = tep_db_query("select categories_htc_title_tag as htc_title, categories_htc_description as htc_description from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "'");
       }
       $htc = tep_db_fetch_array($db_query);
    ?>
    <h1><?php echo $htc['htc_title']; ?></h1>
       <?php /*** End Header Tags SEO ***/ ?>
    =============================================
    FIND (Around line 251)
       include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);
    ?>
    </div>
    REPLACE with
       /*** Begin Header Tags SEO ***/
       if (tep_not_null($htc['htc_description'])) {
    	 echo '<h2 style="text-decoration:none;">'. $htc['htc_description'] . '</h2>';
     }
       /*** End Header Tags SEO ***/
    
       include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);
    ?>
    </div>
      <!--- BEGIN Header Tags SEO Social Bookmarks -->
      <?php if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true')
      include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php');
      ?>
      <!--- END Header Tags SEO Social Bookmarks -->
    =============================================
    FIND (Around line 286)
    <?php
       }
       include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS);
    ADD BENEATH:
       // <!--- BEGIN Header Tags SEO Social Bookmarks -->
       if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') {
        include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php');
       }
       // <!--- END Header Tags SEO Social Bookmarks -->
    

     

    Can I just skip adding this or is it important?

     

    Thanks in advance everyone.

  9.  

    I also couldn't find that statement in index.php, but the contribution is working.

    Allthough I don't have 'buy this' buttons on the categorypages.

    Haven't found something yet what isn't working.

     

    Is there any 'FILENAME_DEFAULT' in index.php, and that's not an argument of tep_href_link() ?

     

    I did find the following with FILENAME_DEFAULT

     

    Line 33:

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

     

    Line 56 and 57:

    $tab_sel = tep_href_link(FILENAME_DEFAULT);

    $current_page = FILENAME_DEFAULT;

     

     

    I was just very cautious as this was the first step and I was not finding anything remotely close to what was mentioned in the instructions.

     

    Thanks so much for your help.

  10. I am looking for an add-on that makes it that no shipping method is automatically selected when you get to the Checkout Shipping page in OSC 2.3.1

     

    I have tried the No Default Shipping for v2.2 but that does not function correct in OSC 2.3.1 and created a loop and thus was stuck in the Checkout Shipping page.

     

    Any help is grateful!

×
×
  • Create New...