Hi,
I had phplist running on php7, I don’t now which version it was. I upgraded the website to php8 but forgot phplist. On this host I can not switch back to php7 easily. When I call the old phplist on php8 there was a white page saying something about an MySql problem.
I uploaded 3.6.15 now, copied the old config and see the login page but I get a message that the login is wrong. I checked the password in phpMyAmin and it is correct.
The old version is still on the server.
Edit: forgot to say, that when I ask for a new password and click on the link, the page to reset the password is completely blank.
How can I get phplist running again?
Thanks a lot for any help.
Forgot to say: the page, where you can reset the password after an email is completely blank
@tpk If you view the html source of the “blank page” then at the end there might be an explanation of what has failed.
Database error 1146 while doing query Table 'DBxxx.phplist_admin_password_request' doesn't exist
Unknown token or time expired (More than 24 hrs. passed since the notification email was sent)
Database error 1146 while doing query Table 'DBxxx.phplist_admin_password_request' doesn't exist
------------------
There is a table missing. The database is obviously not up to scratch.
@tpk The admin_password_request table is not a new table. Possibly it didn’t exist in your previous database. If you have database backups available you could try restoring from an earlier one to see whether that table is present.
Thanks. This table is not in my database and as it is still in the original state a backup should not make any difference?
If I make a new installation with a new database, would it be difficult to import the old data? I am fine in using phpMyAdmin.
@tpk It is simpler to create the table in your current database. This is the sql from my phplist but you will need to change the table prefix from phplist_ if you have a different prefix.
CREATE TABLE `phplist_admin_password_request` (
`id_key` int(11) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
`admin` int(11) DEFAULT NULL,
`key_value` varchar(32) NOT NULL,
PRIMARY KEY (`id_key`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
if the admin table is showing the actual password then you must have been using a very old release of phplist because it now stores a hash of the password. You can work-around this by editing the field in phpmyadmin
Use this web site SHA256 - Online Tools to generate a hash of the actual password, then update the password field in the admin table
Hi Duncan, thanks a lot, creating the table actually helped and I could create a new password and can log in now. Trouble now is that my version is 2.10.19 and I can’t upgrade.
I read that I need to install 3.2.0 in order to update the db. Is that the only way?
@tpk Yes, you do need to upgrade to 3.2.0 first.
Do I need 2.11 first? An AI told me that :-)?
@tpk No, just upgrade to 3.2.0
It works!!! I can’t thank you enough. 
What I don’t get is that according to the footer my version 3.6.15 but it tells me above to download 3.2.2?
On page upgrade it says:
Your database version: 3.6.15
Your database is already the correct version, there is no need to upgrade