Page 1 of 1

Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Tue Jul 09, 2019 1:26 pm
by dianakoenraadt
Hi all,

I've been going through several posts on here to try to help resolve two errors. Our forum is currently in a unusable state, I'm afraid.

1. Intermittently, I get "The submitted form was invalid. Try submitting again." when logging in.
2. After logging in, after a very very veeerry short amount of time (seconds), I am suddenly logged out.

I've tried: changed the cookie settings, reset all sessions and purged the cache. It's really tough to do, because when I click on the ACP link, I often get "Access to the Administration Control Panel is not allowed as you do not have administrative permissions." which is because I got logged out again. I ended up edited the cookie settings via the database directly, but alas no resolution yet.

Are there any other things I can try to resolve this?

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Tue Jul 09, 2019 1:50 pm
by stevemaury
Please fill out the Support Request Template and post it back here to enable us to assist you better. Please include your cookie settings.

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Tue Jul 09, 2019 2:13 pm
by dianakoenraadt
Support Request Template
What version of phpBB are you using? phpBB 3.2.7
What is your board's URL? n/a (PM me)
Who do you host your board with? Antagonist
How did you install your board? I used a tool provided by my host
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.2.6
What styles do you currently have installed? can't tell because I can't reach the ACP. Default I believe.
What language(s) is your board currently using? default, I believe
Which database type/version are you using? MariaDB
What is your level of experience? Comfortable with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Automatic updates were enabled at the host side.
Please describe your problem. 1. Intermittently, I get "The submitted form was invalid. Try submitting again." when logging in.
2. After logging in, after a very very veeerry short amount of time (seconds), I am suddenly logged out.
Generated by SRT Generator

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Tue Jul 09, 2019 2:51 pm
by stevemaury
Run this query and report back the results: ( Executing SQL Queries in phpMyAdmin )

Code: Select all

SELECT config_value FROM phpbb_config WHERE config_name = 'cookie_domain';
SELECT config_value FROM phpbb_config WHERE config_name = 'cookie_path';
SELECT config_value FROM phpbb_config WHERE config_name = 'cookie_secure';
SELECT config_value FROM phpbb_config WHERE config_name = 'cookie_domain';
SELECT config_value FROM phpbb_config WHERE config_name = 'server_protocol';
SELECT config_value FROM phpbb_config WHERE config_name = 'form_token_sid_guests';
If your table prefix is not phpbb_ change accordingly.

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Tue Jul 09, 2019 3:02 pm
by dianakoenraadt
Results, respectively:

.mydomain.nl
/
0
.mydomain.nl
http://
1


(Domain itself anonymized here, rest assured the leading dot is there)

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Tue Jul 09, 2019 4:20 pm
by warmweer
dianakoenraadt wrote:
Tue Jul 09, 2019 2:13 pm

How did you install your board? I used a tool provided by my host

What version of phpBB3 did you update from? phpBB 3.2.6

What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Automatic updates were enabled at the host side.
One of the boards I had to fix recently had similar problems and had exactly the same as what I quoted from your SRT.

For one, host installs are not recommended since there is no guarantee the files haven't been changed to suit the host's "needs"
3.2.6 had some problems.
Automatic updating is not recommended (and is totally unnecessary if the files are the original files).

I didn't fix it myself (lack of time) but suggested the following actions (and it worked).
Replace all phpBB files with new 3.2.7 (the board had no modifications, nor extensions) (NO OVERWRITING the config.php of course)
In the database, set the version to 3.2.5 (phpBB_config table), delete all entries in the migrations table referencing 3.2.6 and 3.2.7.
Empty the /cache directory except for index.htm and .htaccess
In /store delete any migrationsxxx, install_config.php and io.lock.
Then browser to yourforum/install and the update process ran smoothly (from what I was told).

Warning: if you decide to try this - just in case, backup your database (and in this case perhaps the files also)
In future: don't use autoupdate especially you shouldn't since you do have experience with php (and phpBB).


Added: Oops, forgot to mention that the procedure seems to have worked. No other feedback yet. (also fixed a load of typo's in my post)

And another add: The fix for the backup restore function is in this post viewtopic.php?f=556&t=2516006#p15284176.

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Tue Jul 09, 2019 6:32 pm
by stevemaury
Run this SQL:

Code: Select all

UPDATE phpbb_config SET config_value = 0 WHERE config_name = 'form_token_sid_guests'

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Wed Jul 10, 2019 12:23 pm
by skybound
stevemaury wrote:
Tue Jul 09, 2019 6:32 pm
Run this SQL:

Code: Select all

UPDATE phpbb_config SET config_value = 0 WHERE config_name = 'form_token_sid_guests'
Tried that now, and has not made a difference. Also issue started after latest upgrade to 3.2.7

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Wed Jul 10, 2019 12:45 pm
by KevC
skybound wrote:
Wed Jul 10, 2019 12:23 pm
stevemaury wrote:
Tue Jul 09, 2019 6:32 pm
Run this SQL:

Code: Select all

UPDATE phpbb_config SET config_value = 0 WHERE config_name = 'form_token_sid_guests'
Tried that now, and has not made a difference. Also issue started after latest upgrade to 3.2.7
Have you posted in the right topic? You're not the topic starter.

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Wed Jul 10, 2019 1:21 pm
by skybound
KevC wrote:
Wed Jul 10, 2019 12:45 pm
skybound wrote:
Wed Jul 10, 2019 12:23 pm
stevemaury wrote:
Tue Jul 09, 2019 6:32 pm
Run this SQL:

Code: Select all

UPDATE phpbb_config SET config_value = 0 WHERE config_name = 'form_token_sid_guests'
Tried that now, and has not made a difference. Also issue started after latest upgrade to 3.2.7
Have you posted in the right topic? You're not the topic starter.
Yes correct topic. Also experiencing the staying logged in issue since upgrade.

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Wed Jul 10, 2019 2:03 pm
by KevC
It's better to start a new topic though in case your problem is not exactly the same as the topic starters' otherwise it can get confusing trying to fix two issues on two different boards at the same time.

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Wed Jul 10, 2019 2:37 pm
by skybound
Will do. :oops:

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Wed Jul 10, 2019 2:47 pm
by dianakoenraadt
Thank you for your replies.
I had already contacted the host, but they directed me here. I have now contacted the host again, to ask if they have encountered this before with other customers.

@stevemaury, what does 'form_token_sid_guests' do?
@warmweer, if nothing else comes up, I'll do what you suggest as soon as I can.

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Wed Jul 10, 2019 10:49 pm
by stevemaury
Ties forms to Guest session IDs, or not.

Re: Problems with logging in and staying logged in since upgrade to 3.2.7

Posted: Thu Jul 11, 2019 11:09 am
by dianakoenraadt
Thank you for your reply. Will try your suggestion later today.

@warmweer: Host indicates no phpBB files were changed by them at all.

Not that I won't try your suggestion if all else fails.