Thread: Administrative and Maintenance Tools - vBSEO Google/Yahoo Sitemap Generator
View Single Post
  #721  
Old 02-09-2009, 07:50 PM
steven.hartland steven.hartland is offline
 
Join Date: Oct 2008
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

First off the fix for vb 3.8.2 as the group changes break the base code:-
Code:
--- vbseo_sitemap_functions.php.orig    2009-02-06 14:57:36.000000000 +0000
+++ vbseo_sitemap_functions.php 2009-02-06 14:59:58.000000000 +0000
@@ -569,6 +569,7 @@
                $tcount = $db->query_first("
                        SELECT count(*)as cnt,max(dateline) as lastupdate
-                       FROM " . TABLE_PREFIX . "groupmessage
-                       WHERE groupid='$rrow[groupid]'
+                       FROM " . TABLE_PREFIX . "discussion d, " . TABLE_PREFIX . "groupmessage g
+                       WHERE d.groupid='$rrow[groupid]'
+                               AND g.discussionid = d.discussionid
                ");
                $pcount = ceil($tcount['cnt']/$vboptions['vm_perpage']);
Next up we are getting a load of garbage in our sitemap even the zcat cant read the files:-
Code:
sh -c ' for i in *.gz; do echo $i; zcat $i | head; done' > 1
zcat: sitemap_21.xml.gz: trailing garbage ignored
zcat: sitemap_24.xml.gz: trailing garbage ignored
zcat: sitemap_27.xml.gz: trailing garbage ignored
zcat: sitemap_30.xml.gz: trailing garbage ignored
zcat: data stream error
zcat: sitemap_31.xml.gz: uncompress failed
zcat: data stream error
zcat: sitemap_34.xml.gz: uncompress failed
zcat: sitemap_36.xml.gz: trailing garbage ignored
zcat: data stream error
zcat: sitemap_37.xml.gz: uncompress failed
zcat: data stream error
zcat: sitemap_39.xml.gz: uncompress failed
zcat: sitemap_42.xml.gz: trailing garbage ignored
zcat: urllist.txt.gz: not in gzip format
Even some of the files that can be decompress are corrupt internally with invalid xml e.g. the data of the lastmod appearing in the url and missing close tags all over.

Has anyone seen this sort of corruption before?

We are running the following:-
Code:
PHP 5.2.6 with Suhosin-Patch 0.9.6.2 (cli) (built: Sep 18 2008 16:29:55) 
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
    with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
    with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies

apache-2.2.8        Version 2.2 of Apache web server with prefork MPM.

FreeBSD loncore1.multiplay.co.uk 7.0-RELEASE-p2 FreeBSD 7.0-RELEASE-p2 #9: Mon Jun 30 17:43:02 BST 2008
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01084 seconds
  • Memory Usage 1,769KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete