Bug #5371

sql errors in rights mngt

Added by blerohellec about 6 years ago. Updated almost 6 years ago.

Status:ClosedStart date:06/07/2015
Priority:NormalDue date:
Assignee:-% Done:


Target version:-


version 1.8.0 (0.85)

Go to plugin configuration, choose a report from the list -> a list of profiles is displayed.
Change one/several rights (or none) and update -> sql errors are generated (extract hereafter).
1 sql error per profile which is marked as 'No access*', ie which has no right on Tools / Reports.

SQL: UPDATE `glpi_profilerights` SET `rights` = NULL WHERE `id` =\'1565\'
Error: Column 'rights' cannot be null
Backtrace :
inc/commondbtm.class.php:1108 CommonDBTM->updateInDB()
plugins/reports/inc/profile.class.php:169 CommonDBTM->update()
plugins/reports/front/report.form.php:58 PluginReportsProfile::updateForReport()

Associated revisions

Revision 317
Added by yllen almost 6 years ago

fix right - fixed #5371


#1 Updated by yllen almost 6 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Applied in changeset r317.

#2 Updated by blerohellec almost 6 years ago

  • Status changed from Resolved to Closed

OK. Solved in 1.8.1

Also available in: Atom PDF