vb.org Archive

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)

Chuta 09-07-2011 01:49 AM

Quote:

Originally Posted by iyama (Post 2242564)
If i use the regenerator:



Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM thread AS thread
INNER JOIN tagcontent AS tagcontent ON
(tagcontent.tagid = 1 AND tagcontent.contentid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10
GROUP BY tagcontent.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, 1)' at line 5
Error Number : 1064
Request Date : Tuesday, September 6th 2011 @ 08:13:39 AM
Error Date : Tuesday, September 6th 2011 @ 08:13:39 AM
Script : http://www.mysite.info/forum/vbseo_s...eo_sitemap.php
Referrer : http://www.mysite.info/forum/vbseo_s...php?rlist=true

Hello iyama,

Please try to disable 'Tag pages' from being added to your sitemaps.

Chuta 09-07-2011 01:49 AM

Quote:

Originally Posted by strudinox (Post 2242595)
Excellent! I can confirm that it is working correctly now. Thanks for the support!

Hi strudinox,

I'm glad to hear that!. Thank you for your report and again sorry for the delay.

FReeSTER 09-07-2011 05:01 AM

Quote:

Originally Posted by Chuta (Post 2242047)
Hello,

Do you mean the sitemap_index.xml.gz file? i.e http://www.yoursite.com/forum/sitemap_index.xml.gz?.

I mean at the adminCP. When I try to get into vBSEO Sitemap Result it just take me to the homeforum instead and all the files are on the FTP like it have to. I have triple checked this and I dont see any files missing

iyama 09-07-2011 06:58 AM

Quote:

Originally Posted by Chuta (Post 2242841)
Hello iyama,

Please try to disable 'Tag pages' from being added to your sitemaps.

That was it. :D

I have a other question.

In the first week that my site was online, about 3 years ago.
Google has located my admincp and modcp map, and also set this online then.
Is this now again possibel or?

MagicThemeParks 09-07-2011 09:18 AM

Quote:

Originally Posted by Chuta (Post 2242317)
Hello,

The issue has been corrected. Please download the package again and follow the upgrade instructions supplied within the readme.html file, which is located inside the docs (do not upload) folder.

Was the only updated file the vbseo_sitemap_functions.php file?

iojam 09-08-2011 05:31 AM

Yes, that was the only file updated (md5_sums_crawlability_sitemap.php has changed too, since checksum is now different).

MagicThemeParks 09-08-2011 06:27 PM

Thanks iojam, but that file shows an updated date of February 7, 2011. Is there a newer version uploaded now with a newer version of that file?

Chuta 09-09-2011 03:33 AM

Quote:

Originally Posted by MagicThemeParks (Post 2243516)
Thanks iojam, but that file shows an updated date of February 7, 2011. Is there a newer version uploaded now with a newer version of that file?

Hello MagicThemeParks,

Yes, there's a newer version of the script and it is the one available for download in the first post of this thread. You can see at the middle-center part of the add-on information that it says: 'Last Update: 05 Sep 2011'.

strudinox confirms that the issue has been resolved here: https://vborg.vbsupport.ru/showpost....&postcount=430

Chuta 09-09-2011 03:35 AM

Quote:

Originally Posted by FReeSTER (Post 2242879)
I mean at the adminCP. When I try to get into vBSEO Sitemap Result it just take me to the homeforum instead and all the files are on the FTP like it have to. I have triple checked this and I dont see any files missing

Hello,

Is the .htaccess file in place?.

Chuta 09-09-2011 03:36 AM

Quote:

Originally Posted by iyama (Post 2242903)
That was it. :D

I have a other question.

In the first week that my site was online, about 3 years ago.
Google has located my admincp and modcp map, and also set this online then.
Is this now again possibel or?

Hello,

I do not fully understand your question. Please re-phrase.


All times are GMT. The time now is 06:49 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.01515 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
  • (8)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