[Dbix-class] Read Only DB - SQLite

[Anthony Gardner]

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"]

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

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20070915/5dd0dc8d/attachment.htm