Install Error (Mysql)

[BlackRanger3d]

I don't know MYSQL so I don't know where to start.

Here is the error e-mail that I got.

Database error in vBulletin :
Invalid SQL:
CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, forumid)
)
mysql error: Table 'access' already exists
mysql error number: 1050
Date: Friday 03rd of June 2005 10:02:38 PM
Script: http://www.ultimatecheer.ca/forums/install/install.php?step=3
Referer: http://www.ultimatecheer.ca/forums/install/install.php?step=2
IP Address: ***.***.***.***


Versions

PHP 4.3.10
MySQL 3.23.54


TIA

[Floris]

You already have a forum running and you are trying to run install.php ?

[Steve Machol]

Somebody is trying to run install.php again. If this is not you, then you should immediiately remove the install.php file.

[BlackRanger3d]

I am so lost. I am the only person who should be running anything on this server. And this is the first time I have ever run a vb forum on there.

The only thing that is currently on there is a *.php data base that the tech support people at my hosting company created for me to manage basic access to a members area page I have.

Any Suggestions

[Steve Machol]

Back to basics. Are you trying to install vB or is your forum already installed and running?

[BlackRanger3d]

Trying to install VB for the first time. I have never had a forum on this (or anyother) server.

[Floris]

The database you're installing to appears to already have a table called 'access'.

I advise to edit the config.php file and find the variable for $table_prefix (near bottom file) and set it to

jelsoft_

and then run install.php again.

[BlackRanger3d]

I fixed it. I just erased the database that was in there.....

"The only thing that is currently on there is a *.php data base that the tech support people at my hosting company created for me to manage basic access to a members area page I have"

It was a list of about 80 people that I did not need.

The installation process is running smooth now. I hope.

[Floris]

vBulletin has prefix support, so you could have saved that data. But glad to hear installation is running ok now.

Note: http://www.vBulletin.com/docs/html/ online manual; might be handy for you now that you're starting up.

[BlackRanger3d]

Ya I thought about changing prefixes, and that there was already a table there. But I figured the data was not needed and would have been more trouble then it was worth to save.

But Thanks A bunch.

The support alone for this product is worth the price.


PS> Install completed without another hitch. Now I am in the CP.

[Floris]

Thank you for the follow up and the kind feedback (and of course your recent purchase).

Glad things are working out and have fun exploring vBulletin and setting things up.