Google XML Sitemap SEO

vashichino7 · September 8, 2011

Hello Jack,

Here is the error I get now.... :

Warning: fopen(/sitemapproducts.xml) [function.fopen]: failed to open stream: Permission denied in /home/savingsh/public_html/googlesitemap/sitemap.class_Alternate.php on line 353

ERROR: Google Product Sitemap Generation FAILED!

Warning: fopen(/sitemapcategories.xml) [function.fopen]: failed to open stream: Permission denied in /home/savingsh/public_html/googlesitemap/sitemap.class_Alternate.php on line 353

ERROR: Google Category Sitemap Generation FAILED!

Warning: fopen(/sitemapindex.xml) [function.fopen]: failed to open stream: Permission denied in /home/savingsh/public_html/googlesitemap/sitemap.class_Alternate.php on line 353

ERROR: Google Sitemap Index Generation FAILED!

Array

(

[QUERY] => Array

(

[PRODUCTS] => Array

(

[sTATUS] => success

[NUM_ROWS] => 108

)

[CATEOGRY] => Array

(

[sTATUS] => success

[NUM_ROWS] => 41

)

[sAVE_FILE_XML] => Array

(

[0] => Array

(

[file] => /sitemapproducts.xml

[status] => failure

[file_exists] => false

)

[1] => Array

(

[file] => /sitemapcategories.xml

[status] => failure

[file_exists] => false

)

[2] => Array

(

[file] => /sitemapindex.xml

[status] => failure

[file_exists] => false

)

Any clue? I saw the previous posts regarding this but I couldnt figure out which one exactly it is... Thank you

vashichino7 · September 8, 2011

Jack error is fixed and fully installed! Thank you for the earlier posts!

Jack_mcs · September 8, 2011

Jack error is fixed and fully installed! Thank you for the earlier posts!

You're welcome. If you post the fix it may help others with the same problem.

vashichino7 · September 9, 2011

Well i followed an earlier try at the fix which was this:

Hi,

I had the same problem as Benjjj6

What I did was enter the code from your post 7

and change the lines from 263-266 to this:

$this->savepath .= (substr($this->savepath, 0, -1) !== '') ? '' : ''; //append a slash if needed

}

else

$this->savepath = DIR_FS_CATALOG . (substr(DIR_FS_CATALOG, 0, -1) !== '') ? '' : '';

It now works, great contribution

Hope that helps!

Tiff13 · September 18, 2011

My shop is 2.3 and I get this error on googlesitemap/index.php after install when set to standard:

1054 - Unknown column 'c.categories_status' in 'where clause'[/size]

SELECT p.products_id as pID, p.products_date_added as date_added, p.products_last_modified as last_mod, p.products_ordered
   FROM products p, categories c, products_to_categories p2c where c.categories_status='1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p.products_status='1'
ORDER BY products_ordered DESC[/size]

[TEP STOP][/size]

Or this when set to Alternative

The 5 sitemap ... files are set to 777

Edited September 18, 2011 by epwork

Jack_mcs · September 19, 2011

My shop is 2.3 and I get this error on googlesitemap/index.php after install when set to standard:

The 5 sitemap ... files are set to 777

For the first problem, that field isn't part of this contribution so you've made a mistake somewhere. For the second problem, the paths are incorrect so it would seem that there is something wrong with your configure file. See the link to the thread that explains how to setup a configure file elsewhere in this thread.

Tiff13 · September 19, 2011

For the first problem, that field isn't part of this contribution so you've made a mistake somewhere. For the second problem, the paths are incorrect so it would seem that there is something wrong with your configure file. See the link to the thread that explains how to setup a configure file elsewhere in this thread.

Thanks Jack, I double-checked and my configure.php file was perfectly fine. I did go to this suggestion #1046 which made a change to the sitemap.class_Alternate.php file. That seemed to do the trick. Only 1 error now: "Google Pages Sitemap Generation FAILED! "

I'm guessing the Pages Sitemap is all the other pages other than products in a shop, at least all other sitemaps successfully generated for now.

qxonn · September 26, 2011

I just discovered this issue and I am not aware if anyone else has had this problem. If so, I apologize. If not, here is a description of my issue below. I'd be grateful for any insight. We use Ultimate SEO URL's along with this Google Sitemap contribution.

Our googlesitemap output URLs are wrong. The URLs themselves DO work and resolve to a product page, but they aren't the same as if you manually navigated to the page.

Example:

googlesitemap output: 4hp46-p-30486.html

user navigation output: hp46-swivel-union-connector-swivel-p-23703.html

Both of these pages take you to the same product. I'm not sure which contribution would be causing this issue. Thanks for your time. I will go back and re-read and reinstall things and see if I can figure it out.

September 26, 2011

For the first problem, that field isn't part of this contribution so you've made a mistake somewhere.

Hmmm, interesting. I came up with the same error when going to mydomain/googlesitemaps/index.php. If it not part of this contrib, it sure is strange that this is the only time it has ever come up. Sure would like to know where it came from....

Marianne

Jack_mcs · September 27, 2011

I just discovered this issue and I am not aware if anyone else has had this problem. If so, I apologize. If not, here is a description of my issue below. I'd be grateful for any insight. We use Ultimate SEO URL's along with this Google Sitemap contribution.

Our googlesitemap output URLs are wrong. The URLs themselves DO work and resolve to a product page, but they aren't the same as if you manually navigated to the page.

Example:

googlesitemap output: 4hp46-p-30486.html

user navigation output: hp46-swivel-union-connector-swivel-p-23703.html

Both of these pages take you to the same product. I'm not sure which contribution would be causing this issue. Thanks for your time. I will go back and re-read and reinstall things and see if I can figure it out.

Sounds like a problem with the url rewriter you are using. If you are using SEO 5, there is a version of this contribution that will work with it.

george_png · September 27, 2011

Hello !

I have instaled osCommerce v2.3.1 and googlesitemap from Jack but when

I try to open http://mydomain.com/...temap/index.php I have this error:

Opening /sitemapproducts.xml

FS_CAT /var/www/users/png/

Server http://mypc-bg.com

Save Path /

WS_CAT /

ERROR: Google Product Sitemap Generation FAILED!

Opening /sitemapcategories.xml

FS_CAT /var/www/users/png/

Server http://mypc-bg.com

Save Path /

WS_CAT /

ERROR: Google Category Sitemap Generation FAILED!

Opening /sitemapmanufacturers.xml

FS_CAT /var/www/users/png/

Server http://mypc-bg.com

Save Path /

WS_CAT /

ERROR: Google Manufacturers Sitemap Generation FAILED!

Opening /sitemapspecials.xml

FS_CAT /var/www/users/png/

Server http://mypc-bg.com

Save Path /

WS_CAT /

ERROR: Google Specials Sitemap Generation FAILED!

ERROR: Google Pages Sitemap Generation FAILED!

Opening /sitemapindex.xml

FS_CAT /var/www/users/png/

Server http://mypc-bg.com

Save Path /

WS_CAT /

ERROR: Google Sitemap Index Generation FAILED!

Array

(

[QUERY] => Array

(

[PRODUCTS] => Array

(

[sTATUS] => success

[NUM_ROWS] => 566

)

[CATEOGRY] => Array

(

[sTATUS] => success

[NUM_ROWS] => 38

)

[MANUFACTURERS] => Array

(

[sTATUS] => success

[NUM_ROWS] => 35

)

[sPECIALS] => Array

(

[sTATUS] => success

[NUM_ROWS] => 5

)

[sAVE_FILE_XML] => Array

(

[0] => Array

(

[file] => /sitemapproducts.xml

[status] => failure

[file_exists] => false

)

[1] => Array

(

[file] => /sitemapcategories.xml

[status] => failure

[file_exists] => false

)

[2] => Array

(

[file] => /sitemapmanufacturers.xml

[status] => failure

[file_exists] => false

)

[3] => Array

(

[file] => /sitemapspecials.xml

[status] => failure

[file_exists] => false

)

[4] => Array

(

[file] => /sitemapindex.xml

[status] => failure

[file_exists] => false

)

Jack...

Can You help me ?

What wrong ?

Thanks in advance!

Sorry for my bad english :-)

Edited September 27, 2011 by george_png

Jack_mcs · September 27, 2011

Hello !

I have instaled osCommerce v2.3.1 and googlesitemap from Jack but when

I try to open http://mydomain.com/...temap/index.php I have this error:

Jack...

Can You help me ?

What wrong ?

Thanks in advance!

Sorry for my bad english )

In the settings in admin for this contribution there is an option to switch to a different mode. Did you try that?

velvetpixel · September 28, 2011

ERROR: Google Pages Sitemap Generation FAILED!

All others are fine.

Any idea what I need to change to get the pages xml created?

Does this cover all non product customer facing pages like privacy policy, shipping etc?

Jack_mcs · September 28, 2011

ERROR: Google Pages Sitemap Generation FAILED!

All others are fine.

Any idea what I need to change to get the pages xml created?

Does this cover all non product customer facing pages like privacy policy, shipping etc?

If it works for all except the pages, then it would almost have to be the sitemappages.xml file, possibly its permissions. However, if you get that to work, be sure to check the file before adding it to your sitemap account since it was adding duplicate pages for some sites. I haven't had time to look at this but if it is happening for you, you wouldn't want to use it. Its purpose is to list all pages not listed in the other files.

velvetpixel · September 28, 2011

Thanks Jack!

Permissions are all fine and the same for all xml files.

I might manually create the entries in the sitemappages.xml file if I can't get it to auto generate for now.

george_png · September 28, 2011

In the settings in admin for this contribution there is an option to switch to a different mode. Did you try that?

Hi!

Yes I did it.

I did this steps:

If the sitemaps fail to generate, then go to admin->Configuration->Google XML SEO

and switch to the alternate class and try again. If the maps still fail, enable

the diagnostic option in the settings and try again. If the error isn't obvious

at that point, post the problem, along with the diagnostic output in the support thread.

But I have error !

Jack_mcs · September 28, 2011

Hi!

Yes I did it.

I did this steps:

If the sitemaps fail to generate, then go to admin->Configuration->Google XML SEO

and switch to the alternate class and try again. If the maps still fail, enable

the diagnostic option in the settings and try again. If the error isn't obvious

at that point, post the problem, along with the diagnostic output in the support thread.

But I have error !

This question gets asked about every other page (looking through those would have saved you some time) and the answer is always the same - your configure file is not setup correctly. See this thread for how to set it up: http://www.oscommerce.com/forums/index.php?showtopic=193738&hl=

velvetpixel · September 28, 2011

If it works for all except the pages, then it would almost have to be the sitemappages.xml file, possibly its permissions. However, if you get that to work, be sure to check the file before adding it to your sitemap account since it was adding duplicate pages for some sites. I haven't had time to look at this but if it is happening for you, you wouldn't want to use it. Its purpose is to list all pages not listed in the other files.

In moving from my testing subdomain to my actual domain and rerunning I was successful with the pages part but rather than it containing pointers to all my site pages it just has one to the sitemap.php page:

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="gss.xsl"?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
<url>
 <loc>http://www.example.com/sitemap.php</loc>
 <lastmod>2011-09-28</lastmod>
 <changefreq>weekly</changefreq>
 <priority>.1</priority>
</url>
</urlset>

Is that expected or should it have different entries for all my pages?

Jack_mcs · September 28, 2011

In moving from my testing subdomain to my actual domain and rerunning I was successful with the pages part but rather than it containing pointers to all my site pages it just has one to the sitemap.php page:

Is that expected or should it have different entries for all my pages?

It should list the sitemap page but all of the others as well.

velvetpixel · September 28, 2011

It should list the sitemap page but all of the others as well.

Thanks Jack,

Looks like I have some manual things to add today :)

george_png · September 29, 2011

This question gets asked about every other page (looking through those would have saved you some time) and the answer is always the same - your configure file is not setup correctly. See this thread for how to set it up: http://forums.oscomm...opic=193738&hl=

Hello Jack !

..again

I saw my configure.php file in /catalog/includes/configure.php

Everything looks fine, like post that you showed me.

Do you have other suggestions on this problem?

Thanks!

Jack_mcs · September 29, 2011

Hello Jack !

..again

I saw my configure.php file in /catalog/includes/configure.php

Everything looks fine, like post that you showed me.

Do you have other suggestions on this problem?

Thanks!

The output shows the configure file is not right. I don't have any suggestions other than that.

george_png · September 29, 2011

The output shows the configure file is not right. I don't have any suggestions other than that.

Hello !

This is my configure file. If you see any error please say me

<?php

define('HTTP_SERVER', 'http://www.mypc-bg.com');

define('HTTPS_SERVER', 'https://www.mypc-bg.com');

define('ENABLE_SSL', false);

define('HTTP_COOKIE_DOMAIN', 'www.mypc-bg.com');

define('HTTPS_COOKIE_DOMAIN', 'www.mypc-bg.com');

define('HTTP_COOKIE_PATH', '/');

define('HTTPS_COOKIE_PATH', '/');

define('DIR_WS_HTTP_CATALOG', '/');

define('DIR_WS_HTTPS_CATALOG', '/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', '/htdocs/mypc-bg/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

define('DB_SERVER', '127.0.0.1');

define('DB_SERVER_USERNAME', 'petko');

define('DB_SERVER_PASSWORD', 'alabala');

define('DB_DATABASE', 'kalinka');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

?>

Sorry ! I am new in osCommerce and my questions some times may seem a bit stupid.

Thanks!

velvetpixel · October 2, 2011

I am running into an issue with the product urls generated in the google sitemap xml files.

It google webmaster tools I am seeing this error:

URLs not followed

When we tested a sample of URLs from your Sitemap, we found that some URLs redirect to other locations. We recommend that your Sitemap contain URLs that point to the final destination (the redirect target) instead of redirecting to another URL.

I am using Ultimate SEO URLs is that what is causing the issue?

The url in the sitemap is:

http://example.com/product_info.php?products_id=34995

Which is then take to the product at:

http://example.com/fashion-necklaces-green-brown-and-silver-sea-shell-pearl-necklace-p-34995.html

How do I keep my good URLs and have those URLS in google sitemaps xml?

CosmeaNailArt · October 2, 2011

Hello,

Great contrib, Jack!

But i'm having a small problem with the cronjob. This is the cron job:

 
/usr/local/bin/php -q -f /home/****/domains/cosmeanailart.nl/private_html/googlesitemap/index.php

The e-mail i receive from my hosting shows me an error:

Warning: require_once(includes/configure.php): failed to open stream: No such file or directory in /home/***/domains/cosmeanailart.nl/public_html/googlesitemap/index.php on line 47
Fatal error: require_once(): Failed opening required 'includes/configure.php' (include_path='.:/usr/local/lib/php') in /home/***/domains/cosmeanailart.nl/public_html/googlesitemap/index.php on line 47

What do I need to change to get the conjob work?

If you need additional information, please let me know.

Tjappie W

Google XML Sitemap SEO

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Jack_mcs

Jack_mcs

Jack_mcs

Posted Images

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

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

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

Join the conversation