Update error - charset

[Cusser]

In 2018_07_07_data_buckets.sql

ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

Change to:

ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; (remove the mb4)

[Uleat]

The 'mb4' is a requirement of newer MySQL/MariaDB installs.

There's a vulnerability that is covered by that change..and isn't backwards compatible...


This will probably become more of a prevalent issue as time goes on.

[Cusser]

The 'mb4' is a requirement of newer MySQL/MariaDB installs.

ok thanx, is this project looking at moving to a newer required sql in the future? Im using 5.1.72 right now

[Uleat]

I don't think this issue is fully realized as yet...

I ran into this last year and may have seen one or two posts related.


Yours is the first post I've seen describing a fix :)