mahara-contributors team mailing list archive

[Howard Miller <837012@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Mahara versions 1.3.7 and latest 1.4 (at time of writing)

The table notification_internal_activity adds the field 'from' at
upgrade 2010042600. From is a reserved word in MySQL. I know that Mahara
checks for reserved words and escapes them but.... (a) 'from' is not in
the list of reserved words and (b) even if it was the correct quote
character is the back-tick not the double-quote as used in Mahara. (see
http://dev.mysql.com/doc/refman/5.5/en/identifiers.html)

** Affects: mahara
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/837012

Title:
  MySQL reserved words not handled properly

Status in Mahara ePortfolio:
  New

Bug description:
  Mahara versions 1.3.7 and latest 1.4 (at time of writing)

  The table notification_internal_activity adds the field 'from' at
  upgrade 2010042600. From is a reserved word in MySQL. I know that
  Mahara checks for reserved words and escapes them but.... (a) 'from'
  is not in the list of reserved words and (b) even if it was the
  correct quote character is the back-tick not the double-quote as used
  in Mahara. (see
  http://dev.mysql.com/doc/refman/5.5/en/identifiers.html)

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