Re: The CMSB cannot be installed!!!

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? 

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.

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!

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

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

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

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.

Hi Dave,

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

Thanks,
Yusuke

Hi Dave,

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

Thanks,
Yusuke