I think the problem is that no primary key is specified: http://smallbusiness.chron.com/duplicate-ignore-mysql-inserts-28260.html
If we need to specify a primary key for these statements to work, I'm not sure how we can use them because the id column is auto-incremented. On Mon, Jun 23, 2014 at 1:34 PM, Ian Duffy <i...@ianduffy.ie> wrote: > Hey Mike, > > This appears to be correct. > > There newly added lines in create-schema-sql ending in ;$ > > They appear to be introduced with the OVM stuff. > > > On 23 June 2014 20:17, Mike Tutkowski <mike.tutkow...@solidfire.com> > wrote: > > > Do we seriously have an error in our SQL code? :) I ran mvn -P developer > > -pl developer -D deploydb and received the following: > > > > ========> Processing SQL file at > > /home/cloudstack/cloudstack/developer/target/db/create-schema.sql > > Unable to execute > > /home/cloudstack/cloudstack/developer/target/db/create-schema.sql: You > have > > an error in your SQL syntax; check the manual that corresponds to your > > MySQL server version for the right syntax to use near '$ INSERT IGNORE > INTO > > `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervis' at line 1 > > > > -- > > *Mike Tutkowski* > > *Senior CloudStack Developer, SolidFire Inc.* > > e: mike.tutkow...@solidfire.com > > o: 303.746.7302 > > Advancing the way the world uses the cloud > > <http://solidfire.com/solution/overview/?video=play>*™* > > > -- *Mike Tutkowski* *Senior CloudStack Developer, SolidFire Inc.* e: mike.tutkow...@solidfire.com o: 303.746.7302 Advancing the way the world uses the cloud <http://solidfire.com/solution/overview/?video=play>*™*
