Unable to log into ACP (refreshes)

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Ideas Centre
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Unable to log into ACP (refreshes)

Post by Oyabun1 » Sun Jun 21, 2015 10:21 pm

Cookie settings are now correct.

It could be a database problem. In phpMyAdmin you may have the option to repair all tables, if so, do that, if not, run a repair on the sessions, sessions_keys, and users tables.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Cable Player
Registered User
Posts: 516
Joined: Thu Feb 03, 2011 4:45 pm
Location: Hampshire, England

Re: Unable to log into ACP (refreshes)

Post by Cable Player » Mon Jun 22, 2015 12:52 am

Hi,
Having repaired all tables they all came back "OK" apart for phpbb_sessions

xx.phpbb_sessions repair note: The storage engine for the table doesn't support r...


I've run repairs before with the same host and haven't had this come back before.

Thanks

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Unable to log into ACP (refreshes)

Post by Oyabun1 » Mon Jun 22, 2015 1:09 am

If that table uses the InnoDB storage engine then the repair command won't work. (It's strange that your database uses a mix of storage engines.)

How many records are in the sessions table?
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Cable Player
Registered User
Posts: 516
Joined: Thu Feb 03, 2011 4:45 pm
Location: Hampshire, England

Re: Unable to log into ACP (refreshes)

Post by Cable Player » Mon Jun 22, 2015 1:24 am

Hi, there's 29,580 rows in phpbb_sessions.

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Unable to log into ACP (refreshes)

Post by Oyabun1 » Mon Jun 22, 2015 2:40 am

That is too many.

Run this SQL query

Code: Select all

TRUNCATE TABLE phpbb_sessions
Change phpbb_ if that is not your table prefix.

Note that running the query will log out everyone, so it is best done when the board is quite.

Always backup the database before making any changes to it.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Cable Player
Registered User
Posts: 516
Joined: Thu Feb 03, 2011 4:45 pm
Location: Hampshire, England

Re: Unable to log into ACP (refreshes)

Post by Cable Player » Mon Jun 22, 2015 1:25 pm

Hi, that did the trick, I'm back into the ACP.
Is there anything else I need to do, or is that it?

Thanks :)

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Unable to log into ACP (refreshes)

Post by Oyabun1 » Mon Jun 22, 2015 9:56 pm

That should do it.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Cable Player
Registered User
Posts: 516
Joined: Thu Feb 03, 2011 4:45 pm
Location: Hampshire, England

Re: Unable to log into ACP (refreshes)

Post by Cable Player » Tue Jun 23, 2015 10:39 am

Brilliant, thank you for your help :)

Locked

Return to “[3.1.x] Support Forum”