search

pluginsGLPI / room

Room GLPI plugin
GNU General Public License v2.0
16 stars 12 forks source link

9.3.1/3.1.2alpha: sql error reported: #35

Closed Stoatwblr closed 5 years ago

Stoatwblr commented 5 years ago

Installing works fine, but enabling shows this error:

[2019-01-24 13:22:40] glpisqllog.ERROR: DBmysql::query() in /usr/share/glpi/inc/dbmysql.class.php line 177 ** MySQL query error: SQL: SELECT FROM glpi_profilerights WHERE profiles_id 4 AND name LIKE "%plugin_room%" 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 '4 AND name LIKE "%plugin_room%"' at line 3 Backtrace : inc/dbmysqliterator.class.php:95
inc/dbmysql.class.php:580 DBmysqlIterator->execute() plugins/room/inc/profile.class.php:195 DBmysql->request() inc/plugin.class.php:800 PluginRoomProfile::initProfile() front/plugin.form.php:47 Plugin->activate() {"user":"11@msslyz.mssl.ucl.ac.uk"}

Stoatwblr commented 5 years ago

It looks like inc/profile.class.php line 195 is missing a "=" character

This change fixes the problem here.

C-Duv commented 5 years ago

Fixed, thanks @Stoatwblr.