Upgrading

[Ikoru]

I'm trying to upgrade my forum to 3.6.3 and all I'm getting is it's saying I have an database error in class_core.php on line 273. I deleted my old class_core.php and uploaded a new one but still the error continues.

Access denied for user 'root'@'localhost' (using password: NO)
/forum/upload/includes/class_core.php on line 273

Thanks for any help.

[Boxy]

The most likely cause of this error is that the info in your config.php file is wrong or your database user does not have full permissions to this database. Please read this for all the known causes of this error:

http://www.vbulletin.com/forum/showthread.php?t=145384

[Ikoru]

Would this be the config.php in 3.6.3 or the old one in 3.6.2?

[Boxy]

The config file is not overwritten as there is no config.php file included in the package. The new version will use the existing config file unless you renamed and edit the config,php.new file that is included in the package.

[Ikoru]

The config file is not overwritten as there is no config.php file included in the package. The new version will use the existing config file unless you renamed and edit the config,php.new file that is included in the package.

Well it told me to rename config.php.new to config.php when running upgrade.php.

[Ikoru]

I've just redone my config.php, recreated the account on the database and put the username and password in. The forum works fine. The only thing I've changed since I've uploaded 3.6.2 is class_core.php which errored for me so I uploaded a new copy. The error is on class_core.php on line 273 and I'm sure information must be wrong there but I'm not sure what.

This is line 273 in my current class_core.php: while ($link == false AND $this->reporterror);

This is line 273 on the uploaded one which is erroring: $link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);

[Ikoru]

Can anyone help?

[Steve Machol]

What is the current error?

[Ikoru]

What is the current error?

I've taken out the link to the upgrade.php and IP for any safety reasons but:

Database error in vBulletin :

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

MySQL Error :
Error Number :
Date : Tuesday, November 14th 2006 @ 12:52:57 PM
Script : /forum/upload/install/upgrade.php
Referrer :
IP Address : **.***.***.***
Username :
Classname : vb_database

[Steve Machol]

All the known causes of that error are in the link Jo posted in post #2.

Why are you using the root user? You should create a non-root db user for this.

[Ikoru]

All the known causes of that error are in the link Jo posted in post #2.

Why are you using the root user? You should create a non-root db user for this.

How do I do that? I've gone through the second post and all of my details are correct. There is no trouble with my forum running normally just when I try to upgrade to 3.6.3. Could you point me into a more clear direction please?

[Steve Machol]

Here is our online documentation for creating a new database and db user:

http://www.vbulletin.com/docs/html/create_database

And from the MySQL site:

http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html

[Ikoru]

Here is our online documentation for creating a new database and db user:

http://www.vbulletin.com/docs/html/create_database

And from the MySQL site:

http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html

I can't see anything I haven't done. I still don't know what you mean by non-root, I use cpanel.

[Steve Machol]

You are using the root user as per your post:

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

My recommendation is not to use root. Sorry that wasn't clear.

[Ikoru]

You are using the root user as per your post:

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

My recommendation is not to use root. Sorry that wasn't clear.

How do I not use root though?

[Steve Machol]

See post #12.

[Ikoru]

See post #12.

I can't find anything in the links about root. On the my config file there's nothing about root. Everything set to how the vb manual told me to create it. Sorry if I'm becoming an hassle but I can't work this out.

[Steve Machol]

You create a db user and db. The instructions are hewre:


http://www.vbulletin.com/docs/html/create_database

And here:

http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html

[Ikoru]

You create a db user and db. The instructions are hewre:


http://www.vbulletin.com/docs/html/create_database

And here:

http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html

I gave up last time and have now decided to try again and once again nothing has worked. The only thing I can think of doing now is creating a new forum that is version 3.6.4 and then importing the database to it.

[Steve Machol]

That wouldn't fix this because you would still need a valid db user and database. And if you had that info you could just use that in your existing config.php file.

[Ikoru]

That wouldn't fix this because you would still need a valid db user and database. And if you had that info you could just use that in your existing config.php file.

I've upgraded before though and everything was fine. This is the only time it's happened. The only thing that's not filled in on the config.php is the part about slave something.

[Ikoru]

I've again tried to update to the latest version with no success. Is there any other reasons why I can't upgrade other than the correct details are not used?

[peterska2]

Please start a new thread in the relevant forum for your issue ensuring that you provide as much detail as possible.