_DB_NOT_UTF8

Install and configure FormaLMS and DoceboCE
Post Reply
gihel
FormaLms User
Posts: 56
Joined: Tue Jun 26, 2018 4:36 pm
Version: forma.lms 2.0

_DB_NOT_UTF8

Post by gihel » Mon Aug 27, 2018 10:06 pm

Hi everybody

I don't understand. My BD is utf8_unicode
I already installed formalms on the same host and all was right and now there is problem

Have you an idea about the bug ?

User avatar
canelli
FormaLms Guru
Posts: 469
Joined: Thu Nov 08, 2012 12:21 pm
Version: forma.lms 2.0
Contact:

Re: _DB_NOT_UTF8

Post by canelli » Tue Aug 28, 2018 8:51 am

Please share more information in your issue and configuration.

during installation and upgrade , formalms checks the database default charset that must be UTF8 .
Cercate nel forum le riposte prima di chiedere. Check the forum before posting
---------------
Claudio Anelli
Joint Technologies - Sistemi avanzati per l'information technology

http://www.joint-tech.com
---------------

gihel
FormaLms User
Posts: 56
Joined: Tue Jun 26, 2018 4:36 pm
Version: forma.lms 2.0

Re: _DB_NOT_UTF8

Post by gihel » Tue Aug 28, 2018 11:20 am

When I put the hostname into address and database name I have the message : db will be created but if I click the next step the process turn one hour for nothing

if I put the real database name into database name it say not utf

address must be hostname and database name must be the name of database, isn't ??????

my DB configuration =

Serveur : db751359211.db.1and1.com via TCP/IP
Type de serveur : MySQL
Version du serveur : 5.5.60-0+deb7u1-log - (Debian)
Version du protocole : 10
Utilisateur : dbo751359211@10.46.135.37
Jeu de caractères du serveur : UTF-8 Unicode (utf8)

thank you for help

User avatar
canelli
FormaLms Guru
Posts: 469
Joined: Thu Nov 08, 2012 12:21 pm
Version: forma.lms 2.0
Contact:

Re: _DB_NOT_UTF8

Post by canelli » Tue Aug 28, 2018 2:20 pm

I have the message : db will be created but if I click the next step the process turn one hour for nothing
the mysql user specified in the form must have "create privilege" as general privilege to create a database.
Jeu de caractères du serveur : UTF-8 Unicode (utf8)
this is not the database charset , is the general default of the mysql server
the database that you want to use must be set with UTF.8 charset

you can use the following mysql statement with a mysql command line tool

Code: Select all

CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
ù

or , if you use a phpmyadmin tool , create the db as in the following img:
create_db.png
or change the charset / collaction in the "operations" tab
Cercate nel forum le riposte prima di chiedere. Check the forum before posting
---------------
Claudio Anelli
Joint Technologies - Sistemi avanzati per l'information technology

http://www.joint-tech.com
---------------

gihel
FormaLms User
Posts: 56
Joined: Tue Jun 26, 2018 4:36 pm
Version: forma.lms 2.0

Re: _DB_NOT_UTF8

Post by gihel » Tue Aug 28, 2018 5:02 pm

Thank you very much
It's OK now
Congratulations

Post Reply