Page 1 of 1

_DB_NOT_UTF8

Posted: Mon Aug 27, 2018 10:06 pm
by gihel
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 ?

Re: _DB_NOT_UTF8

Posted: Tue Aug 28, 2018 8:51 am
by canelli
Please share more information in your issue and configuration.

during installation and upgrade , formalms checks the database default charset that must be UTF8 .

Re: _DB_NOT_UTF8

Posted: Tue Aug 28, 2018 11:20 am
by gihel
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

Re: _DB_NOT_UTF8

Posted: Tue Aug 28, 2018 2:20 pm
by canelli
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

Re: _DB_NOT_UTF8

Posted: Tue Aug 28, 2018 5:02 pm
by gihel
Thank you very much
It's OK now
Congratulations