[Dbix-class] Read Only DB - SQLite

[Matt S Trout]

On Sat, Sep 15, 2007 at 05:32:30PM +0100, Anthony Gardner wrote:
> After a loooooong break from all things DBIC, I'm now looking to get back into it but have come up against some strange problems.
> 
> While running as a web application, I get the following error even though I made the db rw
> 
> DBIx::Class::Schema::populate(): DBI Exception: DBD::SQLite::st execute failed: unable to open database file(1) at dbdimp.c line 402 [for Statement "INSERT INTO user_profiles (address_line_1, address_line_2, address_number, company_name, email, first_name_contact, phone, postcode, surname_contact, town) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"]

It says "unable to open" entirely. I'd suspect either the parent dir
permissions are wrong or your app isn't running as the user you think it is.

Judicious use of -r $db and -w $db may help debug this.

> What I find strange also, is the order of the fields in the error message. They don;t match the order of the schema declaration nor the order in DBIC's populate

Insert stuff is flattened from a hashref so you get hash key ordering, I think.

I suspect the alphabeticality is merely a side-effect.

> Everything works ok with MySQL in a web app and non web app for SQLite.
> 
> Any pointers would be great. DBIC version 0.08007
> 
> CIA
> 
> -Ants
> 
>        
> ---------------------------------
>  For ideas on reducing your carbon footprint visit Yahoo! For Good this month.
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.rawmode.org

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/