# Ticket #503, "Bootstrap with sqlite3 db fails to create admin user"

**URL:** <https://www.ruby-forum.com/t/ticket-503-bootstrap-with-sqlite3-db-fails-to-create-admin-user/129513>\
**Category:** Radiant CMS\
**Created:** [February 19, 2008, 6:42am UTC](https://www.ruby-forum.com/t/ticket-503-bootstrap-with-sqlite3-db-fails-to-create-admin-user/129513 "2008-02-19T06:42:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![smc7000](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@smc7000](https://www.ruby-forum.com/u/smc7000)\
**Post date:** [February 19, 2008, 6:42am UTC](https://www.ruby-forum.com/t/ticket-503-bootstrap-with-sqlite3-db-fails-to-create-admin-user/129513/1 "2008-02-19T06:42:09Z")

</div>

Radianteers,

Ticket #503 on the Radiant Trac is about problems with the bootstrap  
process on sqlite3. I have recently been unable to reproduce this  
problem. This is a call for help – please test it on your platform and  
let me know the results. Here’s how to test the problem (on trunk):

1. Make sure you have the SQLite3 library installed for your platform,  
and the sqlite3-ruby gem.

2. Check out the trunk of the Radiant source:  
$ svn checkout [http://dev.radiantcms.org/svn/radiant/trunk/radiant](http://dev.radiantcms.org/svn/radiant/trunk/radiant)

3. Generate a new project with the sqlite3 database:

$ cd radiant  
$ script/generate instance -d sqlite3 …/test\_sqlite3

1. Freeze edge into the new project:

$ cd …/test\_sqlite3  
$ rake radiant:freeze:edge

3b) Instead of rake radiant:freeze:edge, you can link directly to the  
source (on Unix-y and Mac systems):

$ ln -nfs …/radiant vendor/radiant

1. Bootstrap the database, choosing the defaults and the “Empty”  
template when prompted:

$ rake db:bootstrap --trace

1. Test that the admin user was created:

$ script/runner “puts User.count”

If you get “1” printed from the last command, it worked. If you get  
“0”, you have reproduced the problem. If at any point in step 4, you  
get an exception or failure, please include the stack trace with your  
report.

\*\*\* IMPORTANT \*\*\*

These platform/library combinations have already been tested, please do  
not respond with one of these unless it fails:

Ubuntu 7.04, sqlite3 3.3.13, sqlite3-ruby 1.2.1  
Mac OS/X 10.5.x, sqlite3 3.4.0, sqlite3-ruby 1.2.1

Thank you!

Sean