2 Forums on 1 database

[Str8ballin]

Hey Just need some help ive got a forum installed on my database already, my database allows you to add users so my main user is str8ballin for my str8ballin.com forums.

I added another user and wanted to install the forum did all the uploadin got to the install.php part. now it was sayying empty database but that wud delete me othe forum data and thats dumb so i tried to continue and it said this error:

Database error in vBulletin Installer :

Invalid SQL: CREATE TABLE access (
userid int(10) unsigned DEFAULT '0' NOT NULL,
forumid smallint(5) unsigned DEFAULT '0' NOT NULL,
accessmask smallint(5) unsigned DEFAULT '0' NOT NULL
)
mysql error: Table 'access' already exists

mysql error number: 1050

now i find this frustrating i cant install 2 vbulletins on the same database, can somebody point me in the right direction?

[Steve Machol]

Of course you do know you'll need two licenses - one for each forum, right?

There is no reason to run the install script to do this. Just upload the vB files and edit cobnfig.php to point to the current database.

[Str8ballin]

nooooooooooooo i mean I want to have two totally different issue/interest forums running on my 1 mysql database.

Yeah I know the rule.

basically a forum for 1 site and a forum for another site runnin off the same database isnt workin. any ideas?

[Steve Machol]

Then this would require significant hacking since you will need to rename all the tables of one of the vBs. You should ask over at vbulletin.org.

[Str8ballin]

Man this is alot of messing about, its gonna be weeks now before i can even run another forum I mean whos gonna hack it out the good of their heart for me. haha im dissapointed now because ive just bought a new domain and everything

[Yo.]

I would suggest just waiting for vB3 which I believe has table prefixes. There is a hack at vB.org which would solve your problem but it does a preg_replace on every query.