Howard, the quoting style should be handled correctly by the "SET
SQL_MODE='POSTGRESQL'" command which should be run first on every mysql
connection.
Also, I found 'from' in the list of mysql reserved words in
htdocs/lib/xmldb/classes/generators/mysql/mysql.class.php, but I'm
guessing that's not the list you were looking at...
** Changed in: mahara
Status: New => Incomplete
--
You received this bug notification because you are a member of Mahara
Core, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/837012
Title:
MySQL reserved words not handled properly
Status in Mahara ePortfolio:
Incomplete
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
_______________________________________________
Mailing list: https://launchpad.net/~mahara-core
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-core
More help : https://help.launchpad.net/ListHelp
