vb.org Archive - Board Optimization - vBSEO Search Engine XML Sitemap

Page 71 of 77

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Board Optimization - vBSEO Search Engine XML Sitemap (https://vborg.vbsupport.ru/showthread.php?t=253516)

Mecho

05-01-2014 10:41 AM

Quote:

Originally Posted by Spangle (Post 2495534)

http://www.web-site-map.com/ generates an XML sitemap for you absolutely free, they also have links to their broken link checker ( 3000 pages checked for free).

thanks but we have over 2m pages.

gageb

05-04-2014 07:37 PM

thank you installed

GPOClan

05-17-2014 09:06 AM

Hello,

since a few weeks, I get this database error every day:

Code:

Datenbankfehler in vBulletin 4.2.2:



Invalid SQL:



                        INSERT INTO cronlog

                                (varname, dateline, description, type)

                        VALUES

                                ('vbseo_sitemap_task',

                                1400313092,

                                'Google Sitemap Created',

                                0);



MySQL-Fehler  : MySQL server has gone away

Fehler-Nr.    : 2006

Fehler-Zeit   : Saturday, 17.05.2014 @ 09:51:32

Datum         : Saturday, 17.05.2014 @ 09:53:34

Skript        : http://tactical-riot-gaming.de/cron.php?rand=1400202073

[...]

What's the matter here? Is there a problem with the connection to the MySQL server?

Thanks for your help!

bzcomputers

05-17-2014 03:48 PM

Quote:

Originally Posted by GPOClan (Post 2498135)

Hello,

since a few weeks, I get this database error every day:

Code:

Datenbankfehler in vBulletin 4.2.2:



Invalid SQL:



                        INSERT INTO cronlog

                                (varname, dateline, description, type)

                        VALUES

                                ('vbseo_sitemap_task',

                                1400313092,

                                'Google Sitemap Created',

                                0);



MySQL-Fehler  : MySQL server has gone away

Fehler-Nr.    : 2006

Fehler-Zeit   : Saturday, 17.05.2014 @ 09:51:32

Datum         : Saturday, 17.05.2014 @ 09:53:34

Skript        : http://tactical-riot-gaming.de/cron.php?rand=1400202073

[...]

What's the matter here? Is there a problem with the connection to the MySQL server?

Thanks for your help!

Looks like your php or mysql processes are probably set to timeout at 120 seconds. You're sitemap processing probably just became long enough to go over this limit and cause the errors. Try adjusting timeout limits in php.ini.

GPOClan

05-20-2014 08:17 AM

Hello,

thanks for your answer! I set the timeout limit to the highest possible value my hoster permitted, but I still get the database error.

EDIT: I uninstalled vBSEO due to several problems. Thanks for your help.

Ghostt

06-24-2014 02:57 PM

i have this problem since years.
my sitemap has #370 Files

1. this url NEVER worked.
Sitemap Index: /sitemap_index.xml
only this worked sitemap_index.xml.gz
BUT only when sitemap is finished. when cronjob make a new sitemap. all files get deleted. and
google webmaster tools display a error ....

how can i finally fix it? its very important.
i would also pay someone who can fix it.

tpearl5

07-25-2014 02:48 PM

Quote:

Originally Posted by bzcomputers (Post 2421010)

Hadn't had an issue with this mod for over a year, until about a week ago.

Sitemap generations started giving Internal Server Errors (500) when generating a new sitemap. After trying a ton of different things to try and resolve it, I was finally able to get a sitemap to build without error by turning off "Auto-Notify Search Engines" in the settings. The time for creation of the sitemap after doing this went from an average of taking about 12-14 seconds over the last year down to taking less than 1 second (still getting all the links) with the auto-notify off.

Thanks, this was driving me nuts!

MARCO1

07-25-2014 06:38 PM

Waw, I remember these days :)

Quote:

Originally Posted by Ghostt (Post 2503482)

You will not pay anyone :) I'll make a vBSEO rewind for your for FREE :D

The correct sitemap URL is the second not the first, Always use sitemap_index.xml.gz as your sitemap URL.
This URL contains all of your generated sitemap.

dknelson

11-29-2014 10:39 AM

Getting this error. I get it every night when the the VBSEO cron task runs. Am told that VBulletin 4 does not even had a tagthread table so why is it trying to do this?

nvalid SQL:

SELECT
count(*) as maxre
FROM tagthread
GROUP BY tagid
ORDER BY maxre DESC
LIMIT 0,1;

MySQL Error : Table 'my_forums.tagthread' doesn't exist
Error Number : 1146
Request Date : Saturday, November 29th 2014 @ 02:00:24 AM
Error Date : Saturday, November 29th 2014 @ 02:00:24 AM
Script : http://www.mysiteorg/forum/cr...and=1417244421
Referrer : http://www.mysite.org/forum/fo...ing-Hole/page3
IP Address : 98.247.223.92
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

ozzy47

11-29-2014 10:43 AM

TBH I would just ditch vBSEO and go with DBSEO instead.

All times are GMT. The time now is 09:16 PM.

Page 71 of 77

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01970 seconds Memory Usage 1,750KB 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 (2)bbcode_code_printable (4)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
Messages: