Sauserprefs Plugin

[Bennu]

Not sure what I did when migrating MySQL to a new server: Microsoft Server 2025
I am using roundcube 1.6.9 in IIS 10 with PHP 8.4.1 with MySQL 8.0.40.  Roundcube works but the plugin I used before sauserpref now displays the following when updating any of the fields in its config which it seems to load just fine the defaults, but saving changes give a Database Connection Error:

[Bennu]

Scarth this!  I do not know which of the following fixed this but it did.

I dropped the userpref dadtabase for spamassassin and recreated using:
USE spamassassin;
CREATE TABLE userpref (
  username varchar(100) NOT NULL default '',
  preference varchar(50) NOT NULL default '',
  value varchar(255) NOT NULL default '',
  prefid int(11) NOT NULL auto_increment,
  ts timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY  (prefid),
  KEY username (username)
) ENGINE=InnoDB;

Then before testing after that I enabled all optional features in the sauserpref config file.

One of the two or both did the trick.