SQLSTATE[HY000]: General error: 1 no such table

I've been trying to get the tests working on sqlite in memory database but I have been hitting the error 'SQLSTATE[HY000]: General error: 1 no such table'

I have cleared the config cache over and over again and the connection is defined in phpunit.xml

I am using Laravel 6.0.4 and globally installed phpunit is at version 8.3.5 PHP Version is 7.2.13 and SQLite version is 3.24.0

Any ideas?

Sinnbeck

6 years ago

Level 102

Do you have this in your base test file?

use DatabaseMigrations;

11 likes

jannevuori

6 years ago

Level 10

Yes I have.

I might be actually finally finding the reason for that. Will post soon again if this is correct.

denvit

6 years ago

Level 21

Probably something not correctly defined in phpunit.xml. Maybe APP_ENV set to testing and you don't have .env.testing? Also check if you have correctly set DB_DATABASE path and that sqlite db exists.

Otherwise, this could help you https://laracasts.com/discuss/channels/testing/setting-testing-environment-variables

2 likes

thedejavunl

6 years ago

Level 14

Do you have built a migration for that model? In memory databases use the migration files to create the temporary databases.

1 like

jannevuori

6 years ago

Best Answer

Level 10

Found it: the problem came from one of my helper classes that accessed database and which was shared to views with View::share() and this was done in AppServiceProviders boot -method and it really was not cool place for it :)

Moved it to middleware where it can be shared only when it is really needed.

After this change the tests work again and with the sqlite :memory:

7 likes