Activity log for bug #1499568

Date Who What changed Old value New value Message
2015-09-25 00:58:24 Yaju Mahida bug added bug
2015-09-25 00:58:24 Yaju Mahida attachment added Patch and various error logs https://bugs.launchpad.net/bugs/1499568/+attachment/4473860/+files/Patch%20%26%20Error%20logs.tar
2015-09-25 01:06:25 Yaju Mahida description 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@ 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
2015-09-25 01:21:51 Yaju Mahida attachment added lib_db_upgrade.php.patch https://bugs.launchpad.net/mahara/+bug/1499568/+attachment/4473861/+files/lib_db_upgrade.php.patch
2015-09-25 01:22:51 Yaju Mahida attachment removed Patch and various error logs https://bugs.launchpad.net/mahara/+bug/1499568/+attachment/4473860/+files/Patch%20%26%20Error%20logs.tar
2015-09-25 01:23:18 Yaju Mahida attachment added error logs https://bugs.launchpad.net/mahara/+bug/1499568/+attachment/4473862/+files/error%20logs.tar
2015-09-25 01:25:30 Yaju Mahida 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 Red Hat 6.6 Apache 2.2.15 MySQL 5.5.39 PHP 5.4.40 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
2015-09-25 05:32:32 Aaron Wells mahara: importance Undecided High
2015-09-25 05:32:42 Aaron Wells nominated for series mahara/15.04
2015-09-25 05:32:42 Aaron Wells bug task added mahara/15.04
2015-09-25 05:32:42 Aaron Wells nominated for series mahara/15.10
2015-09-25 05:32:42 Aaron Wells bug task added mahara/15.10
2015-09-25 05:32:52 Aaron Wells mahara/15.04: milestone 15.04.4
2015-09-25 05:32:56 Aaron Wells mahara/15.10: milestone 15.10.0
2015-09-25 05:32:58 Aaron Wells mahara/15.04: importance Undecided High
2015-09-25 05:33:01 Aaron Wells mahara/15.04: status New In Progress
2015-09-25 05:33:03 Aaron Wells mahara/15.10: status New In Progress
2015-09-28 01:52:01 Robert Lyon mahara/15.10: status In Progress Fix Committed
2015-09-28 18:12:54 Robert Lyon mahara/15.04: status In Progress Fix Committed
2015-10-23 06:12:40 Aaron Wells mahara/15.10: status Fix Committed Fix Released
2015-10-27 08:53:28 Robert Lyon mahara/15.04: status Fix Committed Fix Released
2016-11-06 23:32:13 Robert Lyon mahara: status Fix Committed Fix Released