SQLite Database Browser

Hello, Using sqlitebrowser 1.3-2.2 from Ubuntu repo on Ubuntu 9.04. I've tried several many times to add a new database record but always get a popup error message saying "Make sure a table is selected". I am in the Browser tab and have definitely chosen a table. I'm looking at a view of 581 records. I can't figure out why on earth this is giving this non-sensical message. The Log panel shows a sql statement was executed that looks like, INSERT INTO Paths(id) VALUES(Null);

To try to figure out what's wrong I did a manual sql query with, INSERT INTO Paths VALUES(0); and that executed without error and created a new record at the top of the browser window. So why doesn't the "New Record" button work then. Any ideas? Chris :)

a bug 2899450 has been created, Hope it will get fixed soon.

Maybe you have a NOT NULL clause in the table definition for any of your fields? The browser will create a new record with all NULL values, and this will fail if NULL can not be used.

For table created by rails model, the first field is always id and is required.

I have a workaround for this implemented in the version of SQLite database browser customized by my company, the one that gave birth to the open source version. I will see about backporting it to Sqlitebrowser: in the past few days I committed some changes that will be part of 2.0. Let us see if I can build and deliver it in the next couple of weeks. It will be the first version based on Qt4.