Archive Problem?

Hey there,

I've installed vBSEO on ExplosiveGFX Community - Where creativity Explodes! recently, and currently have a problem.

I chose to rewrite vB's Archive to /sitemap/ but that brings back a whitepage error, see for yourself here: http://explosivegfx.com/forum/sitemap/

I did have a vBAdvanced error, where the index page redirects to /forum/ but that is what I have set it to do upon a 404, so I think thats a problem with vBA

Oh, and the vBSEO Sitemap keeps giving the error "The MySQL server went away", how do I fix this?


thanks

does your archive work with vbseo temporarily disabled (and accessed via /archive/)?

For the sitemap, you need to increase your wait_timeout setting in my.cnf (mysql config file). You may need ton contact your host to do this for you.

My archive does work with vBSEO temporarily disabled, yes.

What would you suggest making the timeout limit to be?

Do you have and CRR's defined as 'sitemap/' or an actual folder called that? If not, please post your forums htaccess file.

for the my.cnf setting, it will greatly depend on your server hardware itself.
I personally run 180, but i have a pretty mean machine (dual quad xenon, 8gb ram)
The higher you go, the longer open connections will linger, and may cause MAX CLIENTS reached errors. So, it's a fine tuning process of fining the happy medium of getting little to none of either error with what works with your server. Default is 30. You may end up around 100 or so.

This is a good article:
MYSQL : Tuning / Optimizing my.cnf file

Nope, no /sitemap/ directory..

.htaccess:

Code:

ErrorDocument 400 /forum/error.php?show=400
ErrorDocument 401 /forum/error.php?show=401
ErrorDocument 403 /forum/error.php?show=403
ErrorDocument 404 /forum/error.php?show=404
ErrorDocument 405 /forum/error.php?show=405
ErrorDocument 407 /forum/error.php?show=407
ErrorDocument 408 /forum/error.php?show=408
ErrorDocument 409 /forum/error.php?show=409
ErrorDocument 413 /forum/error.php?show=413
ErrorDocument 414 /forum/error.php?show=414
ErrorDocument 415 /forum/error.php?show=415
ErrorDocument 500 /forum/error.php?show=500
ErrorDocument 501 /forum/error.php?show=501
ErrorDocument 503 /forum/error.php?show=503

# 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|vbseo_sitemap)
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]

CRR's:

Code:

/==========================================================================
//                  faq
//==========================================================================
'^faq\.php$' => 'faq/'
'^faq\.php\?faq=vb3_board_faq$' => 'faq/forums/'
'^faq\.php\?faq=vb3_board_usage$' => 'faq/forums/general/'
'^faq\.php\?faq=vb3_user_profile$' => 'faq/forums/profile/'
'^faq\.php\?faq=vb3_reading_posting$' => 'faq/forums/reading-posting/'
/==========================================================================
//                  calendar
//==========================================================================
'^calendar\.php$' => 'calendar/'
'^calendar\.php\?c=1$' => 'calendar/'
'^calendar\.php\?(c=1&)?do=(display.+?)(&year=)?$' => 'calendar/$2/[NF]'
'calendar\.php\?(c=1&)?nojs=1' => 'calendar/nojs/[NF]'
'calendar\.php\?(c=1&)?do=(display.+?)&nojs=1' => 'calendar/$2/nojs/[NF]'
'calendar\.php\?(c=1&)?week=(\d+)&nojs=1' => 'calendar/week-$2/nojs/[NF]'
'calendar\.php\?(c=1&)?month=(\d+)&year=(\d+)&nojs=1' => 'calendar/$3/$2/nojs/[NF]'
'^calendar\.php\?do=getinfo&(c=1&)?day=(\d+)-(\d+)-(\d+)(&c=1)?$' => 'calendar/$2/$3/$4/'
'^calendar\.php\?do=getinfo&e=(\d+)(&day=[0-9\-]+)?(&c=1)?$' => 'calendar/event-$1/'
'^calendar\.php\?(s=&)?(c=1&)?(week=&)?month=(\d+)&year=(\d+)(&c=1)?(&do=displaymonth)?$' => 'calendar/$5/$4/'
'^calendar\.php\?c=1&week=(\d+)(&do=displayweek&month=.+?)?$' => 'calendar/week-$1/'
/==========================================================================
//                 Private Messages
//==========================================================================
'^private\.php$' => 'pm/'
'^private\.php\?do=trackpm' => 'pm/track/'
'^private\.php\?do=editfolders' => 'pm/folders/'
'^private\.php\?do=newpm$' => 'pm/new/'
'^private\.php\?do=newpm&u=(\d+)' => 'pm/new/to-$1/'
'^private\.php\?do=showpm&pmid=(\d+)$' => 'pm/message-$1/'
'^private\.php\?folderid=(.+?)$' => 'pm/folder-$1/'
/==========================================================================
//                 Profile Pages
//==========================================================================
'^profile\.php$' => 'profile/'
'^profile\.php\?do=editsignature' => 'profile/signature/'
'^profile\.php\?do=requestusername' => 'profile/username/'
'^profile\.php\?do=editoptions' => 'profile/options/'
'^profile\.php\?do=editprofilepic' => 'profile/pic/'
'^profile\.php\?do=editprofile' => 'profile/edit/'
'^profile\.php\?do=editavatar' => 'profile/avatar/'
'^profile\.php\?do=editpassword' => 'profile/password/'
'^profile\.php\?do=editattachments' => 'profile/attachments/'
'^profile\.php\?do=ignorelist' => 'profile/foes/'
'^profile\.php\?do=customize' => 'profile/customize/'
'^profile\.php\?do=buddylist' => 'profile/friends/'
'^profile\.php\?do=editusergroups' => 'profile/usergroups/'
/==========================================================================
//                Control Panel
//==========================================================================
'^usercp\.php$' => 'control-panel/'
/==========================================================================
//                  Online Users
//==========================================================================
'^online\.php' => 'online/'
/==========================================================================
//                  Send Message / Email script
//==========================================================================
'^sendmessage\.php$' => 'sendemail/'
'^sendmessage\.php\?do=mailmember&u=(\d+)' => 'sendemail/to-$1/'
/==========================================================================
//                  Forum Page
//==========================================================================
'^showgroups\.php' => 'staff/'
/==========================================================================
//                 Hacks
//==========================================================================
'^articles\.php$' => 'articles/'
'^rules\.php$' => 'rules/'
'^sighistory\.php$' => 'sotw/'
'^search\.php$' => 'search/'
'^vbimghost\.php' => 'imagehost/'
'^vbimghost\.php\?do=myimages' => 'imagehost/myimages'
'^vbimghost\.php\?do=upload' => 'imagehost/upload'
'^vbimghost\.php\?do=userlist' => 'imagehost/users'
'^misc\.php\?do=cybstats$' => 'top-stats/'
'^misc\.php\?oi=true$' => 'invite-friends/'
'^misc\.php\?do=donate' => 'donate/'
'^convert\.php\$' => 'convert/'
'^register\.php\$' => 'register-now/'

Thanks for the link for mysql, I'll be setting it around 50-60.

Your htaccess and CRR's look fine.

Does another url option work? (ie, instead of /sitemap, a different name filling in the custom box)? This is a tricky one to troubleshoot.

Nope, doesn't work no matter what I name it.

Looked in the server error log, as whitepage could also mean 500 error (seen it before), and there is this:

Code:

[Tue Nov 03 08:00:43 2009] [error] [client My-IP.**.**.**] PHP Warning:  include() [<a href='function.include'>function.include</a>]: Failed opening '/home/mikey/public_html/forum/archive/index.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mikey/public_html/forum/vbseo.php on line 173

[Tue Nov 03 08:00:43 2009] [error] [client My-IP.**.**.**] PHP Warning:  include(/home/mikey/public_html/forum/archive/index.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/mikey/public_html/forum/vbseo.php on line 173

[Tue Nov 03 08:00:43 2009] [error] [client My-IP.**.**.**] PHP Warning:  chdir() [<a href='function.chdir'>function.chdir</a>]: No such file or directory (errno 2) in /home/mikey/public_html/forum/vbseo.php on line 147

Do you have any .htaccess file within your archive folder ?

No. There is archive.css, global.php and archive.php

EDIT: Just checked my archive just now, and it works.

I removed a .htaccess from the root of my directory yesterday (outside of /forum/), that must have fixed it.