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