# Sqlite3.3.7 gives "SQL logic error or missing database"

**URL:** <https://www.ruby-forum.com/t/sqlite3-3-7-gives-sql-logic-error-or-missing-database/108590>\
**Category:** Rails\
**Created:** [July 5, 2007, 5:05am UTC](https://www.ruby-forum.com/t/sqlite3-3-7-gives-sql-logic-error-or-missing-database/108590 "2007-07-05T05:05:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Phlip](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/ed8c4c/32.png) [@Phlip](https://www.ruby-forum.com/u/Phlip)\
**Post date:** [July 5, 2007, 5:05am UTC](https://www.ruby-forum.com/t/sqlite3-3-7-gives-sql-logic-error-or-missing-database/108590/1 "2007-07-05T05:05:23Z")

</div>

> annoyingly from test\_dummy with nothing in it. The bug refers to the calls  
> `commence’
> 
> So when I move all my non-Model unit tests out of the unit test folder,  
> and put them into the functional folder, and everything works.

I spoke too soon. The unit tests work, but all the functional view  
helper  
tests don’t work!

So, like others who have tried Sqlite3 on Fiesty Fawn, I am back to  
MySQL  
for the tests. Good thing it doesn’t seem too slow…

---

<div class="post-metadata">

**Author:** ![Phlip](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/ed8c4c/32.png) [@Phlip](https://www.ruby-forum.com/u/Phlip)\
**Post date:** [July 7, 2007, 3:34pm UTC](https://www.ruby-forum.com/t/sqlite3-3-7-gives-sql-logic-error-or-missing-database/108590/2 "2007-07-07T15:34:43Z")

</div>

Phlip wrote:

> > annoyingly from test\_dummy with nothing in it. The bug refers to the calls  
> > `commence’
> 
> > So that doesn’t appear to be pilot error, huh, if all these tests work  
> > fine with MySQL for the test database, and if all these tests worked fine  
> > with slightly older version ticks.
> 
> > Some version dumps:
> 
> > rails (1.2.3)  
> > sqlite3-ruby (1.1.0.1) (This is \_why’s sensibility repack.)  
> > ZenTest(3.6.0)

My biggest recent version change was ZenTest (from 3.4.2). Adding this  
line to the \*ViewTest classes seems to help:

self.use\_transactional\_fixtures = false

And SQLite3 can’t do transactions. So the problem appears to be  
ZenTest’s propagation of the transactional fixtures setting…

–  
Phlip