Laravel Question posted in
The official Laravel Documentation can be found here.

Laravel – SQLite database Table not found

I’m doing laravel project, and trying to create a database factories and migration, where i want to put random data.
I’m using PHP artisan tinker to generate random data for the database.

But I get error message :
enter image description here

It sounds the SQLite cannot find the categories table in the main schema.
But i’m pretty sure i got the path where my database located right.

I try to clean my cache using

php artisan config:cache
php artisan config:clear
php artisan cache:clear

and it didn’t give any changed.

I’m expect i could find where did it get me wrong

Tags:

2

Answers


  1. 0

    Check your Categories Model…it’s probably missing or incorrect naming structures

    Login or Signup to reply.
  2. 0

    It seems like you’re encountering an issue where SQLite is not finding the categories table. Here are a few steps you can take to troubleshoot and resolve this issue:

    Verify Migration and Database Setup:

    Double-check your migration file (database/migrations) to ensure that the categories table is defined correctly with the necessary columns.
    Ensure that you have run the migration using php artisan migrate to create the categories table in your SQLite database.

    Check SQLite Database Path:

    1. Verify the path where your SQLite database file is located. By
      default, Laravel uses database/database.sqlite for SQLite databases.
    2. Ensure that this path is correctly configured in your .env file
      (DB_DATABASE=database/database.sqlite) and matches where your
      database file is located.

    Reset Database and Migrations:

    1. If there are inconsistencies, you can reset your database and rerun
      migrations:
      php artisan migrate:fresh
      This will drop all tables and rerun all migrations, ensuring your database schema is up-to-date.

    Permissions and File Access:

    1. Check the file permissions and ensure that the web server (if
      applicable) has the necessary permissions to access the SQLite
      database file and directory.
      enter code here

    Inspect Migration Errors:

    1. Look for any errors or warnings during the migration process (php
      artisan migrate) that might indicate issues with creating the
      categories table.

    Database Connection Configuration:

    1. Ensure that your database connection configuration in
      config/database.php is correctly set up for SQLite. The default
      configuration should work fine for most cases.

    Artisan Tinker Usage:

    1. When using Artisan Tinker (php artisan tinker), ensure that the
      classes and models you’re interacting with are correctly defined and
      available in your Laravel application.
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search