Heatherbell

Just installed this addon but only get error 1048 - Column 'set_function' cannot be null. Any advice please?

Hoping someone can advise? Running a bootstrap site - there is a small bottom strip missing from every image in the photogrid example here We cannot find the code responsible for this

@@Tsimi Many thanks for your time and advice - that works. I do not understand why, if this is a general problem, it has not been fixed in the oscommerce code

Thanks for your suggestion but bottom margin change to 0 hasn't changed anything. Sorry I am not code literate but it seems that the height of the photogrid is setting to some weird percentage. (I wanted a larger image in product info so had changed pigal to 350px which caused the chopped image in smartphone - now changed back - thanks for that)

We are running OSC Bootstrap. We have had a few customers claiming problems during the checkout process. They have been unable to make a payment selection, the payment options not responding. This is not a general problem as 99% of our transactions are going OK so we can only presume that it is a problem associated with a particular browser or device maybe?? We are not developers or coders so we are grateful for any advice to fix the problem or any advice that we can pass on to these customers.

clustersolutions/Tim, many thanks for taking the time. This is do it myself so I would be grateful if you can say how to fix the IE8 issue? Thanks again

Many thanks for all the responses. The links provided by ArtcoInc are interesting but go over my head, sorry I have very little knowledge here so excuse my ignorance. The customer who reported the problem with IE9 has not got back to us with the device they were using but my desktop is running on IE9 and our website shows no problems there so I can only infer that they were not using a desktop. We have had a few customer reports of this problem but we are worried that we are losing customers here so any practical suggestions are much appreciated, our website is cornishhoney.co.uk

Thanks for your response. One customer has replied that they had the payment button problem using IE9 but no problem with Firefox. Yes, we are using OSC 2.3.4 Bootstrap.

Hope somebody can advise. We have OSC bootstrap running but google is telling us that we do not have a viewport specified. How do we do this? Should we do this? Have we missed something in configuring the OSC installation? Many thanks for any help.

Thank you. I have Header Tags SEO installed which has changed template top - is this the problem? or how to fix it? The code I have is: <?php /*** Begin Header Tags SEO ***/ if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <meta charset="<?php echo CHARSET; ?>"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title><?php echo tep_output_string_protected($oscTemplate->getTitle()); ?></title> <?php

I am in the process of adding add-ons to my 2.3.4 Bootstrap. The 'View Grid/List' buttons have disappeared. I presume I have messed the code for it but I do not know what file contains the code for this (a lot of files were changed for the add-ons, I don't know where to start looking). Many thanks for any help.

Is there any modification available to this addon so the category description also shows on the webpage?

But this is exactly what I have done twice, the description is still not showing in the tabs.

Yes, all done. The Product Tabs works alone, the Product Info Box works alone but your code for Product info for both does not work

Thank you, no error now but the situation is exactly the same, the description is not in the tab, it does not work.

Thanks but error: Warning: require(): open_basedir restriction in effect. File(../../../wamp/www/infobox/includes/application_top.php) is not within the allowed path(s): (/home/sites/vip6484896/httpd/:/home/sites/vip6484896/tmp/:/srv/www/htdocs/userscripts/:/usr/share/pear/) in /home/sites/vip6484896/httpd/htdocs/catalog/product_info.php on line 13 Warning: require(../../../wamp/www/infobox/includes/application_top.php): failed to open stream: Operation not permitted in /home/sites/vip6484896/httpd/htdocs/catalog/product_info.php on line 13 Warning: require(): open_basedir restriction in effect. File(../../../wamp/www/infobox/includes/application_top.php) is not within the allowed path(s): (/home/sites/vip6484896/httpd/:/home/sites/vip6484896/tmp/:/srv/www/htdocs/userscripts/:/usr/share/pear/) in /home/sites/vip6484896/httpd/htdocs/catalog/product_info.php on line 13 Warning: require(../../../wamp/www/infobox/includes/application_top.php): failed to open stream: Operation not permitted in /home/sites/vip6484896/httpd/htdocs/catalog/product_info.php on line 13 Fatal error: require(): Failed opening required '../../../wamp/www/infobox/includes/application_top.php' (include_path='.:/usr/share/php5:/usr/share/php5/PEAR') in /home/sites/vip6484896/httpd/htdocs/catalog/product_info.php on line 13

Thank you but I've done this and double checked and description is still not showing in tabs. I've got Tabs working by itself and Product Info Box working by itself but not both together. This is product info file in case you can find where I have gone wrong <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2010 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if (!isset($HTTP_GET_VARS['products_id'])) { tep_redirect(tep_href_link(FILENAME_DEFAULT)); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); require(DIR_WS_INCLUDES . 'template_top.php'); if ($product_check['total'] < 1) { ?> <!-- // START Product Info Page Box --> <script type="text/javascript" src="includes/general.js"></script> <script type="text/javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=600,height=280,screenX=150,screenY=150,top=150,left=150') } //--></script> <!-- // END Product Info Page Box --> <div class="contentContainer"> <div class="contentText"> <?php echo TEXT_PRODUCT_NOT_FOUND; ?> </div> <div style="float: right;"> <?php echo tep_draw_button(IMAGE_BUTTON_CONTINUE, 'triangle-1-e', tep_href_link(FILENAME_DEFAULT)); ?> </div> </div> <?php } else { // Start Product Tabs $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, pd.products_tab_1, pd.products_tab_2, pd.products_tab_3, pd.products_tab_4, pd.products_tab_5, pd.products_tab_6 from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); // End Product tabs $product_info = tep_db_fetch_array($product_info_query); $manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '" . (int)$languages_id . "'), " . TABLE_PRODUCTS . " p where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.manufacturers_id = m.manufacturers_id"); if (tep_db_num_rows($manufacturer_query)) { $manufacturer = tep_db_fetch_array($manufacturer_query); } tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<del>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</del> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br /><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <div class="contentContainer"> <div class="contentText"> <?php if (tep_not_null($product_info['products_image'])) { $pi_query = tep_db_query("select image, htmlcontent from " . TABLE_PRODUCTS_IMAGES . " where products_id = '" . (int)$product_info['products_id'] . "' order by sort_order"); if (tep_db_num_rows($pi_query) > 0) { ?> <div id="piGal" style="float: right;"> <ul> <?php $pi_counter = 0; while ($pi = tep_db_fetch_array($pi_query)) { $pi_counter++; $pi_entry = ' <li><a href="'; if (tep_not_null($pi['htmlcontent'])) { $pi_entry .= '#piGalimg_' . $pi_counter; } else { $pi_entry .= tep_href_link(DIR_WS_IMAGES . $pi['image'], '', 'NONSSL', false); } $pi_entry .= '" target="_blank" rel="fancybox">' . tep_image(DIR_WS_IMAGES . $pi['image']) . '</a>'; if (tep_not_null($pi['htmlcontent'])) { $pi_entry .= '<div style="display: none;"><div id="piGalimg_' . $pi_counter . '">' . $pi['htmlcontent'] . '</div></div>'; } $pi_entry .= '</li>'; echo $pi_entry; } ?> </ul> </div> <script type="text/javascript"> $('#piGal ul').bxGallery({ maxwidth: 300, maxheight: 200, thumbwidth: <?php echo (($pi_counter > 1) ? '75' : '0'); ?>, thumbcontainer: 300, load_image: 'ext/jquery/bxGallery/spinner.gif' }); </script> <?php } else { ?> <div id="piGal" style="float: right;"> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image'], '', 'NONSSL', false) . '" target="_blank" rel="fancybox">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), null, null, 'hspace="5" vspace="5"') . '</a>'; ?> </div> <?php } ?> <script type="text/javascript"> $("#piGal a[rel^=fancybox]").fancybox({ cyclic: true }); </script> <?php } ?> <!-- // START Product Info Page Box --> <div class="productinfobox"> <div class="ui-widget infoBoxContainer"> <div class="ui-widget-header infoBoxHeading"> <?php echo $products_name = $product_info['products_name']; ?> </div> <div class="ui-widget-content infoBoxContents" style='overflow:hidden;'> <div style='width: 50%; float: left;'> <?php if (PRODUCT_INFO_PAGE_BOX_PRODUCT_MODEL == 'True') { echo TEXT_MODEL . '<br />'; } ?> <font size="+1"><?php echo TEXT_PRICE; ?></font><br /> <?php if (PRODUCT_INFO_PAGE_BOX_PRODUCT_STOCK == 'True') { echo TEXT_STOCK_LEVEL . '<br />'; } ?> <?php if (PRODUCT_INFO_PAGE_BOX_MANUFACTURER_INFO == 'True') { echo TEXT_MANUFACTURER . '<br /><br /><br />'; } ?> </div> <div style='width: 50%; float: right;'> <?php if (PRODUCT_INFO_PAGE_BOX_PRODUCT_MODEL == 'True') { echo $product_info['products_model'] . '<br />'; } ?> <font size="+1"><?php echo $products_price; ?></font><br /><br /> <?php if (PRODUCT_INFO_PAGE_BOX_PRODUCT_STOCK == 'True') { echo tep_get_products_stock($product_info['products_id']) . '<br />'; } ?> <?php if (PRODUCT_INFO_PAGE_BOX_MANUFACTURER_INFO == 'True') { echo $manufacturer['manufacturers_name'] . '<br />'; echo '<a href="' . tep_href_link(FILENAME_REDIRECT, 'action=manufacturer&manufacturers_id=' . $manufacturer['manufacturers_id']) . '" target="_blank">'; echo TEXT_HOMEPAGE; echo '</a><br />'; echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturer['manufacturers_id']) . '">'; echo MODULE_BOXES_MANUFACTURER_INFO_BOX_OTHER_PRODUCTS; echo '</a><br />'; } ?> </div> <?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?> <!-- Attributes Start --> <?php $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <p><strong><?php echo TEXT_PRODUCT_OPTIONS; ?></strong></p> <p> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (is_string($HTTP_GET_VARS['products_id']) && isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <div style='width: 50%; float: left;'> <?php echo $products_options_name['products_options_name'] . ':'; ?> </div> <div style='width: 50%; float: right;'> <?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?> </div><br /> <?php } ?> </p> <?php } ?> <!-- Attributes End --> <div class="buttonSet"> <span class="buttonActionProductInfoCart"> <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_draw_button(IMAGE_BUTTON_IN_CART, 'cart', null, 'primary'); ?></form> </span> </div><br /> <div class="buttonSet"> <span class="buttonAction"> <div class="buttonSetActionLeft"> <?php if (PRODUCT_INFO_PAGE_BOX_QUESTION_BUTTON == 'True') { echo '<a href="' . tep_href_link(FILENAME_ASK_A_QUESTION_POPUP) . '" target="_blank" onclick="$(\'#askaquestion\').dialog(\'open\'); return false;">'; echo tep_draw_button(TEXT_ASK_A_QUESTION_POPUP, 'help'); echo '</a>'; } ?> </div> </span> <div class="buttonSetActionLeft"> <?php if (PRODUCT_INFO_PAGE_BOX_REVIEW_BUTTON == 'True') { echo '<a href="' . tep_href_link(FILENAME_REVIEWS_POPUP) . '" target="_blank" onclick="$(\'#reviews\').dialog(\'open\'); return false;">'; echo tep_draw_button(TEXT_REVIEWS_POPUP, 'comment'); echo '</a>'; } ?> </div> <div align="center"> <?php if (PRODUCT_INFO_PAGE_BOX_TELL_BUTTON == 'True') { echo tep_draw_form('email_friend', tep_href_link(FILENAME_TELL_A_FRIEND, 'action=process&products_id=' . (int)$HTTP_GET_VARS['products_id']), 'post', '', true); echo '<a href="' . tep_href_link(FILENAME_TELL_A_FRIEND_POPUP) . '" target="_blank" onclick="$(\'#tellafriend\').dialog(\'open\'); return false;">'; echo tep_draw_button(TEXT_TELL_A_FRIEND_POPUP, 'mail-closed'); echo '</a>'; } ?> </div> </div> </div> </div> </div> <?php //echo stripslashes($product_info['products_description']); ?> <div id="reviews" title="<?php echo 'Reviews for '; echo tep_get_products_name($product_info['products_id']); ?>"> <?php include(FILENAME_REVIEWS_POPUP); ?> </div></form> <div id="tellafriend" title="<?php echo 'Tell a Friend About '; echo tep_get_products_name($product_info['products_id']); ?>"> <?php include(FILENAME_TELL_A_FRIEND_POPUP); ?> </div></form> <div id="askaquestion" title="<?php echo 'As Us a Question About '; echo tep_get_products_name($product_info['products_id']); ?>"> <?php include(FILENAME_ASK_A_QUESTION_POPUP); ?> </div></form> <script type="text/javascript"> $('#reviews').dialog({ autoOpen: false, width: 700, buttons: { 'Close Dialog Box': function() { $(this).dialog('close'); } } }); </script> <script type="text/javascript"> $('#tellafriend').dialog({ autoOpen: false, width: 400, buttons: { 'Close Dialog Box': function() { $(this).dialog('close'); } } }); </script> <script type="text/javascript"> $('#askaquestion').dialog({ autoOpen: false, width: 500, buttons: { 'Close Dialog Box': function() { $(this).dialog('close'); } } }); </script> <!-- END Scripts for Popups --> </div> <?php include_once (DIR_WS_MODULES . FILENAME_PRODUCTS_TABS); ?> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and reviews_status = 1"); $reviews = tep_db_fetch_array($reviews_query); ?> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } ?> </div> <!--</form>--> <?php } require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

I have tried hard but description will not show in tabs.

Thank you but can you detail the changes needed for product_info, I have product info box running OK but every time I've tried to change product_info, the page is displaying wrong. I think it's because the description isn't showing in the tabs. i really need help to get this running.

Sorry your answer leaves loose threads for me. I'm looking for an easier way, I'm no coder. What about the echo customisations file for example?

I have Product Info Page Box installed and working great and I want to install Product Tabs too but I don't know how to merge them together, can you help?

Looking for help. Shipping cost is showing correct value on my website but when checking out with Paypal, Paypal is showing our highest Air Mail cost by default. This only happens if customer has not created account, how to work around? I am not an expert!

Many thanks for your time, help and kindness, works great

'Ask a Question' is working except email received does not show product name?

I have sorted the layout, sorry to ask stupid question.