6505 replies to this topic

[danielr]

I have loaded the recent version onto the server. When I placed the htaccess file in the catalog folder the site would go down with an internal server error. I spoke to the providers who said that "Options +FollowSymLinks" is not supported. What function does this provide ? Also is their an alternative ?

DanR

[FWR Media]

danielr, on Sep 21 2008, 08:54 PM, said:

I have loaded the recent version onto the server. When I placed the htaccess file in the catalog folder the site would go down with an internal server error. I spoke to the providers who said that "Options +FollowSymLinks" is not supported. What function does this provide ? Also is their an alternative ?

DanR

Change providers.

[driverx]

does anyone know how to fix this error

Quote

1146 - Table 'ebooksab_ebook.TABLE_REVIEWS' doesn't exist

select count(*) as count from TABLE_REVIEWS where products_id = '529'

[TEP STOP]

[digitalwaagen1234]

FWR Media, on Sep 18 2008, 11:17 PM, said:

Did you post your whole .htaccess because something there is refusing all standard index.php based oscommerce urls.

cPath=x
manufacturers_id=x

hi
remembre me ???

today I setup a brand new osc and install the 2.1d
and have still the same problem...:-((
any idea?

[FWR Media]

digitalwaagen1234, on Sep 22 2008, 06:02 PM, said:

hi
remembre me ???

today I setup a brand new osc and install the 2.1d
and have still the same problem...:-((
any idea?

Nope looks like something on your server as no one else has it.

[fszone]

I'm using "Ultimate Seo Urls v2.5 FullPackage" and have one question. Why there is a

url = preg_replace('/&/','&',$url);

line at the end of the script, after last curly bracket?

It generates notices and does seem to be in good place. What $url variable does it change? Certainly not the one that is defined inside seo class.

[digitalwaagen1234]

FWR Media, on Sep 22 2008, 07:23 PM, said:

Nope looks like something on your server as no one else has it.

I don't think so, because I'm using a commercial server shared with many others...
but you never know....

Howerver:
I installed seo_redirect.php 1.2
and put in the admin Enable automatic redirects = false

and anything works perfect >>no more errors with the drop down menu
EXCEPT
the changes/edit in Products SEO URL: / Category SEO URL:
are not working anymore

any idea

[zaini]

Hello,
this contrib works with IE but doesnt work with my mozilla explorer...
Do you know reasons?


Many thanks for contributors !!!

Quote

ERROR
The requested URL could not be retrieved

While trying to retrieve the URL: www . z-tuning . fr

The following error was encountered:

* Connection to xxx.yyy.33.4 Failed

The system returned:

(110) Connection timed out

The remote host or network may be down. Please try the request again.

Your cache administrator is webmaster.

My website : www . z-tuning . fr

Edited by Jan Zonjee, 28 September 2008, 20:42.

[dmartin69]

Hello,
I have SEO URL's installed on numerous websites running as virtual hosts on apache. My product urls work great but my category ones do not. I need a little help please.

My category URL's look like this

http://www.XXXXX.com/-c-4.html?osCsid=412c...0218a8b90be3cf4

I need these to be like

http://www.XXXXX.com/bluecogs-c-4.html?osC...0218a8b90be3cf4

Or what ever it normally would appear as.

Thanks in advance

[FWR Media]

Can I just make clear here .. I support version 2.1d ORIGINAL updated as uploaded by me. Anything else I'm not interested in so please post the version when posting here.

As per usual new versions have gone up and "shock" everyone has problems whereas noone had problems before.

Use the version I mentioned.

Edited by FWR Media, 24 September 2008, 19:21.

[fszone]

FWR Media:
I've switched to your version and want to suggest some minor fixes:

NOTICES generated in few places:
1) add $_sid = null; at the beggining of function add_sid. There are cases where code that sets $_sid not always executes and so the notice.
2) add $container = array(); somewhere in the begging of function short_name. Same case as above.

BROKEN code:
1) generate_categories_cache function does not generate categories cache because sql query is broken. Some of the uploaded versions had this fixed but not your revision. You will see the problem by looking in database or removing error supressing (@) sign from mysql_query function in "Query" funciton.
I have changed query in generate_categories_cache function to this (not sure it's 100% correct in all cases but works for me):

		  $sql = "SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
				  FROM ".TABLE_CATEGORIES." c
				  LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd ON c.categories_id = cd.categories_id
				  LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2 ON c.parent_id=cd2.categories_id
				  AND cd2.language_id='".(int)$this->languages_id."'
				  WHERE c.categories_id=cd.categories_id
				  AND cd.language_id='".(int)$this->languages_id."'";

2) after header("Location: $url"); in function "do_redirect" add "exit;" call. Not sure it's that important for google but for sure will make redirect a bit faster.

USE OF NON EXISTING function:
1) search for $this->keep_in_memory and remove this method call. This method is used but not defined anywhere. I think original versions by Chemo had this problem too.

Consider adding Validatename function that exists in some of the versions. It looks to be very usefull in some situations. For example:
1) Google finds link /my-pink-bunny-p-10.html in shop.
2) You decide to change name of this product so that new link becomes /my-black-bunny-p-10.html
3) Cache expires after a month and now product listing contains link /my-black-bunny-p-10.html
3) Google finds new link but also "remembers" old link which still works so now it has two same pages with different links. I guess this is bad for google.

With Validatename function, when google checks first link, it gets pointed to new link by permanent redirect and so now it has this page only once in its database.

Edited by fszone, 24 September 2008, 21:50.

[FWR Media]

fszone, on Sep 24 2008, 10:48 PM, said:

FWR Media:
I've switched to your version and want to suggest some minor fixes:

NOTICES generated in few places:
1) add $_sid = null; at the beggining of function add_sid. There are cases where code that sets $_sid not always executes and so the notice.
2) add $container = array(); somewhere in the begging of function short_name. Same case as above.

BROKEN code:
1) generate_categories_cache function does not generate categories cache because sql query is broken. Some of the uploaded versions had this fixed but not your revision. You will see the problem by looking in database or removing error supressing (@) sign from mysql_query function in "Query" funciton.
I have changed query in generate_categories_cache function to this (not sure it's 100% correct in all cases but works for me):

		  $sql = "SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
				  FROM ".TABLE_CATEGORIES." c
				  LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd ON c.categories_id = cd.categories_id
				  LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2 ON c.parent_id=cd2.categories_id
				  AND cd2.language_id='".(int)$this->languages_id."'
				  WHERE c.categories_id=cd.categories_id
				  AND cd.language_id='".(int)$this->languages_id."'";

2) after header("Location: $url"); in function "do_redirect" add "exit;" call. Not sure it's that important for google but for sure will make redirect a bit faster.

USE OF NON EXISTING function:
1) search for $this->keep_in_memory and remove this method call. This method is used but not defined anywhere. I think original versions by Chemo had this problem too.

Consider adding Validatename function that exists in some of the versions. It looks to be very usefull in some situations. For example:
1) Google finds link /my-pink-bunny-p-10.html in shop.
2) You decide to change name of this product so that new link becomes /my-black-bunny-p-10.html
3) Cache expires after a month and now product listing contains link /my-black-bunny-p-10.html
3) Google finds new link but also "remembers" old link which still works so now it has two same pages with different links. I guess this is bad for google.

With Validatename function, when google checks first link, it gets pointed to new link by permanent redirect and so now it has this page only once in its database.

Yup all known at my end .. I run all of my sites/dev error_reporting(E_ALL | E_STRICT) but to be honest it is pretty pointless here as users don't even want to validate basic (quirks) html and the core osc throws tons of notice errors if you run E_ALL.

Sooo .. haven't bothered moving my "corrected" files over.

Glad to see someone else cares though

Edited by FWR Media, 24 September 2008, 23:02.

[ricardodacosta]

Dear FWR Media:

Before I post on oscommerce forums, I tried to do all I possibly can to figure out the problem, including re-installing contribution to see if that fix it.

My Problem is:

Old URLs are not being redirecting to new ones.

I first installed version 2.5 and didn't work so I went step by step and changed to your 2.1d ORIGINAL updated.

Here is the link to a product:
http://www.yogicchai.com/catalog/yogicchai...2ea0bb87efbbfb4

and here is the non functional link indexed by Google:
http://www.yogicchai.com/catalog/yogicchai...;products_id=37

Here is my .htaccess:

Options +FollowSymLinks
RewriteEngine On
RewriteBase /catalog/yogicchai/

RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-m-([0-9]+).html$ index.php?manufacturers_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pi-([0-9]+).html$ popup_image.php?pID=$2&%{QUERY_STRING}
RewriteRule ^(.*)-t-([0-9]+).html$ articles.php?tPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-a-([0-9]+).html$ article_info.php?articles_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pr-([0-9]+).html$ product_reviews.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pri-([0-9]+).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-i-([0-9]+).html$ information.php?info_id=$2&%{QUERY_STRING}

Any suggestion will be greatly appreciated

Thanks in advance

Ricardo

[ricardodacosta]

Just to add to my previous post...

If I set in Admin "Enable automatic redirects? to False" all my links work, including the ones indexed by Google but not redirecting to new url.

I tried installing the Validation contribution and I get a message from Firefox saying "REDIRECT LOOP"

Would love some help!

Ricardo

[FWR Media]

ricardodacosta, on Sep 26 2008, 04:40 AM, said:

Just to add to my previous post...

If I set in Admin "Enable automatic redirects? to False" all my links work, including the ones indexed by Google but not redirecting to new url.

I tried installing the Validation contribution and I get a message from Firefox saying "REDIRECT LOOP"

Would love some help!

Ricardo

Your site exibits the index.php?catalog= behaviour which I have seen before.

Try the following: -

Find ..

$this->path_info = is_numeric(strpos(ltrim(getenv('PATH_INFO'), '/') , '/')) ? ltrim(getenv('PATH_INFO'), '/') : NULL;

Change to ..

$this->path_info = false;

Basically USU uses getenv('PATH_INFO') when attempting to ascertain if the broken osc "experimental" search friendly urls is enabled. getenv('PATH_INFO') is unreliable and can return different info on different servers.

[ricardodacosta]

FWR Media, on Sep 26 2008, 08:07 AM, said:

Your site exibits the index.php?catalog= behaviour which I have seen before.

Try the following: -

Find ..

$this->path_info = is_numeric(strpos(ltrim(getenv('PATH_INFO'), '/') , '/')) ? ltrim(getenv('PATH_INFO'), '/') : NULL;

Change to ..

$this->path_info = false;

Basically USU uses getenv('PATH_INFO') when attempting to ascertain if the broken osc "experimental" search friendly urls is enabled. getenv('PATH_INFO') is unreliable and can return different info on different servers.

FANTASTIC Robert!

That did the trick!

All my links are working now, which means my contribution is being installed successfully, right?

One last thing...

Now that Ultimate SEO is working, if I go and enable "Seo URL validation" on ADMIN then I get this response from firefox on all my links:
"Redirect Loop- Firefox has detected that the server is redirecting the request for this address in a way that will never complete"

Any thoughts on that one?

I appreciate your help Robert

Ricardo

[dmartin69]

I am running 2.1d your upload but I need my category text to populate. Any help please

dmartin69, on Sep 24 2008, 01:58 PM, said:

Hello,
I have SEO URL's installed on numerous websites running as virtual hosts on apache. My product urls work great but my category ones do not. I need a little help please.

My category URL's look like this

http://www.XXXXX.com/-c-4.html?osCsid=412c...0218a8b90be3cf4

I need these to be like

http://www.XXXXX.com/bluecogs-c-4.html?osC...0218a8b90be3cf4

Or what ever it normally would appear as.

Thanks in advance

[FWR Media]

dmartin69, on Sep 26 2008, 12:58 PM, said:

I am running 2.1d your upload but I need my category text to populate. Any help please

the category text not populating is caused by the old version of 2.1d not having MySQL5 compatible queries.

This should not happen with 2.1d ORIGINAL updated.

1) Are you sure you have the seo.class.php file from my download (re upload it anyway)

2) Make certain you reset SEO URLs cache or you will be using old urls.

[dmartin69]

Thanks a ton that was the fix I did not have the updated version....

FWR Media, on Sep 26 2008, 10:40 AM, said:

the category text not populating is caused by the old version of 2.1d not having MySQL5 compatible queries.

This should not happen with 2.1d ORIGINAL updated.

1) Are you sure you have the seo.class.php file from my download (re upload it anyway)

2) Make certain you reset SEO URLs cache or you will be using old urls.

[FWR Media]

dmartin69, on Sep 26 2008, 03:52 PM, said:

Thanks a ton that was the fix I did not have the updated version....

Donald

Would you mind testing a small bit of code for me please. I want to upload an update to the contribution but I can't replicate what your server is doing.