I locked myself, as Admin, out :(

[falconking]

I mistakenly changed the cookie prefix to bb in PhotoPost and now I can't login as Admin

What should I do to fix this problem

[Chuck S]

Is Photopost in the same database as vbulletin?

You can issue this query in your vb query window under maintenance if you wish to fix the issue

UPDATE pp_settings SET setting='bb' WHERE id=172

[falconking]

Originally Posted by Chuck S

Is Photopost in the same database as vbulletin?

You can issue this query in your vb query window under maintenance if you wish to fix the issue

UPDATE pp_settings SET setting='bb' WHERE id=172

No, it's in a separate database.

I checked my vBullettin settings and found that it is set to blank, not 'bb'. So how should the above query be changed to fix this issue?

Is there a file I can edit to allow me as Admin once again???

Thanx for your support

[Chuck S]

Your cookie prefix is found in your vbulletin config file and I beleive unless you changed that it should be bb.

[falconking]

Originally Posted by Chuck S

Your cookie prefix is found in your vbulletin config file and I beleive unless you changed that it should be bb.

I am a beginner, so go easu on me, plz I have taken the attached snapshot for you to see.

[Chuck S]

Your cookie prefix is found in your vb config.php file which is in your forums includes subdirectory.

Try just running the query I posted. or post a test account and url here so we can see what you have done wrong.

[falconking]

Originally Posted by Chuck S

Your cookie prefix is found in your vb config.php file which is in your forums includes subdirectory.

Try just running the query I posted. or post a test account and url here so we can see what you have done wrong.

Chuck, thank you for your support. Problem solved after deleting everything and re-installing.

Your input will very much be appreciated here, though .

[Chuck S]

No problem have a good weekend.

[falconking]

Originally Posted by Chuck S

Your cookie prefix is found in your vb config.php file which is in your forums includes subdirectory.

Try just running the query I posted. or post a test account and url here so we can see what you have done wrong.

Chuck, please help me! I have run into the same problem as before and now I can't login as admin or as any user, because I changed the cookie prefix to 'bb'.

As you suggested above, and in an attempt to fix this problem, I ran the SQL query: (UPDATE pp_settings SET setting='bb' WHERE id=172), but I received the following error msg: (Table 'xxxxxxx_vb.pp_settings' doesn't exist) afterwards.

BTW, you already have a test account registered in my Photopost under the username: Test

N.B. In the past, I have fixed this problem by reinstalling Photopost, but now I can't do this, as Photopost is full of photos and I can't afford losing them .

Can I use my FTP to fix the problem?

[Chuck S]

You can rerun install again as it will not delete your database tables. You have a standalone photopost not integrated with anything so you dont use a cookie prefix.

You can either reinstall or if you have phpmyadmin on your control panel of the site view the settings table of photopost and for settings 171 172 and 173 make sure cookies are set like this

COOKIE PATH /

COOKIE PREFIX BLANK

COOKIE DOMAIN BLANK

[falconking]

Thnaks, Chuck for your prompt response. Yes I have phpmyadmin in my cP, but from where can I view the settings table of photopost? I mean, which command should I use to reach it?

[falconking]

YES, YES, YES, YES, YES, YES, YES, I found it and fixed it. This was a totally new experience for me, as I have never used phpmyadmin before. I changed it as you said and everything now is back to normal.
I LOVE YOU, CHUCK, YOU JUST MADE MY DAY.

Photopost and all its members should be proud for your service, Chuck

[Chuck S]

Have a good one glad to be of help