Howard, Also, I believe the quote string should be set properly. In htdocs/lib/xmldb/classes/generators/mysql/mysql.class.php there is a field var $quote_string = '`'; // String used to quote names which is set to the backtick. And from the looks of the forum post, the sql commands have the backtick for quoting.
Do you have any error logs from this upgrade? Does the database have the field in it? Cheers, Hugh -- 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
