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

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

  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