Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Google XML Sitemap SEO


Jack_mcs

Recommended Posts

Perfect, thanks :)

 

Regarding the articles themselves. Are they not generated then?

No, this contribution doesn't produce any articles. It should create links to them if you have Articles Manager installed correctly and the sitemappages option enabled though.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Ah, well they seem to be installed correctly but the articles themselves are not being generated in sitemappages. Sitemap pages is generating;

 

article-submit.php

article-topics.php

article_info.php

article_reviews_info.php

article_reviews_write.php

articles.php

articles_new.php

articles.php?tPath=2

articles.php?tPath=3

articles.php?tPath=4

 

But no articles themselves.......

Link to comment
Share on other sites

A new version has been uploaded with these changes:

 

- Fixed code for Articles Manager so the articles display correctly

- Fixed code so that pages links return SEO type urls if that option is enabled

- Add function for Ultimate SEO code that is not included

- Corrected mistake in the sitemap class file that prevent the xml from being form properly as found by Simon Powers on the forums.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Here is a bit of sql that may help folks in the future who do the same bonehead move I did.

 

In my case, I noticed that my sitemaps were not being created after the initial installation went thru.

After looking at the recent postings on the thread I thought I would look to see how the sitemaps were running.

 

When I noticed they werent, and tried a manual build thru the address bar index.php url.

It failed.

 

Checked the file permissions, switched them a tad from the 644 they were set at, to 755

Still failed.

 

I noticed the output was set for using the alternate file.

So I went to admin>config, but there was no Google XML SEO.

hmmm.

 

So I looked to the sql, since that is how the Google XML SEO command is applied.

 

OK, grab the sql, and apply it, right?

One should check to see if values are already applied before running sql statements.

 

Now I had a menu command for Google XML SEO, but 2 of all the options too.

Oooops.

 

Here is the undo sql statements in case you pull this bonehead move too.

DELETE FROM configuration WHERE configuration_title='Sitemap file' AND configuration_key='GOOGLE_XML_SITEMAP_SEO' AND configuration_value='Standard' AND configuration_description='Which file to use for the sitemap creation. Use Standard unless it doesn\'t work correctly.<br>(Standard=on Alternate=off)' AND configuration_group_id='289' AND sort_order='1' AND set_function='tep_cfg_select_option(array(\'Standard\', \'Alternate\'), ';


DELETE FROM configuration WHERE configuration_title='Enable Manufacturers Map' AND configuration_key='GOOGLE_XML_SITEMAP_CREATE_MANU' AND configuration_value='false' AND configuration_description='Set to true if you would like a site map created for your manufactureres.<br>(true=on false=off)' AND configuration_group_id='289' AND sort_order='5' AND set_function='tep_cfg_select_option(array(\'true\', \'false\'), ';


DELETE FROM configuration WHERE configuration_title='Enable Specials Map' AND configuration_key='GOOGLE_XML_SITEMAP_CREATE_SPECIALS' AND configuration_value='false' AND configuration_description='Set to true if you would like a site map created for your specials.<br>(true=on false=off)' AND configuration_group_id='289' AND sort_order='7' AND set_function='tep_cfg_select_option(array(\'true\', \'false\'), ';


DELETE FROM configuration WHERE configuration_title='Enable Standard Pages Map' AND configuration_key='GOOGLE_XML_SITEMAP_CREATE_PAGES' AND configuration_value='false' AND configuration_description='Set to true if you would like a site map created for your standard pages.<br>(true=on false=off)' AND configuration_group_id='289' AND sort_order='10' AND set_function='tep_cfg_select_option(array(\'true\', \'false\'), ';


DELETE FROM configuration WHERE configuration_title='Enable Diagnostic Output' AND configuration_key='GOOGLE_XML_SITEMAP_SHOW_DIAGNOSTIC' AND configuration_value='false' AND configuration_description='Set to true if you would like debug information displayed. This is useful if the site maps are not being created correctly.<br>(true=on false=off)' AND configuration_group_id='289' AND sort_order='15' AND set_function='tep_cfg_select_option(array(\'true\', \'false\'), ';


DELETE FROM configuration WHERE configuration_title='Exclude these pages' AND configuration_key='GOOGLE_XML_SITEMAP_EXCLUDE_PAGES' AND configuration_description='Add these pages to the built-in file exclude list. This will prevent the links from being added to the pages site map.' AND configuration_group_id='289' AND sort_order='20';

 

Jack, feel free to add this to your package, I have noticed you have been putting similar in your other contribs.

 

 

Corey

 

or you could just run:

 

delete from configuration where configuration_group_id = '289';

 

delete from configuration_group where configuration_group_id = '289';

 

and then rerun the SQL from the package.

 

I also found that the admin>config > Google XML SEO just "disapeared". Very odd. Rerunning the above fixed it quick smart.

 

Evan

Link to comment
Share on other sites

A new version has been uploaded with these changes:

 

- Fixed code for Articles Manager so the articles display correctly

- Fixed code so that pages links return SEO type urls if that option is enabled

- Add function for Ultimate SEO code that is not included

- Corrected mistake in the sitemap class file that prevent the xml from being form properly as found by Simon Powers on the forums.

 

Jack

 

Upgraded from 1.3 to 1.4 and......

 

That fixed my issue, thanks :)

 

Can confirm everything else still works a charm and URLS generated for articles and topics are SEO friendly. Bonza :D

Link to comment
Share on other sites

Hi all,

 

a bit of a confusing issue I hope the collective wisdom can solve.

 

Using the latest install, which was working smoothly, suddenly fails with:

 

- the deletion of the Google XML SEO link from admin->Config (and the row in the configuration_group table as well!)

- failure of generation bombing out with..... <b>Warning</b>: fopen(/sitemapproducts.xml) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied in <b>/home/xxxx/public_html/xxxxxxx/googlesitemap/sitemap.class_Alternate.php</b> on line <b>354</b><br />

ERROR: Google Product Sitemap Generation FAILED!

- all the others fail too, with the same error.

 

- all the xml files are set to 0777 for good measure

- diagnostics point to a permissions issue, but they have not changed, and are on max

 

What is REALLY odd is this was working for weeks then suddenly dies. I "fixed" it be re-installing everything from scratch, confirmed it worked by hand, ran a few crons to test and then left it thinking it was a glitch in the matrix..... now, it pops right back - exact same issue.

 

What freaks me out is that the row is deleted from configuration_group table.... I cant find any code that would be doing this, and the failure is seemly utterly random.

 

Thanks friends,

 

Ev

Link to comment
Share on other sites

I don't understand your question and you didn't post the results from running the diagnostic so it is difficult to answer. But if you are saying the admin options are going away, then that is most likely due do to the version of Ultimate SEO you have installed.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

My Store --> http://www.wholesalewheel.net/store/

 

Contributions Installed:

YMM 1.5 autoinstaller 2.14

http://addons.oscommerce.com/info/6684

 

Infobox Admin 2.25

http://addons.oscommerce.com/info/1175

 

Ultimate SEO URLs

http://addons.oscommerce.com/info/2823

 

osCommerce Google Analytics module V2.2 for E-commerce

http://addons.oscommerce.com/info/3756

 

GoogleBase V 2.3

http://addons.oscommerce.com/info/4513

 

Google XML Sitemap SEO V 1.4

http://addons.oscommerce.com/info/6583

 

Header Tags SEO V 3.1.7

http://addons.oscommerce.com/info/5851

 

I am having the same problem as described. The link in the "Configurations" menu has disappeared. In the configuration table I still have the following:

 

Enable Manufacturers Map GOOGLE_XML_SITEMAP_CREATE_MANU

Enable Specials Map GOOGLE_XML_SITEMAP_CREATE_SPECIALS

Enable Standard Pages Map GOOGLE_XML_SITEMAP_CREATE_PAGES

Enable Diagnostic Output GOOGLE_XML_SITEMAP_SHOW_DIAGNOSTIC

Exclude these pages GOOGLE_XML_SITEMAP_EXCLUDE_PAGES

 

For time time being it looks like you need to only rerun the followng SQL command to get it to appear again:

 

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible)

VALUES ('289', 'Google XML SEO', 'Google XML Sitemap SEO Options', '29', '1');

 

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)

VALUES (NULL,'Sitemap file', 'GOOGLE_XML_SITEMAP_SEO', 'Standard', 'Which file to use for the sitemap creation. Use Standard unless it doesn\'t work correctly.<br>(Standard=on Alternate=off)', '289', '1', 'tep_cfg_select_option(array(\'Standard\', \'Alternate\'), ', now(), NULL);

 

So now we need to figure out why those two database entries are being automatically deleted. Any ideas?

 

Thanks,

Blaine

Link to comment
Share on other sites

Also, here is the Diagnostic output:

 

Opening /home/xxxx/public_html/store/sitemapproducts.xml

FS_CAT /home/xxxx/public_html/store/

Server http://www.wholesalewheel.net

Save Path /home/xxxx/public_html/store/

WS_CAT /store/

Write /home/xxxx/public_html/store/sitemapproducts.xml

Generated Google Product Sitemap Successfully

 

Opening /home/xxxx/public_html/store/sitemapcategories.xml

FS_CAT /home/xxxx/public_html/store/

Server http://www.wholesalewheel.net

Save Path /home/xxxx/public_html/store/

WS_CAT /store/

Write /home/xxxx/public_html/store/sitemapcategories.xml

Generated Google Category Sitemap Successfully

 

Opening /home/xxxx/public_html/store/sitemapmanufacturers.xml

FS_CAT /home/xxxx/public_html/store/

Server http://www.wholesalewheel.net

Save Path /home/xxxx/public_html/store/

WS_CAT /store/

Write /home/xxxx/public_html/store/sitemapmanufacturers.xml

Generated Google Manufacturers Sitemap Successfully

 

Opening /home/xxxx/public_html/store/sitemappages.xml

FS_CAT /home/xxxx/public_html/store/

Server http://www.wholesalewheel.net

Save Path /home/xxxx/public_html/store/

WS_CAT /store/

Write /home/xxxx/public_html/store/sitemappages.xml

Generated Google Pages Sitemap Successfully

 

Opening /home/xxxx/public_html/store/sitemapindex.xml

FS_CAT /home/xxxx/public_html/store/

Server http://www.wholesalewheel.net

Save Path /home/xxxx/public_html/store/

WS_CAT /store/

Write /home/xxxx/public_html/store/sitemapindex.xml

Generated Google Sitemap Index Successfully

 

CONGRATULATIONS! All files generated successfully.

 

If you have not already submitted the sitemap index to Google click the link below.

Before you do I HIGHLY recommend that you view the XML files to make sure the data is correct.

 

http://www.google.com/webmasters/sitemaps/...itemapindex.xml

 

For your convenience here is the CRON command for your site:

php /home/xxxx/public_html/store/googlesitemap/index.php

 

Here is your sitemap index: http://www.wholesalewheel.net/store/sitemapindex.xml

Here is your product sitemap: http://www.wholesalewheel.net/store/sitemapproducts.xml

Here is your category sitemap: http://www.wholesalewheel.net/store/sitemapcategories.xml

Here is your manufacturers sitemap: http://www.wholesalewheel.net/store/sitemapmanufacturers.xml

Here is your pages sitemap: http://www.wholesalewheel.net/store/sitemappages.xml

 

 

 

I originally installed this contribution early yesterday and had to re-run the SQL once yesterday which made duplicate entries. I had to run it once today (after examining which part more carefully first to not create duplicates). Not sure how long it actually lasts before it gets booted out. I will try to check every few hours until I notice it gone.

 

Thanks,

Blaine

Link to comment
Share on other sites

I have Ultimate SEO v2.8. From looking it seems that this is the latest version released on July 27th. Is there a different version that I should be running?

There are different versions. That is one by another author and it has mistakes in the code. Try the latest version by me and the problem will be fixed.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

I just installed the Google XML Sitemap SEO, but I get a warning when I create the sitemapindex and the sitemapindex file is emty..

 

File permissions are 755 for all sitemap files.

 

This is what i get:

 

Write /mnt/web2/13/22/5625022/htdocs/sitemapproducts.xmlGenerated Google Product Sitemap Successfully

 

Write /mnt/web2/13/22/5625022/htdocs/sitemapcategories.xmlGenerated Google Category Sitemap Successfully

 

Write /mnt/web2/13/22/5625022/htdocs/sitemapmanufacturers.xmlGenerated Google Manufacturers Sitemap Successfully

 

Write /mnt/web2/13/22/5625022/htdocs/sitemapspecials.xmlGenerated Google Specials Sitemap Successfully

 

Write /mnt/web2/13/22/5625022/htdocs/sitemappages.xmlGenerated Google Pages Sitemap Successfully

 

 

Warning: glob() expects parameter 2 to be long, string given in /mnt/web2/13/22/5625022/htdocs/googlesitemap/sitemap.class.php on line 429

 

Warning: Invalid argument supplied for foreach() in /mnt/web2/13/22/5625022/htdocs/googlesitemap/sitemap.class.php on line 429

Write /mnt/web2/13/22/5625022/htdocs/sitemapindex.xmlGenerated Google Sitemap Index Successfully

 

CONGRATULATIONS! All files generated successfully.

 

Does anybody have an idea what the problem could be??

 

 

Thanks

Soren

Link to comment
Share on other sites

I just installed the Google XML Sitemap SEO, but I get a warning when I create the sitemapindex and the sitemapindex file is emty..

 

Warning: glob() expects parameter 2 to be long, string given in /mnt/web2/13/22/5625022/htdocs/googlesitemap/sitemap.class.php on line 429

The above error is happening because the standard flag, GLOB_BRACE, isn't available on your server. You will need to talk to your host about that.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

The above error is happening because the standard flag, GLOB_BRACE, isn't available on your server. You will need to talk to your host about that.

 

Jack

 

Thank you Jack.

 

It seems that this GLOB_BRACE is a constant? Maybe I could just use the value of GLOB_BRACE in sitemap_class.php?

 

Or is the GLOB_BRACE, a flag I can set in my php.ini?

 

Regards

Soren

Link to comment
Share on other sites

The above error is happening because the standard flag, GLOB_BRACE, isn't available on your server. You will need to talk to your host about that.

 

Jack

 

Hi Jack and others

 

I solved the problem by replacing this line:

 

foreach ( glob($this->savepath . $pattern, GLOB_BRACE) as $filename ) {

 

with this:

 

foreach (array_merge(glob($this->savepath . $pattern),glob("*.xml")) as $filename ) {

 

works perfectly..

 

Regards

Soren

Link to comment
Share on other sites

The catalog directory is equivalent to the root of your shop so if public_html is the root, the contents of the catalog directory gets uploaded into the public_html directory, not the catalog directory itself.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

The catalog directory is equivalent to the root of your shop so if public_html is the root, the contents of the catalog directory gets uploaded into the public_html directory, not the catalog directory itself.

 

Jack

 

Ahhh, that could be the issue! so all the contents of the folder goes into the public_html and it should all work. Ive set the permissions to 644 same as the images is this correct?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...