Forum GLPI-Project

Bruce79

Member

Registered: 2012-05-23

Posts: 34

Plugin badges

When trying to install Badges 2.1.1 on glpi 0.90.1 I get the following error:

Incorrect integer value: '' for column 'id' at row 1

Whe I look in the sql-errors.log

I see the following

*** MySQL query error:
  SQL: INSERT INTO `glpi_notificationtemplates`(`id`, `name`, `itemtype`, `date_mod`, `comment`, `css`) VALUES (\'\',\'Access Badges Return\',\'PluginBadgesBadge\', NOW(),\'\',\'\');
  Error: Incorrect integer value: '' for column 'id' at row 1
  Backtrace :
  plugins\badges\hook.php:130                       
  inc\plugin.class.php:643                           plugin_badges_install()
  :                                                  Plugin->install()
  front\plugin.form.php:49                           call_user_func()

Bruce79

Member

Registered: 2012-05-23

Posts: 34

Re: Plugin badges

note: solved by accessing the mysql database...

checking the last id number with:
select max(id) from glpi.glpi_notificationtemplates;

manually inserting the correct id with:
INSERT INTO glpi.glpi_notificationtemplates(id, name, itemtype, date_mod, comment, css) VALUES (40,'Access Badges Return','PluginBadgesBadge', NOW(),'','');

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

Re: Plugin badges

Already corrected :
https://github.com/InfotelGLPI/badges/c … 67c8a663b8

Thanks

---

Xavier Caillaud
Blog GLPI Infotel