← Back to team overview

mahara-contributors team mailing list archive

[Bug 1292713] [NEW] xml table incomplete

 

Public bug reported:

I am using the git 1.8 stable repos, though my site is reporting
1.8.2Testing.  I did a git pull on the site tonight and it prompted an
upgrade.  On performing the upgrade it stuck with various error messages
(I didn't screen shot as I wanted to fix it, but it was errors in
/lib/db/upgrade.php; /lib/dml.php; /lib/ddl.php; /admin/upgrade.php and
/admin/upgrade.json.php) .  The messages related to a modification of
the usr_custom_layout table.  In the upgrade xml it was reporting to add
to the existing table.  The old version had, as far as I can tell, no
group and institution settings.  The new table xml says to build into
the table the group and institution tables and the corresponding foreign
keys to link these tables.  I am no developer, so this was more brute
force and ignorance, but looking at various files I can see that the
only foreign keys required are the user table and view_layout.  I used
phpmyadmin to delete the other foreign keys and linked the fields in
usr_custom_layout to the corresponding id fields in user and layout_view
and the update completed.

Apologies as I went around in circles a bit between work and it is late
on Friday so well into beer time.

Hope this makes sense.

** Affects: mahara
     Importance: Undecided
         Status: New

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

Title:
  xml table incomplete

Status in Mahara ePortfolio:
  New

Bug description:
  I am using the git 1.8 stable repos, though my site is reporting
  1.8.2Testing.  I did a git pull on the site tonight and it prompted an
  upgrade.  On performing the upgrade it stuck with various error
  messages (I didn't screen shot as I wanted to fix it, but it was
  errors in /lib/db/upgrade.php; /lib/dml.php; /lib/ddl.php;
  /admin/upgrade.php and /admin/upgrade.json.php) .  The messages
  related to a modification of the usr_custom_layout table.  In the
  upgrade xml it was reporting to add to the existing table.  The old
  version had, as far as I can tell, no group and institution settings.
  The new table xml says to build into the table the group and
  institution tables and the corresponding foreign keys to link these
  tables.  I am no developer, so this was more brute force and
  ignorance, but looking at various files I can see that the only
  foreign keys required are the user table and view_layout.  I used
  phpmyadmin to delete the other foreign keys and linked the fields in
  usr_custom_layout to the corresponding id fields in user and
  layout_view and the update completed.

  Apologies as I went around in circles a bit between work and it is
  late on Friday so well into beer time.

  Hope this makes sense.

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


Follow ups

References