Manniman

Hello Robert, thank you for your KissMT contribution. It is great as all your code and works fine for me. Just wanted to let you know that the produced keywords can sometimes look strange in multi language stores that use utf-8 character set: i.e. czech word oblečení looks like oble�en� For me it helped to replace the strtolower() php-function in kiss_modules.php in private function stripStopWords() at line 286 like this: $word = strtolower( trim( $word ) ); replace with $word = mb_strtolower( trim( $word ), CHARSET ); Thank you for reading! Manfred

This didn't work for me. I thought it was because I use the utf-8 character set. So I included '™' => '', '©' => '', '®' => '' to my character conversion table. But now I found this line in page_modules.php: $pattern = ( defined( 'SEO_REMOVE_ALL_SPEC_CHARS' ) && SEO_REMOVE_ALL_SPEC_CHARS == 'true' ) ? "@[^\sa-z0-9]@i" : "@[!#\$%&'\"()\*\+,\-\./:;<=>\?\@\[\]\^_`\{|\}~]+@"; after changing this line to: $pattern = ( defined( 'USU5_REMOVE_ALL_SPEC_CHARS' ) && USU5_REMOVE_ALL_SPEC_CHARS == 'true' ) ? "@[^\sa-z0-9]@i" : "@[!#\$%&'\"()\*\+,\-\./:;<=>\?\@\[\]\^_`\{|\}~]+@"; it worked as you described.

For your problem #2 just add '™' => '', '©' => '', '®' => '', etc. to the $char_convert array in catalog/includes/modules/ultimate_seo_urls5/includes/character_conversion/"your_language".php

Hello Robert, USU5 Pro contribution works fine and is very helpful for my shop. I use the uri rewrite option and today I had a look at the apache rewrite.log: Not only the *.php and *.html are checked for rewriting but also each and every *.gif, *.png. *.jpg ... That means hundreds of images are tested against every RewriteRule. For speed reasons I added the following lines into my htaccess-file: after: RewriteEngine On RewriteBase / I added: <FilesMatch "\.(ico|pdf|flv|jpg|jpeg|png|gif|js|css|swf)$"> RewriteEngine Off </FilesMatch> I tested it for a while and didn't find any problems. The "rewrite.log" is much smaller now and pages are shown a little faster. Do you think adding these few lines to htaccess could have any unwanted side-effects? Thank you very much again for your USU5 Pro contribution. Manfred

Because the manufacturers_names in my shop have their origin in germany or in the czech republic, they contain many special characters. To display all of them, I have to use the UTF-8 charset. As german customers see czech manufacturers I have to include the special czech characters in the german character conversion table german.php and for the czech customers I have to include the special german chars into the czech.php. I also had to include some more special signs, which are not automatically stripped away for the URI, when you use UTF-8. So my $char_convert array for czech.php, german.php and english.php is the same: $char_convert = array('ů' => 'u', 'á' => 'a', 'â' => 'v', 'ý' => 'y', 'ä' => 'ae', 'ž' => 'z', 'š' => 's', 'ť' => 't', 'č' => 'c', 'é' => 'e', 'ê' => 'k', 'Ť' => 't', 'ě' => 'e', 'í' => 'i', 'ď' => 'd', 'ï' => 'p', 'ð' => 'r', 'Ď' => 'd', 'ň' => 'n', 'ó' => 'o', 'Ť' => 't', 'Š' => 's', 'ö' => 'oe', '÷' => 'ch', 'ř' => 'r', 'ù' => 'u', 'ú' => 'u', 'ü' => 'ue', '™' => '', 'ÿ' => 'ia', 'À' => 'a', 'Á' => 'a', 'Â' => 'v', 'Ã' => 'g', 'Ä' => 'ae', 'Å' => 'e', 'Ý' => 'y', 'Ž' => 'z', 'Č' => 'c', 'É' => 'e', 'Ê' => 'k', 'Ů' => 'u', 'Ě' => 'e', 'Í' => 'i', 'Î' => 'o', "´" => "", '°' => '', 'Ø' => '', 'Ň' => 'n', 'Ó' => 'o', 'Ô' => 'f', 'Õ' => 'h', 'Ö' => 'oe', '×' => 'ch', 'Ř' => 'r', 'Ù' => 'u', 'Ú' => 'u', 'Ü' => 'ue', '–' => '-', 'ß' => 'ss'); Hope it helps. Manfred

Hi Robert, online again after moving my complete home to another location and finishing christmas preparations, I saw that you finished beta phase for USU5Pro. I installed the new version on my life site and it works great. Thank you very much for your wonderful contribution. Manfred

Robert posted a patch to solve this problem earlier in this thread.

Intermediate Report: I found the last described error by accident, when I changed a setting in the admin, which didn't obviously have a connection to Seo Urls. Could you replicate this error? During the last week I tried many other combinations of admin settings without finding other errors. But there are still millions of combinations left for testing and I'll continue. Idea for an improvement: For multi language shops it could be good for the search engines to have different language names for standard pages like "privacy.php" "shipping.php" ... I mean it could be nice to have "versand.php/de" and "doprava.php/cz" instead of "shipping.php/de" or "shipping.php/cz"

Hi Robert, I found something else: When I change the value of "Manufacturers Select Size" in Admin->Configuration->Maximum Values to any other value but 1 it becomes impossible to select a manufacturer from the manufacturer's list-box in the shop. And please allow me to repeat my last question: Is the reason somewhere in the rewrite rules in htaccess?

Manufacturer name "AL-KO". I know I have to set "Filter short words" = "1" if I want to see that manufacturer's name in a search engine friendly URL. Anyway, when I set USU5 Pro Setting "Filter short words" = "2" USU5 Pro produces the following URLs as expected: //localhost/USU5Pro/de/-m-3.html (german) //localhost/USU5Pro/en/-m-3.html (english) //localhost/USU5Pro/-m-3.html (default language czech) The first two of them work fine, but the last one produces a HTTP 404 page-not-found-error from the server. Why??

Same thing happens when I come from a categories listing (such as DVD/Action) and select a manufacturer (Warner) from the list box above.

Here is another little report: Everything seems to work perfect, but now I found something that looks strange. My default language is czech. When I switch the shop's language to german, everything looks fine until I have a manufacturers page like //localhost/USU5Pro/de/microsoft-m-2.html In this page, when I choose "Show: mice" from the select box above the product listing, the language switches back to the default language czech and I get the page //localhost/USU5Pro/microsoft-m-2.html?filter_id=9&sort=2a

Sorry for my english. The main thing is: I'm testing with UTF-8 character coding which needs up to 4 bytes per character. As long as the character tables in includes/modules/ultimate_seo_urls5/includes/character_conversion/*.php are also coded in UTF-8, everything looks fine till now and I get perfect URLs. I shouldn't have asked. After reading your answer, I remember that you have described this somewhere before.

It works. I changed my settings to sqlite cache again. Next thing I did, was to install czech language. As I want the osC fast search to find products indepentent of form of writing in all languages (it should find "Dětský" even if the user types "detsky" and mySQL uses like '%detsky%') I needed to change the database to use utf8_general_ci collation. This must be done, because utf-8 is the only character-set which keeps all signs for the eastern and western european languages and has good results with the "like" operator. After that I had to modify the czech.php, german.php, english.php ... (in catalog and in admin): // charset for web pages and emails define('CHARSET', 'utf-8'); and for the connection to the database I modified the function tep_db_connect() in all database.phps: function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') { global $$link; if (USE_PCONNECT == 'true') { $$link = mysql_pconnect($server, $username, $password); } else { $$link = mysql_connect($server, $username, $password); } if ($$link){ mysql_set_charset('utf8',$$link); mysql_select_db($database,$$link); } return $$link; } What I'd like to know now is, if I have to care for sqlite (for the cache). But I think, it only keeps URLs which are free from special characters. Anyway, I need you help now: In all languages I get URLs like localhost/USU5Pro/de/hardware-c-1.html or localhost/USU5Pro/en/hardware-c-1.html but the czech URL is only localhost/USU5Pro/hardware-c-1.html

Thanks for your patch. There is another warning left: ( ! ) Warning: SQLiteDatabase::query() [sqlitedatabase.query]: column cache_name is not unique in C:\xampp\htdocs\SeoProBeta\includes\modules\USU5Pro\cache_system\sqlite.php on line 66 Call Stack # Time Memory Function Location 1 0.2678 3437992 Usu_Main->__destruct( ) ..\usu5.php:0 2 0.2679 3437992 Sqlite_Cache_Module->store( ) ..\usu5.php:51 3 0.2683 3444704 SQLiteDatabase->query( ) ..\sqlite.php:66 Meanwhile I selected cache system mysql. The warning messages disappear.

I use your USU5 (not Pro) contribution on my live site with german and czech language. For testing USU5 Pro, I installed a local server (believe me: that was not easy for me, as I'm not a developer, and till now I have some problems with the configuration). After setting up a fresh osCommerce, I dropt the files of your package on top and found the warnings, which I mentioned. As I never get any warnings on my running live system, I was sure there was something wrong with the settings in my local-server configuration, but I could not find the reason for these warnings. After I posted the problem here, your answer was "Yup sqlite needs updating to sqlite3, will post some revised code later." I'm sorry, maybe I misunderstood your words (english isn't my native language). I was sure this was one of the bugs you wanted to be found by your beta testers and that's why I waited for the revised code. So, shall I just continue testing and ignore these warnings?

Looks like you are very busy this moment, as you post your solutions very fast normally. I'll keep waiting patiently. Hope you will not forget the posting.

I've still some problems with my local server installation (Apache, Windows). I always get warnings like the one below in front of the webshop-pages. And I have no idea, which module (PHP / Apache) produces these warnings and how I can switch them off. ( ! ) Warning: Missing argument 1 for Sqlite_Cache_Module::gc(), called in C:\xampp\htdocs\USU5Pro\includes\modules\ultimate_seo_urls5\main\usu5.php on line 212 and defined in C:\xampp\htdocs\USU5Pro\includes\modules\ultimate_seo_urls5\cache_system\sqlite.php on line 78 Call Stack # Time Memory Function Location 1 0.0207 453912 {main}( ) ..\index.php:0 2 0.0475 716144 require( 'C:\xampp\htdocs\USU5Pro\includes\application_top.php' ) ..\index.php:13 3 0.6631 2560544 Usu_Main->initiate( ) ..\application_top.php:325 4 0.6631 2560656 Usu5_Bootstrap->bootStrapper( ) ..\usu5.php:69 5 1.1124 3457344 Usu5_Bootstrap->setRegistry( ) ..\bootstrap.php:50 6 1.1125 3457576 Sqlite_Cache_Module->retrieve( ) ..\bootstrap.php:391 7 1.1125 3457624 Usu_Main->extractCacheData( ) ..\sqlite.php:74 8 1.1546 3461088 Sqlite_Cache_Module->gc( ) ..\usu5.php:212

Forgot to say: I loose my session and have a new osCid after that.

Still didn't solve the problem. I had a look at the access.log of my apache server: Default language: english Click product link: 127.0.0.1 - - [26/Aug/2010:07:39:18 +0200] "GET /SeoProBeta/msimpro-microsoft-intellimouse-pro-p-3.html?osCsid=pauai4bgcu5kgoc2tn683i18f0 HTTP/1.1" 200 30433 "http://localhost/SeoProBeta/hardware-c-1.html?osCsid=pauai4bgcu5kgoc2tn683i18f0" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.127 Safari/533.4" Looks good. Click german language flag procuces duplicate ?osCsid=pauai4bgcu5kgoc2tn683i18f0 ?osCsid=pauai4bgcu5kgoc2tn683i18f0 in the get command: 127.0.0.1 - - [26/Aug/2010:07:39:56 +0200] "GET /SeoProBeta/index.php/de?osCsid=pauai4bgcu5kgoc2tn683i18f0?osCsid=pauai4bgcu5kgoc2tn683i18f0 HTTP/1.1" 302 2330 "http://localhost/SeoProBeta/msimpro-microsoft-intellimouse-pro-p-3.html?osCsid=pauai4bgcu5kgoc2tn683i18f0" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.127 Safari/533.4" Server's answer "302" (Moved Temporarily) and next is 127.0.0.1 - - [26/Aug/2010:07:39:57 +0200] "GET /SeoProBeta/index.php HTTP/1.1" 200 30515 "http://localhost/SeoProBeta/msimpro-microsoft-intellimouse-pro-p-3.html?osCsid=pauai4bgcu5kgoc2tn683i18f0" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.127 Safari/533.4" which leads me to the default language index page (english)

It is installed now, but possibly I made something wrong. When "multiple language support" is switched on in the admin, the following will happen to the shop: The current language remains as it was, but it's symbol-flag disappeares in the shop. A mouseclick on any of the remaining language symbols switches the language to english, the english flag disappeares and any later mouseclick doesn't change anything.

Thanks Robert, but how can I define the settings for the new freatures like "flexible product uri creation" or "True Multi language support for SEO". The only defines I find in includes/modules/ultimate_seo_urls5/includes/Usu_Init.php are: @define( 'SEO_URLS_RESET_CACHE', 'false' ); @define( 'SEO_URLS_ENABLED', 'true' ); @define( 'SEO_URLS_TYPE', 'standard' ); @define( 'SEO_URLS_CHAR_CONVERT_SET', '' ); @define( 'SEO_URLS_FILTER_SHORT_WORDS', 3 ); @define( 'SEO_URLS_REMOVE_ALL_SPEC_CHARS', 'false' ); @define( 'SEO_URLS_CACHE_DAYS', 7 ); @define( 'SEO_URLS_USE_W3C_VALID', 'true' ); @define( 'SEO_URLS_ADD_CPATH_TO_PRODUCT_URLS', 'false' ); @define( 'SEO_URLS_OUPUT_PERFORMANCE', 'false' ); @define( 'SEO_URLS_ADD_CAT_PARENT', 'true' ); and @define( 'SEO_URLS_CACHE_SYSTEM', 'FileSystem' ); It is just the same as in USU5 (without Pro)

Hello Robert, I just installed the USU5 Pro beta on a new system (drop on top), but I cannot find any new settings in the admin. Everything looks like USU5 (not Pro). How can I test the new features? Thank you for your assistence Manfred

Thank you very much for your explanation. I didn't know it would make duplicate content. I'll better try to build an extra page that looks like cPath=0 Thanks again Manfred

Maybe I made something wrong, when I started to build the shop. I created some categories and since the beginning there has always been a welcome-page "http://www.mystrangeshop.cz/index.php" and a parent-page of all categories "http://www.mystrangeshop.cz/index.php?cPath=0". It looks like other categorypages, when they contain many subcategories. I thought it was standard in every OsCommerce shop and since I made many beautiful symbols for each category, it looked very nice. Isn't such a page in your shop too, when you switch off Seo Urls? I can show you an online-example: "http://www.uk-mobilestore.co.uk/index.php?cPath=0" Anyway may be you have an idea for a workaround in Seo Urls just for this single page. Thanks Manfred