Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

giuli8

Pioneers
  • Posts

    36
  • Joined

  • Last visited

Posts posted by giuli8

  1. I installed the more_pics_classic_1.4.3 and I have the same problem.

    And I found out the problem lies in the admin/categories.php file.

    I found out in my file, one line is missing.

    It works for me. I hope it works for you too.

     

    I have not installed classic version but advanced version, are more different. I check the code and I continue to have the problem. I don't find any error, if there is anyone that have the same problem write here!

  2. This is the correct behavior. Please read section 3 of the how_to_use.txt in the distribution.

     

    Regards

    Jim

     

    I have read section 3 of how_to_use.txt and I have check with Diffmerge my admin/categories.php and the same file in the contribution. I have done the modified exactly also with other contributions (Header Tags Seo and Xsell). If you have 5 minutes, can I send to you my categories.php ?

    Thanks

  3. Those queries appear to be correct. Where are you using the data? If you intend to change the operation of admin/categories.php, you may certainly do that, but I don't know how you are going to make that work with More Pics. I may be able to help with this if you explain what you are trying to accomplish here.

     

    Regards

    Jim

     

    The images in my store are only uploaded with more pics, I haven't the classic product image. This determines no images when I go on admin -> catalog -> categories/product , I can't see images of existing products and images of products when I modified any information.

    I try to change the queries that you have read, but I have the same problem. I don't know if is sufficient to change the queries or must do another changes.

    Regards

    Giulio

  4. After install more pics on admin categories, where I can see the information of product and where I can add a product, I can't see image.

    I have modified this queries (in bold) but I can't see images again. Anyone have resolved this problem?

    On admin/categories.php:

     

    $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, pi.image_filename, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_to_rss from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_IMAGES . " pi on p.products_id = pi.products_id and pi.product_page = '1', " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");v

     

    $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, pi.image_filename, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, p.products_to_rss from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_IMAGES . " pi on p.products_id = pi.products_id and pi.product_page = '1', " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");

     

    $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, pi.image_filename, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id, p.products_to_rss from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_IMAGES . " pi on p.products_id = pi.products_id and pi.product_page = '1', " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name");

     

    $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, pi.image_filename, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_to_rss from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_IMAGES . " pi on p.products_id = pi.products_id and pi.product_page = '1', " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name");

  5. When I open specials.php, only in this page and not in other pages, I have these warnings. The warnings not appears in italian and english languages but appears in other languages.

     

    Warning: implode() [function.implode]: Invalid arguments passed in /web/htdocs/www.catinipipe.com/home/includes/functions/header_tags.php on line 63

    Warning: implode() [function.implode]: Invalid arguments passed in /web/htdocs/www.catinipipe.com/home/includes/functions/header_tags.php on line 64

    Warning: implode() [function.implode]: Invalid arguments passed in /web/htdocs/www.catinipipe.com/home/includes/functions/header_tags.php on line 66

    Warning: implode() [function.implode]: Invalid arguments passed in /web/htdocs/www.catinipipe.com/home/includes/functions/header_tags.php on line 63

    Warning: implode() [function.implode]: Invalid arguments passed in /web/htdocs/www.catinipipe.com/home/includes/functions/header_tags.php on line 64

    Warning: implode() [function.implode]: Invalid arguments passed in /web/htdocs/www.catinipipe.com/home/includes/functions/header_tags.php on line 66

     

    In my includes/functions/header_tags.php

     

    63 $header_tags_array['title'] = ltrim(tep_db_prepare_input(implode(' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION . ' ', $sortOrder['title'])), ' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION);

    64 $header_tags_array['desc'] = ltrim(tep_db_prepare_input(implode(' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION . ' ', $sortOrder['description'])), ' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION);

    65 $header_tags_array['keywords'] = ltrim(tep_db_prepare_input(implode(' ' . HEADER_TAGS_SEPARATOR_KEYWORD . ' ', $sortOrder['keywords'])), ' ' . HEADER_TAGS_SEPARATOR_KEYWORD);

    66 $header_tags_array['logo_text'] = ltrim(tep_db_prepare_input(implode(' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION . ' ', $sortOrder['logo'])), ' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION);

     

    Why can see the warnings only in specials.php and in other languages, exclude italian and english?

    Bye

  6. Check the page that is missing the logo text in Page Control and make sure something is entered there. If it is, try looking at the page in IE (if that isn't what you are using). If that works, then the problem is that you need to add a title attribute, which was just recently explained.

     

    Missing meta tag information refers to a product or category. It is usually due to a missing title for that item.

     

    Jack

     

    I have updated to Header Tags Seo 3.1.5 and work ok, I think that I haven't updated a file when I change from 3.1.3 to 3.1.4.

    Now I can check missing meta tag information of products or categories!

  7. I fill logo text in all pages on Header tags Seo 3.1.4 -> page control, but the title and alt tags of the Store Logo remain "CatiniPipe" (the name of my store)

    This is the code of includes/header.php:

     

    	<?php /*** Begin Header Tags SEO ***/ ?>
    <td valign="middle"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image(DIR_WS_IMAGES . 'store_logo.png', (tep_not_null($header_tags_array['logo_text']) ? $header_tags_array['logo_text'] : STORE_NAME)) . '</a>'; ?></td>
    <td valign="middle"><img src="/images/ruotapipe.jpg" alt="Pipe" align="right"></td>
    <?php /*** End Header Tags SEO ***/ ?>

     

    I don't know the reason of problem. I have notice of 22 items with missing meta tag information, but with "Add missing page" in page control I don't resolve the problem. I don't know if these problems are related.

    Thanks in advance.

  8. I believe the problem of only 1 entry is caused by the following code at around lines: 424, 468, 512, 599 in googlesitemap/sitemap.class.php

     

    if ( sizeof($container) > 1 )

     

    Should be changed to:

     

    if ( sizeof($container) > 0 )

     

    Thanks

     

    Steve

     

    Yes, after change in code at around lines: 424, 468, 512, 559 in googlesitemap/sitemap.class.php the contribution work well also with one Manufacturer. I think that this modify can add on next full package of contribution.

    Thanks!

  9. Not all of those pages will be added to the database because they are restricted by code in Header Tags. That's because it doesn't help to have Header Tags code in a popup, ofr example, since the search engines will never see it. Those files are listed in admin/includes/functions/header_tags.php so you can see the ones to remove the Header Tags code from. For the others, try going to Page Control and selecting the Add Missing Pages option. That might fix it.

     

    Jack

     

    If I go to Page Control and select the Add Missing Pages option, it don't fix anything and during the test I see the same error.

    In admin/includes/functions/header_tags.php I can exclude a file from list or add files on $baseFiles array, in this array there are index.php product_info.php product_reviews.php product_reviews_info.php product_reviews_write.php specials.php. If I try in $baseFiles to add for example info_shopping_cart.php, in test the error remains.

    Any ideas?

    Bye

  10. When I do the test of Header Tags SEO I have this error:

     

    Database/File Mismatch Error: explain

    The number of file entries in the database (14) does not match the number in the includes/header_tags.php file (28).

    Files not in the database:

    info_shopping_cart.php

    popup_image.php

    redirect.php

    shipping.php

    cookie_usage.php

    download.php

    contact_us.php

    products_new.php

    reviews.php

    tell_a_friend.php

    advanced_search.php

    shopping_cart.php

    advanced_search_result.php

    rss.php

     

    I would to fix this error without uninstall and install the database because i have correct other problem and i have already modify the database, but I don't know anithing to resolve this problem.

    Bye

  11. I see the original specials.php and modified specials.php after installing more pics contribution.

     

    There is a modify, original is:

    	  echo '			<td align="center" width="33%" class="smallText"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $specials['products_image'], $specials['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . $specials['products_name'] . '</a><br><s>' . $currencies->display_price($specials['products_price'], tep_get_tax_rate($specials['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($specials['specials_new_products_price'], tep_get_tax_rate($specials['products_tax_class_id'])) . '</span></td>' . "\n";

     

    after more pics contribution:

    	  echo '			<td align="center" width="33%" class="smallText"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $specials['image_filename'], $specials['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . $specials['products_name'] . '</a><br><s>' . $currencies->display_price($specials['products_price'], tep_get_tax_rate($specials['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($specials['specials_new_products_price'], tep_get_tax_rate($specials['products_tax_class_id'])) . '</span></td>' . "\n";

     

    The changes in only products_image to image_filename.

     

    On the original sql query is:

      $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC";

     

    on modified:

      $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, pi.image_filename, s.specials_new_products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_IMAGES . " pi on p.products_id = pi.products_id and pi.category_page = '1', " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC";

     

    The changes are p.products_image with pi.image_filename and the line of left join with TABLE_PRODUCTS_IMAGE

     

    On rss.php I see 5 queries, one of these is:

    		$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_model, p.products_price, p.products.image, p.products_date_added, pd.products_name, pd.products_description,
    		   m.manufacturers_name, cd.categories_name, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd
    		   ON p2c.categories_id = cd.categories_id where p.products_status = '1' and p.products_to_rss='1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' 
    		   and p2c.categories_id = '" . (int)$current_category_id  . "' 
    		   GROUP BY p.products_id
    	ORDER BY p.products_id DESC
    	LIMIT ". (int)MAX_RSS_ARTICLES."";

     

    After I have change p.products_image with pi.products_filename and I think that I must insert a left join but I do a mistake and my query don't work correctly

     

    Anyone can write a right query? After I can do the changes on other four similar queries!

    Bye

  12. I have installed More pics 2.0.6 advanced and Rss Feed, I have a problem with Rss Feed. When I click on rss icon I see the list of product without photos. I think that the problem is on more pics that don't add a category image correctly, or on rss feed that is configure to work with basic product image. Have you got an idea for resolve this problem?

    Bye

  13. I have installed More pics 2.0.6 advanced and Rss Feed, I have a problem with Rss Feed. When I click on rss icon I see the list of product without photos. I think that the problem is on more pics that don't add a category image correctly, or on rss feed that is configure to work with basic product image. Have you got an idea for resolve this problem?

    Bye

×
×
  • Create New...