[module] Google sitemap.xml Generator

[viulian]

Hi Guys!

It's been a long time since I haven't really updated this module - seems it went ok for most of you out there

I will try to investigate the errors that appeared [please let me know what php versions you are using when submitting error reports]. Little things change in php from version to version and I usually work with the latest one - which might issue small problems here and there which have to be manually tweaked.

[SaschaN]

Google changed some links ...

HTTP/1.0 301 Moved Permanently Location: /webmasters/tools/ping?sitemap=http%3A%2F%2Fwww.SECRET:).de%2Fsitemap.xml Cache-control: private Content-Length: 262 Date: Wed, 15 Nov 2006 19:36:56 GMT Content-Type: text/html Server: GFE/1.3 Connection: Keep-Alive

Moved Permanently
The document has moved here. Done.

[Erik]

Im so confused on installing this its not even funny. Ive read the guide and still makes no sense to me. Is there an easy to read step by step?

[mandros]

Hi, I read this tread and installed the module. When I run the hidden page I get these errors (PS: I am using the view.php you attached for analysis of a previsous error):

Warning: filesize() [function.filesize]: Stat failed for info.php (errno=2 - No such file or directory) in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 37

Warning: fopen(info.php) [function.fopen]: failed to open stream: No such file or directory in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 38

Warning: filesize() [function.filesize]: Stat failed for info.php (errno=2 - No such file or directory) in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 39

Warning: fread(): supplied argument is not a valid stream resource in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 39

Warning: fclose(): supplied argument is not a valid stream resource in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 40

SecureSSI: Das Script (/usr/export/www/vhosts/funnetwork/hosting/mandros/pages/generate_sitemap.php) hat versucht ausserhalb von ihrem Userverzeichniss auf die Datei /usr/export/www/vhosts/funnetwork/hosting/mandros\sitemap.xml zuzugreifen.
Dies ist nicht erlaubt!

Warning: fopen() [function.fopen]: Sicherheitsverletzu ng: in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 239

Warning: fopen(/usr/export/www/vhosts/funnetwork/hosting/mandros\sitemap.xml) [function.fopen]: failed to open stream: Operation not permitted in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 239

Warning: fwrite(): supplied argument is not a valid stream resource in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 243

Warning: fclose(): supplied argument is not a valid stream resource in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 247
Done in 0 seconds.

Link is: http://www.mandros.nl\sitemap.xml
Link is: /webmasters/sitemaps/ping?sitemap=http%3A%2F%2Fwww.mandros.nl%5Csitemap.xml
Submitting sitemap to Google...
Warning: fsockopen() has been disabled for security reasons in /usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/view.php on line 202
Failed connecting to www.google.com.Done.

What I found strange is the use of "/" and "\" in for example this line:

/usr/export/www/vhosts/funnetwork/hosting/mandros\sitemap.xml

PS: The file "logsitemap.txt" is attached!

[tomhung]

i may have run into something similar....


do you have a sitemap.xml in your doc root?  and is it writable by the webserver user? nobody:nogroup or something like that.  or chmod 777 the file.



That was my problem when I was working on this problem...

[viulian]

Well, it seems your hosting provider disabled some elementary functions in php (such as fsockopen) for security reasons. For that, php is not able to connect to google.com.

Second, there are heavy security restraints too - I think the module didn't even installed completly.. Can you please tell me how many files there are in the folder:

/usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/

[mandros]

Yes, the file sitemap.xml is in the root (where wb is installed) and it has 777. At this moment it is still empty.....waiting to be filled by the module!

[mandros]

Well, it seems your hosting provider disabled some elementary functions in php (such as fsockopen) for security reasons. For that, php is not able to connect to google.com.

Second, there are heavy security restraints too - I think the module didn't even installed completly.. Can you please tell me how many files there are in the folder:

/usr/export/www/vhosts/funnetwork/hosting/mandros/modules/gsitemap/

They rest of the WebsiteBaker seems to work fine!

Well this is in the directory: 9 files
add.php
delete.php
index.php
info.php
install.php
modify.php
save.php
uninstall.php
view.php

PS: I am going to bed now, me next reply will be tomorrow.

[viulian]

I kept looking at the screen warnings and was wondering whether it wouldn't be the same case as the previous error (which was caused by an info.php in some other path and the view.php tried to include that info.php and not the module's one).

Even if we'll going to manage to fix the problem - the trouble is that you won't be able to do automatically do google submit (fsockopen is disabled on your host - or at least that's what the log file tells me). You will have to submit manually.

What puzzles me about this php thing in general is that most of the time it works correctly - but when it doesn't - there isn't any clue or descriptive error message. So basically I cannot tell right now whether the bug is in the code nor what causes php to report a missing file when it's there in the module directory.

I will need some time to search a solution for this issue - because I cannot reproduce it locally.. I'll probably have to send you some test files (like the ones I've prev. attached in this thread - to try and isolate the problem) and then come up with a fix..

[mandros]

Your right!  "fsockopen() has been disabled for security reasons" I looked at the forum and found out they don't accept the demand at my webhost (it's free....).

Hi I looked and didn't see the info.php in any other folder then the different modle and template folders. No clue there....

I alos logged in on the MySQL Database to look at it. I looked like this mod doesn't use a database because I can't find one for example there is one for mod_guestbook and mod_sitemap. This last one is the sitemap modules that generates a page with the sitemap-links in my website. Couldn't be that this somehow is any influence?

Did you look at the strange use of the "/" and "\" in the error?

/usr/export/www/vhosts/funnetwork/hosting/mandros\sitemap.xml

PS: to look at the PHP settings oon the server click: http://phpinfo.ma.funpic.de/

[viulian]

The \ issue is no problem.. I mean it's ok, in paths, to use eitherone. In case \s would have been considered an escape char, the error would have been related to "itemap.xml" instead of "sitemap.xml". So no problem there.

The module itself does not need entries in the database (I mean it just reads the database and outputs the sitemap.xml file - so there are no settings needed to be saved in the database).

I'll send you a new view.php tonight when I get home..
If you fiddle with the module, send me any details you find worth mentioned - as they might help me in debugging

Thanks

[mandros]

Thanks for the support, i'll wait on the custom view.php.

One thing I found in my mail (I have a custom 404 that sends me info if pages are called that don't exist):

Wed Dec 13 2006 10:11:01 am CET
 
89.98.xxx.xxx tried to load www.mandros.nl/pages/function.filesize
 
User Agent = Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)
 
Yes you have been bagged and tagged for a making an illegal move
 
http://www.mandros.nl/pages/generate_sitemap.php

So, It tried to open function.filesize but that isn't a actual page?

[adiwillow]

wheres the download gone !!  This thread and others just sends you round in circles asking you to click links...

[ruebenwurzel]

Hello,

have you looked at the first post of this thread?    . One of the best places i think or?

Or maybe there are new versions in the thread. As the modul didn't work everywhere we don't have it at the addons page. As soon as all bugs are fixed and it works everywhere we will add it to our addons page.

Matthias

[adiwillow]

s'okay.. i wasnt logged in when i was reading the threads. I never knew that i needed to be logged in to see downloads.. perhaps a viewable link for guests would be better, with a 'you need to login to downloads this file' would be better? if the forum allows it..

[bisi]

Great module! Easy installation!

[baZzz]

Hi,

I've made a few updates to the module because it wasn't working on my server. (The problem is that on some servers the info.php cannot be included, which results in the general variables not being included, which in this case causes the $fSep variable (containing the "/" of "\\") to be empty.)

Attached is the updated module.

Regards,
Bas

P.S. Kudos to viulian for creating this module!

[viulian]

Perfect

I'll integrate and post a thank you message in the description.

[mystic]

Hi,

I think WEBSITEBAKER is a great little product and has so much that other products like WP Joomla etc. still seem to be struggling with ...
My prior sites have basically been max 10 pages or so and quite low key
I am currently about to set up a website that will probably have hundreds of pages and will be intended to drive adsense / google adds revenue (I am quite new to this)

I have thus been looking at SEO in WEBSITEBAKER and this has led me to this area of the forum

I have a few questions that I would be very gratefull if someone more experienced than me could answer.

- Where do I get the latest version of the google sitemap ? I have seen references to the download but can't be sure whether this is the latest. is it 1.0.4 ? and is it the one for WB 2.6.4 ?

- Regarding SEO I saw the posts about doing the pings using CRON, but I also saw something that was mentioned about doing this automatically based on the frequency of pages updates, ... daily ... weekly ... Monthy .. Is there some code/module that I would need to install into WB to make this work automatically ?

- Is this "post" to google what people generically refer to as "PINGING" in bloggs ? I suspect not as I have the feeling that it refers to making your new page/article know to other sites or something like that. If so, is there something equivalent available for WB as it seems quite a powerfull way to generate more traffic to one's website

- Is there anything else out there for SEO on WB that you guys know about ?

I love WB due to it's simplicity and the fact that out of the box , all the URLs are already SEO friendly

Thanks in advance for any help on the above

[SaschaN]

What does this error mean? I cant create google sitemaps ... just an empty page:

[03-Aug-2007 14:56:10] PHP Fatal error:  Call to a member function numRows() on a non-object in /Users/sascha/Projekte/xxx/2007/CMS/modules/gsitemap/view.php on line 119

[viulian]

Please provide more explanations please - about your setup.

WB version, PHP version, Mysql version.

Thanks!

[SaschaN]

I solved the problem. I deleted the news module and in line 119 of gsitemap the module checks the following:

  /* iterating over the news posts. They have to be visible so they can get into the listing. */

  $query_content = $database->query("SELECT * FROM " . TABLE_PREFIX . "mod_news_posts WHERE active=1");

 

  /* do we have some pages ?*/

  if($query_content->numRows() > 0)

[axima]

For those who need dynamic Google site map, I have made  a simple script which generates XML file on fly, you need just to submit it to Google and forget about it.

Place the attached file to your WB root folder, that's it.   No installation is needed. 

[Eki]

Great!!! No more manual submitting of the XML-file. I wil give it a try...

Regards,
Erik

[Eki]

Hi there,

installed the file to the root of my WB folder, and managed to submit it in Google. Works like a charm. There is only one disadvantage: the generated xml-file doesn't contain the links to the news posts.

regards,
Erik