You are not logged in.
- Topics: Active | Unanswered
Announcement
Téléchargez la dernière version stable de GLPI
- Et vous, que pouvez vous faire pour le projet GLPI ? :
Contribuer
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
#1 2016-06-10 07:39:41
- antsharapov
- Member
- Registered: 2015-08-18
- Posts: 5
Errors after upgrading to Ubuntu 16.04 and php7.0
Hi! After upgrading my glpi server to 16.04LTS Ubuntu server, and a php7.0, I've get this in logs (php_errors):
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:232 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 08:21:04 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:232 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 08:21:04 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:233 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 08:21:04 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:233 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 08:21:04 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/problem.class.php:667 DBmysql->numrows()
inc/central.class.php:236 Problem::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 08:21:04 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/problem.class.php:672 DBmysql->numrows()
inc/central.class.php:236 Problem::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()Screenshot with debug enabled - https://yadi.sk/i/MAw_XAs9sPcs5
Offline
#2 2016-06-10 11:34:49
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: Errors after upgrading to Ubuntu 16.04 and php7.0
Version of GLPI used?
Can you give us exacts errors in glpi/files/_logs (php and sql-error.log)?
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
#3 2016-06-10 11:48:25
- antsharapov
- Member
- Registered: 2015-08-18
- Posts: 5
Re: Errors after upgrading to Ubuntu 16.04 and php7.0
GLPI 0.90.3 (/glpi => /usr/share/glpi)
Server
Operating system: Linux SGLPI001 4.4.0-24-generic #43-Ubuntu SMP Wed Jun 8 19:27:37 UTC 2016 x86_64
PHP 7.0.4-7ubuntu2.1 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, calendar, ctype,
curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, json, ldap, libxml, mbstring, mcrypt, mysqli,
mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, standard, sysvmsg, sysvsem, sysvshm, tokenizer,
wddx, xml, xmlreader, xmlwriter, xsl, zlib)
Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files"
upload_max_filesize="2M"
Software: Apache/2.4.18 (Ubuntu) (Apache/2.4.18 (Ubuntu) Server at sglpi001 Port 80)
Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.84 Safari/537.36
Server Software: (Ubuntu)
Server Version: 5.7.12-0ubuntu1
Server SQL Mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Parameters: root@localhost/glpi
Host info: Localhost via UNIX socket
OK/usr/share/glpi/config : OK
OK/usr/share/glpi/files : OK
OK/usr/share/glpi/files/_dumps : OK
OK/usr/share/glpi/files/_sessions : OK
OK/usr/share/glpi/files/_cron : OK
OK/usr/share/glpi/files/_graphs : OK
OK/usr/share/glpi/files/_lock : OK
OK/usr/share/glpi/files/_plugins : OK
OK/usr/share/glpi/files/_tmp : OK
OK/usr/share/glpi/files/_rss : OK
OK/usr/share/glpi/files/_uploads : OK
OK/usr/share/glpi/files/_pictures : OK
OK/usr/share/glpi/files/_log : OK
Libraries
htmLawed version 1.1.21 in (/usr/share/glpi/lib/htmlawed)
phpCas version 1.3.4 in (/usr/share/glpi/lib/phpcas)
PHPMailer version 5.2.8 in (/usr/share/glpi/lib/phpmailer)
ZetaComponent ezcGraph installed in (/usr/share/glpi/lib/zeta/Base): OK
Zend Framework version 2.4.9 in (/usr/share/glpi/lib/Zend)
SimplePie version 1.3.1 in (/usr/share/glpi/lib/simplepie)
TCPDF version 6.2.12 in (/usr/share/glpi/lib/tcpdf)
ircmaxell/password-compat in (/usr/share/glpi/lib/password_compat). Compatitility: Ok
LDAP directories
Server: *
Mysql replicas
Not active
Notifications
Way of sending emails: SMTP+TLS (sitis-glpi@aaqcas01)
Mails receivers
Name: 'help@aaq.basel.aero' Active: Yes
Server: '{aaqcas01/pop/novalidate-cert/notls}INBOX' Login: 'sitis-glpi' Password: Yes
Plugins list
news Name: Alerts Version: 0.90-1.0 State: Enabled
fusioninventory Name: FusionInventory Version: 0.90+1.2 State: Enabled
dashboard Name: Панель отчетов Version: 0.7.3 State: Enabled
formcreator Name: Формы Version: 0.90-1.3.3 State: Enabled
resources Name: Человеческие Ресурсы Version: 2.2.1 State: Enabled2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:218 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:218 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:223 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:223 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:226 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:226 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:228 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:228 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:229 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:229 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:230 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:230 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:232 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:232 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4614 DBmysql->numrows()
inc/central.class.php:233 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/ticket.class.php:4619 DBmysql->numrows()
inc/central.class.php:233 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/problem.class.php:667 DBmysql->numrows()
inc/central.class.php:236 Problem::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** PHP Notice(8): Trying to get property of non-object
Backtrace :
inc/dbmysql.class.php:240
inc/problem.class.php:672 DBmysql->numrows()
inc/central.class.php:236 Problem::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`) LEFT JOIN `glpi_ticketvalidations`
ON (`glpi_tickets`.`id` = `glpi_ticketvalidations`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0
AND `users_id_validate` = \'6\'
AND `glpi_ticketvalidations`.`status` = \'2\'
AND (`glpi_tickets`.`status` NOT IN (\'6\',
\'5\')) ORDER BY date_mod DESC
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4613
inc/central.class.php:218 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`) LEFT JOIN `glpi_ticketvalidations`
ON (`glpi_tickets`.`id` = `glpi_ticketvalidations`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0
AND `users_id_validate` = \'6\'
AND `glpi_ticketvalidations`.`status` = \'2\'
AND (`glpi_tickets`.`status` NOT IN (\'6\',
\'5\')) ORDER BY date_mod DESC LIMIT 0,5
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4618
inc/central.class.php:218 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND (`status` = \'5\')
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'1\') OR `glpi_tickets`.users_id_recipient = \'6\' ) ORDER BY date_mod DESC
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4613
inc/central.class.php:223 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND (`status` = \'5\')
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'1\') OR `glpi_tickets`.users_id_recipient = \'6\' ) ORDER BY date_mod DESC LIMIT 0,5
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4618
inc/central.class.php:223 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`) INNER JOIN `glpi_ticketsatisfactions`
ON (`glpi_tickets`.`id` = `glpi_ticketsatisfactions`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'1\')
OR `glpi_tickets`.`users_id_recipient` = \'6\')
AND `glpi_tickets`.`status` = \'6\'
AND `glpi_ticketsatisfactions`.`date_answered` IS NULL ORDER BY date_mod DESC
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4613
inc/central.class.php:226 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`) INNER JOIN `glpi_ticketsatisfactions`
ON (`glpi_tickets`.`id` = `glpi_ticketsatisfactions`.`tickets_id`)
WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'1\')
OR `glpi_tickets`.`users_id_recipient` = \'6\')
AND `glpi_tickets`.`status` = \'6\'
AND `glpi_ticketsatisfactions`.`date_answered` IS NULL ORDER BY date_mod DESC LIMIT 0,5
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4618
inc/central.class.php:226 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\'))
AND `status` <> \'6\'
AND `global_validation` = \'4\' ORDER BY date_mod DESC
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4613
inc/central.class.php:228 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\'))
AND `status` <> \'6\'
AND `global_validation` = \'4\' ORDER BY date_mod DESC LIMIT 0,5
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4618
inc/central.class.php:228 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'1\') )
AND (`status` IN (\'1\',
\'3\',
\'2\',
\'4\'))
AND NOT ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\') ) ORDER BY date_mod DESC
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4613
inc/central.class.php:229 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'1\') )
AND (`status` IN (\'1\',
\'3\',
\'2\',
\'4\'))
AND NOT ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\') ) ORDER BY date_mod DESC LIMIT 0,5
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4618
inc/central.class.php:229 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'3\'))
AND (`status` IN (\'1\',
\'3\',
\'2\',
\'4\'))
AND NOT ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\') )
AND NOT ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'1\') ) ORDER BY date_mod DESC
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4613
inc/central.class.php:230 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'3\'))
AND (`status` IN (\'1\',
\'3\',
\'2\',
\'4\'))
AND NOT ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\') )
AND NOT ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'1\') ) ORDER BY date_mod DESC LIMIT 0,5
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4618
inc/central.class.php:230 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\') )
AND (`status` IN (\'2\',\'3\')) ORDER BY date_mod DESC
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4613
inc/central.class.php:232 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\') )
AND (`status` IN (\'2\',\'3\')) ORDER BY date_mod DESC LIMIT 0,5
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4618
inc/central.class.php:232 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\'))
AND `status` = \'4\' ORDER BY date_mod DESC
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4613
inc/central.class.php:233 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id`
FROM `glpi_tickets`
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`)WHERE `glpi_tickets`.`is_deleted` = 0
AND ( (`glpi_tickets_users`.`users_id` = \'6\'
AND `glpi_tickets_users`.`type` = \'2\'))
AND `status` = \'4\' ORDER BY date_mod DESC LIMIT 0,5
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_tickets.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/ticket.class.php:4618
inc/central.class.php:233 Ticket::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_problems`.`id`
FROM `glpi_problems`
LEFT JOIN `glpi_problems_users`
ON (`glpi_problems`.`id` = `glpi_problems_users`.`problems_id`)
LEFT JOIN `glpi_groups_problems`
ON (`glpi_problems`.`id` = `glpi_groups_problems`.`problems_id`)WHERE `glpi_problems`.`is_deleted` = 0
AND ( (`glpi_problems_users`.`users_id` = \'6\'
AND `glpi_problems_users`.`type` = \'2\'))
AND (`status` IN (\'3\',\'2\')) ORDER BY date_mod DESC
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_problems.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/problem.class.php:666
inc/central.class.php:236 Problem::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()
2016-06-10 12:43:30 [6@SGLPI001]
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_problems`.`id`
FROM `glpi_problems`
LEFT JOIN `glpi_problems_users`
ON (`glpi_problems`.`id` = `glpi_problems_users`.`problems_id`)
LEFT JOIN `glpi_groups_problems`
ON (`glpi_problems`.`id` = `glpi_groups_problems`.`problems_id`)WHERE `glpi_problems`.`is_deleted` = 0
AND ( (`glpi_problems_users`.`users_id` = \'6\'
AND `glpi_problems_users`.`type` = \'2\'))
AND (`status` IN (\'3\',\'2\')) ORDER BY date_mod DESC LIMIT 0,5
Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'glpi.glpi_problems.date_mod' which is not in SELECT list; this is incompatible with DISTINCT
Backtrace :
inc/problem.class.php:671
inc/central.class.php:236 Problem::showCentralList()
inc/central.class.php:83 Central::showMyView()
inc/commonglpi.class.php:469 Central::displayTabContentForItem()
ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()Offline
#4 2016-07-07 21:02:11
- lf.suporte
- Member
- Registered: 2016-07-07
- Posts: 1
Re: Errors after upgrading to Ubuntu 16.04 and php7.0
Im having the same issue.
Any solution?
PHP 7 is incompatible!
Offline
#5 2016-07-08 06:45:37
- remi
- GLPI-DEV
- From: Champagne
- Registered: 2007-04-28
- Posts: 7,127
- Website
Re: Errors after upgrading to Ubuntu 16.04 and php7.0
> Server Version: 5.7.12-0ubuntu1
This is not a PHP issue, but a MySQL one, 5.7 is not supported
https://github.com/glpi-project/glpi/issues/627
Isn't Ubuntu providing MariaDB ?
Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/
Offline