ACP problems

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
mcdanielnc89
Registered User
Posts: 703
Joined: Tue Feb 06, 2007 10:49 pm
Location: Missouri
Contact:

ACP problems

Post by mcdanielnc89 » Sun Dec 07, 2008 10:42 pm

Your board's URL: http://www.newbreedjesusfreaks.com/2009/community
Version of phpBB3: 3.0.3
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? Update
If update, what package(s) did you use? 3.0.2-3.0.3 upgrade
Did you use an automated wizard provided by your host to install phpBB? Yes
MODs you have installed: None
When the problem started: About 24 hours ago
Your level of expertise (be honest): I know how to edit coding. I don't know php, but I do wonderfully editing it.
Template(s) used: Prosilver
Language(s) used: English
Version of PHP used: 5

I can't login to my ACP. It says I have successfully logged in, but then it tells me i have no admin rights. I am on the admin account. It worked fine after I updated. it just started doing this about 24-48 hours ago.

User avatar
blueray2048
Registered User
Posts: 324
Joined: Mon Sep 25, 2006 5:20 pm
Contact:

Re: ACP problems

Post by blueray2048 » Sun Dec 07, 2008 11:06 pm

Could the delete all board cookies link at the bottom of forum index page helps your issue ?

User avatar
mcdanielnc89
Registered User
Posts: 703
Joined: Tue Feb 06, 2007 10:49 pm
Location: Missouri
Contact:

Re: ACP problems

Post by mcdanielnc89 » Sun Dec 07, 2008 11:14 pm

No, that doesn't work either. I've tried that.

User avatar
blueray2048
Registered User
Posts: 324
Joined: Mon Sep 25, 2006 5:20 pm
Contact:

Re: ACP problems

Post by blueray2048 » Mon Dec 08, 2008 12:12 am

Please run this sql to see then,

Code: Select all

mysql > update [phpbb_]sessions set session_admin = 1 where session_user_id = [your_user_id];
Replace phpbb_ with the prefix that is used on your tables;
Replace your_user_id with your current user id

Should look from this to this

Code: Select all

+----------------------------------+-----------------+---------------+
| session_id                       | session_user_id | session_admin |
+----------------------------------+-----------------+---------------+
| 7a29df126154e4e8ab0918f917c1dd04 | 2               | 0             |
+----------------------------------+-----------------+---------------+

Code: Select all

+----------------------------------+-----------------+---------------+
| session_id                       | session_user_id | session_admin |
+----------------------------------+-----------------+---------------+
| 7a29df126154e4e8ab0918f917c1dd04 | 2               | 1             |
+----------------------------------+-----------------+---------------+
Then try entr ACP again.

User avatar
mcdanielnc89
Registered User
Posts: 703
Joined: Tue Feb 06, 2007 10:49 pm
Location: Missouri
Contact:

Re: ACP problems

Post by mcdanielnc89 » Mon Dec 08, 2008 2:33 am

Error..
SQL query:

mysql > UPDATE [phpbb_]sessions SET session_admin =1 WHERE session_user_id = [NBJF]

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql > update [phpbb_]sessions set session_admin = 1 where session_user_id = [N' at line 1

User avatar
Phil
Former Team Member
Posts: 10403
Joined: Sat Nov 25, 2006 4:11 am
Name: Phil Crumm
Contact:

Re: ACP problems

Post by Phil » Mon Dec 08, 2008 2:46 am

Remove the square brackets ([ ]) and the "mysql >" prefix, then try again.
Moving on, with the wind. | My Corner of the Web

User avatar
mcdanielnc89
Registered User
Posts: 703
Joined: Tue Feb 06, 2007 10:49 pm
Location: Missouri
Contact:

Re: ACP problems

Post by mcdanielnc89 » Mon Dec 08, 2008 2:58 am

Error

SQL query:

UPDATE phpbb_sessions SET session_admin =1 WHERE session_user_id = NBJF

MySQL said: Documentation
#1054 - Unknown column 'NBJF' in 'where clause'

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50562
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: ACP problems

Post by stevemaury » Mon Dec 08, 2008 3:04 am

user_id is a number. You put in username.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

User avatar
mcdanielnc89
Registered User
Posts: 703
Joined: Tue Feb 06, 2007 10:49 pm
Location: Missouri
Contact:

Re: ACP problems

Post by mcdanielnc89 » Mon Dec 08, 2008 3:17 am

K Still getting
Access to the Administration Control Panel is not allowed as you do not have administrative permissions.

User avatar
blueray2048
Registered User
Posts: 324
Joined: Mon Sep 25, 2006 5:20 pm
Contact:

Re: ACP problems

Post by blueray2048 » Mon Dec 08, 2008 3:41 am

After executed the update command, please execute this command also.
And post it here.

Code: Select all

select session_id, session_user_id, session_admin from [phpbb_]sessions;
Replace phpbb_ with the prefix that is used on your tables;

User avatar
mcdanielnc89
Registered User
Posts: 703
Joined: Tue Feb 06, 2007 10:49 pm
Location: Missouri
Contact:

Re: ACP problems

Post by mcdanielnc89 » Mon Dec 08, 2008 4:42 am

Here's a screenshot, didn't exactly know what you wanted.
Attachments
screenshot.png
screenshot.png (49.53 KiB) Viewed 449 times

User avatar
blueray2048
Registered User
Posts: 324
Joined: Mon Sep 25, 2006 5:20 pm
Contact:

Re: ACP problems

Post by blueray2048 » Mon Dec 08, 2008 5:02 am

Yes, that's what I need. Thanks.

Please execute this sql statement

Code: Select all

delete from [phpbb_]sessions where session_user_id = 2;
Also again and post it here,

Code: Select all

select session_id, session_user_id, session_admin from [phpbb_]sessions;
Replace phpbb_ with the prefix that is used on your tables;

Thanks,

User avatar
mcdanielnc89
Registered User
Posts: 703
Joined: Tue Feb 06, 2007 10:49 pm
Location: Missouri
Contact:

Re: ACP problems

Post by mcdanielnc89 » Mon Dec 08, 2008 5:05 am

And here ya go!
Attachments
screenshot1.png
screenshot1.png (37.02 KiB) Viewed 450 times

User avatar
blueray2048
Registered User
Posts: 324
Joined: Mon Sep 25, 2006 5:20 pm
Contact:

Re: ACP problems

Post by blueray2048 » Mon Dec 08, 2008 6:16 am

You may now try login to ACP again.


>> A note to the data above.
You may also need to delete the row the session_user_id has value of 1 ( By default, it is anonymous user ).
Because it might cause security issues.
As I do not have well security related knowledge.
You may need to ask for help on that with anyone who are master. :)


Thanks,

User avatar
mcdanielnc89
Registered User
Posts: 703
Joined: Tue Feb 06, 2007 10:49 pm
Location: Missouri
Contact:

Re: ACP problems

Post by mcdanielnc89 » Mon Dec 08, 2008 6:34 pm

K. i deleted that row an it screwed the forum up....

I then did a backup before hand and it still says that row is missing.

Locked

Return to “[3.0.x] Support Forum”