Howdy everyone, v10 5 2 has been released

Download and install:

http://dadamailproject
com/d/install_dada_mail
pod
html

Changelog:

http://dadamailproject
com/d/changes_10_x
pod
html#pod10
5
2

and below:

10 5 2

This is mostly a bug-fix release for issues found in the v10 5 1 release of Dada Mail

Changes

Rich Filemanager Upgraded to v2 3 2

This is a feature/bugfix version release of Rich Filemanager:

https://github com/servocoder/RichFilemanager/releases/tag/v2 3 2

Bugfixes

MySQL table schema, "dada_message_drafts" does not work for MySQL v5 5 #662

https://github com/justingit/dada-mail/issues/662

Unfortunetely, the schema change we made for the, dada_message_drafts is incompatible with v5 5 of MySQL, so anyone trying to install Dada Mail and using v5 5 of MySQL will fail This new schema:

    CREATE TABLE IF NOT EXISTS dada_message_drafts (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    list varchar(16),
    created_timestamp TIMESTAMP default '0000-00-00 00:00:00', 
    last_modified_timestamp TIMESTAMP DEFAULT NOW() ON UPDATE NOW(),
    name varchar(80), 
    screen varchar(80),
    role varchar(80),
    draft mediumtext
    );

SHOULD work Any previous schemas for this table will be automatically be updated when you run Dada Mail, but you may also do this manually, by either:

Dropping the dada_message_drafts table and recreating it (this will delete ALL mass mailing drafts/stationery/schedules), or issuing the following SQL (current drafts/stationery/schedules should not be removed):

    ALTER TABLE dada_message_drafts MODIFY COLUMN created_timestamp TIMESTAMP default '0000-00-00 00:00:00';
    ALTER TABLE dada_message_drafts MODIFY COLUMN last_modified_timestamp TIMESTAMP DEFAULT NOW() ON UPDATE NOW(); 

This isn't an issue that affects either PostgreSQL or SQLite, only MySQL