Forum GLPI-Project

n00b73

Member

Registered: 2021-11-24

Posts: 2

Have an error in your SQL syntax; check the manual that corresponds

J'ai cette erreur lors de l'installation sur Windows.

" Uncaught Exception mysqli_sql_exception: 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 ''0', `type` int(11) NOT NULL DEFAULT '0' COMMENT 'see' at line 4 in C:\Webserver\nginx\html\glpi\glpi\inc\dbmysql.class.php at line 302"

Versions:

Windows: 10 Pro 20H2
Nginx: 1.20.2
Mysql: 8.0.27
php: 8.1.0
glpi: 9.5.6

Tout cela sur une VM (VMware)

Log:

[2021-11-24 15:28:48] glpiphplog.WARNING: Test logger 
[2021-11-24 15:29:17] glpiphplog.CRITICAL:   *** Uncaught Exception mysqli_sql_exception: 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 ''0',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT 'see' at line 4 in C:\Webserver\nginx\html\glpi\glpi\inc\dbmysql.class.php at line 302
  Backtrace :
  inc\dbmysql.class.php:302                          mysqli->query()
  inc\dbmysql.class.php:831                          DBmysql->query()
  inc\toolbox.class.php:2493                         DBmysql->runFile()
  install\install.php:405                            Toolbox::createSchema()
  install\install.php:677                            step4()

Last edited by n00b73 (2021-11-24 18:03:44)

Odisley

Member

Registered: 2022-01-05

Posts: 3

Re: Have an error in your SQL syntax; check the manual that corresponds

Good afternoon, I had the same problem and found out that it was the PHP version, GLPI works well with php 7 and with php 8 it gave the same problem.

francois-teclib

Expert GLPI

From: TECLIB

Registered: 2006-11-05

Posts: 76

Website

Re: Have an error in your SQL syntax; check the manual that corresponds

Hello,

GLPI 9.5 n'est pas compatible avec PHP 8.1, seulement jusqu'à PHP 8.0 : pour faire l'installation vous devez donc downgrade votre version de PHP.

PHP 8.1 est prévu pour GLPI 10.

++

---

Besoin d'un support professionnel pour GLPI ? Pensez à GLPI Network ! https://glpi-project.org/fr/tarifs/

Connaissez-vous l'offre Cloud maintenue et supportée par l'équipe qui édite GLPI ?
Vous pouvez tester gratuitement pendant 45 jours ! https://glpi-network.cloud (ou plus si besoin)