3.7.0 Beta 5 Problem

[Marco van Herwaarden]

If i remember correct it is nowhere written in the instructions that you should overwrite your old ./includes/config.php when upgrading.

Unless you come from a 3.0 version, you should just kep your old config.php.

[Virtualshiner]

This is the error I get:

Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:

	SELECT COUNT(*) AS count
	FROM moderation AS moderation
	INNER JOIN post AS post USING (postid)
	WHERE moderation.type='reply';

MySQL Error   : Unknown column 'disneyma_vb.moderation.postid' in 'on clause'
Error Number  : 1054
Date          : Sunday, February 17th 2008 @ 05:59:30 AM
Script        : http://disneymagiconline.com/vbulletin/admincp/index.php?do=home
Referrer      : http://disneymagiconline.com/vbulletin/admincp/index.php?do=nav

[Marco van Herwaarden]

Please make sure that you have uploaded all Beta 5 files. If you are not sure, please redownload them and upload a fresh set.

In the current version of 3.7.0B5 i can only find the folowing in admincp/index.php:

PHP Code:

// ##### Posts to Moderate
$postcount = $db->query_first("
 SELECT COUNT(*) AS count
 FROM " . TABLE_PREFIX . "moderation AS moderation
 INNER JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = moderation.primaryid)
 WHERE moderation.type = 'reply'
"); 


which is not the same as the error you posted.