API ne charge pas / Page blanche

JordanGround · Septembre 28, 2020, 6:25

Bonjour,

Lorsque je souhaite accéder à l’API Explorer, une page blanche et un chargement infini, rend le serveur lent durant quelques minutes (ainsi que les autres projets sur le même serveur) et ensuite sort des dizaines d’erreurs sur chrome : Failed to load resource: net::ERR_HTTP2_PROTOCOL_ERROR.

Sur Firefox, même problème, mais de temps en temps deux champs apparaissent sans aucun CSS (Dolapikey et url de l’api) ainsi qu’un bouton mais rien de se passe.

doli

Je suis chez OVH, sous PHP 7.4, avec Dolibarr 12.0.2, avec une installation d’origine sur Dolibarr 4.0.0. Pour ce qui est du SSL, je suis bien en HTTPS sur l’installation.

J’ai ce problème depuis des années, mais j’aimerai aujourd’hui vraiment utiliser l’API mais cela est complètement impossible.

J’ai déjà changer la version de PHP, changer le force_ssl dans le config, activer/désactiver, … et parfois par miracle, sa fonctionne, je me plonge dans l’explorer et d’un coup le problème revient.

Merci pour vos lumières !

ksar · Septembre 28, 2020, 8:06

Bonjour,

Déjà une V4.0.0 c’est antédélvien et non compatible php7.4 : https://wiki.dolibarr.org/index.php/Versions
Une V4 est PHP 7.0 maximum.

Qu’es ce qui vous empeche de faire les mises à jours ?

Si vous ne voulez pas monter de version, il faudrait forcer le php d’OVH à la version 5.6 et faire les mises à jours au moins jusqu’à une V4.0.6

JordanGround · Septembre 28, 2020, 8:59

Bonjour,

Non absolument pas, je suis en version 12.0.2 (12.0.3 depuis quelques minutes), mais j’ai installé dolibarr il y a quelques années quand il était en version 4. Depuis toutes les mises à jours ont été effectuée.

ksar · Septembre 28, 2020, 9:01

Pardon j’ai mal lu votre message.

Vous avez regardé du coté du log des erreurs php ?

JordanGround · Septembre 28, 2020, 9:23

Bonsoir,

Merci pour votre réponse. Mise à part l’erreur que me renvoi Chrome et Firefox, voici le log de Dolibarr au moment de l’accès à l’explorer API :

2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/ - action=, massaction=
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 INFO    MON-IP  --- End access to /api/index.php/explorer/
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/css/typography.css - action=, massaction=
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/handlebars-2.0.0.js - action=, massaction=
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/jquery-1.8.0.min.js - action=, massaction=
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/jquery.ba-bbq.min.js - action=, massaction=
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/jquery.slideto.min.js - action=, massaction=
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/underscore-min.js - action=, massaction=
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/css/screen.css - action=, massaction=
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/css/reset.css - action=, massaction=
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/jquery.wiggle.min.js - action=, massaction=
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 INFO    MON-IP  --- End access to /api/index.php/explorer/css/reset.css
2020-09-28 23:18:57 INFO    MON-IP  --- End access to /api/index.php/explorer/css/typography.css
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/backbone-min.js - action=, massaction=
2020-09-28 23:18:57 INFO    MON-IP  --- Access to /api/index.php/explorer/swagger-ui.js - action=, massaction=
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:57 INFO    MON-IP  --- End access to /api/index.php/explorer/css/screen.css
2020-09-28 23:18:58 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:58 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:58 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:58 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:58 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:58 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/highlight.7.3.pack.js - action=, massaction=
2020-09-28 23:18:58 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/highlight.7.3.pack.js
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/jquery-1.8.0.min.js
2020-09-28 23:18:58 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:58 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:58 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:58 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:58 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:58 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/handlebars-2.0.0.js
2020-09-28 23:18:58 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:58 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:58 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/jsoneditor.min.js - action=, massaction=
2020-09-28 23:18:58 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:58 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:58 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:18:58 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/jquery.slideto.min.js
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/jquery.ba-bbq.min.js
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/underscore-min.js
2020-09-28 23:18:58 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:58 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/swagger-oauth.js - action=, massaction=
2020-09-28 23:18:58 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:58 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:58 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:18:58 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:18:58 INFO    MON-IP  --- Access to /api/index.php/explorer/lib/marked.js - action=, massaction=
2020-09-28 23:18:58 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/marked.js
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/backbone-min.js
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/jsoneditor.min.js
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/jquery.wiggle.min.js
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/lib/swagger-oauth.js
2020-09-28 23:18:58 INFO    MON-IP  --- End access to /api/index.php/explorer/swagger-ui.js
2020-09-28 23:19:03 ERR     MON-IP  Your state setup use an old syntax. Reedit it using setup area.
2020-09-28 23:19:03 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:19:03 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:19:03 DEBUG   MON-IP  Company.lib::getState
2020-09-28 23:19:03 DEBUG   MON-IP  sql=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 mng_c_departements as d, mng_c_regions as r,mng_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=41 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2020-09-28 23:19:03 INFO    MON-IP  --- Access to /api/index.php/explorer/css/print.css - action=, massaction=
2020-09-28 23:19:03 DEBUG   MON-IP  sql=SELECT transkey, transvalue FROM mng_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-09-28 23:19:03 INFO    MON-IP  --- End access to /api/index.php/explorer/css/print.css

Je ne comprend pas tout mais l’erreur qui revient souvent est :

Your state setup use an old syntax. Reedit it using setup area.

Et si je laisse Chrome charger la page durant plusieurs minutes, un joli « 504 Gateway Time-out »

JordanGround · Septembre 28, 2020, 11:44

Après quelques tests de mon coté, l’API fonctionne très bien avec les URLs (exemple : https://<url>/api/index.php/invoices&DOLAPIKEY=<key>).

Le problème est donc seulement à l’affichage de l’explorer, ce qui est tout de même assez dérangeant pour mettre en place l’API.

Merci pour vos aides

JordanGround · Septembre 29, 2020, 12:03

/* UPDATE */

En modifiant dans le fichier de configuration :

$dolibarr_main_force_https='0';
$dolibarr_main_url_root='http://<url>';

Donc en désactivant le SSL et le HTTPS, l’explorer fonctionne parfaitement. Dès que je réactive le HTTPS et le SSL, plus rien ne fonctionne. Pourtant le certificat SSL est bien installé, dolibarr est bien en https.

Avez-vous des informations ?

pascal_z · Septembre 29, 2020, 8:28

Bonjour,

Essayez d’afficher la page à partir d’une fenêtre de navigation privée de firefox ou chrome. Si le problème disparaît cela peut être lié au cache du navigateur ou a d’autres paramètres désactivés avec la navigation privée.
C’est juste une piste qui va vous permettre d’identifier ou d’éliminer une cause probable.

Cdlt

JordanGround · Septembre 29, 2020, 3:59

Bonjour,

En navigation privée, le problème est identique.

La seule solution est de désactiver le SSL et le HTTPS, et dans ce cas, tout fonctionne correctement. Si je réactive le SSL, l’API fonctionne toujours mais pas l’explorer de l’API.

Merci pour ton aide

yves57 · Septembre 29, 2020, 6:53

Bonjour,
J’ai l’impression que c’est un fonctionnement non pris en compte, et je suggère d’aller en causer sur github.com/dolibarr/dolibarr/issues

pascal_z · Septembre 30, 2020, 11:49

Sur votre hébergement OVH vous devez avoir un fichier nommé .ovhconfig
Dans ce fichier il doit y avoir une ligne

app.engine=php

faites un test en remplaçant php par phpcgi pour voir si cela règle le problème

app.engine=phpcgi

Timar · Février 22, 2021, 11:22

Pour ma part, merci pour la solution ça a totalement fonctionné sans désactivation https / SSL comme mentionné ci-dessus.

Hmarais · Octobre 2, 2023, 10:33

J’ai tenté la solution proposée par pascal_z. En effet désormais la page du swagger s’affiche, avec la possibilité de rentrer la DOLAPIKEY, par contre je n’ai pas de route qui s’affiche, et quand j’utilise la route pour récupérer le swagger en json (https:///api/index.php/explorer/swagger.json?DOLAPIKEY=), je n’ai plus de routes non plus, alors que sans la modification de .ovhconfig j’en avais

Hmarais · Octobre 2, 2023, 11:09

J’ai trouvé un autre thread sur le sujet.
En gros, en ajoutant un fichier .htaccess à la racine du dossier de dolibarr et en y mettant la configuration suivante :
SetEnv no-gzip 1

ça fonctionne

gbbn · Octobre 2, 2023, 11:54

Juste pour mon information personnelle et pour ma culture de béotien, qu’est-ce qui fait que cela fonctionne avec cette configuration ?

Hmarais · Octobre 2, 2023, 12:47

Désolé, j’ai corrigé mon message et j’ai ajouté le lien de l’autre thread.
L’explication y est indiquée.

gbbn · Octobre 2, 2023, 1:58

Merci. J’ai essayé, malheureusement sans changement pour moi.

Hmarais · Novembre 6, 2023, 4:22

Ah, désolé