[Contribution] Ultimate SEO URLs - by Chemo

Thoomp! · February 7, 2005

Hi everyone,

Forgive my bumping my Rewrite issue from last week, which follows this message. It seems like it may have been lost in the shuffle, I'm afraid. Bobby - sorry to hear that you were sick last week. :(

This is the whole "Rewrite mode not working with 404 errors" issue. I did try all sorts of different configurations in the .htaccess, for copies of .htaccess in the root directory and the catalog directory (/Thoomp/catalog).

I'm wondering at this point if I need to change something in my http.conf file, although supposedly

the rewrite_module in Apache is already activated (mod_rewrite.c).

Thoughts? Thanks again in advance! :)

- Seth <>

http://www.gameoeuvre.com

royalfunk · February 7, 2005

I'm not familiar with that contribution so can't be of any help...sorry.
The Ultimate SEO URLs contribution is nothing more than an URL wrapper...so if you pages don't have meta tags then none will be picked up. If you have a Header Tag Controller installed it will function correctly. I have this installed on more client sites than I can count and all of their installations work correctly with header tags controller.

Bobby

<{POST_SNAPBACK}>

My page(s) do have meta tags. I am using PHP to generate dynamic meta tags and I would assume once the page is loaded as an HTML file that it is cached somewhere on the server so that when the HTML file is called, it references those generated tags. Below is the code and it does work perfectly when loading PHP pages. I am using VSE Be Found Pro to run SE optimization, reports, and tracking.

CODE FOR DYNAMIC META TAGS ON PRODUCT_INFO.PHP

<!-- begin dynamic meta tags query -->

<?php

$the_product_info_query = tep_db_query("select pd.language_id, p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_price_retail, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'" . " and pd.language_id ='" .  (int)$languages_id . "'"); 

   $the_product_info = tep_db_fetch_array($the_product_info_query);

$the_product_name = strip_tags ($the_product_info['products_name'], "");

$the_product_description = strip_tags ($the_product_info['products_description'], "");

$the_product_model = strip_tags ($the_product_info['products_model'], "");

?>

<?php

$the_manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '" . (int)$languages_id . "'), " . TABLE_PRODUCTS . " p  where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.manufacturers_id = m.manufacturers_id"); 

$the_manufacturers = tep_db_fetch_array($the_manufacturer_query);

?>

<!-- end dynamic meta tags query -->

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<?php
//begin dynamic meta tags query -->
?>

<title><?php echo TITLE ?> : <?php echo $the_product_name; ?></title>

<meta name="keywords" content="<?php echo TITLE ?>, <?php echo $the_product_name; ?>, <?php echo $the_product_model; ?>, <?php echo $the_manufacturers['manufacturers_name']; ?>">

<meta name="description" content="<?php echo $the_product_description . "," . $the_product_name; ?>">

<?php
//end dynamic meta tags query -->
?>

Fourbit · February 7, 2005

Aaron,

I may be missing something, but just off hand I don't see wher you are defining the 'TITLE'.

The first time it's used is here.

Paul

My page(s) do have meta tags. I am using PHP to generate dynamic meta tags and I would assume once the page is loaded as an HTML file that it is cached somewhere on the server so that when the HTML file is called, it references those generated tags. Below is the code and it does work perfectly when loading PHP pages. I am using VSE Be Found Pro to run SE optimization, reports, and tracking.

CODE FOR DYNAMIC META TAGS ON PRODUCT_INFO.PHP

<!-- begin dynamic meta tags query -->

<?php

$the_product_info_query = tep_db_query("select pd.language_id, p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_price_retail, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'" . " and pd.language_id ='" .  (int)$languages_id . "'"); 

   $the_product_info = tep_db_fetch_array($the_product_info_query);

$the_product_name = strip_tags ($the_product_info['products_name'], "");

$the_product_description = strip_tags ($the_product_info['products_description'], "");

$the_product_model = strip_tags ($the_product_info['products_model'], "");

?>

<?php

$the_manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '" . (int)$languages_id . "'), " . TABLE_PRODUCTS . " p  where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.manufacturers_id = m.manufacturers_id"); 

$the_manufacturers = tep_db_fetch_array($the_manufacturer_query);

?>

<!-- end dynamic meta tags query -->

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<?php
//begin dynamic meta tags query -->
?>

<title><?php echo TITLE ?> : <?php echo $the_product_name; ?></title>

<meta name="keywords" content="<?php echo TITLE ?>, <?php echo $the_product_name; ?>, <?php echo $the_product_model; ?>, <?php echo $the_manufacturers['manufacturers_name']; ?>">

<meta name="description" content="<?php echo $the_product_description . "," . $the_product_name; ?>">

<?php
//end dynamic meta tags query -->
?>

<{POST_SNAPBACK}>

royalfunk · February 7, 2005

Aaron,

I may be missing something, but just off hand I don't see wher you are defining the 'TITLE'.

The first time it's used is here.

<title><?php echo TITLE ?> : <?php echo $the_product_name; ?></title>

Paul

<{POST_SNAPBACK}>

Look more closely.

The <?php echo TITLE; ?> is generated in the english.php language file.

<?php echo $the_product_name; ?> is defined in the SQL query I posted.

The title comes out loking like this, for example:

MySite.com : Product Name

Let me know if I missed something, but it is working and has been for months. I would think the cahcing of the PHP to HTML would catch all that info.

Fourbit · February 7, 2005

Look more closely.

The <?php echo TITLE; ?> is generated in the english.php language file.

<?php echo $the_product_name; ?> is defined in the SQL query I posted.

The title comes out loking like this, for example:

MySite.com : Product Name

Let me know if I missed something, but it is working and has been for months. I would think the cahcing of the PHP to HTML would catch all that info.

<{POST_SNAPBACK}>

:D

I did look closer. And I don't see that you posted your english.php file. So, as I said I don't see where you are defining that 'TITLE'. I assumed that you were going dynamic with the db sql and were trying to use that as part of your 'TITLE'. But, no go.

I really think that this may have nothing to do with this contrib. So, it should probably be moved to a different thread or we can go PM? Just my thoughts.

Also, it may be helpful for us to see the actual site in question? ;)

Paul

yandus · February 7, 2005

Bobby,

Many thanks for the fast reply! I have read all your related threads to cookies & domains. Still when I did it my website was messed up after modifying catalog/includes/configure.php

I would like to remember you that your contributions works fully! The problem is due to me & my website which is forcing the use of cookies (or else cName & Rewrite html won't work)

This is my configuration. Please let me know if I am missing something. Why is this common 'cookie-matter' taking me up to 2 days now?

I will be grateful if you could deliver me from this problem.

SEO URLs

-Enable SEO URLs? <===> Value= true

-Choose URL Type <===> Value=Rewrite

-Filter Short Words <===> Value=0

-Reset SEO URLs Cache<===> False

Sessions

-Sessions Directory <===> /tmp

-Force Cookie Use <===> True

Check SSL Session ID <===> False

Check User Agent <===> False

Check IP Address <===> True

Prevent Spider Sessions <===> True

Recreate Session <===> False

Cache

Cache <===> Use Cache <===> Value= False

Cache <===> Cache Directory <===> Value= /tmp/

mujina · February 7, 2005

Thanks for your reply Chemo!

I'm gonna work on it and post the fix if I find it!!!

Thanks so much for your contribution and you availability. :thumbsup:

Best regards.

<{POST_SNAPBACK}>

Thanks to Kai the author of buy_two_module I am now able to use the two contributions together. One have to desactivate the name matching feature from the admin panel.

yandus · February 7, 2005

Thanks for all the help Chemo!

Don't bother replying my last question about cookies. I had exactly the same problem as the guy from oasefilter.de

I forgot to turn cache to false.

Great Contribution! All works extremely fine!

royalfunk · February 7, 2005

:D

I did look closer. And I don't see that you posted your english.php file. So, as I said I don't see where you are defining that 'TITLE'. I assumed that you were going dynamic with the db sql and were trying to use that as part of your 'TITLE'. But, no go.

I really think that this may have nothing to do with this contrib. So, it should probably be moved to a different thread or we can go PM? Just my thoughts.

Also, it may be helpful for us to see the actual site in question? ;)

Paul

<{POST_SNAPBACK}>

Thanks for the quick reply - I am banging my head on why engines/software do not seem to pick up the title and meta tags. The title for all pages is defined in your english.php file so that has not changed. I was assuming that the way this contribution worked is that when a product page is called, it caches a temporary HTML file that it can call on (rather than PHP) until admin changes something relating to that product. Then it would need to cache a new file. Correct? :huh:

Browsers have never had a problem processing the metas or titles of site pages before, and that part of it still works now. I was under the impression that once a product PHP page is "cached" to HTML, that you could call on that HTML file and all the metas, text, title, etc. would be pre-stored and easily readable in HTML format. Unfortunately that doesn't seem to work (at least for me).

The site is http://www.coolhotstuff.com and a specific product URL you can reference is:

http://coolhotstuff.com/store/chase-authen...cket-p-165.html

I would be interested to see how your search engine software recognizes the page. Since we do everything on Apple :thumbsup: , we do not have a plethora of SE software to choose from.

Thanks,

Aaron

Fourbit · February 7, 2005

Thanks for the quick reply - I am banging my head on why engines/software do not seem to pick up the title and meta tags. The title for all pages is defined in your english.php file so that has not changed. I was assuming that the way this contribution worked is that when a product page is called, it caches a temporary HTML file that it can call on (rather than PHP) until admin changes something relating to that product. Then it would need to cache a new file. Correct? :huh:

Ummm. No, this contrib doesn't cache any files. All it does is put your cat/product in a data table that can then be used to generate the corrected url's . Then the redirects in the .htaccess take that new url when it's used and reconfigure it along with some other codeing into a url that OSC recognizes.

So, none of the titles or metas are used. Your program code in index, phpinfo etc are still the ones that control the dynamic code. (I think) :D

Browsers have never had a problem processing the metas or titles of site pages before, and that part of it still works now. I was under the impression that once a product PHP page is "cached" to HTML, that you could call on that HTML file and all the metas, text, title, etc. would be pre-stored and easily readable in HTML format. Unfortunately that doesn't seem to work (at least for me).

The site is http://www.coolhotstuff.com and a specific product URL you can reference is:

http://coolhotstuff.com/store/chase-authen...cket-p-165.html

I would be interested to see how your search engine software recognizes the page. Since we do everything on Apple :thumbsup: , we do not have a plethora of SE software to choose from.

Thanks,

Aaron

<{POST_SNAPBACK}>

BTW, looks like the title and meta tags are doing fine. I just went to your site ( http://coolhotstuff.com/store/chase-authen...cket-p-165.html ). And this is the code at the top of the page.

<head>

<title>CoolHotStuff.com : Get it all here! : Chase Authentics Jeff Gordon Uniform Jacket</title>

<meta name="keywords" content="CoolHotStuff.com : Get it all here!, Chase Authentics Jeff Gordon Uniform Jacket, cuj24, Chase">

<meta name="description" content="Chase Authentic Nascar Jackets are the best on the market and highest quality Driver Jacket available !!!

These jackets boldly and proudly displays the driver and all team graphics and colors on the sleeves, across the chest and back as well !!!

Wearing these high quality jackets will surely get you noticed as you display who your favorite driver and racing team are !!

Chase Jackets Are The Official Trackside Jackets !!!,Chase Authentics Jeff Gordon Uniform Jacket">

Not knowing what it should look like, it looks good to me. :D

Paul

February 7, 2005

Hi Aaron,

Can you tell me what you are using for the lookup software etc? This is very interesting.

Thanks,

Paul

PS. Or anyone else for that matter. What are you using for search engine emulation? To see what the search engines will see.

<{POST_SNAPBACK}>

You can use my search engine useragent simulator located here: Chemo's osC Search Engine Spider - Beta. I coded it to put to rest the issues of whether or not the contribution was causing osCsid's to be cached with Google. It does not cause the osCsid's to be cached but is also nice to get some other info about your page.

Hi everyone,

Forgive my bumping my Rewrite issue from last week, which follows this message. It seems like it may have been lost in the shuffle, I'm afraid. Bobby - sorry to hear that you were sick last week. :(

This is the whole "Rewrite mode not working with 404 errors" issue. I did try all sorts of different configurations in the .htaccess, for copies of .htaccess in the root directory and the catalog directory (/Thoomp/catalog).

I'm wondering at this point if I need to change something in my http.conf file, although supposedly

the rewrite_module in Apache is already activated (mod_rewrite.c).

Thoughts? Thanks again in advance! :)

- Seth <>

http://www.gameoeuvre.com

<{POST_SNAPBACK}>

You should not have any entries in the root level .htaccess file other than a possible redirect. To be honest, I would not use them in the root file and instead would use a PHP based header redirect (with 301 header of course).

Thanks for the quick reply - I am banging my head on why engines/software do not seem to pick up the title and meta tags. The title for all pages is defined in your english.php file so that has not changed. I was assuming that the way this contribution worked is that when a product page is called, it caches a temporary HTML file that it can call on (rather than PHP) until admin changes something relating to that product. Then it would need to cache a new file. Correct? :huh:

Browsers have never had a problem processing the metas or titles of site pages before, and that part of it still works now. I was under the impression that once a product PHP page is "cached" to HTML, that you could call on that HTML file and all the metas, text, title, etc. would be pre-stored and easily readable in HTML format. Unfortunately that doesn't seem to work (at least for me).

The site is http://www.coolhotstuff.com and a specific product URL you can reference is:

http://coolhotstuff.com/store/chase-authen...cket-p-165.html

I would be interested to see how your search engine software recognizes the page. Since we do everything on Apple :thumbsup: , we do not have a plethora of SE software to choose from.

Thanks,

Aaron

<{POST_SNAPBACK}>

There is something awry with your site...I checked it with my browser and the tags are coming across just fine. However, when I check it with my spider simulator it does not pick up content NOR tags. Do you have anything else installed that may be conflicting?

Bobby

GLS · February 7, 2005

Help!

I've done everything twice, meticulously, and my site's gone down :( . (That's not an accusation....I should have backed up :blush: )

To begin with, I've discovered the flavour of osC installed by my ISP sticks "oscommerce_" in front of every table name but I think I've managed to find all the entries that needed changing...well, certainly enough to get me through the install-seo.php setup page.

Now my site displays:

"Fatal error: Cannot redeclare implode_assoc() (previously declared in my shop/catalog/includes/functions/html_output.php:13) in my shop/catalog/includes/functions/html_output.php on line 36"

Any ideas?

February 7, 2005

You have two functions in there that are duplicates of each other. Open includes/functions/html_output.php and remove one of the implode_assoc() functions.

Bobby

GLS · February 7, 2005

You have two functions in there that are duplicates of each other. Open includes/functions/html_output.php and remove one of the implode_assoc() functions.

Bobby

<{POST_SNAPBACK}>

Great....thanks for the lightning response :D

I cut and paste that code from the help file....I've now deleted lines 13-35 and that error has stopped but now I'm getting:

"1146 - Table myDB.cache' doesn't exist

DELETE FROM cache WHERE cache_expires <= '2005-02-07 09:21:06'

[TEP STOP]

Last question....promise! If I can't sort it this time, I'll start with the original files again.

Thoomp! · February 7, 2005

Hi again, Bobby -

You said the following:

>> You should not have any entries in the root level .htaccess file other than a possible redirect.

>> To be honest, I would not use them in the root file and instead would use a PHP based

>> header redirect (with 301 header of course).

The only .htaccess file right now at all that's there, is in /Thoomp/catalog - I also tried placing an .htaccess file in root, but with no success.

The redirect that I probably mentioned is just an "index.html' page, which has a javascript redirect to: /Thoomp/catalog/index.php - Nothing fancy in the least bit.

PHP based header redirect? Scratching my head here, and I'll have to look it up. Do I need one to get this to work?

I checked httpd.conf of the server, and it seems that the rewrite engine module is set to "on."

Still confused and without out luck. Thanks, Bobby!

- Seth <>

clarocque · February 7, 2005

You can use my search engine useragent simulator located here: Chemo's osC Search Engine Spider - Beta. I coded it to put to rest the issues of whether or not the contribution was causing osCsid's to be cached with Google. It does not cause the osCsid's to be cached but is also nice to get some other info about your page.
You should not have any entries in the root level .htaccess file other than a possible redirect. To be honest, I would not use them in the root file and instead would use a PHP based header redirect (with 301 header of course).

There is something awry with your site...I checked it with my browser and the tags are coming across just fine. However, when I check it with my spider simulator it does not pick up content NOR tags. Do you have anything else installed that may be conflicting?

Bobby

<{POST_SNAPBACK}>

I would have to agree with Bobby. When I view the source of you site I see the meta tags but when I run it through a spider sim nothing... I know it is not the SEO contribution as any other site I check using it is ok.

Not sure what it is... but you might try using a different system for meta tags...

I have a simple one (link below) that seems to work fine if that helps...

Might want to looka the punctuation - migh be causing some problem???

royalfunk · February 7, 2005

Not knowing what it should look like, it looks good to me. :D

Paul

<{POST_SNAPBACK}>

Thanks Paul,

Yes, it does load correctly, but so do the PHP files. What I am worried about are indexing robots and SEO software. They seem to not be picking up the metas and title. Does anyone here have SEO software they can use to verify this? It is possible it could just be our software, but I doubt it. Thanks again!

PS - When I use Chemo's Search Engine Spider Tool it shows no META info for the HTML url:

http://www.coolhotstuff.com/store/chase-au...cket-p-165.html

;)

-Aaron

Edited February 7, 2005 by royalfunk

February 7, 2005

Great....thanks for the lightning response :D

I cut and paste that code from the help file....I've now deleted lines 13-35 and that error has stopped but now I'm getting:

"1146 - Table myDB.cache' doesn't exist

DELETE FROM cache WHERE cache_expires <= '2005-02-07 09:21:06'

[TEP STOP]

Last question....promise! If I can't sort it this time, I'll start with the original files again.

<{POST_SNAPBACK}>

You need to run the install-cache.php file as per the instructions (STEP #2).

If you have installed the code in application_top.php already then comment them out so you can run the installer. Once you run the install script then go back to application_top.php and uncomment the code.

Hi again, Bobby -

You said the following:

>> You should not have any entries in the root level .htaccess file other than a possible redirect.

>> To be honest, I would not use them in the root file and instead would use a PHP based

>> header redirect (with 301 header of course).

The only .htaccess file right now at all that's there, is in /Thoomp/catalog - I also tried placing an .htaccess file in root, but with no success.

The redirect that I probably mentioned is just an "index.html' page, which has a javascript redirect to: /Thoomp/catalog/index.php - Nothing fancy in the least bit.

PHP based header redirect? Scratching my head here, and I'll have to look it up. Do I need one to get this to work?

I checked httpd.conf of the server, and it seems that the rewrite engine module is set to "on."

Still confused and without out luck. Thanks, Bobby!

- Seth <>

<{POST_SNAPBACK}>

Seth, your site is apparently not the typical install. I'm afraid I cannot help you anymore without actually getting in there and changing code myself (after debugging it).

Thanks Paul,

Yes, it does load correctly, but so do the PHP files. What I am worried about are indexing robots and SEO software. They seem to not be picking up the metas and title. Does anyone here have SEO software they can use to verify this? It is possible it could just be our software, but I doubt it. Thanks again!

PS - When I use Chemo's Search Engine Spider Tool it shows no META info for the HTML url:

http://www.coolhotstuff.com/store/chase-au...cket-p-165.html

;)

-Aaron

<{POST_SNAPBACK}>

Could it possible be that you have line breaks in your meta tags? I tried a quick experiement with one of my sites and made it two lines (using \n) and it did not show that particular meta tag.

Try removing the line breaks.

Bobby

royalfunk · February 7, 2005

Try removing the line breaks.

<{POST_SNAPBACK}>

There are no line breaks. IS there anything else you could think of??

-Aaron

February 7, 2005

There are line breaks.

Bobby

TomCavendish · February 7, 2005

Hello Bobby,

You are using an MS1 release. There is no doubt about it. I am 100% sure.

In MS1 there was no function that you had to imort. Secondly, you're having a DIR_WS_HTTP_CATALOG problem which was introduced in MS2 andhas a small code snippet in application top to handle it in MS2.

In my application_top.php I have:

// define the project version
 define('PROJECT_VERSION', 'osCommerce 2.2-MS2-CVS');

Third, MS2 uses index.php and ONLY MS1 used default.php

I had changed that myself.

Tommy :(

February 8, 2005

OK...you are using an MS2-CVS release which is just above MS1. It is not the same code and the same steps cannot be used to install it.

Since MS2-CVS changed from day to day there is no way to tell you which snapshot you are using. The only way to get this installed is look at each step and merge the changes with your existing code. It can be done...I've installed it on several MS1 stores successfully.

Bobby

GLS · February 8, 2005

You need to run the install-cache.php file as per the instructions (STEP #2).

If you have installed the code in application_top.php already then comment them out so you can run the installer. Once you run the install script then go back to application_top.php and uncomment the code.

Thanks again...I thought that was going to be the last question... I'm too close to give up now :lol:

Seems like I've missed a table name somewhere:

1146 - Table 'myDB.products' doesn't exist

select p.products_id, pd.products_name from products p left join products_description pd on p.products_id=pd.products_id and pd.language_id='1' where p.products_status='1'

[TEP STOP]

February 8, 2005

That is a core table...you need to restore your database backup and try again.

Bobby

GLS · February 8, 2005

That is a core table...you need to restore your database backup and try again.

Bobby

<{POST_SNAPBACK}>

Bobby,

On my version of osC, every table name has the prefix "oscommerce_". I had to change some of install-seo.php to get round that. Is it possible that this is happening again? If I restore application_top.php, the site works again, is there something I could have missed in there?

Cheers,

[Contribution] Ultimate SEO URLs - by Chemo

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation