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)

iojam 02-09-2009 09:07 PM

steven.hartland,

try to downloads sitemap files via FTP (from vbseo_sitemap/data/ folder) and check if they are correct.

steven.hartland 02-09-2009 10:19 PM

Thanks for the suggestion iojam, I was already in the data dir when checking the compression with zcat.

I've done some more digging and its definitely something to do with the gzip compression turning that off in the config fixes the issue. We've not had any issues with standard gzip support on the forums, but something in the sitemap code seems to be triggering an issue with it.

After looking at the code which is only a few lines I can only conclude the issue is with the underlying php function. There are a number of bugs still open in php's bug tracker which may be the cause.

For the time being we will live with gzip off.

DarkFaCe 02-10-2009 03:19 AM

Code:

Warning: main(): Unable to access /var/www/vhosts/yourdomain.com/httpdocs/forums/global.html in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 31

Warning: main(/var/www/vhosts/yourdomain.com/httpdocs/forums/global.html): failed to open stream: No such file or directory in /var/www/vhosts/cafedostlar.com/httpdocs/forums/vbseo_sitemap/index.php on line 31

Warning: main(): Unable to access /var/www/vhosts/yourdomain.com/httpdocs/forums/global.html in /var/www/vhosts/cafedostlar.com/httpdocs/forums/vbseo_sitemap/index.php on line 31

Warning: main(/var/www/vhosts/yourdomain.com/httpdocs/forums/global.html): failed to open stream: No such file or directory in /var/www/vhosts/cafedostlar.com/httpdocs/forums/vbseo_sitemap/index.php on line 31

Warning: main(): Unable to access /var/www/vhosts/yourdomain.com/httpdocs/forums/global.html in /var/www/vhosts/yourdomainr.com/httpdocs/forums/vbseo_sitemap/index.php on line 31

Warning: main(/var/www/vhosts/yourdomain.com/httpdocs/forums/global.html): failed to open stream: No such file or directory in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 31

Warning: main(): Failed opening '/var/www/vhosts/yourdomain.com/httpdocs/forums/global.html' for inclusion (include_path='.:/usr/share/pear') in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 31

Warning: main(): Unable to access /var/www/vhosts/yourdomain.com/httpdocs/forums/includes/config.html in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 34

Warning: main(/var/www/vhosts/yourdomain.com/httpdocs/forums/includes/config.html): failed to open stream: No such file or directory in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 34

Warning: main(): Unable to access /var/www/vhosts/yourdomain.com/httpdocs/forums/includes/config.html in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 34

Warning: main(/var/www/vhosts/yourdomainr.com/httpdocs/forums/includes/config.html): failed to open stream: No such file or directory in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 34

Warning: main(): Unable to access /var/www/vhosts/yourdomain.com/httpdocs/forums/includes/config.html in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 34

Warning: main(/var/www/vhosts/yourdomain.com/httpdocs/forums/includes/config.html): failed to open stream: No such file or directory in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 34

Warning: main(): Failed opening '/var/www/vhosts/yourdomain.com/httpdocs/forums/includes/config.html' for inclusion (include_path='.:/usr/share/pear') in /var/www/vhosts/yourdomain.com/httpdocs/forums/vbseo_sitemap/index.php on line 34

Help me please

iojam 02-10-2009 12:46 PM

Do you have .html vBulletin package installed for your forum? If not you should have this in vbseo_sitemap_config.php file (which is default):
PHP Code:

       define('VBSEO_PHP_EXT''php'); 


DarkFaCe 02-10-2009 01:33 PM

Thanks ioJam

Sym0n 02-10-2009 06:05 PM

Quote:

Originally Posted by iojam (Post 1714011)
Sym0n,

in order to redirect www to non-www domain, the code will looks like:
Code:

RewriteEngine On
RewriteCond %{HTTP_HOST} !^example\.com$
RewriteRule (.*) http://example.com/$1 [R=301,L]

and:
Code:

RewriteEngine On
RewriteCond %{HTTP_HOST} !^example\.com$
RewriteRule (.*) http://example.com/forums/$1 [R=301,L]

detailed description can be found here: http://www.vbseo.com/f2/how-setup-ww...directs-21501/

iojam, thanks that code worked. But my situation is slightly different in that I have two different domains (.com and .net) pointing to the same site and don't want them to rewrite the domain.

Quote:

Originally Posted by aciurczak (Post 1713474)
Sy -

Go to this forum:

http://forum.modrewrite.com

Sign up and post your issue in the new topics forum (new users can only post in that section until they are approved). Post a link in your question to my similar question:

http://forum.modrewrite.com/viewtopic.php?t=23736

and I'm sure they will suggest a working htaccess solution for you very quickly. When they do, post it up back here so the next schmo (after us 2 schmo's) don't have to search the internet and spend hours on what is at its core just a simple question.

aciurczak, cheers mate. I followed your advice and headed over to modrewrite.com. After just my initial post richardk nailed it in one and now it works perfectly.

In case anyone else requires the same thing:

root
Code:

Options +FollowSymLinks
 
RewriteEngine On
 
RewriteCond %{HTTP_HOST} ^.+\.(example\.(com|net))$
RewriteRule .* http://%1%{REQUEST_URI} [R=301,L]

/forum/
Code:

Options +FollowSymLinks
 
RewriteEngine On
 
RewriteCond %{HTTP_HOST} ^.+\.(example\.(com|net))$
RewriteRule .* http://%1%{REQUEST_URI} [R=301,L]
 
RewriteRule ^(urllist|sitemap).*\.(xml|txt)(\.gz)?$ /forum/vbseo_sitemap/vbseo_getsitemap.php?sitemap=$0 [L]

:D

Sy

relaxiha 02-10-2009 10:40 PM

please update for 3.8.1

trickfly 02-11-2009 02:31 AM

Yes please update for 3.8.1 !!!!

howcome 02-14-2009 02:37 PM

i have this installed and it is making vbseo links causing google to have not found url's

dholt 02-14-2009 03:25 PM

Works perfect in 3.8.1 I especially love the Site-map Reports page.

Eventually I'll get vbseo but for now this works great as it installed flawlessly and generate a pretty good site map as Google shows it's having no problems accessing the pages. very cool
Thanks again for the Great Free SEO Package :up:

khurtsiya 02-15-2009 05:53 PM

Hello everybody!

Downloaded and installed Sitemap Generator and manually started it by clicking "Run Sitemap Generator". Sitemap generated cuz I see report, but the link it shows in CP (Your Google Sitemap Index URL: kiev.com.ua/forum/sitemap_index.xml.gz) is not working...

Any ideas why?

iojam 02-16-2009 07:59 AM

Make sure that you created .htaccess file as described in installation instructions.

khurtsiya 02-16-2009 10:47 AM

Installation instruction note says

Quote:

vBSEO Users skip this step
So I have .htaccess file in forum root, and not in site root (homepage is CMPS).

And one more question - why I have no links in the bottom of the forum like 1 2 3 4 5 6 7 8 9 etc... (each number is a link). What makes that links - vBSEO or Sitemap Generator?

TIA

Michael

iojam 02-16-2009 10:56 AM

Try to modify .htaccess file:
find:
Code:

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron)
replace with:
Code:

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

And one more question - why I have no links in the bottom of the forum like 1 2 3 4 5 6 7 8 9 etc... (each number is a link). What makes that links - vBSEO or Sitemap Generator?
This is vBSEO's feature (check "Footer Archive Links" option in vBSEO CP).

khurtsiya 02-16-2009 12:35 PM

Quote:

Originally Posted by iojam (Post 1745798)
Try to modify .htaccess file:
find:
Code:

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron)
replace with:
Code:

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron|vbseo_sitemap)
This is vBSEO's feature (check "Footer Archive Links" option in vBSEO CP).

Great! All is working now. Thanks!

I found that in archive I have my forumlist and if you click on any forum it takes you to nowhere but this same page. Is it correct or I break smth?

iojam 02-17-2009 03:43 PM

It's related to vBSEO, not sitemap generator: http://www.vbseo.com/f77/archive-sit...24/#post181527

havard20009 02-17-2009 08:52 PM

hello

i receive db erro after site map generator
Database Error Database error
database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www....com home page, then try to open another page.
* Click the Back button to try another link.

The www....com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

what can i do ??
and also i cant open sitemap_1.xml.gz
tanx about your hellp

iojam 02-17-2009 10:35 PM

Check the html source of that page to find out exact db error message.

Das UndergrounD 02-18-2009 01:55 AM

to generate a sitemap I get the following error:

Fatal error: Call to undefined function vbseo_sitemap_albums() in /************/public_html/vbseo_sitemap/vbseo_sitemap.php on line 113

havard20009 02-18-2009 05:32 AM

my db error
https://vborg.vbsupport.ru/external/2009/02/44.jpg

iojam 02-18-2009 06:39 PM

Das UndergrounD,

if you don't have vBSEO installed, turn off "vBSEO URLs" option.

havard20009,

you should check the *html source*, not the on page content for exact message.

havard20009 02-18-2009 10:38 PM

<!--
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT *
FROM blog
WHERE state = 'visible';

MySQL Error : Unknown column 'state' in 'where clause'
Error Number : 1054
Request Date : Thursday, February 19th 2009 @ 03:51:55 AM
Error Date : Thursday, February 19th 2009 @ 03:51:57 AM
Script : http://...com/forums/vbseo_sitemap/vbseo_sitemap.php
Referrer : http://.com.com/forums/vbseo_sitemap/
IP Address : 120.28.133.235
Username : not register
Classname : vB_Database
MySQL Version :
-->


also i used this code 4 resolve but i have problem with this

PHP Code:
$tcount = $db->query_first("
SELECT count(*)as cnt,max(dateline) as lastupdate
FROM " . TABLE_PREFIX . "groupmessage
WHERE groupid='$rrow[groupid]'
");
replace with

PHP Code:
$tcount = $db->query_first("
SELECT count(*)as cnt,max(dateline) as lastupdate
FROM " . TABLE_PREFIX . "groupmessage AS groupmessage
LEFT JOIN " . TABLE_PREFIX . "discussion AS discussion ON (groupmessage.discussionid = discussion.discussionid)
WHERE discussion.groupid='$rrow[groupid]'
");

iojam 02-19-2009 11:23 AM

Do you have vBulletin Blog installed? If yes, are you running the latest version?

goxy63 02-20-2009 02:59 PM

please update for 3.8.1

carrlos 02-21-2009 03:21 AM

I tested mod_rewrite and it works. The generator generates the sitemap in the .../data folder. The problem is that I get a 404 error when trying to access it. Google is saying the same thing. I have the .htaccess file in the forum root. I gave this link to Google:

http://www.mywebsite.com/forum/sitemap_index.xml.gz

Any suggestions?

Huy Ho?ng 02-22-2009 06:00 AM

Uninstall this version to switch to version 3.8 :D
Good job

Scalemotorcars 02-23-2009 08:40 PM

Seems to be working fine. Thanks! :up:

Ipuck 02-25-2009 03:33 AM

I have been using the Sitemap Generator for months, I just upgrade to 2.5 and I have a couple of questions

Questions:

Show Sitemap Downloads Log -- Should I erase or keep them? Is there any option no to save the log?

Show SE Bots Activity Log-- How do I erase the log? if it is possible to erase, should I erase or keep them? Is there any option no to save the log?

Show Reports List -- Should I erase or keep the list? Is there any option no to save the list?

Last question: I upgraded to 2.5 but still shows 2.2 at the bottom, am I doing something wrong?

iojam 02-25-2009 03:51 AM

I'd recommend to setup "Prune log" setting in vbseo_sitemap_config.php file to automatically erase old logs:
Code:

        define('VBSEO_SM_PRUNE', 0); // logs age in days to prune
Quote:

Last question: I upgraded to 2.5 but still shows 2.2 at the bottom, am I doing something wrong?
Make sure that you uploaded all new files to vbseo_sitemap/ folder and imported xml product file in vB admincp.

rinkrat 02-26-2009 02:12 AM

I just upgraded from the previous version and now when I run the script it stalls here

forumdisplay] forum_id: 15, total threads: 382, pages: 13 [6,631.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 20, total threads: 172, pages: 6 [6,637.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 43, total threads: 225, pages: 8 [6,641.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 45, total threads: 70, pages: 3 [6,644.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 46, total threads: 134, pages: 5 [6,646.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 44, total threads: 25, pages: 1 [6,648.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 47, total threads: 71, pages: 3 [6,649.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 18, total threads: 108, pages: 4 [6,650.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 11, total threads: 299, pages: 10 [6,651.9Kb mem used] [0s (+0s)]
[SECTION START] showthread [6,655.2Kb mem used] [0s (+0s)]

How can I kick start it to finish the job?

iojam 02-26-2009 02:36 AM

Check the html source of the page when that happens, possibly there is a database error.

MTGDarkness 02-26-2009 11:17 AM

Quote:

[Thu Feb 26 05:13:27 2009] [error] [client 66.249.73.9] Premature end of script headers: /<snip>/forums/vbseo_sitemap/vbseo_getsitemap.php
SoftException in Application.cpp:252: File "<snip>/forums/vbseo_sitemap/vbseo_getsitemap.php" is writeable by group
Those are the errors my error log is giving me. I keep getting 500 errors.

Silviu 02-27-2009 09:29 PM

Hello iojam,

We're using vBulletin 3.7.5, have vBSEO 3.2 and just installed version 2.5 of the Sitemap Generator.

The problem is that when we try to run the task, it outputs this

Quote:

[SECTION START] blog tags [6,796.6Kb mem used] [20,219,278s (+281s)]
[create sitemap file] filename: sitemap_502.xml.gz, number of urls: 4 [6,799.7Kb mem used] [20,219,278s (+0s)]
[create sitemap in text format] part #503 [6,799.9Kb mem used] [20,219,278s (+0s)]
[create sitemap index] filename: sitemap_index.xml.gz, number of sitemaps: 502 [6,927.0Kb mem used] [20,219,278s (+0s)]
Then just dies.

Any ideas as to what might cause this behavior? We're not getting any SQL errors and the upgrade to version 2.5 went smoothly and was done correctly.

rinkrat 02-28-2009 01:24 AM

I had that same problem and deleted the stuff in the /data subdirectory (after being instructed to) then ran it again and it ran fine.

Silviu 02-28-2009 11:16 AM

Thank you for the tip, worked like a charm.

mdrs2 03-01-2009 10:04 AM

my "vbseo sitemap" time is mismatch with my Forum Time... (my Forum time is +3.5)
How can in set it ?

mdrs2 03-01-2009 06:36 PM

no anyBody Help me ? :(

iojam 03-02-2009 08:27 AM

MTGDarkness,

make sure that you did NOT change permissions for vbseo_getsitemap.php file (it should be set to 0644).

mdrs2,

that's a server time and it doesn't affect sitemap generation.

MTGDarkness 03-02-2009 05:07 PM

The permissions were wrong; I reset them to 644. Should the other files also be 664? Every file (and folder) in the folder is set to CHMOD777. I reset the file you mentioned to 664, but I'm still getting these 500 errors...

Quote:

[Mon Mar 2 11:05:27 2009] [error] [client <snip>] Premature end of script headers: /<snip>/forums/vbseo_sitemap/index.php
SoftException in Application.cpp:252: File "/<snip>/forums/vbseo_sitemap/index.php" is writeable by group

iojam 03-02-2009 11:14 PM

You should apply 0777 permissions to vbseo_sitemap/data/ folder *only*.


All times are GMT. The time now is 09:11 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.01740 seconds
  • Memory Usage 1,847KB
  • 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
  • (10)bbcode_code_printable
  • (1)bbcode_php_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