Page 1 of 3

ACP problems

Posted: Sun Dec 07, 2008 10:42 pm
by mcdanielnc89
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.

Re: ACP problems

Posted: Sun Dec 07, 2008 11:06 pm
by blueray2048
Could the delete all board cookies link at the bottom of forum index page helps your issue ?

Re: ACP problems

Posted: Sun Dec 07, 2008 11:14 pm
by mcdanielnc89
No, that doesn't work either. I've tried that.

Re: ACP problems

Posted: Mon Dec 08, 2008 12:12 am
by blueray2048
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.

Re: ACP problems

Posted: Mon Dec 08, 2008 2:33 am
by mcdanielnc89
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

Re: ACP problems

Posted: Mon Dec 08, 2008 2:46 am
by Phil
Remove the square brackets ([ ]) and the "mysql >" prefix, then try again.

Re: ACP problems

Posted: Mon Dec 08, 2008 2:58 am
by mcdanielnc89
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'

Re: ACP problems

Posted: Mon Dec 08, 2008 3:04 am
by stevemaury
user_id is a number. You put in username.

Re: ACP problems

Posted: Mon Dec 08, 2008 3:17 am
by mcdanielnc89
K Still getting
Access to the Administration Control Panel is not allowed as you do not have administrative permissions.

Re: ACP problems

Posted: Mon Dec 08, 2008 3:41 am
by blueray2048
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;

Re: ACP problems

Posted: Mon Dec 08, 2008 4:42 am
by mcdanielnc89
Here's a screenshot, didn't exactly know what you wanted.

Re: ACP problems

Posted: Mon Dec 08, 2008 5:02 am
by blueray2048
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,

Re: ACP problems

Posted: Mon Dec 08, 2008 5:05 am
by mcdanielnc89
And here ya go!

Re: ACP problems

Posted: Mon Dec 08, 2008 6:16 am
by blueray2048
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,

Re: ACP problems

Posted: Mon Dec 08, 2008 6:34 pm
by mcdanielnc89
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.