Installation problem Error number: 1046

[jmart]

Hello,

I am having the following installation problem.
-------------------------------------------------------------
Step 2) Connect to the database

Attempting to attach to database

Connect failed: unexpected error from the database.

Error number: 1046

Error description: No database selected

Please ensure that the database and server is correctly configured and try again.
------------------------------------------------------------

any ideas??

My config looks like the following

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['database']['dbname'] = 'username_dbname';

[Steve Machol]

The db info in your config.php file is wrong, or this db doesn't exist. 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

[jmart]

Thank you for this info.

I have been through this many times and I cannot find where I am going wrong with the config file. I was hoping someone could point it out?

[Steve Machol]

Unfortunately it's impossible for us to know what the correct info is for you. Did you create the db and db user and make sure this user is assigned full permissions to that database?

[jmart]

yes

I did all three. Any ideas?

[Steve Machol]

Then something is wrong with the data you've entered in your config.php file. Please read this for all the known causes of this error:

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

[jmart]

It says that there is no database selected.

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

// name of database
$dbname = 'vbulletin';

I see that this is a default value. Wouldn't my value be my db name?

Also I see this note here

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

Note:
cPanel will always preface the database name and database username with your main account username and an underscore.
If you chose the database name [forums] and the database username [user] your database will be [mainusername_forums] and your database username will be [mainusername_user]

I think my problem is somewhere in here?

[Steve Machol]

What do you have for the dbname line?

[jmart]

I have

$config['database']['dbname'] = 'username_dbname';

[Steve Machol]

I doubt that your username on this host is 'username' and the real database name is 'dbname'.

You said you created this db. What is the real name of it?

[jmart]

The db name is forextra_forums

[Steve Machol]

Then that is what you need to use in config.php.

[jmart]

I am using that in the config.php. I can't seem to find where the error is coming from.



Attempting to attach to database

Connect failed: unexpected error from the database.

Error number: 1046

Error description: No database selected

Please ensure that the database and server is correctly configured and try again

I have selected the database

[Steve Machol]

I asked you what that line was and you replied:

I have

$config['database']['dbname'] = 'username_dbname';

Honestly I don't know what more I can tell you. I'm not getting clear answers. All I can say is that you are not using the correct dsb info in config.php and you need to fix this.

[jmart]

The line for the dataase name is as follows

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['database']['dbname'] = 'forextra_forums';

Connection StringsPerl$dbh = DBI->connect("DBI:mysql:forextra_forums:localhost","forextra_admin","<PASSWORD HERE>");PHP$dbh=mysql_connect ("localhost", "forextra_admin", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("forextra_forums");

Is this the correct way to list the line? I am sorry if I mis-informed the line earlier. This is my first attempt at setting a forum db up. I appreciate all your help....