Forum GLPI-Project

stoatwblr

Member

Registered: 2014-04-13

Posts: 118

mysql syntax error

0.85.5

When removing the reports plugin, the following error was logged:

  *** MySQL query error:
  SQL: DELETE *
                FROM `glpi_profilerights`
                WHERE `name` LIKE \'plugin_reports_%\'
  Error: 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 '*
                FROM `glpi_profilerights`
                WHERE `name` LIKE 'p' at line 1
  Backtrace :
  inc/dbmysql.class.php:201                         
  plugins/reports/inc/profile.class.php:354          DBmysql->queryOrDie()
  plugins/reports/hook.php:49                        PluginReportsProfile::uninstall()
  inc/plugin.class.php:616                           plugin_reports_uninstall()
  front/plugin.form.php:45                           Plugin->uninstall()

The syntax error is pretty simple: It should be "DELETE FROM", not "DELETE * FROM"

Last edited by stoatwblr (2015-09-17 17:31:07)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: mysql syntax error

Corrected: https://forge.glpi-project.org/projects … isions/318
Many thanks

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)