Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Google XML Sitemap SEO


Jack_mcs

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

Link to comment
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.

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

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!

Link to comment
Share on other sites

  • 2 weeks later...

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
Link to comment
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.

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

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.

Link to comment
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.

Link to comment
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

Link to comment
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.

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

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
Link to comment
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?

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

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?

Link to comment
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.

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

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.

Link to comment
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 !

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

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

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?

Link to comment
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.

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

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

Link to comment
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!

Link to comment
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.

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 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!

Link to comment
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?

Link to comment
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

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...