Database file at path does not exist

hi, a very beginner here so pardon if this is very basic question or not the place for it. been trying to search for answers but was unable to find any. so here's my problem. i have created a project with Laravel with breeze (react flavor) for frontend and FilamentPhp for admin panel. i am using laravel Herd for local development. i started with default sqlite configuration and

forkingbeardman's avatar
forkingbeardman's avatar acframeLaravel
8

SQLite/MySQL error using Spatie Roles and Permissions.

Spent a couple of days on this and can't figure this out (chatGPT no help, Spatie site no help, and non githug discussions I can find). Using straight up Spatie Roles and Permissions not changes to base package.. Getting this error with Spatie Roles & Permissions v6: "select "roles".*, "permission"."table_names"."model_has_roles"

curtsheller's avatar
curtsheller's avatar jlrdwTips
5

Failed job uses incorrect database login

My failed jobs driver seems to be using an incorrect database login and I cannot figure out how to change it. This issue seems to have started after I upgraded to Laravel 11 from Laravel 10, but I can't be sure if that is the cause. The error I receive is as follows: "Access denied for user 'xxx'@'localhost' (using password: YES) (Connection: mysql, SQL: insert into `faile

will83's avatar
will83's avatar SnapeyLaravel
6

How to Solve This Error ???

SQLSTATE[HY000]: General error: 1 no such table: user (Connection: sqlite, SQL: select count(*) as aggregate from "user" where "email" [email protected] )

deepoccean's avatar
deepoccean's avatar sm3rterCode Review
2

Making two columns unique in combination (or a composite primary key).

I have the following Models: Opportunity Vote User A User can only have one Vote on an Opportunity. I just went to change my auto-incrementing Vote Id field to a composite key made up of the User Id and the Opportunity Id like so: $table->primary('user_id', 'opportunity_id'); Having done this my seeder fails like so: SQLSTATE[HY000]: General error: 1 foreign key mismatch - &

CodyMcCode's avatar
CodyMcCode's avatar CodyMcCodeEloquent
2

Tinker not retrieving models

Tinker will count() the number of records for my tables but it will not ::find(1) or ::first() or ::all() etc. It just hangs. db:show delivers: SQLite .............................................................. 3.37.2 Connection .......................................................... sqlite Database .......................................... database/database.sqlite Host

msr2406's avatar
msr2406's avatar SnapeyLaravel
6

SQLlite remote management

Whats the best way to manage a sqlite database over an SSH connection to a production site?

Snapey's avatar
Snapey's avatar Tray2General
5

Class "Faker\Factory" not found

I have this Dockerfile FROM php:8.2-apache WORKDIR /var/www/html # Install required packages and libraries RUN apt-get update && apt-get install -y \ libicu-dev \ libpng-dev \ libjpeg-dev \ libfreetype6-dev \ unzip zip \ libzip-dev \ zlib1g-dev \ python3 \ python3-pip \ python3-venv \ && docker-php-ext-install gettex

Deadly_Smile's avatar
Deadly_Smile's avatar Tray2Laravel
3

Missing property when using spatie/laravel-settings when running tests

HI, I am using laravel-settings 2.1 on a Laravel 8 project, and it has been working fine until now. I need a new setting, so I created a migration: <?php use Spatie\LaravelSettings\Migrations\SettingsMigration; class AddOnboardingVersionSetting extends SettingsMigration { public function up(): void { $this->migrator->add('general.onboarding_version',

ouissla's avatar
ouissla's avatar JackJonesLaravel
1

Connection error

Im new in laravel and i have problem about connecting database :( always error when do php artisan migrate PS C:\laragon\www\percobaan> php artisan migrate Illuminate\Database\QueryException could not find driver (Connection: sqlite, SQL: PRAGMA foreign_keys = ON;) at vendor\laravel\framework\src\Illuminate\Database\Connection.php:813 809▕ $this->getNa

hendraaa's avatar
hendraaa's avatar hendraaaLaravel
2

Failed deploy when missing database.sqlite even when using MySql.

I have having an odd issue that recently started happening. Background on issue: We are running Laravel via Caprover. Everything has been working flawlessly. We connected CapRover to our GitHUb to auto deploy when we push to main. Great, everything has been working! The issue: Recently we have been pushing commits and the caprover server will start the building process on the n

drewkovihair's avatar
drewkovihair's avatar drewkoviha...Laravel
2

30 days of Laravel: Day 10; General error: 10 disk I/O error

Hello, I am trying to use tinker to add entries into my db. However I continue to get this error. SQLSTATE[HY000]: General error: 10 disk I/O error (Connection: sqlite, SQL: insert into "job_listings" ("title", "salary", "updated_at", "created_at") values (Rolling Machine Setter, $50,000 USD, 2024-07-09 20:39:46, 2024-07-09 20:3

lifeboatcreative's avatar
lifeboatcreative's avatar EldarusLaravel
7

Cant get artisan to run db migrations using docker permissions issue

I am following The Docker Tutorial by Andrew Schmelyun on laracasts. All was going well I could run migrations using artisan but only if I am using sqlite db. when I change to mysql db I get this error. Thank you ahead of time for any help. I know sail works well but can you deploy sail to production? /Users/henrylemmon/Sites/laravel-docker.test > docker-compose run --rm art

lemmon's avatar
lemmon's avatar lemmonCode Review
6

column "foreign_key" doesn't exist in database

I am learning Laravel, YouTube "30 Days to Learn Laravel". In video number 12 at 05:51, if I click onto "Structure", there is no column named "foreign_key" in my SQLite database. It is really difficult to find the bug, if I don't know, where to search. This is the content of the file "2024_06_14_153747_create_tags_table.php" in the migrat

codehacker's avatar
codehacker's avatar codehackerLaravel
6

Error when i Try to create Register Page with Model & Controller

Im Sorry im new in Laravel, i try to create my first project with laravel 11, can u help me for this problem ?? SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.password (Connection: sqlite, SQL: insert into "users" ("name", "email", "role", "updated_at", "created_at") values ($2y$1

mfadhlillahrasyid's avatar
mfadhlillahrasyid's avatar jlrdwLaravel
3

Laravel through docker container

Hi everyone, Just putting this out here if anyone has/had any issues like I did. Also, I am interested to find out why is this particular view - 9863e6fd842e71f3f1bb5c3122567b0d.php missing from the composer creation of a new laravel/laravel project. Rather, I get the symphony file_put_contents permission denied. So, what I have figured out in the past week of banging my head i

Mega_Aleksandar's avatar
Mega_Aleksandar's avatar Mega_Aleks...Laravel
2

How to use SoftDeletes and Unique together?

PROBLEM: Say you want your users table with unique emails but at the same time you want to soft delete. After being soft deleted, you want that user to be able to re-register with the same email but with a new user id . If you create your column the classic way: $table->string('email')->unique(); you'll get a "Integrity constraint violation: 1062 Duplicate entry"

bshan's avatar
bshan's avatar SnapeyTips
7

php artisan migrate error

Can someone help me with i'm getting this error when i run php artisan migrate Illuminate\Database\QueryException could not find driver (Connection: sqlite, SQL: PRAGMA foreign_keys = ON;) I use laravel herd on Windows

eauyelbekov's avatar
eauyelbekov's avatar Shivamyada...Laravel
1

How to send multiple requests in laravel phpunit tests?

I have a Test class extended from Illuminate\Foundation\Testing\TestCase. I use DatabaseTransactions trait. In setUp() method i create models using factories. In one of tests i need to make two calls: first to retrieve offset param and second to retrieve data with offset. Like this: $response = $this ->get('/api/v1/companies') ; $response = $this->get('/api/v1/compan

moongod's avatar
moongod's avatar moongodTesting
2

Laravel Github CICD

Hello everyone. I have laravel cicd for github action. But I want to use mysql for database and I want my cicd create the mysql database from the phpunit.xml file value. Can you adjust the script? name: Laravel on: push: branches: [ "main" ] pull_request: branches: [ "main" ] jobs: laravel-tests: runs-on: ubuntu-latest steps: -

KarlHill69's avatar
KarlHill69's avatar KarlHill69DevOps
6

Constraint failed: customers.name In Laravel Spark

Hi Guys! Developing a project from scratch using Jetstream and Laravel Spark, the first user I register gives me this error: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: customers.name I tried from scratch to create another project with Breeze, changing from sqlite to mysql, and it still gives that error, only with the first user. In fact, the

Nicom's avatar
Nicom's avatar NicomSpark
2

RefreshDataBase trait not working for some tests

4 tests of my 128 tests persist data to the database and refreshDataBase not working for them in laravel testing and my test db is local mysql and not sqlite in memory how can i fix the problem?

amirghasempoor's avatar
amirghasempoor's avatar amirghasem...Testing
2

Why is Laravel such an Uphill battle compared to just coding in PHP

have spent over 4 days (8 hours a day) I am not new to php but getting frustrated and losing time. Documentation is vague it doesnt show anything about installing for MYSQL or MARIADB and then when you wade through 100's of other people posts you have to modify the code of laravel to make it work.....(defaeting the purpose of using a framework if im having to recode the framew

blizzardza's avatar
blizzardza's avatar tykusGeneral
1

Many to Many Relationship Confusion.

I've been using Laravel since v5 but for some odd reason Eloquent relationships make my brain turn to mush. Help me out here peeps. I have groups and users. A group can have many users and a user can have many groups. To help me out I created a pivot model defined like this ... <?php namespace App\Models; use App\Enums\Group\GroupUserRole; use Illuminate\Database\Eloquent\

normykinz's avatar
normykinz's avatar amitsolank...Laravel
4

PDOException: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: orders.reconciled

I am updating a legacy project from laravel9 to laravel 11. After updating laravel 10 to 11 i started getting below error in test cases. Caused by PDOException: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: orders.reconciled I have a schema dump for the sqlite. Here is a statement in the file CREATE TABLE orders (id INTEGER PRIMARY KEY AUTOINCR

mahaguru24's avatar
mahaguru24's avatar mahaguru24Laravel
2

installing new laravel 11 app problems

I use wsl (latest version) on windows 10, with ubuntu 22.04. I'm trying to create a new laravel 11 project. i have installed php 8.3.4 >> composer and then laravel installer. (note that i couldn't find a pdo extension to install. trying to do so results in a message that php8.3-common is already installed) then i tried to create a project (in my home folder, so no permis

yossi's avatar
yossi's avatar yossiLaravel
8

Laravel Jetstream & Auth Tests Fail On Github Actions

Hello, I'm having some trouble getting a CI pipeline setup to run my test suite through Github Actions with Laravel Jetstream and basic authentication tests. All of my other tests, like Livewire components, work without an issue. I've using the base YAML that I've found on Github Actions for a Laravel app, but Feature tests from Laravel Jetstream and basic authentication ones (

masonfox's avatar
masonfox's avatar princejohn...Testing
8

Laravel 11 deployment on Forge

Has anyone tried to deploy their Laravel 11 application on forge? The thing I am worried about is that we are now using sqlite but it does not look like Laravel Forge is supporting this as of yet.

BrianHollenbach's avatar
BrianHollenbach's avatar Polar_BearForge
2

failed_jobs driver not found

I've set-up a new Laravel (10.44.0) environment and all is working. But, when running a job and it fails, I'm getting the bellow error. could not find driver (Connection: postgres, SQL: insert into "failed_jobs" ("uuid", "connection", "queue", "payload", "exception", "failed_at") values (9b66c3d1-0cba-473b-84

obayd's avatar
obayd's avatar obaydLaravel
1

Laravel Migrations Stopped Working

Hello, I've been scratching my head for maybe the last error trying to figure out what's going on. I deleted my database.sql file since I wanted a new one from scratch. I've done this dozens of times, but upon running php artisan migrate:fresh it returned the following error: Database file at path [{..}/database/database.sqlite] does not exist. Ensure this is an absolute pat

The_titan's avatar
The_titan's avatar The_titanLaravel
8

How to make the db revalidate after migrate:fresh

Hi, If I change my database migration in some way and run php artisan migrate:fresh the changes don't seem to take effect until I revalidate the db connection (sqlite) in the db client (dBeaver). Is there a setting in Laravel I've missed that would do this for me? Thanks.

n2fole00's avatar
n2fole00's avatar gychGeneral
1

What database architecture for an analytics system?

Hi, I'm going to create an app where users can create pages that can be visited. I want to store each visit so that my users can have a visitor dashboard (date, country, browser, device...). I'm using MariaDB and I was going to make a simple "visits" table with a page_id and user_id to filter but, eventually when this table grow too much, queries are going to be very

darkylmnx's avatar
darkylmnx's avatar SairahcazLaravel
8

RefreshDatabase when testing using MySQL

I'm using MySQL as DB for testing because I want the same environment as my real server. But I realize that DB is not refreshed after each test classes (It only be refreshed if I use the Sqlite). When I run seeder in a test class, the data will be remain when another test class runs. Regarding that, I think about 2 approaches: Run a seeder before all test classes, but I can't

manhnguyen's avatar
manhnguyen's avatar Tray2Laravel
1

Tests get stuck and time out after using Refreshdatabase a few times.

Hello dear Laracasts Forum. I have a weird problem, searched SO, Here, but could not find help. When i start my IDE (Phpstorm) und boot my system, i can run all the tests just fine. But after a while, my tests who uses this Trait will timeout and i cant continue doing TDD until i eventually reboot my System, which as you can imagine is super annoying. I use .env.testing file DB

zufflie's avatar
zufflie's avatar LaryAITesting
1

Cypress GitHub workflow

Any good reference to set up a GitHub workflow for Cypress with Laravel? The main issue I am facing is that on local development I am using Laravel Herd - which generates a secured TLS for my domain. With Cypress, setting the baseUrl configuration parameter causes the workflow to wait for a server to response before running the tests (GH Workflow). If I try to run npm run vite

talel's avatar
talel's avatar talelmisha...Testing
1

Pest Test wipes MySql database

Hi folks - I'm just starting with using Pest for testing and its working except that it is wiping my local MySql database with each test. I thought I followed the instructions and found some addition help in this forum, but I haven't figured it out yet. I've set up my phpunit.xml for sqlite: <?xml version="1.0" encoding="UTF-8"?> <phpunit xmlns:xsi

Rretzko's avatar
Rretzko's avatar RretzkoTesting
2

Newbee stuck on page 1

Sorry to waste your time with a no doubt trivial issue but I am following the laravel bootcamp with Blade and sqlite. Everything looks alright right down to the last paragraph on page one: "If you refresh your new Laravel application in the browser, you should now see a "Register" link at the top-right. Follow that to see the registration form provided by Laravel

ClausQ's avatar
ClausQ's avatar SnapeyLaravel
2

Laravel Pest test ignore not resetting mariadb autoincrement ids

I have a laravel pest test that checks a redirect after data is submitted to a controller to create a client. it('redirects to the clients show page', function () { $user = User::factory()->asAdmin()->create(); auth()->login($user); post(route('clients.store'), [ 'name' => 'Test Client', 'description' => 'Test Description', '

FMK's avatar
FMK's avatar FMKTesting
3

Laravel/Inertia/Vuejs

I'm very new to the concept of this type of development (although not new to development itself). I've created an app which uses a sqlite database. The database is seeded with data. I have for the time being retained the standard laravel welcome page but added my own link to a new page to it just to check that that works, which it does. On that new page i added a simple strin

DomSinclair's avatar
DomSinclair's avatar martinbeanInertia
2

Optimizing a search by "partial words"

Hi ! I've got a Products table that contains, of course, names. In my app, I want to allow the user to search from partial name words, whatever the order they put the words in. Let's imagine I've got a product name "cookie with chocolate chips" in my table. The user is able to perform a search typing in the search form "choc cook", which returns this exact p

Napo7's avatar
Napo7's avatar Napo7Eloquent
11

How to use multiple database tests

I have a multiple data base app. General data in mysql connection Two tables in sqlite connection database.php 'connections' => [ 'sqlite_log' => [ 'driver' => 'sqlite', 'url' => env('DATABASE_URL'), 'database' => database_path(env('SQLITE_LOG_DATABASE', 'log_errors.sqlite')), 'prefix' => '',

abkrim's avatar
abkrim's avatar abkrimTesting
2

how do you do testing with migrations (drop foreign key, dropcolumns, add new)?

Hello! I have 54 migrations. I was removing, adding columns, dropping indexes, adding indexes, etc. Now tests (phpunit) don't run . I have bunch o sqlite problem like BadMethodCallException: SQLite doesn't support dropping foreign keys (you would need to re-create the table). and porbably many more. Is there any good way so test will run fast (in memory?) and without errors?

restart93's avatar
restart93's avatar martinbeanLaravel
7

Searching within 10KM radus.

Good evening, i have some problem with search feature. PropertySearchController public function __invoke(Request $request) { return Property::with('city') //..... ->when($request->geoobject, function($query) use ($request) { $geoobject = Geoobject::find($request->geoobject); if ($geoobject) {

codelyftlab's avatar
codelyftlab's avatar codelyftla...Laravel
0

Livewire reloads complete page after action

Hey guys, Maybe one of you can help. When I submit an action the code is executed but the page completely reloads after it. I'm using Laravel 10.25.1 with Livewire 3.0.10. As a development server I'm using Herd. Here's a gif that demonstrates the issue more clearly. This is my component <div wire:init="loadConfig"> <div class="flex gap-4 mb-4"&g

Kazuto's avatar
Kazuto's avatar KazutoLivewire
0

laravel test

Community experts, please help me take a look at this error. The error message I'm getting while using Laravel test, is it because I'm not using use RefreshDatabase? test code test('user_who_is_logged_in_shows_voted_if_idea_already_voted_for',function() { $user = User::factory()->create(); $idea = Idea::factory()->create(); Vote::factory()->create([

o227786060@gmail.com's avatar
o227786060@gmail.com's avatar o227786060...Laravel
5

Relationships return null when called from the same Model, but works fine everywhere else

I am using SQLite, and backpack, but I doubt that affects anything. Anyway the issue is in the method public function category(): BelongsTo in the Content class When I try to access the section, I get that it is null. I have even tried doing $section = Section::find($this->section_id); but I got null. Even though it works fine outside the Content class, for example I can get

Saad5400's avatar
Saad5400's avatar Saad5400Eloquent
3

artisan tests pass when using in-mem DB, fail when using MySQL

I haven't figured out why this is happening, but I need to set up my tests and phpunit such that it uses a mysql database to seed and run database tests, instead of in memory / sqlite. Originally, the tests worked perfectly with sqlite and everything passed, but I recently added a migration that uses some storedAs functions that sqlite can't handle (like DATEDIFF). So I need to

garrettmassey's avatar
garrettmassey's avatar garrettmas...Testing
3

Mocking A Static Eloquent Model?

Currently, I have a bunch of static helper methods with a fair amount of logic that requires testing. Buried in those numerous methods is a single database call used in a single helper function: Categories::where('x', 'y')->first(). I currently do not want to go through all the trouble of configuring a whole sqlite database and populating it with seeder data (our .env files

theferrett's avatar
theferrett's avatar theferrettTesting
6

Error when running laravel's phpunit test

I get an error when running the "test laravel project" action through github actions Running on Laravel 10.10, PHP 8.1.21. my workflow file: name: Laravel on: push: branches: [ "main" ] pull_request: branches: [ "main" ] jobs: laravel-tests: runs-on: ubuntu-latest steps: - uses: shivammathur/setup-php@v2 with:

Timtendo12's avatar
Timtendo12's avatar Timtendo12Laravel
6

Mysql SQLSTATE[HY000] [2002] Connection refused

Hi, I freshly installed laravel 10. Running on WSL-windows-docker. My database settings are using mysql. My artisan commands work (php artisan migrate:fresh; php artisan db:seed;), but when I try it on the localhost-webpage, it fails. Error shown is SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select * from.... Docker-mysql log shows it is running 2023-0

pjuakiy's avatar
pjuakiy's avatar pjuakiyLaravel
3