mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

This is too old a bug to fix auto-magically

If a site is needing to upgrade from pre 1.4 to something more modern
they will need to later the database pre-upgrade to:

1) Make sure all view_access rules are not null (they can use the view mtime as a logic ctime for this)
2) Make the view_access table ctime column to be a not-null column

** Changed in: mahara
       Status: Confirmed => Won't Fix

** Changed in: mahara
     Assignee: Robert Lyon (robertl-9) => (unassigned)

-- 
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/1494128

Title:
  view_access.ctime NULL/NOT-NULL is different on upgrade (from 1.3) or
  clean install

Status in Mahara:
  Won't Fix

Bug description:
  As reported on the forums:
  https://mahara.org/interaction/forum/topic.php?id=7344

  The view_access.ctime column was added in this commit:
  https://git.mahara.org/mahara/mahara/commit/843b8263a67022cf9765839f4e227c5026e17295

  The upgrade script for that commit creates it as a NULLable column,
  while the install.xml for it creates it as a NOT NULL column.

  So this results in some schema drift for sites that were created prior
  to Mahara 1.4. There may also be a bug caused during 1.8.1 to 15.04.3
  upgrades, due to this.

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