Laravel php artisan migrate not working

Question

When I try to use 'php artisan migrate' in Laravel I get 2 errors:

[Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 26 file is encrypted or is not a database (SQL: select * from sqlite_master where type = 'table' and name = migrations)

[PDOException] SQLSTATE[HY000]: General error: 26 file is encrypted or is not a database

I created a storage/database.sqlite file before attempting the migration. I also edited the config/database.php, making the default=sqlite. I am using windows and have sqlite3 installed.

Has anyone encountered this/know how to get past it?

Is there someone who can help with this? It is a massive stumbling block — S. Hantz
– S. Hantz, Commented Sep 24, 2015 at 0:25

liamvictor · Accepted Answer · 2016-03-15 19:36:16Z

10

I had the same results, in my case the /database/database.sqlite file was not empty.

I deleted the contents reran php artisan migrate and the migration table was created successfully.

answered Mar 15, 2016 at 19:36

liamvictor

3,3091 gold badge24 silver badges25 bronze badges

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

2 Comments

S. Hantz Over a year ago

Awesome! Glad you found a fix.I just abandoned sqlite and went back to mysql

M I Over a year ago

i was having a new line in sqlite file, upon removing it worked, thanks

Tim D · Accepted Answer · 2018-07-20 11:07:23Z

Running Laravel in Windows under the Powershell console I was getting the same errors as the original poster. The documentation reads After creating a new SQLite database using a command such as touch database/database.sqlite... The Powershell equivalent of touch is typically Out-File FILENAME

PS D:\Learning\PHP-Laravel\database> out-file database.sqlite
PS D:\Learning\PHP-Laravel> php artisan migrate
   Illuminate\Database\QueryException  : SQLSTATE[HY000]: General error: 26 file is not a database...

When creating my database.sqlite file I received these errors. I deleted the database and recreated it using the New-Item command and it worked properly

new-item -ItemType File -Name database.sqlite
PS D:\Learning\PHP-Laravel> php artisan migrate
Migration table created successfully.

Sultan Dadakhanov · Accepted Answer · 2019-02-09 16:56:02Z

0

If somebody came here with the same error with manually created table in sqlite db - it could be the sqlite version mismatch. I solved the same error by emptying db file and recreate the table with getConnection()->statement('CREATE TABLE

answered Feb 9, 2019 at 16:56

Sultan Dadakhanov

679 bronze badges

Comments

Fibonacci Gramicci · Accepted Answer · 2021-01-18 23:05:51Z

-1

check if your .sqlite file is empty and the is no indentation(no spaces)

answered Jan 18, 2021 at 23:05

Fibonacci Gramicci

1

1 Comment

DanielM Over a year ago

this is more of a comment

Collectives™ on Stack Overflow

Laravel php artisan migrate not working

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Linked

Related