← Back to team overview

mahara-contributors team mailing list archive

[Bug 1519780] Re: Missing unique index in usr_custom_layout

 

*** This bug is a duplicate of bug 1515929 ***
    https://bugs.launchpad.net/bugs/1515929

** This bug has been marked a duplicate of bug 1515929
   Duplicate records in usr_custom_layout cause fatal crash when copying a collection

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

Title:
  Missing unique index in usr_custom_layout

Status in Mahara:
  New

Bug description:
  We had some issues with duplicate records in usr_custom_layout when
  creating a page from a template. In lib/view.php, function
  create_from_template, there is the database read...

  $haslayout = get_record('usr_custom_layout', 'layout',
  $template->get('layout'), 'usr', $owner);

  This failed because more than one record was returned. I have no idea
  what caused this but it would have been more robust if ('usr',
  'layout') was defined as a unique index.

  The problem occurred in 15.04 with MySQL. A quick glance suggests that
  nothing has changed in this area in 15.10.

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


References