Debs

osCommerce apparently allows categories id's to be added to no end in the url. I have around 1,000 categories 3 levels deep and around 20,000 products. I've had page load times in excess of 5 minutes, which seem to be caused by the caching system (speeds increased after cache has been deleted). After more insight from problems every 3 months at the start, and more frequent as time went on I've came to notice an interesting trend. For some reason the web crawlers just start adding categories such as: 22_34_78_79_99 and so on! I now have around 90k pages indexed at Google, LOL. I'm going to have a lot of pages not found for quite awhile to come. As long as the last two are valid osCommerce category id's the site accepts the entry and displays the last category id.

Many of the cached entries had category depths as high as 5 levels deep or more?

This becomes a serious issue in USU5 because of the size of the cache (seek times in sqlite are enormous, file seek times are impossible, I never tried mysql caching), with google indexing around 90k pages and crawling an amazing amount of pages and continually adding random add-on categories. I was desperate and made a change to the tep_parse_category_path function in general.php, this fixed the caching problem from osCommerce's cache, but did nothing for the problem with caching in USU5. In order to stop USU5 from caching these invalid url's, I tried to modify the index.php in the page modules directory and couldn't figure out how. So instead I was able to modify the hrefLink function in usu5.php file in the main directory like this:

	public function hrefLink( $page, $parameters, $connection, $add_session_id, $search_engine_safe ) {
	 // Badly coded shops often pass in odd characters
	
	 if (sizeof($parameters)>2){
	  $parameters = array_slice ($parameters, -3);	
	  return osc_href_link( $page, $parameters, $connection, $add_session_id, $search_engine_safe );
	 }

I'm not sure if this is the most elegant way to fix this problem or if there is a better way!

-Bill

Interesting Debs,

I tried a bunch of what they were talking about, but really came away with a couple of thoughts.....

1..I have no idea what or how to deal with JQuerry, or infact any JavaScript
2..Maybe I should update the JQuerry.

So I grabbed the latest version of JQuerry called: jquery-ui-1.8.14.custom.min.js, changed the name to jQuery.ui.js and placed it into the ext folder, I also grabbed a copy of jQuery.js 1.6.2 and slammed that into my website, again into the ext folder.

Now I no longer get the Waiting for long running script error, I do, however, get the annoying Message from webpage "there was an error checking e-mail address, please inform......" pop up. So really no better off. In fact worse, as my Chrome no longer works, I get the same error as I do in IE9.

The fact that I changed the error I am getting indicates to me that I am on the right path, and need to get my JQuerry files sorted out, but to do that I need a better understanding of what they do. Anyone disagree/agree? I am sure I have created my own problems by using what I guessed at as the right script and would love someone to give me a clearer picture as to what we need for this script to work.

Steve C