VaultWiki - vBSEO SiteMap Integration

[Hostboard]

Ummm... looks like you forgot to upload/attach the file(s)? Checked member area and not listed their either.

[pegasus]

Oops, sorry about that. Please see the first post again.

EDIT: Module updated. The old version wasn't running on every possible variation of the cron.

EDIT again: Sorry about the rapid releases here. vBulletin made cron unnecessarily complicated. There was a problem with old-style category pages and articles with comments when generated by cron (which was fixed in the previous release an two hours ago).

[pegasus]

Posted an update for VaultWiki 3 today. Also fixed a bug where image pages were indexed.

[pegasus]

3.0.0 Gold compatible version released. If you upgrade to VaultWiki 3.0.0 gold, you'll need to update or your sitemaps will break.

[ctrlbrk]

I am using VW 3.0.0 gold and vb 3.8.5 and vbseo 3.3.0. I added this add-on, and it is throw vbulletin database errors at night during the cron.

The error:

Database error in vBulletin 3.8.5:

Invalid SQL:

						SELECT p.dateline,p.postid,p.threadid
						FROM post AS p
						WHERE p.threadid = 
							AND visible = 1
							AND p.postid != 
						ORDER BY p.dateline;

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 visible = 1
							AND p.postid != 
						ORDER BY p.dateline' at line 4

Mike

[ctrlbrk]

I can't seem to edit my above post. I neglected to mention I downloaded "vault_sitemap_304.zip" of this add-on.

Mike

[pegasus]

This occurs if you have a Category namespace and you have configured the vBSEO Sitemap to include showpost URLs in the sitemap. I have released an update that should correct this issue.

[ctrlbrk]

Ok, I am running the new version.

However, the <priority> tag is invalid (missing attribute) for the wiki URLs which is throwing errors with Google.

Here is a sample:

<url>
  <loc>http://www.bigmiketrading.com/wiki/category/Options</loc>
  <priority></priority>
  <lastmod>2010-07-04T04:27:17+00:00</lastmod>
  <changefreq>daily</changefreq>
</url>

The Google error is:

Tag: priority
Invalid tag value
This XML tag has an invalid value. Please fix it and resubmit.

The priority tag should be omitted if there is not a value for it, then it will default to 0.5.

Mike

[pegasus]

Do you have vBSEO sitemap's "smart" priority turned off?

In this case, in vbseo_sitemap/addons/special_addon_sitemap.php, find:

				if ($vbulletin->options['vbseo_sm_freq_tsmart'])

Add before:

				else
				{
					$prior = vbseo_sm_priority($vbulletin->options['vbseo_sm_priority_rt'], $relp);
				}

[ctrlbrk]

That solved it, thx.

Mike

[pegasus]

Seems to still be working in vBSEO Sitemap 3.0 Gold. Anyone confirm?

[pegasus]

Updated with a fix for Smart Frequency setting to one year when page comments are disabled, regardless of the edit frequency of the page. Version 1.0.6.