[Building Sakai] 2.9.0 DB Conversion, MySQL script error

[Gast, Cynthia (cmw6s)]

Thanks, Sam, will-do :-)

FYI, found another 2.9.0 MySQL DB conversion script bug, for LTI tables.  3 create-table statements are not terminated with a ';' so when I ran the conversion script, I received an error after a 4th create-table (SST_SERVERSTATS) statement, and none of the 4 tables were created.  Tables involved: lti_mapping, lti_content, lti_tools, and then SST_SERVERSTATS (which is terminated with ';').  See BLTI-156 sql, then STAT-315 sql, in the script: sakai_2_9_0_mysql_conversion.sql.

I will file a new JIRA for this LTI issue also.

Cindy

________________________________
From: Sam Ottenhoff [ottenhoff at longsight.com]
Sent: Thursday, January 24, 2013 11:19 AM
To: Gast, Cynthia (cmw6s)
Cc: sakai-dev at collab.sakaiproject.org
Subject: Re: [Building Sakai] 2.9.0 DB Conversion, MySQL script error



Unsure if this has been reported.  If not, should SAK-22700 or SAK-16091 be re-opened, or a new issue opened?

Attaching the adjusted script, which runs without error after editing the table name.

Re-opening old, merged, and verified issues is really confusing.  Opening a new JIRA and linking the new JIRA to the problematic ticket is preferred.

And yes, your bug is legitimate.  Please file a new issue.

Thanks,
Sam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130124/e895e284/attachment.html