1179 replies to this topic

[Adamanto75]

Hello everyone,

Thank you so much for this contribution I really appreciate it,

But after I installed it I tried to run it and it wouldn't run I changed all the setting the instructions talk about but I get this.


ERROR: Google Product Sitemap Generation FAILED!

ERROR: Google Category Sitemap Generation FAILED!

Opening /sitemapmanufacturers.xml
FS_CAT /hermes/web08/b2492/moo.oursacredgardencom/oursacredgarden.com/
Server http://oursacredgarden.com
Save Path /
WS_CAT /


Warning: fopen(/sitemapmanufacturers.xml) [function.fopen]: failed to open stream: Permission denied in /hermes/web08/b2492/moo.oursacredgardencom/oursacredgarden.com/googlesitemap/sitemap.class_Alternate.php on line 353

ERROR: Google Manufacturers Sitemap Generation FAILED!

Google Sitemap Specials not generated - no specials found!

ERROR: Google Pages Sitemap Generation FAILED!

Opening /sitemapindex.xml
FS_CAT /hermes/web08/b2492/moo.oursacredgardencom/oursacredgarden.com/
Server http://oursacredgarden.com
Save Path /
WS_CAT /


Warning: fopen(/sitemapindex.xml) [function.fopen]: failed to open stream: Permission denied in /hermes/web08/b2492/moo.oursacredgardencom/oursacredgarden.com/googlesitemap/sitemap.class_Alternate.php on line 353

ERROR: Google Sitemap Index Generation FAILED!

Array
(
[QUERY] => Array
(
[PRODUCTS] => Array
(
[STATUS] => success
[NUM_ROWS] => 0
)

[CATEOGRY] => Array
(
[STATUS] => success
[NUM_ROWS] => 0
)

[MANUFACTURERS] => Array
(
[STATUS] => success
[NUM_ROWS] => 10
)

[SPECIALS] => Array
(
[STATUS] => success
[NUM_ROWS] => 0
)

)

[SAVE_FILE_XML] => Array
(
[0] => Array
(
[file] => /sitemapmanufacturers.xml
[status] => failure
[file_exists] => false
)

[1] => Array
(
[file] => /sitemapindex.xml
[status] => failure
[file_exists] => false
)

)

)

I have the file permissions set to 755 (same as my images) but it's telling me it doesn't have permission... I'm confused any help would be so great...

Thank You

Adamanto75

[Jack_mcs]

Adamanto75, on 29 January 2012, 05:04, said:

Hello everyone,

Thank you so much for this contribution I really appreciate it,

But after I installed it I tried to run it and it wouldn't run I changed all the setting the instructions talk about but I get this.


ERROR: Google Product Sitemap Generation FAILED!

ERROR: Google Category Sitemap Generation FAILED!

Opening /sitemapmanufacturers.xml
FS_CAT /hermes/web08/b2492/moo.oursacredgardencom/oursacredgarden.com/
Server http://oursacredgarden.com
Save Path /
WS_CAT /
I have the file permissions set to 755 (same as my images) but it's telling me it doesn't have permission... I'm confused any help would be so great...

Please see the many, many posts on this problem in this thread.

[linux4ever]

Thank you. Very good job.

Edited by linux4ever, 06 February 2012, 11:19.

[linux4ever]

Hello, My server have SAFE MODE On, Is necessary put in Off?

Warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 1778 is not allowed to access / owned by uid 0 in /home4/todopiel/public_html/googlesitemap/sitemap.class_Alternate.php on line 353

[Jack_mcs]

linux4ever, on 06 February 2012, 12:02, said:

Hello, My server have SAFE MODE On, Is necessary put in Off?

Warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 1778 is not allowed to access / owned by uid 0 in /home4/todopiel/public_html/googlesitemap/sitemap.class_Alternate.php on line 353

Possibly not. It depends on how your host has the server setup. You will need to adk your host to turn it off or change the settings so the code will have permissions.

[linux4ever]

Thanks for your quick response.
I've solved the problem. I had the same problem as many people commented in this thread.

Warning: fopen(/sitemapindex.xml) [function.fopen]: failed to open stream: Permission denied

I fixed it changing line 139 in index.php :

$mapfile = ((GOOGLE_XML_SITEMAP_SEO != 'Standard') ? 'sitemap_Alternate.class.php' : 'sitemap.class.php');

for this other:

$mapfile = ((GOOGLE_XML_SITEMAP_SEO != 'Standard') ? 'sitemap.class.php' : 'sitemap.class_Alternate.php');

Now generates sitemaps perfectly. I do not know if it is correct but it works.

I have yet to solve that not shows admin-> Configuration-> XML Google SEO.

Sorry for my English.

[NodsDorf]

Hi Jack

Is there a way for the sitemap to be generated using FWRMedia Ultimate SEO URL's instead of the strict Oscommerce path?

Google may find it odd to keep submitting URL's that all get 301 redirected.

Thanks,
Don

[Jack_mcs]

NodsDorf, on 09 February 2012, 20:12, said:

Hi Jack

Is there a way for the sitemap to be generated using FWRMedia Ultimate SEO URL's instead of the strict Oscommerce path?

Google may find it odd to keep submitting URL's that all get 301 redirected.

I'm sure it is possible but I don't use that contribution so I don't know what to change. Maybe someone in its support thread has already done it.

[NodsDorf]

Jack_mcs, on 09 February 2012, 23:40, said:

I'm sure it is possible but I don't use that contribution so I don't know what to change. Maybe someone in its support thread has already done it.

Didn't realize you both had different versions of the original from Chemo. Either way, I rolled back his, installed yours and everything is perfect.

Thanks, yet again.

Don

[Jack_mcs]

NodsDorf, on 10 February 2012, 19:48, said:

Didn't realize you both had different versions of the original from Chemo. Either way, I rolled back his, installed yours and everything is perfect.

Thanks, yet again.

Don

You're welcome. There not the same. The one I support is Chemo's original with many bug fixes/code changes. His, usually called SEO 5, is a complete rewrite.

[discxpress]

Hi Jack,
The latest version worked fine until I added a couple hundred thousand products . I guess my problem comes when the script has to generate multiple sitemapproducts.xml files. The below snippet is from the referenced file, sitemap.class.php:

         if (GOOGLE_XML_SITEMAP_SHOW_DIAGNOSTIC == 'true')
           echo 'Opening   '.$filename. '<br>FS_CAT    '.DIR_FS_CATALOG. '<br>Server    ' . HTTP_SERVER . '<br>Save Path '. $this->savepath . '<br>WS_CAT    '. DIR_WS_HTTP_CATALOG.' <br>';
if ($fp = fopen($filename, 'w+')){
    echo 'Write '.$filename.'<br>';
fwrite($fp, $data);
fclose($fp);
$this->debug['SAVE_FILE_XML'][] = array('file' => $filename, 'status' => 'success', 'file_exists' => 'true');
return true;
} else {
$file_check = file_exists($filename) ? 'true' : 'false';
$this->debug['SAVE_FILE_XML'][] = array('file' => $filename, 'status' => 'failure', 'file_exists' => $file_check);
return false;
}
break;

Below is a sample of the output in the error log:

PHP Warning:  fopen(/var/www/html/sitemapproducts1.xml) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied in /var/www/html/googlesitemap/sitemap.class.php on line 344
File does not exist: /var/www/html/sitemapindex.html
PHP Warning:  fopen(/var/www/html/sitemapproducts2.xml) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied in /var/www/html/googlesitemap/sitemap.class.php on line 344
PHP Warning:  fopen(/var/www/html/sitemapproducts3.xml) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied in /var/www/html/googlesitemap/sitemap.class.php on line 344
PHP Warning:  fopen(/var/www/html/sitemapproducts4.xml) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied in /var/www/html/googlesitemap/sitemap.class.php on line 344

I've tried adjusting the resources in the php.ini file because I was getting 'exhaustion' errors but the above errors persist even on the alternate state. I searched this thread but don't really understand the solutions others had.

Thanks for your help.

[Jack_mcs]

discxpress, on 14 February 2012, 07:44, said:

Hi Jack,
The latest version worked fine until I added a couple hundred thousand products . I guess my problem comes when the script has to generate multiple sitemapproducts.xml files. The below snippet is from the referenced file, sitemap.class.php: I've tried adjusting the resources in the php.ini file because I was getting 'exhaustion' errors but the above errors persist even on the alternate state. I searched this thread but don't really understand the solutions others had.

If the file gets too large, it will create a new sitemap file. The error you are getting is a permissions error so maybe you didn't set the permissions correctly or your host is preventing the creation of a new file.

[discxpress]

Jack,

Thanks for your reply. I checked the permissions of all sitemap files and they're set to 777, the same as the images folder. You mentioned my host. The last time my site was that size, I was kicked off because it was consuming too many resources.

Now I'm on a dedicated server. When I was on a shared server, the sitemaps generated with no problem. So maybe it's how the server is setup. What can I check on my server that would cause this problem?

Thanks for your time.

[discxpress]

Jack,

Help me understand this. While I was trying resolve an issue with Google XML Sitemap SEO, my server's host had began migrating my server to a new company. Now my site won't load. They blamed it on a script being called twice and blocking two ports. Also, they say it's something to do with httpd. Here's what the tech said in a support ticket:

Quote

The migration effected did not involved changing anything on the networks or the servers.
The reason why httpd was not serving content is because it had stopped, further research on the matter showed that there were two httpd services that were using ports 80 and 443.
It appears that a cronjob or script called the first httpd session with some additional command line switches which at the end called another httpd session, since both were blocking/using ports 80 and 443 the httpd process that were supposed to be serving the content could not start, after stopping the first two processes, the "legit" httpd process were able to start.


Please check wether you have scripts starting from rc.local, crontabs, etc that involve, one way or another the usage of httpd processes.

Since this contrib and Configuration Cache was the last scripts I attempted to run (if it's a script), I decided to start here so I can began to see if they're trying to avoid blame.

Thanks for reading.

Edited by discxpress, 16 February 2012, 23:44.

[Jack_mcs]

discxpress, on 16 February 2012, 23:42, said:

Jack,

Help me understand this. While I was trying resolve an issue with Google XML Sitemap SEO, my server's host had began migrating my server to a new company. Now my site won't load. They blamed it on a script being called twice and blocking two ports. Also, they say it's something to do with httpd. Here's what the tech said in a support ticket:

Since this contrib and Configuration Cache was the last scripts I attempted to run (if it's a script), I decided to start here so I can began to see if they're trying to avoid blame.

Thanks for reading.

No, it's not due to this contribution. You can delete the cron job though to prove it. Or, I suppose, the cron job could be setup incorrectly, in which case deleting it would remove the problem.

[Roaddoctor]

Jack,

I've just switched from 1.3 to 1.5. All files generated fine. I have one notice when executing, at the top of /googlesitemap/index.php

Notice: Constant MODULE_PAYMENT_PAYPAL_DP_NEW_ACCT_NOTIFY already defined in .../googlesitemap/index.php on line 58

my Line 58: define($configuration['cfgKey'], $configuration['cfgValue']);

I have no clue what to check, and I relaize its probably not directly related to this module. A google search of the generic error yields 0 results. Your direction or input is appreciated.

[Roaddoctor]

I'm noticing:

1. sitemapcategories.xml has each category listed twice. Not sure why

2. It seems because I have SPPC and Price break for SPPC installed, sitemapspecials.xml is listing each product special 7 times (once for each customer type I assume). Is their a way to limit that to just the public "retail" designation....


Thaks again

[Jack_mcs]

Roaddoctor, on 25 February 2012, 18:11, said:

Jack,

I've just switched from 1.3 to 1.5. All files generated fine. I have one notice when executing, at the top of /googlesitemap/index.php

Notice: Constant MODULE_PAYMENT_PAYPAL_DP_NEW_ACCT_NOTIFY already defined in .../googlesitemap/index.php on line 58

my Line 58: define($configuration['cfgKey'], $configuration['cfgValue']);

I have no clue what to check, and I relaize its probably not directly related to this module. A google search of the generic error yields 0 results. Your direction or input is appreciated.

It is just a warning due to the level you have error reporting set to and isn't anything to worry abut.

[Jack_mcs]

Roaddoctor, on 25 February 2012, 18:38, said:

I'm noticing:

1. sitemapcategories.xml has each category listed twice. Not sure why

2. It seems because I have SPPC and Price break for SPPC installed, sitemapspecials.xml is listing each product special 7 times (once for each customer type I assume). Is their a way to limit that to just the public "retail" designation....

The code would have to be edited to ignore the various groups other than the main one but that isn't something that would be covered in a support thread like this.

[Roaddoctor]

Jack_mcs, on 26 February 2012, 00:58, said:

The code would have to be edited to ignore the various groups other than the main one but that isn't something that would be covered in a support thread like this.

Jack, I've tried to sort this myself. Can you tell me if this is correct:

To fix duplicate categories in sitemapcategories.xml, on multi language shop
In /googlesitemap/sitemap.class.php

* Funciton to generate category sitemap data
* @[member='author'] Bobby Easland
* @version 1.1
* @[member='Return'] boolean
*/
function GenerateCategorySitemap($languages_id) {
		$quotes = (defined('QUOTES_CATEGORY_NAME') ? " where cd.categories_name NOT LIKE '" . QUOTES_CATEGORY_NAME . "' " : '');
  $sql = "SELECT c.categories_id as cID, c.date_added, c.last_modified as last_mod
	   FROM " . TABLE_CATEGORIES . " c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.categories_id = cd.categories_id
				and cd.language_id = '" . (int)$languages_id . "'
		  " . $quotes . "
	ORDER BY c.parent_id ASC, c.sort_order ASC, c.categories_id ASC";

and in /googlesitemap/index.php, changle line 157

- 	 if ($google->GenerateCategorySitemap()){
+	 if ($google->GenerateCategorySitemap($languages_id)){

That seems to have done it. Is there a better / more correct way?


Next, I will try to resolve the SPPC bug for specials

Edited by Roaddoctor, 26 February 2012, 04:31.