> I post this message on the dev list too as I am not sure to get help on
> the users'list
> I want to unit test a behavior as shown on http://www.propelorm.org/**
> 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
> 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" />
> 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
> 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<firstname.lastname@example.org>
> To unsubscribe from this group, send email to
> email@example.com<propel-development%2Bunsu firstname.lastname@example.org>
> For more options, visit this group at