yesudo

Sounds like a possible mysql issue - has your host upgraded you to mysql 5.xx ? or are you on mysql 5.xx ?

That is for putting your own url in there - if not populated then the url is generated dynamically.

Was anything changed on your store just prior to it not continuing to work ?

Yes.

The database installer is part of the contribution - not an extra file: 'Call your store in your favorite browser! The contribution should be functional out of the box and all database settings will be installed automatically on first page request. The contribution has an intelligent database installer that detects whether the proper settings are present and if not will install them.'

31 October version incorporates Randelia's update: http://www.oscommerce.com/community/contri...,all/search,seo

http://www.oscommerce.com/forums/index.php?s=&...st&p=955711

Double check all is installed - including the htaccess file.

I just tried Randalia modification and it worked.

My fault - you have from in there twice.

Backup and then try: $product_deletion_query = tep_db_query("select products_id from from " . TABLE_PRODUCTS . " where products_status = 0"); while ($product_deletion = tep_db_fetch_array($product_deletion_query)) { tep_db_query("delete from " . TABLE_PRODUCTS . " where products_id = '" . $product_deletion['products_id'] . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $product_deletion['products_id'] . "'"); } You will need to add any other relevant product tables within the while loop e.g. products_attributes, products_description etc...

Do you mean concatenating the product name with the admin input seo url ? The modification I added allows the user to put whatever they want, some examples being: domain.com/catalog/matrix-movie-keanu-reeves.html domain.com/catalog/matrix-keanu-reeves.html domain.com/catalog/keanu-reeves-movie.html domain.com/catalog/keanu-reeves-matrix-movie.html domain.com/catalog/keanu-reeves-matrix.html Which is a lot more flexible than concatenating the fields.

1) Anyway, tested it on a new install and found does work but whenever a category or product SEO URL is added, the image is lost and whenever an image URL is typed the page gets stuck because the 'save' button stops working but the cancel button still does work? 2) Another idea would be to have the obvious... an 'item' SEO URL field where you can add your own URL's for items... this would be better because your standard SEO URL 'matrix.html' would look better like 'matrix-the-movie-keanu-reeves.html' If you pm me your ftp details i'll take a look at 1. Not sure what you mean on 2 ?

Hello Tom, I'd re-check your install as it looks like you may have put those defines in the wrong place in the file. Cheers,

Did you add the code from the additional instructions file - as it sounds like you dont have that function added within your code.

New version uploaded - incorporating updated install instructions.

The server error page is usually indicative of either: .htaccess file not being in place. .haccess file has wrong store path in it. mod_rewrite is not switched on or is not allowed, on your server.

Please pm me a copy of your unmodified categories file.

I would suggest discarding your amended categories file - then doing the modifications again - incase something was missed.

For the database insert - do it via something like phpMyAdmin - which you may find a link to in your host's control panel. For the language edits put them in the file before the last ?>

As Jack mentions, this is the support thread for the automatic version, not sure where you will find the thread for the manual one you are trying.

Fix posted. Correction to file catalog/includes/classes/seo.class.php from version dated 11 Sep 2006. Should help where tailored category names are not showing in the URL. Thanks to Miro Igov for the spot.

The amendment you made above should be fine - If p.products_min_level was an issue then you should get an sql error.

The amendment you made above should be fine - If p.products_min_level was an issue then you should get an sql error.