Re: The CMSB cannot be installed!!!

11 posts by 2 authors in: Forums > CMS Builder
Last Post: June 27 (RSS)

In response to: https://www.interactivetools.com/forum/forum-posts.php?postNum=2242360#post2242360

Hi,

I have the same issue. I am getting the below error message, therefore, I can't install CMSB 3.65.

mysqli: error setting character set utf8mb4: Can't initialize character set utf8mb4 (path: /usr/local/share/mysql/charsets/)

Is there any work around so I can move forward?

Please advise

By Dave - May 27

HI yusuketaga,

It sounds like it might be a MySQL server configuration issue. You should definately have a utf8mb4 charset.

I'd check with your server admin. Also, can you list the files in /usr/local/share/mysql/charsets/ or check what your MySQL version is?

Dave Edis - Senior Developer
interactivetools.com

By yusuketaga - May 28

Hi Dave,

Thank you for your reply.

I' ve asked a server admin, he said, utf8mb4 charset is not supported.

MySQL version is 5.5.

By Dave - May 28

Hi yusuketaga,

It would be good to upgrade to a more recent MySQL if possible, but if note the latest CMSB to support MySQL 5.5 was version 3.63.

If you need a copy of that feel free to email me direct and I'll see if I can find it for you.

Hope that helps!

Dave Edis - Senior Developer
interactivetools.com

By yusuketaga - May 28

Hi Dave,

I will try 3.61. since this is the closest version to 3.63. I have.

If it doesn't work, I will email asking 3.63.

Thanks!

Yusuke

By Dave - May 29

Ok, sounds good. Good luck and let us know if you need any help.

Dave Edis - Senior Developer
interactivetools.com

By yusuketaga - June 4

No luck on 3.61.

Since the CMSB is installed on client’s active server, we are no longer use it for testing purpose.

We are currently setting up a developing environment so we can try various tests.

I will let you know the result.

Thank you,
Yusuke

By Dave - June 5

Hi Yusuke,

Ok, good luck and let us know if we can help with anything.

It's important to note that MySQL's original utf8 charset is not technically UTF-8, it only uses 3 bytes instead of 4, so it can't store emojis or less common multi-byte characters. So ideally you want to find a way to use an updated database. Although, we completely understand that some projects have restrictions on what you have to work with.

Dave Edis - Senior Developer
interactivetools.com

By yusuketaga - June 6

Hi Dave,

Thank you so much for your kind advice.
I will let my staff know about it.

Thanks,
Yusuke

By yusuketaga - June 26

Hi Dave,

This problem has been solved!
We simply modified "utf8mb4" to "utf8" in several files.

Thanks,
Yusuke