# Setup\_database fails for sqlite3

**URL:** <https://www.ruby-forum.com/t/setup-database-fails-for-sqlite3/72158>\
**Category:** Radiant CMS\
**Created:** [October 14, 2006, 11:43pm UTC](https://www.ruby-forum.com/t/setup-database-fails-for-sqlite3/72158 "2006-10-14T23:43:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![gui\_dos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/e79b87/32.png) [@gui\_dos](https://www.ruby-forum.com/u/gui_dos)\
**Post date:** [October 14, 2006, 11:43pm UTC](https://www.ruby-forum.com/t/setup-database-fails-for-sqlite3/72158/1 "2006-10-14T23:43:04Z")

</div>

I’m trying out the mental branch and sqlite3 doesn’t appear to be  
creating User objects properly resulting in the following backtrace:-

– add\_index(“users”, [“login”], {:unique=\>true, :name=\>“login”})  
-\> 0.2646s  
– initialize\_schema\_information()  
-\> 0.5167s  
– columns(“schema\_info”)  
-\> 0.0040s  
OK  
Creating user ‘admin’ with password ‘radiant’…FAILED  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/base.rb:955:in  
`find_one': Couldn't find User with ID=0 (ActiveRecord::RecordNotFound) from ./script/../config/../vendor/rails/activerecord/lib/active_record/base.rb:941:in`find\_from\_ids’  
from  
./script/…/config/…/vendor/rails/activerecord/lib/active\_record/base.rb:382:in  
`find' from ./script/setup_database:179:in`create\_admin\_user’  
from ./script/setup\_database:258:in `announce' from ./script/setup_database:177:in`create\_admin\_user’  
from ./script/setup\_database:20:in `run' from ./script/setup_database:9:in`run’  
from ./script/setup\_database:297

I took the ugly but easy way out which creates a new User object and  
saves it twice, which is really what create is supposed to be doing. I  
don’t know if it is my sqlite3 setup that is the problem here. I’m  
using sqlite3-ruby here …

— script/setup\_database (revision 155)  
+++ script/setup\_database (working copy)  
@@ -175,8 +175,8 @@

def create\_admin\_user  
announce “Creating user ‘admin’ with password ‘radiant’” do

- 

```
 @admin = User.create :name => 'Administrator', :login =>

```

‘admin’, :password =\> ‘radiant’, :password\_confirmation =\> ‘radiant’,  
:admin =\> true

- 

```
 @admin = User.find(@admin.id)

```

- 

```
 @admin = User.new :name => 'Administrator', :login => 'admin',

```

:password =\> ‘radiant’, :password\_confirmation =\> ‘radiant’, :admin =\>  
true, :developer =\> true

- 

```
 @admin.save!
 UserActionObserver.current_user = @admin
 @admin.created_by = @admin
 @admin.save
```