vb.org Archive - Administrative and Maintenance Tools - vBSEO Google/Yahoo Sitemap Generator

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Administrative and Maintenance Tools - vBSEO Google/Yahoo Sitemap Generator (https://vborg.vbsupport.ru/showthread.php?t=184573)

Got it working. I had to allow "Everyone" Full Control.
Still have 3 issues:

1. The file created is located in /vbseo_sitemap/data when it needs to be created in the root of the web. I tried changing this value in the AdminCP, but didn't save in the root.
2. The file is a .gz when it needs to be an uncompressed sitemap.xml
3. The results show [create sitemap index] filename: sitemap_index.xml.gz, number of sitemaps: 1 [3,112.0Kb mem used] [0s (+0s)]. The conpressed file is 2Kb and uncompressed 30Kb. Why is this when the report says 3.1MB?

Thanks.

1. files are stored in data/ folder, but are rewritten with rewrite rules in .htaccess file.

2. gzip compressed sitemaps are supported by Google.

3. what is the size of sitemap_1.xml.gz?

Quote:

Originally Posted by iojam (Post 1684046)

1. files are stored in data/ folder, but are rewritten with rewrite rules in .htaccess file.

2. gzip compressed sitemaps are supported by Google.

3. what is the size of sitemap_1.xml.gz?

Thanks for the reply.
1. I'm running IIS7 on Srv 08. How do I proceed?
2. Noted that there is no need to decompress.
3. 1.2Kb. Uncompressed it is 30Kb. But when I open the decompressed file, it looks ok. My concern is that the report says 3.11MB: [create sitemap index] filename: sitemap_index.xml.gz, number of sitemaps: 1 [3,112.0Kb mem used] [0s (+0s)].

Hello,

1. you should use rewrite rules for IIS (check installation instructions), ISAPI_Rewrite module is required

3. This is a PHP memory usage report, it's not related to file size.

Hi all,

I have been trying to get this to work for a couple of days now. I've looked all over but I haven't seen the particular error that I'm getting so I thought I would brave the wild and finally ask.

I uploaded all of the files in the upload dir to my forum root, changed the data folder perm to 0777.

I already have an .htaccess file so I added the required lines to it so it looks like this:

Code:

Redirect /forums/ http://www.houseofparents.com/

AddHandler php5-script .php

RewriteEngine On

RewriteRule ^((urllist|sitemap).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]

I installed the product and left the settings pretty much at default. I don't have vbSEO installed so that was changed to "No".

Everything looks great but when I try to generate the sitemap I get the following error:

Code:

[homepage] [5,819.8Kb mem used] [0s (+0s)]

[SECTION START] forumdisplay [5,819.9Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 12, total threads: 189, pages: 4 [5,819.9Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 21, total threads: 1377, pages: 28 [5,819.9Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 105, total threads: 40, pages: 1 [5,820.1Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 106, total threads: 9, pages: 1 [5,820.1Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 20, total threads: 173, pages: 4 [5,820.1Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 118, total threads: 34, pages: 1 [5,820.1Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 45, total threads: 23, pages: 1 [5,820.1Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 15, total threads: 125, pages: 3 [5,820.1Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 16, total threads: 457, pages: 10 [5,820.1Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 17, total threads: 54, pages: 2 [5,820.3Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 18, total threads: 15, pages: 1 [5,820.6Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 14, total threads: 190, pages: 4 [5,820.8Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 38, total threads: 0, pages: 1 [5,821.4Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 121, total threads: 1, pages: 1 [5,821.5Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 42, total threads: 3, pages: 1 [5,821.7Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 41, total threads: 91, pages: 2 [5,821.9Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 43, total threads: 3, pages: 1 [5,822.4Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 40, total threads: 66, pages: 2 [5,822.6Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 6, total threads: 0, pages: 1 [5,823.0Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 82, total threads: 8, pages: 1 [5,823.2Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 125, total threads: 60, pages: 2 [5,823.4Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 27, total threads: 84, pages: 2 [5,823.8Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 24, total threads: 252, pages: 6 [5,824.2Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 99, total threads: 8, pages: 1 [5,825.4Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 25, total threads: 43, pages: 1 [5,825.6Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 31, total threads: 0, pages: 1 [5,825.8Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 37, total threads: 31, pages: 1 [5,826.0Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 36, total threads: 32, pages: 1 [5,826.2Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 47, total threads: 35, pages: 1 [5,826.4Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 56, total threads: 0, pages: 1 [5,826.6Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 57, total threads: 55, pages: 2 [5,826.9Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 127, total threads: 2, pages: 1 [5,827.3Kb mem used] [0s (+0s)]

[forumdisplay] forum_id: 53, total threads: 0, pages: 1 [5,827.5Kb mem used] [0s (+0s)]

[SECTION START] showthread [5,827.5Kb mem used] [0s (+0s)]

[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 20000 [5,850.5Kb mem used] [6s (+6s)]

[create sitemap in text format] part #2 [5,850.4Kb mem used] [6s (+0s)]

[create sitemap file] filename: sitemap_2.xml.gz, number of urls: 20000 [5,853.6Kb mem used] [9s (+3s)]

[create sitemap in text format] part #3 [5,853.5Kb mem used] [9s (+0s)]

[SECTION START] member [6,113.4Kb mem used] [11s (+2s)]

[SECTION START] polls [5,876.6Kb mem used] [11s (+0s)]

[SECTION START] blogs [5,900.6Kb mem used] [11s (+0s)]

[SECTION START] albums [5,921.3Kb mem used] [11s (+0s)]

[SECTION START] groups [5,921.4Kb mem used] [11s (+0s)]

[SECTION START] tags [5,921.5Kb mem used] [11s (+0s)]

[addon module] vbseo_sm_downloads.php [5,921.5Kb mem used] [11s (+0s)]

Database Error

No other error codes or anything are displayed so I don't even know where to begin to look. But I do get this generated to my e-mail afterwards:

Code:

   Database error in vBulletin 3.7.4:

   

  Invalid SQL:

  SELECT id,name FROM file_cats ORDER BY `order`;

   

  MySQL Error   : Table 'mydatabasename.file_cats' doesn't exist

  Error Number  : 1146

  Request Date  : Saturday, December 13th 2008 @ 11:25:18 PM

  Error Date    : Saturday, December 13th 2008 @ 11:25:30 PM

  Script        : ../vbseo_sitemap/vbseo_sitemap.php

  Referrer      : ../vbseo_sitemap/index.php?rlist=true

  IP Address    : xx.xxx.xxx.xxx

  Username      : Unregistered

  Classname     : vb_database

  MySQL Version :

Do I need to manually create this table or is there something else that I've failed to setup that wasn't in the instructions?

I'm running vBulletin 3.7.4 PL. Any help you could provide would be greatly appreciated. I'd really like to have this Add-on for my site. :)

Thanks,

Quote:

Originally Posted by Sherrie (Post 1683447)

Hello,

Thank you for providing this, but is there a particular way that the extra urls text file is meant to be laid out? as I have been getting a mismatched tag error in sitemap 1 file, ever since adding urls to the extra-urls.txt. I couldn't find any reference on how this was to be done so I assumed that I just add them in sitemap format which is what I did. Before adding extra urls everything appeared to be working fine.

Thanks for your help.

Could someone please help me with this because I do not know what I am doing wrong.

When I open up the sitemap_1 file it generates my forum root url first and then it follows with this:

Code:

<url>

  <loc><url></loc>

  <priority>1</priority>

  <lastmod>2008-12-14T10:45:24+00:00</lastmod>

  <changefreq>daily</changefreq>

</url>

From then on it is all out of wack until it goes back to my forum urls.

Here is an example of the format that I have used in the extra-urls.txt:

Code:

<url>

        <loc></loc>

        <priority>1.00</priority>                

        <lastmod>2007-10-30</lastmod>

        <changefreq>daily</changefreq>

</url>

I am sure this is something really simple and would appreciate any help.

Thank you

Nevermind, I finally found the solution on your forums but now I am having a problem with google giving me sitemap errors for all but the last sitemap:

Quote:

Sitemap file size error
Your Sitemap exceeds the maximum file size limit. Please create multiple Sitemaps containing fewer URLs to meet the file size limit.

Okay I found a setting in the control panel to change the maximum urls which has fixed this issue.

cheers

Hi I'm having a problem. It works fine most of the time but is missing out a large number of my threads. They're controled by VbGeek's GARS system but surely that shouldn't be a problem? I also have vbSEO installed.

eglyntine,

you should remove all entries from "Add-ons" list option in case if you don't have corresponding modules installed.

rock3radio,

are those threads visible to guests?

It worked! Thanks so much! :)

HI iojam, yes they are both viewable and one can even be posted in by unregistered users. I've checked all my sitemaps and none are listed. I even tried changing the permissions to basically a free for all then generating the sitemap but still no luck.

great stuff !!
Thanks

Hi mates,

In Scheduled Task what I need to put in Varname?
Can someone help me?

Thank you

Hello,

with the latest version a scheduled task should be created automatically, please check the list of task and search for "sitemap" in it.

my vbseo sitemap has been working for years.

However my yahoo ping has failed today and yesterday, what can i do about this?

In Scheduled Task what I need to put in Varname?
Can someone help me?

thanx bro marked as install............

okay i have installed this ...how do i check if it is wokring. i seen it says google bot downloaded it but if i look in google and see if my site has a sitemap ..it only shows add ? is there something else i was suppose to do ? sorry for such the newbie requests ....

CP,

sometimes Yahoo fails to receive the ping, I wouldn't worry about that and recommend to manually submit it to yahoo here: https://siteexplorer.search.yahoo.com/mysites

Divvy,

you can enter "vbseo_sitemap_task" as varname.

mmoore5553,

you should manually submit sitemap_index.xml.gz in Google Webmaster Account to check that's parsed correctly.

prob solved thanx

veenuisthebest

There's no problem in your sitemap. Infact, this is how sitemap looks.

Quote:

can u plz explain me this

CHMOD 777 the 'forum-root/vbseo_sitemap/data/' folder

This just means that you need to give write permissions to data folder, which you had already given I suppose, that is why your sitemap is created successfully.

thanx bro
but no such file /forum/sitemap_1.xml.gz is created
can u tell me how togive write permission to data folder..........

check it once mere bhai! It is created:

http://devilsfunhouse.org/forum/sitemap_1.xml.gz

thank u bhai it wasnt at the time of posting :o

I'm trying to figure out how to make vbseo put the sitemap on the domain root rather than in the forumsroot/vbseo_sitemap/data/ folder but can't quite seem to figure it out.

My guess is that it has something to do with the rewrite url in the .htaccess file but I don't know what to change it toto make it work correctly.

Currently I have an htaccess file in my domain root, forums root and the forumsroot/vbseo_sitemap/data/ folder but they all say the same thing. I'm guessing one of them needs to be changed or removed.

This is what they all 3 say:

Quote:

RewriteEngine on
RewriteRule ^((urllist|sitemap_).*\.(xml|txt)(\.gz)?)$ forums/vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]

I see in the admin panel there's a setting for Sitemap Files URL, but putting my domain url in there doesn't change anything once I re-run it. As a matter of fact, the cron runs, says done, and it now hasn't updated the file anywhere apparently. Well, I don't see a sitemap file on the root anyway. however, if I type this url in my browser: http://www.mydomain.com/sitemap_1.xml.gz, a current sitemap pulls up. I'm confused.

Can someone give me some help?

Thanks!

OK, I think I have this figured out and it does indeed appear to be working although a "sitempa" file isn't being generated on the root.

Quote:

Originally Posted by ATVTorture (Post 1691183)

OK, I think I have this figured out and it does indeed appear to be working although a "sitempa" file isn't being generated on the root.

Yes, it DOES work, that way only.

The .htaccess in forums root is taking care of sitemap url being called from forum root despite it actually resides in data folder.

plz help for error after run genrator

Fatal error: Out of memory (allocated 7077888) (tried to allocate 12734714 bytes) in /home/XXXXXX/public_html/forums/vbseo_sitemap/vbseo_sitemap_functions.php on line 1298

Quote:

Originally Posted by nesta1 (Post 1691584)

1. Delete the .gz files from your vbseo_sitemap/data folder manually.
2. Disable the Yahoo Text sitemap option in sitemap settings.
3. Run sitemap again.

exelent job, thanks a lot.

Quote:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, REMOVED LINK and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

:confused:

Please update to 3.8.0

vBulletin 3.8 is still on RC stages. Once it is updated to gold a new version will be released.

Tetractys,

please make sure that mod_rewrite is working on your host: http://www.vbseo.com/f77/how-check-i...my-site-21502/

Hallo. :)

What must I do to their own pages to integrate. I have, for example, a page named "impressum.php" from the search engine is not found. what should I do?

Quote:

Originally Posted by Forum-Germany (Post 1695186)

Hallo. :)

What must I do to their own pages to integrate. I have, for example, a page named "impressum.php" from the search engine is not found. what should I do?

Add it to extra-urls.txt manually.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01991 seconds Memory Usage 1,844KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: