Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2018, 11:26 PM
Cusser
Sarnak
 
Join Date: Sep 2017
Posts: 60
Default 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)
Reply With Quote
  #2  
Old 07-09-2018, 11:47 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,392
Default

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.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #3  
Old 07-10-2018, 12:07 AM
Cusser
Sarnak
 
Join Date: Sep 2017
Posts: 60
Default

Quote:
Originally Posted by Uleat View Post
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
Reply With Quote
  #4  
Old 07-10-2018, 06:30 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,392
Default

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
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:24 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3