vb.org Archive

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)

lowlight 01-25-2009 02:38 PM

I'm getting the following error from Google, after I submit the sitemap:

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

This is using 50,000 entries per page (we have about 6 million URLs to index)

PakFuse 01-25-2009 07:06 PM

Is there any update on VB 3.8 for this MOD????

Das UndergrounD 01-25-2009 09:34 PM

Quote:

Originally Posted by iojam (Post 1724134)
Das UndergrounD,

if you have vBSEO installed, make sure that you have the latest version (v3.2.0) xml product file in vB admincp.

I have installed the latest version (3.2.0)

FiMeTi 01-26-2009 05:24 PM

Great! Works fine on my vb 3.8 gold.

Thx very much.

lowlight 01-27-2009 05:00 AM

Quote:

Originally Posted by lowlight (Post 1724282)
I'm getting the following error from Google, after I submit the sitemap:

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

This is using 50,000 entries per page (we have about 6 million URLs to index)

Anyone?

bigtree 01-27-2009 07:32 AM

I must be stupit or somthing. My browser shows no download link to this. Can someone please tell me where it is?

bigtree 01-27-2009 07:34 AM

skip that, I found it.

lowlight 01-27-2009 07:13 PM

Hi, I am getting this odd error, after upgrading to php5

Quote:

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 148373504 bytes) in /home/revscene/www/forums/vbseo_sitemap/vbseo_sitemap_functions.php on line 1298
Before you tell me to increase the php memory limit, please notice that it is set to 512MB already, and it is only trying to allocate 141.5 MB to run the script.

iojam 01-27-2009 09:27 PM

Please try to:
- disable text sitemap option
- remove existing *.gz files from data/ folder
- regenerate sitemap

hscorp 01-27-2009 11:23 PM

i have 3.8 but it doesn't extract forums or topic links

see the last report

http://img210.imageshack.us/img210/4373/77985750sl9.jpg

any help? thanks

lowlight 01-28-2009 05:00 AM

Quote:

Originally Posted by iojam (Post 1726535)
Please try to:
- disable text sitemap option
- remove existing *.gz files from data/ folder
- regenerate sitemap

Thanks.

Do you know what the max size per file is for Google? Mine are all around 4MB, but are being rejected by Google.

cooltechie 01-28-2009 05:35 PM

Looking at the report, it shows the google index url pointing to http://www.example.com/forum/sitemap_index.xml.gz but if I look in the same directory using FTP, it's not there. Do I need to change a setting somewhere?

iojam 01-28-2009 06:11 PM

hscorp,

are your subforums open for guest visitors? (otherwise search engines will not be able to view them, and they are automatically excluded from sitemap)

lowlight,

maximum file size if 10Mb. What exactly is the error message you get?

cooltechie,

files are stored in vbseo_sitemap/data/ folder, but you can access them via forums root using rewrite rule entered in .htaccess file.

hscorp 01-28-2009 06:35 PM

Quote:

are your subforums open for guest visitors? (otherwise search engines will not be able to view them, and they are automatically excluded from sitemap)
I'm using mod that allow search engine to access the forum and prevent the guests

so how can i make the sitemap include the links?

regards

O'NEAL 01-28-2009 08:42 PM

Hi;
When I Run Sitemap I gives me Error;

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT *
FROM vbthread AS thread
WHERE forumid = 3
AND visible = 1
AND pollid > 0;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, January 29th 2009 @ 12:09:58 AM
Error Date : Thursday, January 29th 2009 @ 12:23:50 AM
Script : http://www..com/vbseo_sitemap/vbseo_sitemap.php
Referrer : http://www..com/vbseo_sitemap/
IP Address : 88.231.140.146
Username : Kayıtsız
Classname : vB_Database
MySQL Version :

Please Help.
Thanks...

cooltechie 01-29-2009 12:23 AM

Quote:

Originally Posted by iojam (Post 1727441)
cooltechie,

files are stored in vbseo_sitemap/data/ folder, but you can access them via forums root using rewrite rule entered in .htaccess file.

Are these part of the instructions? I'm sure I followed everything but can't figure out why it would point there when in fact the files are stored elsewhere. The bots didn't make one download which was why I looked there. Kindly point me in the right direction.

joe1989 01-29-2009 12:29 AM

In the AdminCP settings for this mod, one of the options is "Max URLs in Sitemap Files." In the description it says "Google allows no more than 50,000 URLs per file." What happens if my site starts getting over 50,000 URL's?? If I leave the default setting at 20,000 what will happen when I get to 20,000? Does it just start making a new sitemap file, or do I lose old links in the sitemap?

I hope that question makes sense...

Thanks!

iojam 01-29-2009 12:36 AM

hscorp,

that is cloaking, that's why those URLs are not included in sitemap.


O'NEAL,

you should increase wait_timeout setting in MySQL configuration.


cooltechie,
> Are these part of the instructions?
yes:
Quote:

B. Enable rewriting via .htaccess
1. Upload the vBSEO Google/Yahoo Sitemap .htaccess file (located in the 'htaccess' folder) to your forum root.
....
joe1989,

it will just split sitemap on multiple files in this case.

joe1989 01-29-2009 12:41 AM

Quote:

it will just split sitemap on multiple files in this case.
So all the links will still be found by the crawler bots?

cooltechie 01-29-2009 03:51 AM

Quote:

Originally Posted by iojam (Post 1727694)

cooltechie,
> Are these part of the instructions?
yes:

I triple checked and verified that the line is there. Since I had an existing .htaccess, I simply cut and pasted the line you have in the htaccess.txt file. I can access the report details but not the linked gz file.

edit: I renamed my htaccess and uploaded the one you have and it works. My guess is the bad bots list is conflicting with yours.

niteflyer32 01-29-2009 05:31 AM

I looked but didn't see this question. What's the advantage, or is there an advantage, of the paid vbSEO over this SEO plug in?

Thanks

iojam 01-29-2009 07:26 AM

joe1989,

yes, exactly.


cooltechie,

please post your complete .htaccess so that we can find the conflicting directives.


niteflyer32,

this mod just creates XML sitemap for your forum, while vBSEO is a complete SEO add-on for vBulletin (including URL rewrites, links consolidation etc): http://www.vbseo.com

Chadi 01-31-2009 01:45 AM

I manually ran the task and got this:

Code:

Database error in vBulletin 3.8.1:

Invalid SQL:

                SELECT count(*)as cnt,max(dateline) as lastupdate
                FROM groupmessage
                WHERE groupid='1';

MySQL Error  : Unknown column 'groupid' in 'where clause'
Error Number  : 1054
Request Date  : Friday, January 30th 2009 @ 09:45:06 PM
Error Date    : Friday, January 30th 2009 @ 09:45:09 PM
Script        : http://www.talkjesus.com/xxxxx/cronadmin.php?do=runcron&cronid=56
Referrer      : http://www.talkjesus.com/xxxxx/cronadmin.php?do=modify
IP Address    : xxxxx
Username      : Chad
Classname    : vB_Database
MySQL Version : 5.0.67-community


iojam 01-31-2009 07:46 AM

Check this please: http://www.vbseo.com/f67/error-durin...50/#post190403

VargTimmen 01-31-2009 06:37 PM

Hi,

do I need vbSEO for this Mod?

Greetings,
Benny

iojam 02-01-2009 02:24 PM

No, vBSEO product is not required to run "vBSEO Sitemap Generator".

Sean James 02-03-2009 05:48 AM

Im getting the error in revision history step 7 as above.

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT t_threadid,count(*) as cnt
FROM linkback
GROUP BY t_threadid;

MySQL Error : Table 'MYDBNAME.linkback' doesn't exist
Error Number : 1146
Request Date : Tuesday, February 3rd 2009 @ 02:37:52 AM
Error Date : Tuesday, February 3rd 2009 @ 02:37:52 AM
Ive been away for a few months and noticed when checking my sitemaps that i have not generated a sitemap since may last year

iojam 02-03-2009 09:23 AM

Are you running vBSEO as well? If yes, you need v3.2.0 or greater to use "Smart priority" option in sitemap generator.

ATVTorture 02-03-2009 11:01 PM

When our cron job runs automatically in the middle of the night to update the sitemap, it will get say 20,000 URLs generated. However, when we run it manually from scheduled tasks, it will generate an additional 4000-5000 URLs for a total of somewhere between 24,000 and 25,000. It's random how many additional it will get from the previous scheduled run but it's always in the thousands of new URLs.

What could possibly be the cause of this sillyness?

Thanks!
Buster

iojam 02-03-2009 11:18 PM

You should not run it manually in Scheduled tasks manager since that executes it with admin privileges and links to private subforums are included in sitemap as a result. You can manually create sitemap in vbseo_sitemap/ interface though.

ATVTorture 02-04-2009 12:15 AM

Makes perfect sense. Thanks for the tip. Re-ran it the way you suggested to get it updated.

I have another question. I noticed in a lot forums that many people submit multiple sitemaps for one domain URL like sitemap_1, sitemap_2, sitemap_3, etc.. What is the purpose of this and are they getting a whole differnet set of URLs?

Thanks!
Buster

iojam 02-04-2009 12:35 AM

You should only submit sitemap_index.xml.gz - it includes links to all your sitemap files (sitemap_X.xml.gz)

ATVTorture 02-04-2009 03:47 AM

Well when I look in that file, all it shows is sitemap_1.xml.gz. So what's the difference? I guess I don't understand the purpose of multiple sitemap files. I also don't see what generates multiple ones since the sitemap generator only creates one by default.

Is there some advantage to multiple ones and if so, what do the differnet ones point to differently than just one?

Thanks for any insight you can provide.

Buster

iojam 02-04-2009 10:23 AM

In case if you have many URLs vBSEO Sitemap Generator will separate them on multiple file (default setting is 20,000 URLs max per file).

nca 02-04-2009 11:27 PM

I keep running the generate link from the control panel and it says that everything ran fine. But when I go through FTP to the site the files it said it created are nowhere to be found.

Here is the output it gives me:

Code:

[homepage] [4,875.7Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay [4,875.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 4, total threads: 0, pages: 1 [4,875.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 3, total threads: 0, pages: 1 [4,894.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 5, total threads: 409, pages: 21 [4,894.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 6, total threads: 97, pages: 5 [4,896.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 7, total threads: 93, pages: 5 [4,899.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 8, total threads: 46, pages: 3 [4,900.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 9, total threads: 83, pages: 5 [4,902.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 10, total threads: 110, pages: 6 [4,903.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 11, total threads: 130, pages: 7 [4,905.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 12, total threads: 85, pages: 5 [4,907.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 13, total threads: 35, pages: 2 [4,909.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 14, total threads: 197, pages: 10 [4,910.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 15, total threads: 16, pages: 1 [4,913.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 16, total threads: 29, pages: 2 [4,917.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 17, total threads: 56, pages: 3 [4,917.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 18, total threads: 119, pages: 6 [4,919.0Kb mem used] [0s (+0s)]
[SECTION START] showthread [4,921.1Kb mem used] [0s (+0s)]
[archive homepage] [5,037.5Kb mem used] [3s (+3s)]
[SECTION START] forumdisplay archived [5,038.4Kb mem used] [3s (+0s)]
[SECTION START] member [5,048.7Kb mem used] [3s (+0s)]
[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 25000 [4,905.4Kb mem used] [3s (+1s)]
[create sitemap in text format] part #2 [4,905.3Kb mem used] [3s (+0s)]
[SECTION START] polls [5,115.4Kb mem used] [4s (+1s)]
[SECTION START] blogs [5,134.0Kb mem used] [4s (+0s)]
[SECTION START] albums [5,136.7Kb mem used] [4s (+0s)]
[SECTION START] groups [5,136.8Kb mem used] [4s (+0s)]
[SECTION START] tags [5,137.4Kb mem used] [4s (+0s)]
[create sitemap file] filename: sitemap_2.xml.gz, number of urls: 2410 [4,909.0Kb mem used] [4s (+0s)]
[create sitemap in text format] part #3 [4,908.9Kb mem used] [4s (+0s)]
[create sitemap index] filename: sitemap_index.xml.gz, number of sitemaps: 2 [4,909.3Kb mem used] [4s (+0s)]
Sitemap has been created. Click here to return [4,905.6Kb mem used] [4s (+0s)]



But again when I go looking for the sitemaps it said it created I cannot locate them. A click on the link to view the google and yahoo ones just gives a 404 error.



Here is my .htaccess file:

Code:

# Comment the following line (add '#' at the beginning)

# to disable mod_rewrite functions.

# Please note: you still need to disable the hack in

# the vBSEO control panel to stop url rewrites.

RewriteEngine On



# Some servers require the Rewritebase directive to be

# enabled (remove '#' at the beginning to activate)

# Please note: when enabled, you must include the path

# to your root vB folder (i.e. RewriteBase /forums/)

#RewriteBase /



#RewriteCond %{HTTP_HOST} !^www\.yourdomain\.com

#RewriteRule (.*) http://www.yourdomain.com/forums/$1 [L,R=301]



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



RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron)

RewriteRule ^((archive/)?(.*\.php(/.*)?)?)$ vbseo.php [L,QSA]



RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteCond %{REQUEST_FILENAME} !^(admincp|modcp|clientscript|cpstyles|images)/

RewriteRule ^(.+)$ vbseo.php [L,QSA]


iojam 02-04-2009 11:47 PM

What exactly is your sitemap URL?
Try to change this line:
RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron)
to:
RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron|vbseo_sitemap/)

nca 02-05-2009 12:11 AM

It worked! :) thank you iojam!!

Now when I visit the forum in firefox there are no google adsense ads anywhere to be found. Would this sitemap generator affect the ads in the pages?

here the the forum:
http://forum.horseville.com

the is the page for example:
http://forum.horseville.com/intros/1...ggestions.html
When viewed with IE it shows the ads, when viewed with firefox no ads are to be found.

dholt 02-07-2009 02:32 AM

will this work with 3.8.0

buro9 02-09-2009 04:41 AM

Quote:

Originally Posted by chadi (Post 1729618)
I manually ran the task and got this:

Code:

Database error in vBulletin 3.8.1:

Invalid SQL:

                SELECT count(*)as cnt,max(dateline) as lastupdate
                FROM groupmessage
                WHERE groupid='1';

MySQL Error  : Unknown column 'groupid' in 'where clause'
Error Number  : 1054
Request Date  : Friday, January 30th 2009 @ 09:45:06 PM
Error Date    : Friday, January 30th 2009 @ 09:45:09 PM
Script        : http://www.talkjesus.com/xxxxx/cronadmin.php?do=runcron&cronid=56
Referrer      : http://www.talkjesus.com/xxxxx/cronadmin.php?do=modify
IP Address    : xxxxx
Username      : Chad
Classname    : vB_Database
MySQL Version : 5.0.67-community


Quote:

Originally Posted by iojam (Post 1729772)

Solved my problem too... good work.

steven.hartland 02-09-2009 07:50 PM

First off the fix for vb 3.8.2 as the group changes break the base code:-
Code:

--- vbseo_sitemap_functions.php.orig    2009-02-06 14:57:36.000000000 +0000
+++ vbseo_sitemap_functions.php 2009-02-06 14:59:58.000000000 +0000
@@ -569,6 +569,7 @@
                $tcount = $db->query_first("
                        SELECT count(*)as cnt,max(dateline) as lastupdate
-                      FROM " . TABLE_PREFIX . "groupmessage
-                      WHERE groupid='$rrow[groupid]'
+                      FROM " . TABLE_PREFIX . "discussion d, " . TABLE_PREFIX . "groupmessage g
+                      WHERE d.groupid='$rrow[groupid]'
+                              AND g.discussionid = d.discussionid
                ");
                $pcount = ceil($tcount['cnt']/$vboptions['vm_perpage']);

Next up we are getting a load of garbage in our sitemap even the zcat cant read the files:-
Code:

sh -c ' for i in *.gz; do echo $i; zcat $i | head; done' > 1
zcat: sitemap_21.xml.gz: trailing garbage ignored
zcat: sitemap_24.xml.gz: trailing garbage ignored
zcat: sitemap_27.xml.gz: trailing garbage ignored
zcat: sitemap_30.xml.gz: trailing garbage ignored
zcat: data stream error
zcat: sitemap_31.xml.gz: uncompress failed
zcat: data stream error
zcat: sitemap_34.xml.gz: uncompress failed
zcat: sitemap_36.xml.gz: trailing garbage ignored
zcat: data stream error
zcat: sitemap_37.xml.gz: uncompress failed
zcat: data stream error
zcat: sitemap_39.xml.gz: uncompress failed
zcat: sitemap_42.xml.gz: trailing garbage ignored
zcat: urllist.txt.gz: not in gzip format

Even some of the files that can be decompress are corrupt internally with invalid xml e.g. the data of the lastmod appearing in the url and missing close tags all over.

Has anyone seen this sort of corruption before?

We are running the following:-
Code:

PHP 5.2.6 with Suhosin-Patch 0.9.6.2 (cli) (built: Sep 18 2008 16:29:55)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
    with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
    with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies

apache-2.2.8        Version 2.2 of Apache web server with prefork MPM.

FreeBSD loncore1.multiplay.co.uk 7.0-RELEASE-p2 FreeBSD 7.0-RELEASE-p2 #9: Mon Jun 30 17:43:02 BST 2008



All times are GMT. The time now is 09:32 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02298 seconds
  • Memory Usage 1,857KB
  • 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
  • (7)bbcode_code_printable
  • (12)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