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)

HasanSheriff 12-12-2008 01:14 PM

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.

iojam 12-12-2008 07:04 PM

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?

HasanSheriff 12-12-2008 07:54 PM

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

iojam 12-12-2008 08:49 PM

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.

eglyntine 12-14-2008 05:36 AM

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,

Sherrie 12-14-2008 09:00 AM

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

Sherrie 12-14-2008 10:24 AM

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.

Sherrie 12-14-2008 10:54 AM

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

cheers

rock3radio 12-14-2008 06:09 PM

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.

iojam 12-14-2008 10:06 PM

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?


All times are GMT. The time now is 12:38 PM.

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.01948 seconds
  • Memory Usage 1,766KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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