EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Update error - charset (https://www.eqemulator.org/forums/showthread.php?t=41960)

Cusser 07-09-2018 11:26 PM

Update error - charset
 
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 07-09-2018 11:47 PM

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 07-10-2018 12:07 AM

Quote:

Originally Posted by Uleat (Post 259228)
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 07-10-2018 06:30 PM

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 :)


All times are GMT -4. The time now is 11:17 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.