Added Prefix to vBulletin Install, Cant Login

[WeST]

We recently added a prefix to our vBulletin database which is integrated with vB3/Photopost 7. Now I am unable to login, and I dont see a section where I can define a prefix for the user database, or the vBulletin authentication database. How do I get around this?

[Chuck S]

The setting is in your database.

Maybe run a query like this with the correct info

UPDATE pp_settings SET setting='vb3_' WHERE id=83;

[WeST]

Originally Posted by Chuck S

The setting is in your database.

Maybe run a query like this with the correct info

UPDATE pp_settings SET setting='vb3_' WHERE id=83;

Thank you. Now it shows me the "Profile" and "My Photos" option at the main screen of Photopost. However when I visit adm-index it still says I dont have permissions to view it. If there anything else im missing?

[Chuck S]

My suggestion is maybe rerunning the install and specify the correct information I can not be sure what else you have changed but try logging into the admin panel.

[WeST]

Originally Posted by Chuck S

My suggestion is maybe rerunning the install and specify the correct information I can not be sure what else you have changed but try logging into the admin panel.

There isnt an option to define a prefix for the vbulletin username database.

[Chuck S]

not really sure what your referring to as vbulletin uses ONE GLOBAL table prefix for all its tables and thats in your vb config file.

You simply need to install our program correctly with all the correct information to have a successful install. You stated all you changed was a table prefix and I gave you a query to update just that but if you changed lots of stuff your going to want to rerun and go through an install to update all settings. Maybe you also changed your database info to the forum. I have seen people do this alot.