3.7.0 Beta 5 Problem

[Virtualshiner]

Hi
I am trying to perform an upgrade on my forum to vB 3.7 Beta 5.
However, whenever trying to run the upgrade file, I get a database error with this message:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'root'@'localhost' (using password: NO)
/home/disneyma/public_html/vbulletin/includes/class_core.php on line 305

How can I fix this?

Thanks

[WFZ]

Looks like you didnt enter the database password in the .config file, I may be wrong.

[Virtualshiner]

Where do I put that?

[Brandon Sheley]

^ yup
check your db, user and pass in your includes/config.php file

as the read me/docs say ;)

[Virtualshiner]

Yeah but where is that
Im not sure =//

[Guest210212002]

You really need to read the docs, or you're going to run into a lot more problems. This is pretty much the very first section of the upgrade instructions.


Close your board via the Admin Control Panel.

Upload all files from the 'upload/' folder in the zip, with the exception of 'install/install.php'. Then open the 'upload/includes/' folder. In this you will find config.php.new. You should rename this to config.php and then open it in a text editor.


In that file, config.php, is where you put your database settings.

[Virtualshiner]

I know that, I followed that but I dont know where in the config file

[Guest210212002]

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['username'] = 'YOURDBUSER';
$config['MasterServer']['password'] = 'YOURDBPASS';

[Virtualshiner]

Thanks for that, Im getting this now though

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';

[Dismounted]

Please post the whole error.

[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:

// ##### 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.