Error in Accounting Books

Using my Dolibarr
1

If I open the accounting, instructions appear.
Step 1 tells me to go to Settings / Accounting Books, but this error appears (in Italian):

Dolibarr ha rilevato un errore tecnico.
Quest'informazione può essere utile per fini diagnostici (puoi settare l'opzione $dolibarr_main_prod su "1" per rimuovere questa notifica):
Data: 20180622070852
Dolibarr: 7.0.2
Livello di funzionalità: 0
PHP: 7.1.18
Server: Apache
SO: Linux MY-SERVER-NAME 4.4.0-127-generic #153-Ubuntu SMP Sat May 19 10:58:46 UTC 2018 x86_64
UserAgent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

URL richiesto: /gs-erp/accountancy/admin/journals_list.php?id=35&mainmenu=accountancy&leftmenu=accountancy_admin
Referer: https://MY-DOMAIN-NAME/gs-erp/accountancy/index.php?leftmenu=accountancy_admin
Gestore dei menu: eldy_menu.php

Gestore del tipo di database: mysqli
Ultimo errore di accesso al database: SELECT a.rowid as rowid, a.code as code, a.label, a.nature, a.active FROM gs3rp_accounting_journal as a WHERE a.entity=1 WHERE a.entity = 1 ORDER BY code ASC LIMIT 1001
Codice di ritorno per l'ultimo accesso errato al database: DB_ERROR_SYNTAX
Informazioni sull'ultimo accesso errato al database: 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 'WHERE a.entity = 1 ORDER BY code ASC LIMIT 1001' at line 1
2

Should be fixed soon with 7.0.3

1 Like
3

Hi I have 7.0.3 and is the same problem

Dolibarr ha detectado un error técnico.
Esta información puede ser útil para el diagnóstico (puede configurar la opción $dolibarr_main_prod to ‘1’ para eliminar estas notificaciones):
Fecha: 20180807180607
Dolibarr: 7.0.2
Nivel de funciones: 0
PHP: 7.0.30-0+deb9u1
Servidor: Apache
SO: Linux hostingsrv45.dondominio.com 4.14.0-0.bpo.3-amd64 #1 SMP Debian 4.14.13-1~bpo9+1 (2018-01-14) x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36

URL solicitada: /accountancy/admin/journals_list.php?id=35&mainmenu=accountancy&leftmenu=accountancy_admin
Gestor de menú: eldy_menu.php

Tipo de gestor de base de datos: mysqli
Último error en solicitud de acceso de base de datos: SELECT a.rowid as rowid, a.code as code, a.label, a.nature, a.active FROM dol_accounting_journal as a WHERE a.entity=1 WHERE a.entity = 1 ORDER BY code ASC LIMIT 1001
Código de retorno de error para la última petición de acceso a la base de datos: DB_ERROR_SYNTAX
Información del último error de petición de acceso de base de datos: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE a.entity = 1 ORDER BY code ASC LIMIT 1001’ at line 1