Your session was invalidated by a new session in a different browser

ℹ️ Support
1

Hi all,

I’ve upgrade an installation to the latest one and since then I keep getting logged out whenever I click on any link and getting each time the following error:

“Your session was invalidated by a new session in a different browser”

I’m not logged in anywhere else. Cleaned cache, cookies etc same problem.
I’ve also tried to use phpsession table without any luck. It keeps taken me out and have to login each time I click anything.

On top of the main page I also see a text “Database error 1406 while doing query Data too long for column ‘remote_ip4’ at row 1”

Any help is very much appreciated.

2

@mrdebian This looks to be the same problem as reported here phplist logs me off instantly · Issue #1038 · phpList/phplist3 · GitHub

3

It is indeed. Removing the table admin_login as suggested it worked.
I guess I have to wait to the next update to be fixed?

4

I recently had this error, and was able to fix it by going into the database to the phplist_admin_login table and increasing the size of the IP4 field to 50. For those who have deleted the table, here is the SQL to get it set back up, in a way that should work. I had this happen on two installations of phpList at a particular host, so I guess it has something to do with the PHP setup, and what kind of remote address is being detected. In any case, the SQL below will re-create the table. Make sure to run “Verify the DB structure” under the System menu, too. Hope this helps!

CREATE TABLE phplist_admin_login (
id int(11) NOT NULL,
moment bigint(20) NOT NULL,
adminid int(11) NOT NULL,
remote_ip4 varchar(50) NOT NULL,
remote_ip6 varchar(50) NOT NULL,
sessionid varchar(50) NOT NULL,
active tinyint(4) NOT NULL DEFAULT ‘0’
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

1 Like
5

I ran into this problem today. Emptying the admin_login table made no difference. Since this happens any time I want to store a change, I am not able to send out any messages anymore till it’s fixed somehow. It’s the latest phplist, MariaDB, PHP.

6

Did you try increasing the size of the IP4 field, as noted above?

7

Nope I read all the solutions for such problems and tried one or two. Not that one, since I did not find that field in a cursory search of th table. The problem was exhibited in my 2 separate phplist installs on two domains.

Seems a fair amount of people are having these problems based on what I’ve read, going back years.

My solution was to stop looking at folk remedies and to remove the domains from CloudFlare.

Soon as the DNS settings updates propagated, no more problems. Anyone else?

Peace,
Gene