Using sqlite with Laravel 4

Question

Not sure what I'm doing wrong but in my app/config/database.php file I've changed the default driver to sqlite.

First off I got this error.

SQLSTATE[HY000]: General error: 8 attempt to write a readonly database (SQL: create table "migrations" ("migration" varchar null, "batch" integer null)) (Bindings: array ( ))

So I made app/database/production.sqlite writable.

Now I get this error.

SQLSTATE[HY000]: General error: 14 unable to open database file (SQL: create table "migrations" ("migration" varchar null, "batch" integer null)) (Bindings: array ( ))

Anyone know why this would be?

Wouldn't it make more sense to put the sqlite file in app/storage which is already writeable? — AntonNiklasson
– AntonNiklasson, Commented Apr 14, 2014 at 21:07

Rob Gordijn · Accepted Answer · 2013-09-12 20:58:05Z

1

Did you check the folder that holds the db-file? Must be writeable.

answered Sep 12, 2013 at 20:58

Rob Gordijn

6,5211 gold badge25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jonathan · Accepted Answer · 2014-05-15 17:34:57Z

0

I just ran into this issue, and got around it by running the migrate command using the owner of the current file, like so:

sudo -u username php artisan migrate

So, as Rob Gordijn suggested, this is a permissions related issue.

answered May 15, 2014 at 17:34

Jonathan

19.2k10 gold badges59 silver badges56 bronze badges

Collectives™ on Stack Overflow

Using sqlite with Laravel 4

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related