mahara-contributors team mailing list archive

[Yaju Mahida <1499568@xxxxxxxxxxxxxxxxxx>]

** Description changed:

+ MySQL 5.5.39
+ Apache 2.2.15
+ Red Hat 6.6
+ 
  We found three issues while upgrading from Mahara 1.9.8 to 15.04.3.  We
  have attached the tar file which contains the patch and various error
  logs for further help.
  
  Upgrade Issue 1 - Add path and update records :
  
  This adds a field 'path' to artefact table and thereafter runs a update
  query to add data. We have around 500K rows and this takes around 94
  minutes to upgrade! This can be done in one go without the limit of 200
  and it works very well taking around 2-3 minutes!
  
  Few times the upgrade failed due to "mysqli error: [1205: Lock wait
  timeout exceeded; try restarting transaction]".
  
  Upgrade Issue 2 - TinyMCE emoticon changes :
  
-         $replacements = array('view' => 'description',
-                               'artefact' => 'title',
-                               'artefact' => 'description',
-                               'group' => 'description',
-                               'interaction_forum_post' => 'body',
-                               'notification_internal_activity' => 'message',
-                               'blocktype_wall_post' => 'text',
-                               'site_content' => 'content');
+         $replacements = array('view' => 'description',
+                               'artefact' => 'title',
+                               'artefact' => 'description',
+                               'group' => 'description',
+                               'interaction_forum_post' => 'body',
+                               'notification_internal_activity' => 'message',
+                               'blocktype_wall_post' => 'text',
+                               'site_content' => 'content');
  
  The artefact key is defined twice in the array so as soon it reaches
  'artefact' => 'description', it replaces the previous one which ends up
  skipping the title column to be updated.
  
  Upgrade Issue 3 - TinyMCE emoticon changes - Typo!  :
  
-                     $configdata[$key] =
+                     $configdata[$key] =
  preg_replace('/\/emotions\/img/', '/emotions/img', $value);
  
- emotions are replaced emotions@
+ emotions are replaced emotions

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1499568

Title:
  Mahara 15.04.3 upgrade issues

Status in Mahara:
  New

Bug description:
  MySQL 5.5.39
  Apache 2.2.15
  Red Hat 6.6

  We found three issues while upgrading from Mahara 1.9.8 to 15.04.3.
  We have attached the tar file which contains the patch and various
  error logs for further help.

  Upgrade Issue 1 - Add path and update records :

  This adds a field 'path' to artefact table and thereafter runs a
  update query to add data. We have around 500K rows and this takes
  around 94 minutes to upgrade! This can be done in one go without the
  limit of 200 and it works very well taking around 2-3 minutes!

  Few times the upgrade failed due to "mysqli error: [1205: Lock wait
  timeout exceeded; try restarting transaction]".

  Upgrade Issue 2 - TinyMCE emoticon changes :

          $replacements = array('view' => 'description',
                                'artefact' => 'title',
                                'artefact' => 'description',
                                'group' => 'description',
                                'interaction_forum_post' => 'body',
                                'notification_internal_activity' => 'message',
                                'blocktype_wall_post' => 'text',
                                'site_content' => 'content');

  The artefact key is defined twice in the array so as soon it reaches
  'artefact' => 'description', it replaces the previous one which ends
  up skipping the title column to be updated.

  Upgrade Issue 3 - TinyMCE emoticon changes - Typo!  :

                      $configdata[$key] =
  preg_replace('/\/emotions\/img/', '/emotions/img', $value);

  emotions are replaced emotions

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1499568/+subscriptions