Project

General

Profile

Feature #8329

Check migration from 1.9 to 1.11

Added by Yannick Warnier about 5 years ago. Updated almost 5 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
-
Category:
Installation / Migration
Target version:
Start date:
13/07/2016
Due date:
% Done:

100%

Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?

Files

parcours_double.jpg (132 KB) parcours_double.jpg Andre Boivin, 23/08/2016 15:15
1_298051IND_20160819-132821.zip (4.92 MB) 1_298051IND_20160819-132821.zip Andre Boivin, 24/08/2016 12:51
quiz.jpg (215 KB) quiz.jpg Andre Boivin, 24/08/2016 13:46
Selection_005.png (13.8 KB) Selection_005.png Julio Montoya, 24/08/2016 13:47
Selection_004.png (71.4 KB) Selection_004.png Julio Montoya, 24/08/2016 13:47

Related issues

Related to Chamilo LMS - Feature #8331: Add support for importation of 1.10 courses into 1.11Feature implemented14/07/2016

Actions
Related to Chamilo LMS - Support #8445: Revision de migracionesNeeds testing27/09/2016

Actions

Associated revisions

Revision fd58d911 (diff)
Added by jmontoyaa almost 5 years ago

Fix import see #8329

Revision d0ec218c (diff)
Added by jmontoyaa almost 5 years ago

Fix query see #8329

Revision 169ba417 (diff)
Added by jmontoyaa almost 5 years ago

Fix query see #8329

History

#1

Updated by Julio Montoya about 5 years ago

First thing is that changes to app/Migrations/Schema/V110/* should be only sent to branch 1.10.x
by a merge changes should be merged to 1.11.x.

#2

Updated by Julio Montoya about 5 years ago

  • Assignee changed from Julio Montoya to Yannick Warnier

I just remember (checking the code) why this was not possible. Because in 1.11 I deleted very old and legacy 1.9.x code. Otherwise we will always carry the 1.9.x legacy.
1.10.x was in charge of that migration. Otherwise I had to add old code and carry with this code in all 1.11.

So I just suggest again to not do this migration.

Is the same case that you cannot migrate from 1.8.x to 1.10.x you have to pass first for 1.9.x.

#3

Updated by Andre Boivin about 5 years ago

Il y aura donc une version 1.10.7 pour éviter la confusion?

#4

Updated by Julio Montoya about 5 years ago

  • Status changed from Assigned to Needs more info
#5

Updated by Yannick Warnier about 5 years ago

  • Status changed from Needs more info to Assigned
  • Assignee changed from Yannick Warnier to Julio Montoya
I can see 3 huge negative impacts from not supporting 2 migrations in one:
  • people can leave a community (like we did with Drupal)
  • customers can leave a provider (I have a few cases)
  • it can also lead to users or customers not migrating to the latest version (too much work in one piece) and drag us down on the maintenance of very old versions

I made one exception for 1.8 to 1.10 (that requires to go through 1.9), but 1.9 to 1.11 has to be supported, even if it's a heavy process.

Deleting legacy code from 1.9 is not a problem (in fact, we did it in 1.9->1.10 migration).
Just compare the files from a 1.9 to a 1.11 and make a list, then add this list to the list of files to be deleted. I will delay the release of 1.11 as long as necessary to make 1.9 to 1.11 migration work.

The vChamilo task is also related to this.

To André: we will release a 1.10.8 this week to fix a set of security vulnerability that have recently been reported.

#6

Updated by Julio Montoya about 5 years ago

As you wish.

#7

Updated by Julio Montoya about 5 years ago

  • Assignee changed from Julio Montoya to Yannick Warnier

I applied some changes. Now it should work.

#8

Updated by Yannick Warnier about 5 years ago

  • Status changed from Assigned to Needs testing
  • % Done changed from 0 to 50

Thank you! We will test it this Wednesday.

#9

Updated by Yannick Warnier about 5 years ago

Angel has made some tests and added a series of fixes but we'll leave this task open until the stable release.

#10

Updated by Andre Boivin almost 5 years ago

J'ai importé 23 'vieux' cours de la 1.9.10 vers la 1.11 et tout c'est bien passé à part quelques notices mais avec le dernier, un plus récent, j'ai ces notices et cet erreur:
Notice: Undefined index: extension in /var/www/html/chamilo/src/Chamilo/CourseBundle/Component/CourseCopy/CourseRestorer.php on line 852

Notice: Undefined index: extension in /var/www/html/chamilo/src/Chamilo/CourseBundle/Component/CourseCopy/CourseRestorer.php on line 852

Notice: Undefined index: extension in /var/www/html/chamilo/src/Chamilo/CourseBundle/Component/CourseCopy/CourseRestorer.php on line 852

Notice: Undefined property: Event::$size in /var/www/html/chamilo/src/Chamilo/CourseBundle/Component/CourseCopy/CourseRestorer.php on line 1475

Notice: Undefined property: Event::$filename in /var/www/html/chamilo/src/Chamilo/CourseBundle/Component/CourseCopy/CourseRestorer.php on line 1476

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE23000: Integrity constraint violation: 1048 Column 'size' cannot be null' in /var/www/html/chamilo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91 Stack trace: #0 /var/www/html/chamilo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91): PDOStatement->execute(Array) #1 /var/www/html/chamilo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(165): Doctrine\DBAL\Driver\PDOStatement->execute(Array) #2 /var/www/html/chamilo/main/inc/lib/database.lib.php(431): Doctrine\DBAL\Statement->execute(Array) #3 /var/www/html/chamilo/src/Chamilo/CourseBundle/Component/CourseCopy/CourseRestorer.php(1479): Database::insert('c_calendar_even...', Array) #4 /var/www/html/chamilo/src/Chamilo/CourseBundle/Component/CourseCopy/CourseRestorer.php(180): Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer->restore_events(0, false, '') #5 /var/www/html/chamilo/main/coursecopy/import_backup.php(99): Chamilo\CourseBundle\Component\CourseCopy in /var/www/html/chamilo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 112

L'archive fait presque 500Mo

#11

Updated by Julio Montoya almost 5 years ago

  • Assignee deleted (Yannick Warnier)
#12

Updated by Andre Boivin almost 5 years ago

  • Assignee set to Julio Montoya

J'ai récupéré ta correction et maintenent avec ce cours j'ai ce message

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`chamilo111`.`c_item_property`, CONSTRAINT `FK_1D84C18129F6EE60` FOREIGN KEY (`to_user_id`) REFERENCES `user` (`id`))' in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:91 Stack trace: #0 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(91): PDOStatement->execute(Array) #1 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Statement.php(165): Doctrine\DBAL\Driver\PDOStatement->execute(Array) #2 D:\usbw\root\chamilo1.11\main\inc\lib\database.lib.php(431): Doctrine\DBAL\Statement->execute(Array) #3 D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php(246): Database::insert('c_item_property', Array) #4 D:\usbw\root\chamilo1.11\main\coursecopy\import_backup.php(99): Chamilo\CourseBundle\Component\CourseCopy\CourseRestore in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 60

Selon toi, est-ce encore un problème de notre vieille base de données?

#13

Updated by Julio Montoya almost 5 years ago

  • Assignee changed from Julio Montoya to Andre Boivin

Andre Boivin wrote:

J'ai récupéré ta correction et maintenent avec ce cours j'ai ce message

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE23000: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`chamilo111`.`c_item_property`, CONSTRAINT `FK_1D84C18129F6EE60` FOREIGN KEY (`to_user_id`) REFERENCES `user` (`id`))' in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:91 Stack trace: #0 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(91): PDOStatement->execute(Array) #1 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Statement.php(165): Doctrine\DBAL\Driver\PDOStatement->execute(Array) #2 D:\usbw\root\chamilo1.11\main\inc\lib\database.lib.php(431): Doctrine\DBAL\Statement->execute(Array) #3 D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php(246): Database::insert('c_item_property', Array) #4 D:\usbw\root\chamilo1.11\main\coursecopy\import_backup.php(99): Chamilo\CourseBundle\Component\CourseCopy\CourseRestore in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 60

Selon toi, est-ce encore un problème de notre vieille base de données?

Je viens d'ajouter une autre modif:

https://github.com/chamilo/chamilo-lms/commit/fd58d911b9acd7ffeaadb7a0705224c6f4cb4a85

#14

Updated by Andre Boivin almost 5 years ago

  • Assignee changed from Andre Boivin to Julio Montoya

J'ai maintenant ce message:

Notice: Undefined index: extension in D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php on line 525

Notice: Undefined index: extension in D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php on line 525

Notice: Undefined index: extension in D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php on line 525

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE23000: Integrity constraint violation: 1048 Column 'lastedit_user_id' cannot be null' in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:91 Stack trace: #0 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(91): PDOStatement->execute(Array) #1 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Statement.php(165): Doctrine\DBAL\Driver\PDOStatement->execute(Array) #2 D:\usbw\root\chamilo1.11\main\inc\lib\database.lib.php(431): Doctrine\DBAL\Statement->execute(Array) #3 D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php(243): Database::insert('c_item_property', Array) #4 D:\usbw\root\chamilo1.11\main\coursecopy\import_backup.php(99): Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer->restore() #5 {main} Next exception 'Doctrine\DBAL\Driver\PDOException' with message 'SQLSTATE23000: Integrity constraint violation: 1048 in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 112

#15

Updated by Julio Montoya almost 5 years ago

  • Assignee changed from Julio Montoya to Andre Boivin

Andre Boivin wrote:

J'ai maintenant ce message:

Notice: Undefined index: extension in D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php on line 525

Notice: Undefined index: extension in D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php on line 525

Notice: Undefined index: extension in D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php on line 525

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE23000: Integrity constraint violation: 1048 Column 'lastedit_user_id' cannot be null' in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:91 Stack trace: #0 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(91): PDOStatement->execute(Array) #1 D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Statement.php(165): Doctrine\DBAL\Driver\PDOStatement->execute(Array) #2 D:\usbw\root\chamilo1.11\main\inc\lib\database.lib.php(431): Doctrine\DBAL\Statement->execute(Array) #3 D:\usbw\root\chamilo1.11\src\Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer.php(243): Database::insert('c_item_property', Array) #4 D:\usbw\root\chamilo1.11\main\coursecopy\import_backup.php(99): Chamilo\CourseBundle\Component\CourseCopy\CourseRestorer->restore() #5 {main} Next exception 'Doctrine\DBAL\Driver\PDOException' with message 'SQLSTATE23000: Integrity constraint violation: 1048 in D:\usbw\root\chamilo1.11\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 112

I just added one more fix:

https://github.com/chamilo/chamilo-lms/commit/d0ec218c0c8bf037b47498cef5312eb644ff7b0b

#16

Updated by Andre Boivin almost 5 years ago

Ok, ça fonctionne mais j'ai le parcours en double. Voir image jointe

#17

Updated by Julio Montoya almost 5 years ago

  • Assignee deleted (Julio Montoya)

Andre Boivin wrote:

Ok, ça fonctionne mais j'ai le parcours en double. Voir image jointe

Dans l'image il y a 2 parcours différents ...

#18

Updated by Andre Boivin almost 5 years ago

  • Assignee set to Julio Montoya

En plus des parcours en double, il y a aussi un problème avec les questionnaires importés, le score n'est pas enregistré. Pour un nouveau questionnaire, le score est enregistré normalement.

#19

Updated by Julio Montoya almost 5 years ago

  • Assignee changed from Julio Montoya to Andre Boivin

Je pense que le mieux est de me donner un fichier pour faire des test de mon côté.

#20

Updated by Andre Boivin almost 5 years ago

Bonne idée, en voici un en pièce jointe, le dernier qui m'a créé les parcours en double est trop volumineux pour te l'envoyer, près de 500Mo

#21

Updated by Andre Boivin almost 5 years ago

Pour les scores des questionnaires, en fait ils sont bien enregistrés mais c'est que le questionnaire n’apparait pas dans les détails de l'élève Les nouveaux questionnaires apparaissent bien. Voir sur l'image jointe pour ce cours importé, l'image du haut ne présente aucun questionnaire disponible mais le score a bien été sauvegardé dans le parcours. Sur l'image du bas, on voit le nouveau questionnaire.

#22

Updated by Julio Montoya almost 5 years ago

Je viens de faire un essai et pour moi ca marche bien:

Peut être le mieux est de faire un test ici: https://1.11.chamilo.org


#23

Updated by Julio Montoya almost 5 years ago

  • Status changed from Needs testing to Assigned
  • Assignee changed from Andre Boivin to Julio Montoya

Ah d'accord, c'est vrai que les questionnaires ne sont pas dans la page main/mySpace/myStudents.php

#24

Updated by Julio Montoya almost 5 years ago

  • Status changed from Assigned to Needs testing
  • Assignee deleted (Julio Montoya)
#25

Updated by Yannick Warnier almost 5 years ago

  • Status changed from Needs testing to Bug resolved
  • % Done changed from 50 to 100

This task is continued in #8445. Closing this one.

Also available in: Atom PDF