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.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50667
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 6:36 pm

Did you delete the Anonymous user in the user table, or its session_id in the session table?
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 6:52 pm

session id in the table.

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 8:50 pm

Please run these sql statement.

Code: Select all

select session_id, session_user_id, session_admin from [phpbb_]sessions;
and

Code: Select all

select user_id, user_type, group_id, username, username_clean from [phpbb_]users where user_id = 1;
Replace phpbb_ with the prefix that is used on your tables;

This should looks like this and this,

Code: Select all

+----------------------------------+-----------------+---------------+
| session_id                       | session_user_id | session_admin |
+----------------------------------+-----------------+---------------+
| 9ab9bff629c1756b8d5ae5141943c1cf | 2               | 1             |
+----------------------------------+-----------------+---------------+

Code: Select all

+---------+-----------+----------+-----------+----------------+
| user_id | user_type | group_id | username  | username_clean |
+---------+-----------+----------+-----------+----------------+
| 1       | 2         | 1        | Anonymous | anonymous      |
+---------+-----------+----------+-----------+----------------+
and post it here.

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 9:08 pm

Error

SQL query: Documentation

SELECT session_id, session_user_id, session_admin
FROM phpbb_sessions
LIMIT 0 , 30

MySQL said: Documentation
#1054 - Unknown column 'session_user_id' in 'field list'
Attachments
Untitled.jpg
Untitled.jpg (37.91 KiB) Viewed 231 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 9:23 pm

Why you have such an error ?

Please execute this sql statement.

Code: Select all

describe [phpbb_]sessions;
Replace phpbb_ with the prefix that is used on your tables;
and post it here.

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 9:29 pm

Here ya go.
Attachments
Untitled.jpg
Untitled.jpg (63.11 KiB) Viewed 232 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 10:21 pm

Please run these sql statements.

Code: Select all

alter table [phpbb_]sessions add column session_user_id mediumint(8) unsigned not null default '0' after session_id;
and

Code: Select all

create index session_user_id on [phpbb_]sessions (session_user_id);
re-run these and post it here.

Code: Select all

select session_id, session_user_id, session_admin from [phpbb_]sessions;
and

Code: Select all

describe [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 10:32 pm

Here ya go again...
Attachments
Untitled.jpg
Untitled.jpg (45.59 KiB) Viewed 230 times
Untitled1.jpg
Untitled1.jpg (68.04 KiB) Viewed 229 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 11:00 pm

You may now try again to login to ACP.

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 11:12 pm

Nope.. no workie..

The board is back though, LOL...

It says I have successfully logged in to the ACP, but then i get this msg..
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 » Tue Dec 09, 2008 12:07 am

Please re-run this sql statements and post it here.

Code: Select all

select session_id, session_user_id, session_admin from [phpbb_]sessions;
and

Code: Select all

select user_id, user_type, group_id, username, username_clean from [phpbb_]users where user_id = 1;
Replace phpbb_ with the prefix that is used on your tables;

This should looks like this and this,

Code: Select all

+----------------------------------+-----------------+---------------+
| session_id                       | session_user_id | session_admin |
+----------------------------------+-----------------+---------------+
| 9ab9bff629c1756b8d5ae5141943c1cf | 2               | 1             |
+----------------------------------+-----------------+---------------+

Code: Select all

+---------+-----------+----------+-----------+----------------+
| user_id | user_type | group_id | username  | username_clean |
+---------+-----------+----------+-----------+----------------+
| 1       | 2         | 1        | Anonymous | anonymous      |
+---------+-----------+----------+-----------+----------------+
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 » Tue Dec 09, 2008 12:23 am

k.
Attachments
Untitled.jpg
Untitled.jpg (38.58 KiB) Viewed 231 times
1.jpg
1.jpg (28.55 KiB) Viewed 231 times

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

Re: ACP problems

Post by blueray2048 » Wed Dec 10, 2008 1:49 am

Can you PM me an admin account information to look for what caused that ?

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 » Wed Dec 10, 2008 4:49 am

PM sent.

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

Re: ACP problems

Post by blueray2048 » Wed Dec 10, 2008 1:07 pm

I have checked your forum.
It works fine for me, both FF and IE.

I can PM you back a screen print and a user account I used to login to the forum if you need and allowed.

Please clean-up cookies manually,
  • Firefox 2.0.x
    Tools -> Options -> Privacy -> Show Cookies
    Please delete cookie named newbreedjesusfreaks.com
  • IE 6
    Tools -> Internet Options -> General -> Settings -> View Files
    Please delete cookie named [username]@newbreedjesusfreaks.com
Replace username with your current username.

Then, please try to login to ACP again.

Thanks,



P.S. You may need to log into ACP from another computer.

Locked

Return to “[3.0.x] Support Forum”