That schema is incorrect and has the known "NULL problem" of the
ruby-sqlite3 gem. The correct schema is:
---- 8< ----
CREATE TABLE users ("id" INTEGER PRIMARY KEY NOT NULL, "name"
varchar(100) DEFAULT NULL, "email" varchar(255) DEFAULT NULL, "login"
varchar(40) DEFAULT '' NOT NULL, "password" varchar(40) DEFAULT NULL,
"created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL,
"created_by" integer DEFAULT NULL, "updated_by" integer DEFAULT NULL,
"admin" boolean DEFAULT 'f' NOT NULL, "developer" boolean DEFAULT 'f' NOT
NULL, "notes" text, "lock_version" integer DEFAULT 0);
---- 8< ----
You have something wrong somewhere. If you created that database before
updating sqlite3, create it again.
I have rails+sqlite3 working on a debian machine and i don't use the
sqlite3 gem, instead i use a debian package:
---- 8< ----
[EMAIL PROTECTED]:~$ radiant --version
Radiant 0.6.1
[EMAIL PROTECTED]:~$ sqlite3 --version
3.3.17
[EMAIL PROTECTED]:~$ gem list | grep sqlite
[EMAIL PROTECTED]:~$ dpkg -l | grep sqlite
ii libsqlite3-0 3.3.17-1
SQLite
3 shared library
ii libsqlite3-ruby 1.2.1-1
SQLite3 interface for Ruby
ii libsqlite3-ruby1.8 1.2.1-1
SQLite3 interface for Ruby 1.8
ii sqlite3 3.3.17-1 A
command line interface for SQLite 3
ii sqlite3-doc 3.3.17-1
SQLite
3 documentation
[EMAIL PROTECTED]:~$
---- 8< ----
I updated the FAQ (http://wiki.radiantcms.org/FAQ) to comment this.
/AITOR
On 7/16/07, Robert Lorimor <[EMAIL PROTECTED]> wrote:
> Aitor Garay-Romero wrote:
> > Could you please send us the output of the sqlite3 command ".dump users"
> > on the failing data base? Just to check the schema.
> >
> > /AITOR
>
> Ok. Here it is:
>
> BEGIN TRANSACTION;
> CREATE TABLE users ("id" INTEGER PRIMARY KEY NOT NULL, "name"
> varchar(100) DEFAULT '''''''''''''''NULL''''''''''''''', "email"
> varchar(255) DEFAULT '''''''''''''''NULL''''''''''''''', "login"
> varchar(40) DEFAULT
> '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' NOT NULL,
> "password" varchar(40) DEFAULT '''''''''''''''NULL''''''''''''''',
> "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL,
> "created_by" integer DEFAULT 0, "updated_by" integer DEFAULT 0, "admin"
> boolean DEFAULT 'f' NOT NULL, "developer" boolean DEFAULT 'f' NOT NULL,
> "notes" text, "lock_version" integer DEFAULT 0);
> CREATE UNIQUE INDEX "login" ON users ("login");
> COMMIT;
>
> --
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Radiant mailing list
> Post: [email protected]
> Search: http://radiantcms.org/mailing-list/search/
> Site: http://lists.radiantcms.org/mailman/listinfo/radiant
>
_______________________________________________
Radiant mailing list
Post: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant
