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 2019-06-25 15:00:01
- ahilles13
- Member
- From: Russia, Murmansk
- Registered: 2019-06-25
- Posts: 11
Problem Update 9.2 to 9.4
good day
When upgrading from version 9.2 to version 9.4 does not update. Error in the log
Migration :: renameTable () in /var/www/glpi/inc/migration.class.php line 586
Cannot rename glpi_slts (OK) tables to glpi_slas (Enough)!
I was doing sudo php bin/console glpi:migration:myisam_to_innodb
not work
I fixed a clean 9.4 version and using glpi to try to restore data from 9.2 version
pls help
thx
Offline
#2 2019-06-25 17:34:58
- KKAdmin
- Member
- From: Germany
- Registered: 2010-03-05
- Posts: 959
Re: Problem Update 9.2 to 9.4
"you have to entirely drop the database, restore your backup and the do the update.", but it sems you did not.
You can mark this threat as [resolved] in subject of your threat. (This is only available edit of the first post.) It is good for users who help others to quickly see which post is still open.
##############################################
GLPI 9.3.3
Offline
#3 2019-06-26 08:14:17
- ahilles13
- Member
- From: Russia, Murmansk
- Registered: 2019-06-25
- Posts: 11
Re: Problem Update 9.2 to 9.4
I have this whole thing on my virtual machine. I completely rolled back the state before the update.
if you update from the beginning, the error is the same
Offline
#4 2019-06-26 13:10:15
- ahilles13
- Member
- From: Russia, Murmansk
- Registered: 2019-06-25
- Posts: 11
Re: Problem Update 9.2 to 9.4
On the working version 9.2 I try to put updates 9.4
backup files to a separate folder
downloaded version 9.4
copied with the replacement in the working folder on the server with GLPI
in the console launched
sudo bin / console glpi: database: update
+ ----------------------- + ----------- + ------------ +
| | Current | Purpose |
+ ----------------------- + ----------- + ------------ +
| Database host | localhost | |
| Database name | glpi | |
| Database user | glpi | |
| GLPI version | 9.2 | 9.4.2 |
| GLPI database version | 9.2 | 9.4.2 |
+ ----------------------- + ----------- + ------------ +
Do you want to continue? [Yes / no] y
================================= Update to 9.2.1 ============ ======================
Migration :: renameTable () in /var/www/glpi/inc/migration.class.php line 586
Cannot rename glpi_slts (OK) tables to glpi_slas (Enough)!
via phpmyadmin renamed the table glpi_slts. the error is gone
there is a new
**@glpi:/var/www/glpi$ sudo bin/console glpi:database:update
+-----------------------+-----------+------------+
| | Current | Назначение |
+-----------------------+-----------+------------+
| Database host | localhost | |
| Database name | glpi | |
| Database user | glpi | |
| GLPI version | 9.2 | 9.4.2 |
| GLPI database version | 9.2 | 9.4.2 |
+-----------------------+-----------+------------+
Do you want to continue ? [Yes/no]y
================================= Обновление до 9.2.1 ==================================
DBmysql::query() in /var/www/glpi/inc/dbmysql.class.php line 177
*** MySQL query error:
SQL: UPDATE `glpi_profilerights` SET `name` = 'slm' WHERE `name` = 'sla'
Error: Duplicate entry '1-slm' for key 'unicity'
Backtrace :
inc/dbmysql.class.php:958
install/update_92_921.php:279 DBmysql->updateOrDie()
inc/update.class.php:406 update92to921()
inc/console/database/updatecommand.class.php:164 Update->doUpdates()
vendor/symfony/console/Command/Command.php:255 Glpi\Console\Database\UpdateCommand->execute()
vendor/symfony/console/Application.php:953 Symfony\Component\Console\Command\Command->run()
inc/console/application.class.php:196 Symfony\Component\Console\Application->doRunCommand()
vendor/symfony/console/Application.php:248 Glpi\Console\Application->doRunCommand()
vendor/symfony/console/Application.php:148 Symfony\Component\Console\Application->doRun()
bin/console:72 Symfony\Component\Console\Application->run()
In dbmysql.class.php line 968:
SLM profilerights migration - Ошибка во время запроса базы данных: UPDATE `glpi_profilerights` SET `name` = 'slm' WHERE `name` = 'sla' - Ошибка - Duplicate entry '1-slm' for key 'unicity'
Offline
#5 2019-06-26 15:08:52
- KKAdmin
- Member
- From: Germany
- Registered: 2010-03-05
- Posts: 959
Re: Problem Update 9.2 to 9.4
If you have a vm can you go back again and try with 9.4.3 ?
You can mark this threat as [resolved] in subject of your threat. (This is only available edit of the first post.) It is good for users who help others to quickly see which post is still open.
##############################################
GLPI 9.3.3
Offline
#6 2019-06-27 08:21:07
- ahilles13
- Member
- From: Russia, Murmansk
- Registered: 2019-06-25
- Posts: 11
Re: Problem Update 9.2 to 9.4
I tried since version 9,2,1
tried 9.3
I think the problem of updating at stage from 9.2 to 9.3
spent almost the entire working day yesterday, but there was no sense
Offline
#7 2019-06-27 08:46:31
- LaDenrée
- HELPER
- Registered: 2012-11-19
- Posts: 6,167
Re: Problem Update 9.2 to 9.4
Check if you have different profiles with same name, the rename one of them.
(this could be the Reason for " SLM profilerights migration - Ошибка во время запроса базы данных: UPDATE `glpi_profilerights` SET `name` = 'slm' WHERE `name` = 'sla' - Ошибка - Duplicate entry '1-slm' for key 'unicity'"
Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6
Offline
#8 2019-06-27 09:17:20
- ahilles13
- Member
- From: Russia, Murmansk
- Registered: 2019-06-25
- Posts: 11
Re: Problem Update 9.2 to 9.4
Good idea
thank
I'll check now
Offline
#9 2019-06-27 09:27:26
- ahilles13
- Member
- From: Russia, Murmansk
- Registered: 2019-06-25
- Posts: 11
Re: Problem Update 9.2 to 9.4
can empty profile fields be this?
Offline
#10 2019-06-27 09:36:50
- ahilles13
- Member
- From: Russia, Murmansk
- Registered: 2019-06-25
- Posts: 11
Re: Problem Update 9.2 to 9.4
****@glpi:/var/www/glpi$ sudo tail -20 /var/www/glpi/files/_log/php-errors.log
2019-06-21 16:34:25 [7@glpi]
From Toolbox::deprecated() in /var/www/glpi/inc/toolbox.class.php line 477
_e() method is deprecated
2019-06-21 16:34:25 [7@glpi]
Backtrace :
inc/toolbox.class.php:478 Toolbox::backtrace()
inc/autoload.function.php:168 Toolbox::deprecated()
plugins/reports/inc/profile.class.php:113 _e()
plugins/reports/front/report.form.php:111 PluginReportsProfile::showForReport()
2019-06-21 16:34:32 [7@glpi]
From Toolbox::deprecated() in /var/www/glpi/inc/toolbox.class.php line 477
_e() method is deprecated
2019-06-21 16:34:32 [7@glpi]
Backtrace :
inc/toolbox.class.php:478 Toolbox::backtrace()
inc/autoload.function.php:168 Toolbox::deprecated()
plugins/reports/inc/profile.class.php:113 _e()
plugins/reports/front/report.form.php:111 PluginReportsProfile::showForReport()
[2019-06-27 10:33:12] glpiphplog.ERROR: Migration::renameTable() in /var/www/glpi/inc/migration.class.php line 586
Невозможно переименовать таблицы glpi_slts(OK) в glpi_slas(Достаточно)! {"user":"@glpi"}
upd.:
all who had empty password fields - set a password
who had the same name - issued a new one
there are no identical names either
I don't know what else to try
Last edited by ahilles13 (2019-06-27 09:48:35)
Offline
#11 2019-07-03 13:36:31
- ahilles13
- Member
- From: Russia, Murmansk
- Registered: 2019-06-25
- Posts: 11
Re: Problem Update 9.2 to 9.4
Hello again
corrected to a clean GLPI system version 9.2 and made an upgrade to version 9,4,1.
Everything went without problems.
I think that the error in the database tables.
I hope for the answer of developers or who can help me
thank
Offline
Pages: 1