cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Tutkowski <mike.tutkow...@solidfire.com>
Subject Re: [ACS4.5] SQL Error
Date Mon, 23 Jun 2014 19:36:19 GMT
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 <ian@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.tutkowski@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.tutkowski@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.tutkowski@solidfire.com
o: 303.746.7302
Advancing the way the world uses the cloud
<http://solidfire.com/solution/overview/?video=play>*™*

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message