[Forum] Why two users tables ?

[jumbo-mumbo]

Hello,

I just wanted to know why there are two tables for users ? I have one called USER and another one called VB_USER .. both of them look same, different size.

Do we need both of them ?

[BBR-APBT]

Looks like you have two installs in one database. You installed one installation under the VB_ prefix and one with out a prefix.

Do you have doubles of everything?

[Paul M]

Nope, you dont both in vbulletin.

Are you using a table prefix ?

If not - does one of the tables belong to a modification you have installed ?

[jumbo-mumbo]

Looks like you have two installs in one database. You installed one installation under the VB_ prefix and one with out a prefix.

Do you have doubles of everything?

No I only got user and thread without VB_ infront .

Nope, you dont both in vbulletin.

Are you using a table prefix ?

If not - does one of the tables belong to a modification you have installed ?

Yes, I guess I am using table prefix..This is what it says in config.php file

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vb_';

I think vb credits are using user's table, but when I tried to change it to vb_user it says no table found..

[Paul M]

Yes, I guess I am using table prefix..This is what it says in config.php file

Yep, the vb_users is your vbulletin users table.

I think vb credits are using user's table, but when I tried to change it to vb_user it says no table found..

Dont know anything about vb credits, but I would have thought it would use the vb users table.

[jumbo-mumbo]

well, I checked vb credit setting it appears to be using user table instead of vb_user (VB Creadits unable to functioning properly)...

[Trevor Hannant]

You will need to try installing it again so that it edits the vb_user table rather than create it's own.

[Darkwaltz4]

vBCredits absolutely does not create any user tables. The setting you are looking at also includes a setting directly below that called "Use the vBulletin table prefix" which is enabled by default and combines with the "user" to arrive at the accurate table "vb_user". According to the screenshot you posted on my site, you have that enabled correctly. If any of this were incorrect, you would be getting database errors about the table not existing.

This post is just to alert you that the vBCredits inclusion is thoroughly a red herring, thanks