vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Administrative and Maintenance Tools - vBSEO Google/Yahoo Sitemap Generator (https://vborg.vbsupport.ru/showthread.php?t=206169)

drjdh 01-13-2010 04:09 AM

I'm running 3.8.4
I downloaded all of the files as indicated by the instructions.
The vBSEO control panel seems to be working well.
When I choose vBSEO Sitemap reports from the Admin control panel I get:

"The server encountered an unexpected condition which prevented it from fulfilling the request.
The script had an error or it did not produce any output. If there was an error, you should be able to see it in the error log.
"

The data folder is set to "777"
.htaccess contains:
RewriteEngine On
RewriteRule ^((urllist|sitemap).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]

I've been racking my brain trying to figure out what I'm doing wrong :eek:

Any ideas?:confused:

drjdh 01-14-2010 06:39 PM

Here is the error message that I'm getting on my server now:

Invalid SQL:

SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM thread AS thread
INNER JOIN tagthread AS tagthread ON
(tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10
GROUP BY tagthread.tagid;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND thread.visible = 1
AND thread.sticky IN (0, ' at line 5 Error Number : 1064 Request Date : Thursday, January 14th 2010 @ 03:29:26 PM

HeyMe 01-22-2010 08:14 AM

Will the vb 4 compatible version be free?

solidlink 01-26-2010 08:06 AM

i have a problem.......... how do i login to the vBSEO Sitemap Interface Access Password?

I cant remember the password............. i cant even remember setting the password?

sump 01-30-2010 12:23 PM

anyone know about this error ??

Database error in vBulletin 3.8.4:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('vbseo_sitemap_task',
1264298425,
'Google Sitemap Created',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, January 24th 2010 @ 02:00:25 AM
Error Date : Sunday, January 24th 2010 @ 02:02:14 AM
Script : hxxp://www.myforum.com/forums/cron.php?rand=1264298423
Referrer : hxxp://www.myforum.com/forums/kbox-discussions/6820-kbox-file-release-read.html
IP Address : xxx.xxx.xxx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

djbaxter 01-30-2010 01:05 PM

Quote:

Originally Posted by sump (Post 1970433)
anyone know about this error ??

Database error in vBulletin 3.8.4:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('vbseo_sitemap_task',
1264298425,
'Google Sitemap Created',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, January 24th 2010 @ 02:00:25 AM
Error Date : Sunday, January 24th 2010 @ 02:02:14 AM
Script : hxxp://www.myforum.com/forums/cron.php?rand=1264298423
Referrer : hxxp://www.myforum.com/forums/kbox-discussions/6820-kbox-file-release-read.html
IP Address : xxx.xxx.xxx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Not sure about the first one (Invalid SQL) but it may be related to the second (MySQL server has gone away) which tells you you've lost the connection to the MySQL server, a common and saqdly frequent occurrence with shared hosting.

Try breaking up the sitemap into smaller files in the options.

sump 01-30-2010 01:31 PM

Quote:

Originally Posted by djbaxter (Post 1970463)
Not sure about the first one (Invalid SQL) but it may be related to the second (MySQL server has gone away) which tells you you've lost the connection to the MySQL server, a common and saqdly frequent occurrence with shared hosting.

Try breaking up the sitemap into smaller files in the options.

well, for what it is worth it is VPS.

djbaxter 01-30-2010 02:00 PM

Quote:

Originally Posted by sump (Post 1970480)
well, for what it is worth it is VPS.

Then my guess is your cron job is timing out. Try the suggestion of
  1. setting Max URLs in Sitemap Files to something lower, perhaps 20000 or 25000, and
  2. increasing the pause at Delay Execution After Each Sitemap File (I use 15 seconds on a VPS)

sump 01-30-2010 02:28 PM

yes the one was 20000 i think it was default.

the 0 to 15 seconds seemed to do the trick thanks !!!

7shashatop 01-31-2010 03:29 AM

very good


All times are GMT. The time now is 05:49 AM.

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.01556 seconds
  • Memory Usage 1,745KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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