Newbie Advice - Stuck On Step 2, Can't Create Table In My Database...

[bad_bob00]

Hi there,

I had a forum which was using a different forum software, and I deleted this and cleared the database.
I am using phpMyAdmin. When I click on my only available database (which is empty) I try and create a table for my database and it asks me for a name, and also asks me to enter a number of fields. I can't leave this number blank, and if I do enter a number it takes me to another screen to enter even more info (which I am not really sure about).

I was trying to read the technical instructions on the vBulletin site, but I wasn't sure whether phpMyAdmin was classed as either of the following:

Setting-up a MySQL Database on the Command Line
Setting-up a MySQL Database in cPanel
Setting-up a MySQL Database in Plesk
Setting-up a MySQL Database in Ensim

(So therefore I was unsure of which instructions to follow).


Also, when I tried setting up the forum using install.php, I get to step 2 - before it says the following:

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.


Could this mean that the database isn't created properly, or that I have enterred some of the wrong information on my config.php file?


Thanks a lot for any help

[Steve Machol]

This means the db info in your config.php file is wrong. Did you create a database?

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

[bad_bob00]

I tried creating a database - well I do have one, and it is currently empty. Don't I need to give it a name and enter a number of fields?

Thanks for the help

[Steve Machol]

No, it will work as long as your db info is correct and the db user has full permissions to the database. Please read this for all the known causes of this error:

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

[bad_bob00]

I'm still not convinced that the database has been set up correctly though - I'm in phpMyAdmin and it says the following on the left hand side of the screen:


username_com (0) (http://phpmyadmin.forum-money.com/db_details_structure.php?db=forum_money_com&token=4ceb37e4496e56ac3db683c3e12e6806)
No tables found in database.


Does it matter that I have no tables?

And regarding the links to documentation you posted, I'm unsure of the category of phpMyAdmin, so am unsure which instructions to follow :(


Thanks for the help so far

[Steve Machol]

That has nothing to do with the error you are getting becaase vB cannot create any tables. Please read this for all the known causes of this error:

http://www.vbulletin.com/forum/showthread.php?t=194542 (http://www.vbulletin.com/forum/showthread.php?t=194542)

[bad_bob00]

I have sorted the problem now, thank you :)