RAC

Thanks Jack that seems to work now. No doubt I will be back! Regards Shaun

Thanks Jack I was able to delete the files stated, however the new sql has an error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. HTTPS_CATALOG_SERVER . '/googlesitemap/index.php" target="new" style="color:bl' at line 2 Regards

OK Jack thank you, Sorry to be a pain but how do I do that? Please keep it simple. Shaun

Hello @Jack_mcs I have been having problems with the older version of xml so I have replaced all the files with your new version. Do I need to delete the old files from phpMyadmin before I import the new sql? Regards Shaun

Hello @raiwa As usual, common sense where common sense is needed! I put (') in to the file name, what a plonker. Thank you Rainer. Thanks @Dan Cole for your input, it was much appreciated. Regards Shaun

This has turned into a real pickle! I started a new product and used the offending image, again I had an internal server error. From this I take it that the Image has been corrupted. Therefore how can I change the name of the images so that they do not become corrupted? There must be a superbrain out there that can teach us fools. Shaun

Hello @Dan Cole No I didn’t. Do I just change the name in the product_images database using phpmyadmin to the same as the name of the changed file? Is this the best way to change the image filenames? Or am I going to regret changing them? I think I will need to change maybe 100 image names. Kind regards Shaun

Sorry I am using bs Edge.

Hello I have a problem with renaming images an I have Kissit installed. I have just installed googlesitemap,xml and was trying to make my images names more google friendly. Stupidly it seems, I changed the image name in my computers file manager and re-uploaded the newly named product image, now I am getting an internal server error when I attempt to save the changed product image. Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request. I have checked the my shop and admin error logs, but nothing shows up there, is there another error log? How do I rectify this please? Regards Shaun

Thanks for all your help Jack. Kind regards Shaun

Oh @Jack_mcs Looks like we posted at the same time.

OK, I have just reinstalled all the files and called the googlesitemap/index.php and it now seems to work. I get the message. If you have not already submitted the sitemap index to Google or Bing click the link(s) below. Before doing that, please be sure to view the XML files to make sure the data is correct. These XML files are quite large 2-35kb what correct data am I looking for?

My sincere apologies Jack. if ($categories_products['total'] > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require('includes/languages/' . $language . '/index.php'); require('includes/template_top.php'); if ($category_depth == 'nested') { $category_query = tep_db_query("select cd.categories_name, c.categories_image, cd.categories_description from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'"); $category = tep_db_fetch_array($category_query); ?>

OK thank you for your clarification Dan. Jack, thank you for your nice simple instructions, my php version is 5.5.38 (Zend: 2.5.0) Line 20-40 <td colspan="2" class="header-menu"> [ <a href="classtrees_Google-XML-Sitemap-Feed.html" class="menu">class tree: Google-XML-Sitemap-Feed</a> ] [ <a href="elementindex_Google-XML-Sitemap-Feed.html" class="menu">index: Google-XML-Sitemap-Feed</a> ] [ <a href="elementindex.html" class="menu">all elements</a> ] </td> </tr> <tr> <td colspan="2" class="header-line"><img src="media/empty.png" width="1" height="1" border="0" alt="" /></td> </tr> </table> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr valign="top"> <td width="195" class="menu"><div class="package-title">Google-XML-Sitemap-Feed</div> <b>Packages:</b><br /> <div class="package"> <a href="li_Google-XML-Sitemap-Feed.html">Google-XML-Sitemap-Feed</a><br /> </div> <br /> <b>Files:</b><br /> <div class="package"> <span style="padding-left: 1em;"><a href="Google-XML-Sitemap-Feed/_googlesitemap_index_php.html">index.php</a></span><br /> <span style="padding-left: 1em;"><a href="Google-XML-Sitemap-Feed/_googlesitemap_sitemap_class_php.html">sitemap.class.php</a></span><br /> </div> <br /> <b>Classes:</b><br /> <div class="package"> <a href="Google-XML-Sitemap-Feed/GoogleSitemap.html">GoogleSitemap</a> <br /> <a href="Google-XML-Sitemap-Feed/MySQL_DataBase.html" Regards Shaun

Oh and in my Admin the settings are Google XML SEO Title Value Action Enable Images Map true Enable Manufacturers Map false Enable Specials Map false Enable Standard Pages Map true Enable Article Manager Topics Map false Enable Diagnostic Output true Exclude these pages advanced_search_result.php,advanced_search.php,password_reset.php Manual Run 7 Manual IP .0.0.1 Mobile URL Secure IP .0.0.1

Hi Thank you for your replies. @Dan ColeI already have the compatibility module installed, I am sorry though you will need to explain, (in SIMPLE terms) what you mean by “change those constants to the actual file names”. @Jack_mcs I have checked, and it seems that I have been using the latest version! I uploaded the files in the package, I set the permission of googlesitemap to 0775, the same as my images folder, do the files inside the googlesitemap need to be changed to 0755? Currently they are 0644. I have opted for the manual run, (as I still need to get my head around cron jobs), I uploaded the code, however there was no final ?> on that file, so I just put it at the end after the LINUXUK HTTP Errors and IP TRAP. When I call mydomain/shop/googlesitemap/index.php I get This page isn’t working www.retro-antiques-curios.co.uk is currently unable to handle this request. HTTP ERROR 500 When I call mydomain/shop/sitemapindex.xml I get Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request. Please, respond in simple step by step, (with diagrams if needed, lol). Your huge techie brains are different to ours. Regards Shaun

Hi Sorry, I am running Edge. Regards Shaun

Hi I can not seem to get this to work, (however I am blaming the flue that I am suffering with). When attempting to call googlesitemap/index.php The error log shows : [20-Mar-2018 13:57:08 Europe/London] PHP Notice: Use of undefined constant DIR_WS_HTTP_CATALOG - assumed 'DIR_WS_HTTP_CATALOG' in /home/****/public_html/*****/googlesitemap/index.php on line 33 [20-Mar-2018 13:57:08 Europe/London] PHP Notice: Use of undefined constant DIR_WS_INCLUDES - assumed 'DIR_WS_INCLUDES' in /home/*****/public_html/*****/googlesitemap/index.php on line 36 [20-Mar-2018 13:57:08 Europe/London] PHP Warning: require_once(DIR_WS_INCLUDESfilenames.php): failed to open stream: No such file or directory in /home/*****/public_html/*****/googlesitemap/index.php on line 36 [20-Mar-2018 13:57:08 Europe/London] PHP Fatal error: require_once(): Failed opening required 'DIR_WS_INCLUDESfilenames.php' (include_path='.:/opt/alt/php55/usr/share/pear:/opt/alt/php55/usr/share/php') in /home/*****/public_html/*****/googlesitemap/index.php on line 36 Any kick in the right direction could help. Regards Shaun

Hello Although I agree 67 pages of support is overwhelming, but “buggy junk”!!! This is totally unfair, Many thousands of Oscommerce users, like me, rely on people such as @Jack_mcs, and without them there would be no Osc.

Hello @brian_cee I am just trying to configure this addon as well. After you enable the diagnostic element and try to run the contribution, any errors are found in your catalog/error_log. HTH Shaun

OK I have sorted this issue, all I did was to open the offending page in textmaster, copy the whole text, delete the current text, then pasted back in place, all sorted. I hope this helps someone.

Hi @Jack_mcs I have installed this very handy addon in my 2.3.4bs Edge shop, which uses an image as a background. When I copy and paste text from a Word document the text is seen on the page with a white background, (see attached screenshot), is there a way around this without needing to type the whole page directly. Thank you in advance. Regards Shaun Doc3.docx

Hello Rainer @raiwa First to clarify I have 2.3.4bs Edge. Sorry this is my error, I did not see the further option of adding another large image below the image I had just selected. Thank you for your time, this is a great addon. Regards Shaun

Hello all I need to have multiple images for each product, as I will be selling antiques and vintage items. Does anyone know of a multi image addon that does not interfere with the kissIT installation? Shaun

Hello Christoph I have just discovered the problem, my screen was magnified! My mouse pad has pinch magnification and I must have inadvertently increased magnification, I knocked it down a notch and there we have it, all sorted. I am truly sorry for the waste of your time. Kind regards Shaun.