You are not logged in.
- Topics: Active | Unanswered
Announcement
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
Pages: 1
#1 2016-01-05 22:09:49
- spamma.master
- Member
- Registered: 2016-01-05
- Posts: 70
View user impossible
Viewing a user as Technician leads to an error 500
After some investigation, here is the SQL statement in error:
2016-01-05 18:27:36
*** MySQL query error:
SQL: SELECT *
FROM `glpi_profiles` WHERE (`glpi_profiles`.`interface` = \'helpdesk\') OR (`glpi_profiles`.`interface` = \'central\' AND 98 = (
SELECT count(*)
FROM `glpi_profilerights`
WHERE `glpi_profilerights`.`profiles_id` = `glpi_profiles`.`id`
AND ((`glpi_profilerights`.`name` = \'backup\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'bookmark_public\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'budget\'
AND (`glpi_profilerights`.`rights` | 96) = 96) OR (`glpi_profilerights`.`name` = \'calendar\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'cartridge\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'change\'
AND (`glpi_profilerights`.`rights` | 1151) = 1151) OR (`glpi_profilerights`.`name` = \'changevalidation\'
AND (`glpi_profilerights`.`rights` | 20) = 20) OR (`glpi_profilerights`.`name` = \'computer\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'config\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'consumable\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'contact_enterprise\'
AND (`glpi_profilerights`.`rights` | 96) = 96) OR (`glpi_profilerights`.`name` = \'contract\'
AND (`glpi_profilerights`.`rights` | 96) = 96) OR (`glpi_profilerights`.`name` = \'device\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'document\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'domain\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'dropdown\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'entity\'
AND (`glpi_profilerights`.`rights` | 97) = 97) OR (`glpi_profilerights`.`name` = \'followup\'
AND (`glpi_profilerights`.`rights` | 13319) = 13319) OR (`glpi_profilerights`.`name` = \'group\'
AND (`glpi_profilerights`.`rights` | 1) = 1) OR (`glpi_profilerights`.`name` = \'infocom\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'internet\'
AND (`glpi_profilerights`.`rights` | 31) = 31) OR (`glpi_profilerights`.`name` = \'itilcategory\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'knowbase\'
AND (`glpi_profilerights`.`rights` | 6175) = 6175) OR (`glpi_profilerights`.`name` = \'knowbasecategory\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'link\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'location\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'logs\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'monitor\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'netpoint\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'networking\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'notification\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'password_update\'
AND (`glpi_profilerights`.`rights` | 1) = 1) OR (`glpi_profilerights`.`name` = \'peripheral\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'phone\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'planning\'
AND (`glpi_profilerights`.`rights` | 1) = 1) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_agent\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_blacklist\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_collect\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_configsecurity\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_configuration\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_credential\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_credentialip\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_deploymirror\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_esx\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_group\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_importxml\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_iprange\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_lock\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_menu\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_networkequipment\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_package\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_printer\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_remotecontrol\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_reportnetworkequipment\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_reportprinter\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_rulecollect\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_ruleentity\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_ruleimport\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_rulelocation\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_task\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_unmanaged\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_wol\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'printer\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'problem\'
AND (`glpi_profilerights`.`rights` | 1121) = 1121) OR (`glpi_profilerights`.`name` = \'profile\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'project\'
AND (`glpi_profilerights`.`rights` | 1151) = 1151) OR (`glpi_profilerights`.`name` = \'projecttask\'
AND (`glpi_profilerights`.`rights` | 1025) = 1025) OR (`glpi_profilerights`.`name` = \'queuedmail\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'reminder_public\'
AND (`glpi_profilerights`.`rights` | 31) = 31) OR (`glpi_profilerights`.`name` = \'reports\'
AND (`glpi_profilerights`.`rights` | 1) = 1) OR (`glpi_profilerights`.`name` = \'reservation\'
AND (`glpi_profilerights`.`rights` | 1055) = 1055) OR (`glpi_profilerights`.`name` = \'rssfeed_public\'
AND (`glpi_profilerights`.`rights` | 31) = 31) OR (`glpi_profilerights`.`name` = \'rule_dictionnary_dropdown\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'rule_dictionnary_printer\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'rule_dictionnary_software\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'rule_import\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'rule_ldap\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'rule_mailcollector\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'rule_softwarecategories\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'rule_ticket\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'search_config\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'show_group_hardware\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'sla\'
AND (`glpi_profilerights`.`rights` | 1) = 1) OR (`glpi_profilerights`.`name` = \'software\'
AND (`glpi_profilerights`.`rights` | 127) = 127) OR (`glpi_profilerights`.`name` = \'solutiontemplate\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'state\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'statistic\'
AND (`glpi_profilerights`.`rights` | 1) = 1) OR (`glpi_profilerights`.`name` = \'task\'
AND (`glpi_profilerights`.`rights` | 13329) = 13329) OR (`glpi_profilerights`.`name` = \'taskcategory\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'ticket\'
AND (`glpi_profilerights`.`rights` | 37895) = 37895) OR (`glpi_profilerights`.`name` = \'ticketcost\'
AND (`glpi_profilerights`.`rights` | 31) = 31) OR (`glpi_profilerights`.`name` = \'ticketrecurrent\'
AND (`glpi_profilerights`.`rights` | 1) = 1) OR (`glpi_profilerights`.`name` = \'tickettemplate\'
AND (`glpi_profilerights`.`rights` | 1) = 1) OR (`glpi_profilerights`.`name` = \'ticketvalidation\'
AND (`glpi_profilerights`.`rights` | 3088) = 3088) OR (`glpi_profilerights`.`name` = \'transfer\'
AND (`glpi_profilerights`.`rights` | 1) = 1) OR (`glpi_profilerights`.`name` = \'typedoc\'
AND (`glpi_profilerights`.`rights` | 0) = 0) OR (`glpi_profilerights`.`name` = \'user\'
AND (`glpi_profilerights`.`rights` | 1055) = 1055) OR (`glpi_profilerights`.`name` = \'plugin_fusioninventory_status\'
AND (`glpi_profilerights`.`rights` | ) = ))))
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') = ))))' at line 104
Backtrace :
inc\profile.class.php:507
inc\user.class.php:1805 Profile::currentUserHaveMoreRightThan()
inc\config.class.php:1682 User->currentUserHaveMoreRightThan()
inc\commonglpi.class.php:208 Config->getTabNameForItem()
inc\user.class.php:247 CommonGLPI->addStandardTab()
inc\commonglpi.class.php:158 User->defineTabs()
inc\commonglpi.class.php:689 CommonGLPI->defineAllTabs()
inc\commonglpi.class.php:1124 CommonGLPI->showTabsContent()
front\user.form.php:180 CommonGLPI->display()
Also, if it is useful, we did an upgrade from 0.84 to 0.90+1.0 previously, but no clue if the trouble was already in 0.84
Thanks for help
Offline
#2 2016-01-05 22:36:37
- LaDenrée
- HELPER
- Registered: 2012-11-19
- Posts: 6,287
Re: View user impossible
something is missing in the last line
\'plugin_fusioninventory_status\'
AND (`glpi_profilerights`.`rights` | ???) = ???))))
I guess something is wron with plugin fusion inventory....
did you also upgrade this plugin ?
Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9
Offline
#3 2016-01-05 22:43:26
- LaDenrée
- HELPER
- Registered: 2012-11-19
- Posts: 6,287
Re: View user impossible
looks like this :
Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9
Offline
#4 2016-01-05 22:51:35
- spamma.master
- Member
- Registered: 2016-01-05
- Posts: 70
Re: View user impossible
something is missing in the last line
\'plugin_fusioninventory_status\'
AND (`glpi_profilerights`.`rights` | ???) = ???))))I guess something is wron with plugin fusion inventory....
did you also upgrade this plugin ?
Yes I did, and finally I removed it completely (to clean all data of previous fusioninventory), and reinstalled it properly
No change even after that
Offline
#5 2016-01-05 23:08:37
- LaDenrée
- HELPER
- Registered: 2012-11-19
- Posts: 6,287
Re: View user impossible
do you use other plugins ?
Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9
Offline
#6 2016-01-05 23:10:22
- spamma.master
- Member
- Registered: 2016-01-05
- Posts: 70
Re: View user impossible
Nop, but since i read your signature, Dashboard will be the next one ;-)
Offline
#7 2016-01-06 01:17:03
- spamma.master
- Member
- Registered: 2016-01-05
- Posts: 70
Re: View user impossible
Precision: this doesnt happen in Admin profile, only for Technician at the moment (I did not test other profiles)
Offline
#8 2016-01-15 19:47:04
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: View user impossible
If it's happen only for one profile, it's a problem of right in this profile.
Has this profile right to see Users?
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)
Offline
Pages: 1