Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

rockpretty

Banned
  • Posts

    55
  • Joined

  • Last visited

Everything posted by rockpretty

  1. I'm not sure what exactly happened but anyways it's all ''fixed''. My admin and site are working as good as new. I had to run something in my database as per a post that someone else in 2003 had done with the same issue. I appear to have this contribution still loaded as I see it in my admin. I'm not sure what I need to be doing next or how to tell if it's working properly. Can you direct me? Thanks
  2. Thanks Jack, I tried to uninstall but received this message: 1091 - Can't DROP 'products_head_title_tag'; check that column/key exists ALTER TABLE products_description DROP products_head_title_tag [TEP STOP] So I updated as per your post and received this message: Warning: mysql_fetch_field(): supplied argument is not a valid MySQL result resource in /home1/rockpret/public_html/includes/functions/database.php on line 198 Header Tags Controller Setup Database successfully updated!!! Do I need to do anything about the warning above now that I updated? As I never actually installed Header Tags SEO (some how it magically appeared) do I now need to code changes as if I installed it or is it done (as I can access Header Tags SEO in my admin)? If I don't need to change anything how do I know it's all good? Thanks Edit: I guess I've partially answered my ? as I'm unable to access any of my products to edit in admin. I receive this message: 1054 - Unknown column 'pd.products_head_title_tag' in 'field list' 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, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, 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,products_group_access, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_group_access from products p, products_description pd where p.products_id = '48' and p.products_id = pd.products_id and pd.language_id = '1'
  3. Hi, I've loaded the headertags_seo_install.php in the directory where my index.php is, when I try to install it I get this warning I'm unsure how exactly to resolve this. Thanks
  4. I've loaded this contribution (2.1d original by you) but wasn 't able to do step #3 (I couldn't find the exact text to replace) However I've tested my site as you suggested above and all works except for the last one. Any suggestions? You can look at www.rockprettybaby.ca Thanks in advance
  5. Thanks, you're the best! I tried the first 3 and they all worked but the last one did not. Any suggestions? You can check it out http://www.rockprettybaby.ca Thanks again!
  6. Hi, I believe (fingers crossed) I've installed it correctly. How do I tell that all is right? Thanks
  7. I see what I've done. I've should of read this thread PRIOR to downloading the function. I've downloaded the latest version and I've done all the steps except for Step 5 (which looks like Step 3 in the 2.1d version). Should I continue and just finish off or should I be trying to start over using the 2.1d version. If I'm to continue I'm still at a loss. Step 5 (Step 3 in 2.1d version)asks me to replace with a new info. I however can't find the EXACT info. This is what I have (well it's 1/2 of the page), what part should I replace? Thanks: //// // The HTML href link wrapper function function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true) { global $request_type, $session_started, $SID, $spider_flag; if (!tep_not_null($page)) { // die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine the page link!<br><br>'); die('</td></tr></table></td></tr></table><br><br><font color="#ff0000">'.TEP_HREF_LINK_ERROR1); } if ($connection == 'NONSSL') { $link = HTTP_SERVER . DIR_WS_HTTP_CATALOG; } elseif ($connection == 'SSL') { if (ENABLE_SSL == true) { $link = HTTPS_SERVER . DIR_WS_HTTPS_CATALOG; } else { $link = HTTP_SERVER . DIR_WS_HTTP_CATALOG; } } else { //die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine connection method on a link!<br><br>Known methods: NONSSL SSL</b><br><br>'); die('</td></tr></table></td></tr></table><br><br><font color="#ff0000">'.TEP_HREF_LINK_ERROR2); } if (tep_not_null($parameters)) { while ( (substr($parameters, -5) == '&') ) $parameters = substr($parameters, 0, strlen($parameters)-5); $link .= $page . '?' . tep_output_string($parameters); $separator = '&'; } else { $link .= $page; $separator = '?'; } // Add the session ID when moving from different HTTP and HTTPS servers, or when SID is defined // there is a minor logic problem with the original osCommerce code // the SESSION_FORCE_COOKIE_USE must not be honored if changing from nonssl to ssl if ( ($add_session_id == true) && ($session_started == true) ){ if ( ( ($request_type == 'NONSSL') && ($connection == 'SSL') && (ENABLE_SSL == true) ) || ( ($request_type == 'SSL') && ($connection == 'NONSSL') ) ) { if (HTTP_COOKIE_DOMAIN != HTTPS_COOKIE_DOMAIN) { $_sid = tep_session_name() . '=' . tep_session_id(); } elseif ( tep_not_null($SID) && (SESSION_FORCE_COOKIE_USE == 'False') ) { $_sid = $SID; } } } /*--------------------------------------------------------*\ # Page cache contribution - by Chemo # CRE Mods - by Clarocque \*--------------------------------------------------------*/ if (!tep_session_is_registered('customer_id') && ENABLE_PAGE_CACHE == 'true' && class_exists('page_cache')) { $link .= $separator . '<osCsid>'; } elseif (isset($_sid) && !$spider_flag) { $link .= $separator . tep_output_string($_sid); }#eof if # eof Page Cache // AJAX Addto shopping_cart - Begin $pidpos = strpos($parameters, 'product')+12; $mypid = substr($parameters, $pidpos); $link_ajax = ''; if( tep_not_null($parameters) && preg_match("/buy_now/i", $parameters) && $page != 'ajax_shopping_cart.php'){ $link_ajax = '" onclick="return doBuyNowGet(\'' . $parameters . '\', ' . $mypid . ');'; } return $link . $link_ajax; // AJAX Addto shopping_cart - End } //// // The HTML image wrapper function function tep_image($src, $alt = '', $width = '', $height = '', $parameters = '') { if ( (empty($src) || ($src == DIR_WS_IMAGES)) && (IMAGE_REQUIRED == 'false') ) { return false; } // alt is added to the img tag even if it is null to prevent browsers from outputting // the image filename as default $image = '<img src="' . tep_output_string($src) . '" border="0" alt="' . tep_output_string($alt) . '"'; if (tep_not_null($alt)) { $image .= ' title=" ' . tep_output_string($alt) . ' "'; } if ( (CONFIG_CALCULATE_IMAGE_SIZE == 'true') && (empty($width) || empty($height)) ) { if ($image_size = @getimagesize($src)) { if (empty($width) && tep_not_null($height)) { $ratio = $height / $image_size[1]; $width = $image_size[0] * $ratio; } elseif (tep_not_null($width) && empty($height)) { $ratio = $width / $image_size[0]; $height = $image_size[1] * $ratio; } elseif (empty($width) && empty($height)) { $width = $image_size[0]; $height = $image_size[1]; } } elseif (IMAGE_REQUIRED == 'false') { return false; } } if (tep_not_null($width) && tep_not_null($height)) { $image .= ' width="' . tep_output_string($width) . '" height="' . tep_output_string($height) . '"'; } if (tep_not_null($parameters)) $image .= ' ' . $parameters; $image .= '>'; return $image; } // The Javascript Image wrapper build a image tag for a dummy picture, // then uses javascript to load the actual picure. This approach prevents spiders from stealing images. function tep_javascript_image($src, $name, $alt = '', $width = '', $height = '', $parameters = '', $popup = 'false') { global $product_info; $image = ''; if ( empty($name) || ((empty($src) || ($src == DIR_WS_IMAGES)) && (IMAGE_REQUIRED == 'false')) ) { return false; } // Do we need to add the pop up link code? if ( $popup ) { $image .= '<div align="center"><a href="java script:popupWindow(\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . 'ℑ=0') . '\')">' . "\n"; } // alt is added to the img tag even if it is null to prevent browsers from outputting // the image filename as default $image .= '<img name="' . tep_output_string($name) . '" src="' . DIR_WS_IMAGES . 'pixel_trans.gif" border="0" alt="' . tep_output_string($alt) . '"'; if (tep_not_null($alt)) { $image .= ' title=" ' . tep_output_string($alt) . ' "'; } if ( (CONFIG_CALCULATE_IMAGE_SIZE == 'true') && (empty($width) || empty($height)) ) { if ($image_size = @getimagesize($src)) { if (empty($width) && tep_not_null($height)) { $ratio = $height / $image_size[1]; $width = $image_size[0] * $ratio; } elseif (tep_not_null($width) && empty($height)) { $ratio = $width / $image_size[0]; $height = $image_size[1] * $ratio; } elseif (empty($width) && empty($height)) { $width = $image_size[0]; $height = $image_size[1]; } } elseif (IMAGE_REQUIRED == 'false') { return false; } } if (tep_not_null($width) && tep_not_null($height)) { $image .= ' width="' . tep_output_string($width) . '" height="' . tep_output_string($height) . '"'; } if (tep_not_null($parameters)) $image .= ' ' . $parameters; $image .= '>' . "\n"; if ( $popup ) { $image .= '<br>' . tep_template_image_button('image_enlarge.gif', TEXT_CLICK_TO_ENLARGE) . '</a></div>' . "\n"; } // Now for the Javascript loading code $image .= '<script type="text/javascript"><!-- ' . "\n"; $image .= "document['" . tep_output_string($name) . "'].src = '" . tep_output_string($src) . "'" . "\n"; $image .= ' //--></script>' ."\n"; return $image; }
  8. Ok, thanks for the instructions on Step 3 I've done everything else now. However, on Step 5 I couldn't find the EXACT function described. So I tried a number of different options and nothing worked. I would only get an error message stating that line ### on my html_output.php page. Here's what my html_output.php page originally looked like (well approx 1/2 the page but I didn't think you needed the full thing). What should I replace? //// // The HTML href link wrapper function function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true) { global $request_type, $session_started, $SID, $spider_flag; if (!tep_not_null($page)) { // die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine the page link!<br><br>'); die('</td></tr></table></td></tr></table><br><br><font color="#ff0000">'.TEP_HREF_LINK_ERROR1); } if ($connection == 'NONSSL') { $link = HTTP_SERVER . DIR_WS_HTTP_CATALOG; } elseif ($connection == 'SSL') { if (ENABLE_SSL == true) { $link = HTTPS_SERVER . DIR_WS_HTTPS_CATALOG; } else { $link = HTTP_SERVER . DIR_WS_HTTP_CATALOG; } } else { //die('</td></tr></table></td></tr></table><br><br><font color="#ff0000"><b>Error!</b></font><br><br><b>Unable to determine connection method on a link!<br><br>Known methods: NONSSL SSL</b><br><br>'); die('</td></tr></table></td></tr></table><br><br><font color="#ff0000">'.TEP_HREF_LINK_ERROR2); } if (tep_not_null($parameters)) { while ( (substr($parameters, -5) == '&') ) $parameters = substr($parameters, 0, strlen($parameters)-5); $link .= $page . '?' . tep_output_string($parameters); $separator = '&'; } else { $link .= $page; $separator = '?'; } // Add the session ID when moving from different HTTP and HTTPS servers, or when SID is defined // there is a minor logic problem with the original osCommerce code // the SESSION_FORCE_COOKIE_USE must not be honored if changing from nonssl to ssl if ( ($add_session_id == true) && ($session_started == true) ){ if ( ( ($request_type == 'NONSSL') && ($connection == 'SSL') && (ENABLE_SSL == true) ) || ( ($request_type == 'SSL') && ($connection == 'NONSSL') ) ) { if (HTTP_COOKIE_DOMAIN != HTTPS_COOKIE_DOMAIN) { $_sid = tep_session_name() . '=' . tep_session_id(); } elseif ( tep_not_null($SID) && (SESSION_FORCE_COOKIE_USE == 'False') ) { $_sid = $SID; } } } /*--------------------------------------------------------*\ # Page cache contribution - by Chemo # CRE Mods - by Clarocque \*--------------------------------------------------------*/ if (!tep_session_is_registered('customer_id') && ENABLE_PAGE_CACHE == 'true' && class_exists('page_cache')) { $link .= $separator . '<osCsid>'; } elseif (isset($_sid) && !$spider_flag) { $link .= $separator . tep_output_string($_sid); }#eof if # eof Page Cache // AJAX Addto shopping_cart - Begin $pidpos = strpos($parameters, 'product')+12; $mypid = substr($parameters, $pidpos); $link_ajax = ''; if( tep_not_null($parameters) && preg_match("/buy_now/i", $parameters) && $page != 'ajax_shopping_cart.php'){ $link_ajax = '" onclick="return doBuyNowGet(\'' . $parameters . '\', ' . $mypid . ');'; } return $link . $link_ajax; // AJAX Addto shopping_cart - End } //// // The HTML image wrapper function function tep_image($src, $alt = '', $width = '', $height = '', $parameters = '') { if ( (empty($src) || ($src == DIR_WS_IMAGES)) && (IMAGE_REQUIRED == 'false') ) { return false; } // alt is added to the img tag even if it is null to prevent browsers from outputting // the image filename as default $image = '<img src="' . tep_output_string($src) . '" border="0" alt="' . tep_output_string($alt) . '"'; if (tep_not_null($alt)) { $image .= ' title=" ' . tep_output_string($alt) . ' "'; } if ( (CONFIG_CALCULATE_IMAGE_SIZE == 'true') && (empty($width) || empty($height)) ) { if ($image_size = @getimagesize($src)) { if (empty($width) && tep_not_null($height)) { $ratio = $height / $image_size[1]; $width = $image_size[0] * $ratio; } elseif (tep_not_null($width) && empty($height)) { $ratio = $width / $image_size[0]; $height = $image_size[1] * $ratio; } elseif (empty($width) && empty($height)) { $width = $image_size[0]; $height = $image_size[1]; } } elseif (IMAGE_REQUIRED == 'false') { return false; } } if (tep_not_null($width) && tep_not_null($height)) { $image .= ' width="' . tep_output_string($width) . '" height="' . tep_output_string($height) . '"'; } if (tep_not_null($parameters)) $image .= ' ' . $parameters; $image .= '>'; return $image; } // The Javascript Image wrapper build a image tag for a dummy picture, // then uses javascript to load the actual picure. This approach prevents spiders from stealing images. function tep_javascript_image($src, $name, $alt = '', $width = '', $height = '', $parameters = '', $popup = 'false') { global $product_info; $image = ''; if ( empty($name) || ((empty($src) || ($src == DIR_WS_IMAGES)) && (IMAGE_REQUIRED == 'false')) ) { return false; } // Do we need to add the pop up link code? if ( $popup ) { $image .= '<div align="center"><a href="java script:popupWindow(\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'] . 'ℑ=0') . '\')">' . "\n"; } // alt is added to the img tag even if it is null to prevent browsers from outputting // the image filename as default $image .= '<img name="' . tep_output_string($name) . '" src="' . DIR_WS_IMAGES . 'pixel_trans.gif" border="0" alt="' . tep_output_string($alt) . '"'; if (tep_not_null($alt)) { $image .= ' title=" ' . tep_output_string($alt) . ' "'; } if ( (CONFIG_CALCULATE_IMAGE_SIZE == 'true') && (empty($width) || empty($height)) ) { if ($image_size = @getimagesize($src)) { if (empty($width) && tep_not_null($height)) { $ratio = $height / $image_size[1]; $width = $image_size[0] * $ratio; } elseif (tep_not_null($width) && empty($height)) { $ratio = $width / $image_size[0]; $height = $image_size[1] * $ratio; } elseif (empty($width) && empty($height)) { $width = $image_size[0]; $height = $image_size[1]; } } elseif (IMAGE_REQUIRED == 'false') { return false; } } if (tep_not_null($width) && tep_not_null($height)) { $image .= ' width="' . tep_output_string($width) . '" height="' . tep_output_string($height) . '"'; } if (tep_not_null($parameters)) $image .= ' ' . $parameters; $image .= '>' . "\n"; if ( $popup ) { $image .= '<br>' . tep_template_image_button('image_enlarge.gif', TEXT_CLICK_TO_ENLARGE) . '</a></div>' . "\n"; } // Now for the Javascript loading code $image .= '<script type="text/javascript"><!-- ' . "\n"; $image .= "document['" . tep_output_string($name) . "'].src = '" . tep_output_string($src) . "'" . "\n"; $image .= ' //--></script>' ."\n"; return $image; }
  9. Can someone explain to me how to do Step 3??? I'm very Analog so make it simple :) STEP #3 - Use phpMyadmin and run this queries ALTER TABLE `categories_description` ADD `categories_seo_url` VARCHAR( 100 ) NOT NULL ; ALTER TABLE `products_description` ADD `products_seo_url` VARCHAR( 100 ) NOT NULL;
×
×
  • Create New...