Jump to content
Jack_mcs

Google XML Sitemap SEO

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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

Opening   /sitemapproducts.xml
FS_CAT    /home/waybent1/public_html/houseofaberrant.com/
Server    http://www.houseofaberrant.com
Save Path /
WS_CAT    / 


[b]Warning[/b]:  fopen(/sitemapproducts.xml) [[url="http://www.houseofaberrant.com/googlesitemap/function.fopen"]function.fopen[/url]]: failed to open stream: Permission denied in [b]/home/waybent1/public_html/houseofaberrant.com/googlesitemap/sitemap.class_Alternate.php[/b] on line [b]353[/b]

ERROR: Google Product Sitemap Generation FAILED!

Opening   /sitemapcategories.xml
FS_CAT    /home/waybent1/public_html/houseofaberrant.com/
Server    http://www.houseofaberrant.com
Save Path /
WS_CAT    / 


[b]Warning[/b]:  fopen(/sitemapcategories.xml) [[url="http://www.houseofaberrant.com/googlesitemap/function.fopen"]function.fopen[/url]]: failed to open stream: Permission denied in [b]/home/waybent1/public_html/houseofaberrant.com/googlesitemap/sitemap.class_Alternate.php[/b] on line [b]353[/b]

ERROR: Google Category Sitemap Generation FAILED!

Opening   /sitemapmanufacturers.xml
FS_CAT    /home/waybent1/public_html/houseofaberrant.com/
Server    http://www.houseofaberrant.com
Save Path /
WS_CAT    / 


[b]Warning[/b]:  fopen(/sitemapmanufacturers.xml) [[url="http://www.houseofaberrant.com/googlesitemap/function.fopen"]function.fopen[/url]]: failed to open stream: Permission denied in [b]/home/waybent1/public_html/houseofaberrant.com/googlesitemap/sitemap.class_Alternate.php[/b] on line [b]353[/b]

ERROR: Google Manufacturers Sitemap Generation FAILED!

Opening   /sitemapspecials.xml
FS_CAT    /home/waybent1/public_html/houseofaberrant.com/
Server    http://www.houseofaberrant.com
Save Path /
WS_CAT    / 


[b]Warning[/b]:  fopen(/sitemapspecials.xml) [[url="http://www.houseofaberrant.com/googlesitemap/function.fopen"]function.fopen[/url]]: failed to open stream: Permission denied in [b]/home/waybent1/public_html/houseofaberrant.com/googlesitemap/sitemap.class_Alternate.php[/b] on line [b]353[/b]

ERROR: Google Specials Sitemap Generation FAILED!

ERROR: Google Pages Sitemap Generation FAILED!

Opening   /sitemapindex.xml
FS_CAT    /home/waybent1/public_html/houseofaberrant.com/
Server    http://www.houseofaberrant.com
Save Path /
WS_CAT    / 


[b]Warning[/b]:  fopen(/sitemapindex.xml) [[url="http://www.houseofaberrant.com/googlesitemap/function.fopen"]function.fopen[/url]]: failed to open stream: Permission denied in [b]/home/waybent1/public_html/houseofaberrant.com/googlesitemap/sitemap.class_Alternate.php[/b] on line [b]353[/b]

ERROR: Google Sitemap Index Generation FAILED!

Array
(
   [QUERY] => Array
       (
           [PRODUCTS] => Array
               (
                   [sTATUS] => success
                   [NUM_ROWS] => 60
               )

           [CATEOGRY] => Array
               (
                   [sTATUS] => success
                   [NUM_ROWS] => 22
               )

           [MANUFACTURERS] => Array
               (
                   [sTATUS] => success
                   [NUM_ROWS] => 27
               )

           [sPECIALS] => Array
               (
                   [sTATUS] => success
                   [NUM_ROWS] => 9
               )

       )

   [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
               )

       )

)

 

The 5 sitemap ... files are set to 777

Edited by epwork

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 by george_png

Share this post


Link to post
Share on other sites

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 whistling.gif)

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 !

Share this post


Link to post
Share on other sites

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://forums.oscommerce.com/index.php?showtopic=193738&hl=

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×