Is PHPLIST compatible with MySQL version 8

ℹ️ Support
1

hi people
my hosting company is upgrading to MySql v 8.
i’m running PHPLIST 3.6.7
wondering if my version, which is pretty recent, is ok with MySQL V8?

thanks for any comments. haven’t had time yet to upgrade to the latest phplist.

1 Like
2

Here the fix for Mysql 8.0 login crash

Fix the “IP Tracking” Table (The Core Issue)

Run this SQL command in your phpMyAdmin. This expands the IP columns so they don’t crash the session handler when you have an IPv6 or long IP address:

SQL

-- Fix the IP tracking table to accommodate long IP addresses (MySQL 8 compatibility)
ALTER TABLE phplist_admin_login 
MODIFY remote_ip4 VARCHAR(100) NOT NULL,
MODIFY remote_ip6 VARCHAR(100) NOT NULL,
MODIFY sessionid VARCHAR(191) NOT NULL;

-- Clear the corrupted data that is blocking your current session
TRUNCATE TABLE phplist_admin_login;
TRUNCATE TABLE phplistsessions;
TRUNCATE TABLE phplist_admintoken;

2. Update your config/config.php

Make sure these lines are exactly like this. Using a unique $session_name helps prevent the browser from getting confused by old cookies:

codePHP

// Use a unique name to force the browser to set a fresh cookie
$session_name = 'phplist_secure_session';

// Continue using the database for sessions to bypass file permission issues
$SessionTableName = "phplistsessions";

// Disable the strict IP/Referrer checks that trigger logouts in 3.6.15
define("CHECK_SESSIONIP", 0);
define("CHECK_REFERRER", 0);