how to install sitemap in my forum

[Seleno]

Hi There
thanx Jeo ward for sending me your notice about my forum that doesn't have vbseo sitemap
so how can i install vbseo sitemap?

[Mert Gökçeimam]

Hello ,

You can download it from https://www.vbseo.com/downloads/ then check the readme.html file located inside docs folder for detailed instructions.

[Seleno]

Hi There
thanx, its v2.1 should i install it?

[Seleno]

i installed it, done
but what should i do now?
should i run sitemap generator or what?
i don't see any new changes in my forum

also in http://mysite.com/vb/sitemap_index.xml is not working, HTTP 404 NOT Found!
waiting your help

[Freezer]

Can you try the run site map generator link?
What happens then?

[Seleno]

when i run the sitemap genrator i saw lines like these:::
forumdisplay] forum_id: 1, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 14, total threads: 3481, pages: 175 [0s (+0s)]
[forumdisplay] forum_id: 15, total threads: 1476, pages: 74 [0s (+0s)]
[forumdisplay] forum_id: 65, total threads: 25, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 107, total threads: 26, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 16, total threads: 895, pages: 45 [0s (+0s)]
[forumdisplay] forum_id: 50, total threads: 526, pages: 27 [0s (+0s)]
[forumdisplay] forum_id: 17, total threads: 2372, pages: 119 [0s (+0s)]
=============

should i see any changes in my forum?

[Oleg Ignatiuk]

Is that the full output of the script or there are other entries as well?

[Seleno]

yeah oleg there are much lines like it

[Oleg Ignatiuk]

Looks like it's not completed. Try to disable gzip compression in vbseo_sitemap_functions.php file:
FIND:

function_exists('gzopen') 

REPLACE WITH:

function_exists('gzopen2') 

[Mark.S]

Hi Oleg. Sorry for interrupting your talk, but I have nearly the same problem.
Yesterday I installed vBSEO_Sitemap on my server. DID all what was written in the readme.htm
When I run the Sitemap Generator I get an interrupted list with

[homepage] [0s (+0s)]
[SECTION START] forumdisplay [0s (+0s)]
[forumdisplay] forum_id: 1, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 5, total threads: 563, pages: 29 [0s (+0s)]
[forumdisplay] forum_id: 6, total threads: 446, pages: 23 [0s (+0s)]
[forumdisplay] forum_id: 11, total threads: 272, pages: 14 [0s (+0s)]
[forumdisplay] forum_id: 101, total threads: 184, pages: 10 [0s (+0s)]
[forumdisplay] forum_id: 12, total threads: 34, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 13, total threads: 172, pages: 9 [0s (+0s)]
[forumdisplay] forum_id: 107, total threads: 33, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 22, total threads: 425, pages: 22 [0s (+0s)]
[forumdisplay] forum_id: 3, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 4, total threads: 280, pages: 14 [0s (+0s)]
[forumdisplay] forum_id: 99, total threads: 42, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 97, total threads: 63, pages: 4 [0s (+0s)]
[forumdisplay] forum_id: 94, total threads: 116, pages: 6 [0s (+0s)]
[forumdisplay] forum_id: 105, total threads: 40, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 98, total threads: 5, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 96, total threads: 19, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 100, total threads: 15, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 95, total threads: 74, pages: 4 [0s (+0s)]
[forumdisplay] forum_id: 16, total threads: 48, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 18, total threads: 178, pages: 9 [0s (+0s)]
[forumdisplay] forum_id: 28, total threads: 102, pages: 6 [0s (+0s)]
[forumdisplay] forum_id: 90, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 14, total threads: 158, pages: 8 [0s (+0s)]
[forumdisplay] forum_id: 110, total threads: 331, pages: 17 [0s (+0s)]
[forumdisplay] forum_id: 113, total threads: 40, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 112, total threads: 56, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 114, total threads: 56, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 111, total threads: 70, pages: 4 [0s (+0s)]
[forumdisplay] forum_id: 104, total threads: 18, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 108, total threads: 194, pages: 10 [0s (+0s)]
[forumdisplay] forum_id: 109, total threads: 253, pages: 13 [0s (+0s)]
[forumdisplay] forum_id: 106, total threads: 60, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 91, total threads: 20, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 92, total threads: 84, pages: 5 [0s (+0s)]
[forumdisplay] forum_id: 41, total threads: 100, pages: 5 [0s (+0s)]
[forumdisplay] forum_id: 42, total threads: 101, pages: 6 [0s (+0s)]
[forumdisplay] forum_id: 43, total threads: 108, pages: 6 [0s (+0s)]
[forumdisplay] forum_id: 44, total threads: 23, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 45, total threads: 17, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 46, total threads: 28, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 47, total threads: 70, pages: 4 [0s (+0s)]
[forumdisplay] forum_id: 48, total threads: 15, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 49, total threads: 113, pages: 6 [0s (+0s)]
[forumdisplay] forum_id: 50, total threads: 294, pages: 15 [0s (+0s)]
[forumdisplay] forum_id: 51, total threads: 27, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 52, total threads: 12, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 53, total threads: 49, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 54, total threads: 8, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 55, total threads: 55, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 56, total threads: 15, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 20, total threads: 37, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 9, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 19, total threads: 41, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 32, total threads: 4, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 30, total threads: 50, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 10, total threads: 42, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 25, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 26, total threads: 228, pages: 12 [0s (+0s)]
[forumdisplay] forum_id: 29, total threads: 61, pages: 4 [0s (+0s)]
[forumdisplay] forum_id: 27, total threads: 393, pages: 20 [0s (+0s)]
[forumdisplay] forum_id: 103, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 102, total threads: 8, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 116, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 117, total threads: 6, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 118, total threads: 6, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 119, total threads: 2, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 7, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 8, total threads: 44, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 115, total threads: 5, pages: 1 [0s (+0s)]
[SECTION START] showthread [0s (+0s)

 Database Error] 

I also replaced

function_exists('gzopen') 

with

function_exists('gzopen2') 

Thanks for your help

[Oleg Ignatiuk]

Please check the html source of the page, there should be a detailed sql error report.
Also, if you have any entries in add-ons list, try to remove them.

[Mark.S]

In the source code after I run the Sitemap Generator there is this message:

Invalid SQL:

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

MySQL-Fehler : Table 'projec1_forum.vblinkback' doesn't exist
Fehler-Nr.   : 1146
Date         : Tuesday, December 18th 2007 @ 01:40:23 PM
Skript       : http://www.XXXXXXX.com/forum/vbseo_sitemap/vbseo_sitemap.php
Referrer     : http://www.XXXXXXX.com/forum/vbseo_sitemap/index.php?hitdetails=20071218.log
IP-Adresse   : XX.XX.XXX.XXX
Username : Unregistriert

classname  : vb_database 

[Oleg Ignatiuk]

Do you have vBSEO3.0 Gold or greater installed? If not, upgrade to the latest vBSEO version (which is 3.1.0 atm).

[Mark.S]

Thanks for your help.
Now I updated vBSEO to 3.1.0 and run the Sitemap Generator again with no error.
When I click on "Your Goole Sitemap Index URL" with the link http://www.XXXXXX.com/forum/sitemap_index.xml.gz I get this output:
I have a german site. So I try to translate it in the (my translation)

        Mit dieser XML-Datei sind anscheinend keine Style-Informationen verknüpft. Nachfolgend wird die Baum-Ansicht des Dokuments angezeigt.

( there are no connections between your XML-file and any style informations. Successional is the tree view of your document )
      

−
    <sitemapindex xsi:schemaLocation="             http://www.sitemaps.org/schemas/sitemap/0.9             http://www.sitemaps.org/schemas/sitemap/09/siteindex.xsd">
&#8722;
    <sitemap>
<loc>http://www.XXXXXX.com/forum/sitemap_1.xml.gz</loc>
<lastmod>2007-12-18T18:32:27+00:00</lastmod>
</sitemap>
&#8722;
    <sitemap>
<loc>http://www.XXXXXX.com/forum/sitemap_2.xml.gz</loc>
<lastmod>2007-12-18T18:32:27+00:00</lastmod>
</sitemap>
&#8722;
    <sitemap>
<loc>http://www.XXXXXX.com/forum/sitemap_3.xml.gz</loc>
<lastmod>2007-12-18T18:32:27+00:00</lastmod>
</sitemap>
&#8722;
    <sitemap>
<loc>http://www.XXXXXX.com/forum/sitemap_4.xml.gz</loc>
<lastmod>2007-12-18T18:32:27+00:00</lastmod>
</sitemap>
</sitemapindex> 

If I try one of the .xml.gz files I got the Error:

XML-Verarbeitungsfehler: Kein Element gefunden
Adresse: http://www.XXXXX.com/forum/sitemap_1.xml.gz
Zeile Nr. 1, Spalte 1:

( XML - processing defect: No element found
address: http://www.XXXXX.com/forum/sitemap_1.xml.gz
row nr. 1, column 1: ) 

There is also ne source code


[edit]
I found the files via ftp in my folder http://www.XXXXXX.com/forum/vbseo_sitemap/data/ but when I try to get them via browser I get a 403 error message

I downloaded the files and can only open the sitemap_index.xml.gz.
It contains a sitemap_index.xml file with the same content as in the 1st php-infos in this post.
All other files I cannot open with the error message "this archive is unknown or damaged " This are the sitemap_X.xml.gz files.

again... thanks a lot for your help

[Oleg Ignatiuk]

http://www.XXXXXX.com/forum/sitemap_index.xml.gz I get this output:
I have a german site. So I try to translate it in the (my translation)

That's only a message telling that there is no stylesheet attached to the sitemap, which is not required. Feel free to submit it to Google.