Bug #5371

sql errors in rights mngt

Added by blerohellec over 4 years ago. Updated about 4 years ago.

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

100%

Category:-
Target version:-

Description

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:353
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 about 4 years ago

fix right - fixed #5371

History

#1 Updated by yllen about 4 years ago

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

Applied in changeset r317.

#2 Updated by blerohellec about 4 years ago

  • Status changed from Resolved to Closed

OK. Solved in 1.8.1

Also available in: Atom PDF