> I want to unit test a behavior as shown on http://www.propelorm.org/**
> cookbook/testing-your-**behaviors.html<http://www.propelorm.org/cookbook/testing-your-behaviors.html>
> But I met a sqlite error I don't know how to get rid of

> There was 1 error:
> 1) MyBehaviorTest::testOne
> PDO::prepare(): SQLSTATE[HY000]: General error: 1 near "IDENTITY": syntax
> error

> My schema is pretty simple at this point :
> <database name="bookstore" defaultIdMethod="native">
>  <table name="book" description="Book Table">
>       <column name="id" required="true" primaryKey="true"
> autoIncrement="true" type="INTEGER" description="Book Id" />
>       <column name="title" type="VARCHAR" required="true"
> description="Book Title" primaryString="true" />
>   </table>
> </database>

> I am on ubuntu, php5-3-2, sqlite3 3.6.22, propel 1.6.7
> It seems to be related to the autoIncrement="true" that doesn't feet well
> with sqlite.
> I can remove the autoIncrement attribute and the tests go on, but saving
> new objects - that could be expected - have null as an Id

> Any idea how to resolve this ?
> By the way, the propelquickbuilder is really neat en encouraging testing,
> great work
> Thanks
> Loďc

> --
> You received this message because you are subscribed to the Google
> Groups "Propel Development" group.
> To post to this group, send email to propel-development@**googlegroups.com<propel-development@googlegroups.com>
> To unsubscribe from this group, send email to
> propel-development+**unsubscribe@googlegroups.com<propel-development%2Bunsu bscribe@googlegroups.com>
> For more options, visit this group at
> http://groups.google.com/**group/propel-development<http://groups.google.com/group/propel-development>