I can't access the file in the thread...

Is there some other way I can get to this file?

Hugh

Are there any upload instructions for this? Do we upload the htaccess folder to the root/forum directory, do we not?

Thanks

done fast question after i CHMOD 777 the 'forum-root/vbseo_sitemap/data/' folder . do i leave it this way. or i change the premissions back to 744 ?

In our forum at www.unix.com/forum_index.php forum 2 is the "Dummies" forum with over 14, 000 threads.

However, the logfile of the sitemap generating process says:

Why does the forum have so many threads but the sitemap generator says there are 355 threads??

hugh_,

try to simply replace "dl_cats" with "file_cats" and "dl_files" with "file_files".


Chris04S,

.htaccess should be created in forums folder.


chevy01xtreme,

leave it at 0777.


imported_silkroad,

you have "Default View Age" option set to "Last month", so older threads are cut out: http://www.unix.com/unix-dummies-que...rs/index9.html I'd recommend to disable this option to show ALL thread for better exposure to search engines.

I don't see any instances of dl_cats or dl_files, the values are already marked as file_cats and file_files...

Hugh

Oh, that should be reverse replacement then :) ("file_"=>"dl_").

Having applied the changes you suggested leaving me with the following I still get an error (below):

Code:

<?php

/************************************************** ****************************************
* vBSEO Google/Yahoo Sitemap Generator for vBulletin v3.x.x by Crawlability, Inc. *
*-----------------------------------------------------------------------------------------*
* *
* Copyright ? 2005-2008, Crawlability, Inc. All rights reserved. *
* You may not redistribute this file or its derivatives without written permission. *
* *
* Sales Email: sales@crawlability.com *
* *
*-------------------------------------LICENSE AGREEMENT-----------------------------------*
* 1. You are free to download and install this plugin on any vBulletin forum for which *
* you hold a valid vB license. *
* 2. You ARE NOT allowed to REMOVE or MODIFY the copyright text within the .php files *
* themselves. *
* 3. You ARE NOT allowed to DISTRIBUTE the contents of any of the included files. *
* 4. You ARE NOT allowed to COPY ANY PARTS of the code and/or use it for distribution. *
************************************************** ****************************************/

$mods = $db->query("SELECT id,name FROM " . TABLE_PREFIX . "dl_cats ORDER BY `order`");
while ($mod = $db->fetch_array($mods))
{
$url = $vbseo_vars['bburl'].'/downloads.php?do=cat&id='.$mod['id'].'&name='.urlencode($mod['name']);

if(VBSEO_ON)
$url = vbseo_any_url($url);

vbseo_add_url($url, 1.0, '', 'daily');
}

$mods = $db->query("SELECT ff.id as fid, ff.name as fname, fc.id as cid, fc.name as cname FROM " . TABLE_PREFIX . "dl_files ff LEFT JOIN dl_cats fc ON
ff.catid=fc.id");
while ($mod = $db->fetch_array($mods))
{
$url = $vbseo_vars['bburl'].'/downloads.php?do=file&id='.$mod['fid'].'&name='.urlencode($mod['fname']).'&cat='.urlencode($mod['cname']);

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, 1.0, '', 'daily');
}
?>

Error:

<!--
Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT id,name FROM dl_cats ORDER BY `order`;

MySQL Error : Unknown column 'order' in 'order clause'
Error Number : 1054
Request Date : Saturday, July 12th 2008 @ 07:06:33 AM
Error Date : Saturday, July 12th 2008 @ 07:06:55 AM
Script : http://www.xxx.com/forum/vbseo_sitemap.php
Referrer : http://www.xxx.com/forum/index.php
IP Address : xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :
-->

Nice mod *INSTALLED*
Had a little problem setting this up, but found the solution.

Got the 404 error when trying to access the sitemap, so found the problem was the .htaccess file.
This was being ignored by apache because in the httpd.conf the AllowOverrides None option was set.
A bit of googling shows that apache doesn't seem to like .htaccess files much, unless you REALLY want to use them. So, I moves the .htaccess file to /etc/httpd/conf.d/vbseo_sitemap.conf
Apache likes it now and just includes it with all the other configs.

Not much use if you're on some sort of limited access webserver, but having full control over my server this seemed the better option.

Ok, please try this:

Are there any issues running this on Apache on XP (PHP 5)?

Thanks in advance...

That worked, great thanks!

Hugh

After installing vBSEO and running the generator I resubmitted my sitemaps to Google and it tells me this warning:

Unsupported file format
Your Sitemap does not appear to be in a supported format. Please ensure it meets our Sitemap guidelines and resubmit.

I still get nervous about uploading files and folders to the right place. Do I just select all the 6 folders and 3 individual files and then drag them up to the "Forums" folder?

https://vborg.vbsupport.ru/external/2008/07/52.jpg

Thanx ;)

Jacquii.

I'm having trouble getting this to work. I've put everything where it should be but it doesn't seem to generate a sitemap :(

When I run the generator no errors come up:

But there isn't one actually created. Anyone know how to fix this?

Where do I install that?

TsirhCitna,

your sitemap looks ok for me: http://www.tenstones.net/forums/sitemap_index.xml.gz


len backus,

those are vBSEO files on your screenshot, not vBSEO Sitemap Generator.


Jonaid,

don't you have sitemap files in data/ folder?



Greek76,

you only need that if you have DownloadsII (vBulleting mod) installed.

I'm an idiot....there it is staring at me. Thanks! lol

Do I have to move it to the root directory? thats where the link in my vbseo_sitemap page is stating it should be?

Hi
Only succesfull ping is Yahoo as listed below. Anyone who can point me in the direction of a solution to this? I'm also running vBSEO 3.2.0.

Google ping: FAILED.
Yahoo ping: Successful.
Ask ping: FAILED.
Moreover ping: FAILED.
Live.com ping: FAILED.

Jonaid,

you should create .htaccess folder as described in installation instructions, no need to move files.

cykelmyggen,

what is your sitemap URL?

Nice that there is a new release. Pity tho that the downloads.php is still not fixed.
I had to fix it manually again.

But still thanks for this new release, I clicked *installed*.:)

My sitemap-URL is:
http://www.boggnasker.dk/vbforum/sitemap_index.xml.gz

What happens if you have more than 50,000 links on your site?

iojam im still waiting for a reply to my post (page 6 last one)

It wont work for me i get:
Any ideas? The website is www.aouv.co.uk but we have /forums at the end to get to our forum

cykelmyggen,

try to regenerate sitemap.


punchbowl,

vBSEO Sitemap Generator splits it on multiple files.


seanm07,

make sure that you have 0777 permissions for vbseo_sitemap/data/ folder.



alessai,
http://www.vbseo.com/wiki/Sitemap:FA...To_Domain_Root

Ok how exactly do i do that?

*edit nevermind i have done it.

Thanks i voted motm

so you must keep that folder 0777 chmod? that wont affect secruity will it ?

is vbseo site down it hasnt worked all day for me

@Javierogo: It's the "Mark as installed" link, you can find it on every page on the top right side next to the mod description under "Mod Information", it's just under "Edit settings".;)

Could I suggest a feature to allow automatic log pruning?

hi sir sitemap downloads log not created for me here is the screen shot..................


http://gallery.srimeenakshimobiles.c...serialNumber=2

I just found out, by looking at scheduled jobs, that there are two instances of the sitmap-generator listed - is that correct? When I look at installed products I see only 1 instance! See attached screenshot.

im not talking about sitemap index, im talking about the links inside the sitemap index they are not in the root and this is the problems

chevy01xtreme,

yes, you should keep data/ folder with 0777 permissions. There is an .htaccess file in that folder that prevents opening files directly from it.


hugh_,

you can setup log pruning in vbseo_sitemap_config.php file:
sundarmobiles,

do you have vBSEO product installed (it is required).


cykelmyggen,

you should remove the second one.


alessai,

the page I linked above describes exact steps how to change that.

i did what you told me to do

http://www.gulf-heart.com/sitemap_index.xml.gz

open the file and you will see:

<sitemap>
<loc>http://www.gulf-heart.com/vb/sitemap_1.xml.gz</loc>
<lastmod>2008-06-01T02:01:25+00:00</lastmod>
</sitemap>
...etc

the sitemap should be
http://www.gulf-heart.com/sitemap_1.xml.gz
so live.com will accept it

Have you done this:
http://www.vbseo.com/wiki/Sitemap:FA...To_Domain_Root