search

glpi-project / glpi

GLPI is a Free Asset and IT Management Software package, Data center management, ITIL Service Desk, licenses tracking and software auditing.
https://glpi-project.org
GNU General Public License v3.0
4.1k stars 1.27k forks source link

Upgrade 9.4.2 to 9.5.0 not working #13033

Closed Naelven closed 1 year ago

Naelven commented 1 year ago

Code of Conduct

Is there an existing issue for this?

Version

9.4.2

Bug description

I am doing the upgrade from 9.4.2 to 9.5.0 and I got this page Screen Shot 2022-10-19 at 21 26 52

I did as asked in the doc the CLI : mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql and GRANT SELECT ON mysql.time_zone_name TO 'glpi'@'localhost'; FLUSH PRIVILEGES;

When I am trying to do as asked : php bin/console glpi:migration:build_missing_timestamps

I got the error : Votre version de la base de données n'est pas compatible avec la version des fichiers installés. Une mise à jour est nécessaire.

I got blocked in this loop trying to update but while using the bin/console command it is telling me to upgrade my DB.....

If anyone can help,

Thanks

Relevant log output

No response

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

Server

Operating system: Linux XXXXXX 4.19.0-22-amd64 #1 SMP Debian 4.19.260-1 (2022-09-29) x86_64 PHP 7.4.32 fpm-fcgi (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files" upload_max_filesize="2M" Software: nginx/1.22.0 Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36 Server Software: Debian 10 Server Version: 10.3.36-MariaDB-0+deb10u2 Server SQL Mode: Parameters: glpi@localhost/glpi Host info: Localhost via UNIX socket

mysqli extension is installed ctype extension is installed fileinfo extension is installed json extension is installed mbstring extension is installed iconv extension is installed zlib extension is installed curl extension is installed gd extension is installed simplexml extension is installed xml extension is installed ldap extension is installed Zend OPcache extension is installed APCu extension is installed xmlrpc extension is installed exif extension is installed imap extension is not present CAS extension is not present Database version seems correct (10.3.36) - Perfect!Database version seems correct (10.3.36) - Perfect! OK/usr/local/web/htdocs/glpi/files/_log : OK OK/usr/local/web/htdocs/glpi/config : OK OK/usr/local/web/htdocs/glpi/files : OK OK/usr/local/web/htdocs/glpi/files/_dumps : OK OK/usr/local/web/htdocs/glpi/files/_sessions : OK OK/usr/local/web/htdocs/glpi/files/_cron : OK OK/usr/local/web/htdocs/glpi/files/_graphs : OK OK/usr/local/web/htdocs/glpi/files/_lock : OK OK/usr/local/web/htdocs/glpi/files/_plugins : OK OK/usr/local/web/htdocs/glpi/files/_tmp : OK OK/usr/local/web/htdocs/glpi/files/_cache : OK OK/usr/local/web/htdocs/glpi/files/_rss : OK OK/usr/local/web/htdocs/glpi/files/_uploads : OK OK/usr/local/web/htdocs/glpi/files/_pictures : OK Web access to the files directory should not be allowed but this cannot be checked automatically on this instance. Make sure acces to error log file is forbidden; otherwise review .htaccess file and web server configuration. Libraries

htmLawed version 1.2.4 in (/usr/local/web/htdocs/glpi/lib/htmlawed) phpmailer/phpmailer version 6.0.7 in (/usr/local/web/htdocs/glpi/vendor/phpmailer/phpmailer/src) simplepie/simplepie version 1.5.2 in (/usr/local/web/htdocs/glpi/vendor/simplepie/simplepie/library) tecnickcom/tcpdf version 6.2.26 in (/usr/local/web/htdocs/glpi/vendor/tecnickcom/tcpdf) michelf/php-markdown in (/usr/local/web/htdocs/glpi/vendor/michelf/php-markdown/Michelf) true/punycode in (/usr/local/web/htdocs/glpi/vendor/true/punycode/src) iamcal/lib_autolink in (/usr/local/web/htdocs/glpi/vendor/iamcal/lib_autolink) sabre/vobject in (/usr/local/web/htdocs/glpi/vendor/sabre/vobject/lib) zendframework/zend-cache in (/usr/local/web/htdocs/glpi/vendor/zendframework/zend-cache/src) zendframework/zend-i18n in (/usr/local/web/htdocs/glpi/vendor/zendframework/zend-i18n/src) zendframework/zend-serializer in (/usr/local/web/htdocs/glpi/vendor/zendframework/zend-serializer/src) monolog/monolog in (/usr/local/web/htdocs/glpi/vendor/monolog/monolog/src/Monolog) sebastian/diff in (/usr/local/web/htdocs/glpi/vendor/sebastian/diff/src) elvanto/litemoji in (/usr/local/web/htdocs/glpi/vendor/elvanto/litemoji/src) symfony/console in (/usr/local/web/htdocs/glpi/vendor/symfony/console) leafo/scssphp in (/usr/local/web/htdocs/glpi/vendor/leafo/scssphp/src)

SQL replicas

Not active

Notifications

Plugins list

dashboard            Name: Dashboard                      Version: 0.9.4      State: Enabled
ocsinventoryng       Name: OCS Inventory NG               Version: 1.5.4      State: Not installed

Anything else?

No response

trasher commented 1 year ago

This looks like something that can be solved adjusting your database server configuration.

Once done, and server restarted, drop all tables in your broken GLPI database, restore your backup and run migration again.