When doing the installation I received the error:
SQL error: DB_ERROR_1366
I searched the forum and found this link and ran it in the browser:
htdocs / install / repair.php? force_utf8_on_tables = confirmed.
reached the end, but was not “successful”.
I started filling in the mandatory data in the configuration and received this error:
Data: 20210119001814
Dolibarr: 12.0.4 - https://www.dolibarr.org
Nível de funções: 0
PHP: 7.2.19
Servidor: Apache/2.4.35 (Win64) OpenSSL/1.1.1b PHP/7.2.19
SO: Windows NT AGT 10.0 build 19041 (Windows 10) AMD64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36
URL solicitada: /dolibar/admin/company.php
Referer: http://localhost/dolibar/admin/company.php?mainmenu=home&action=edit
Administração do menu: eldy_menu.php
Módulos / Aplicações: user
Tipo de gerente de base de dados: mysqli
Últimos erros de acesso ao banco de dados: SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid= AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
Código de retorno do último erro de acesso ao banco de dados: DB_ERROR_SYNTAX
Informação do último erro de acesso ao banco de dados: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_depar’ at line 1
How to solve this problem. It is the second installation I do, there is no data.
Thanks
