"Unknown Database" from app, however no problem with migrations from the command line

First off, I'm new to all this. I have never developed an app before. I had started last year and had a little bit of progress. I followed the tutorials here on Laracasts. I hit a road-block and stopped for several months. Somewhere in between my computer crashed, luckily I had my project folder saved on Dropbox. I started up again this week with a fresh install of macOS, H

clat23's avatar
clat23's avatar clat23Laravel
6

Laravel Dynamic Database Connections

Recently I have been trying to use a dynamic database connection with Laravel, but I have been running into issues. I have been doing research for the past week, but the answer to this problem seems to be non-existent. So, what I want to do is have a database connection that is SET and SAVED* after a user logs in. A user is tied to a specific company and each company will have

gofish's avatar
gofish's avatar vistmnLaravel
13

I would like to generate a database table, migrate and seed on the fly based using my .env file

So to be clear. What I'd love to see is an Artisan command called: db:make. Using the .env file to create all the need elements. Is it possible, with the current setup of Laravel 5.3 to do this? So after watching the artisan command laracast, i'm feeling confident that i can, but then start to realize that the complexity of the problem. Which I'll lay out now. So the first thin

dwoodard's avatar
dwoodard's avatar dwoodardLaravel
0

Laravel ignores the testing connection

I have a big and complex mysql-based schema and I want to use an in-memory sqlite database for testing using migrations for cleaning up as it's said here: https://laravel.com/docs/5.3/database-testing#using-migrations The fact is that Laravel ignores the connection specified in the phpunit config and runs tests against the primay mysql database. It's not an options due to the s

supertrall's avatar
supertrall's avatar alaameTesting
16

Can't filter down Collections when using PHPUnit?

Hey all... I have a product that has a many to many relation with categories. Each category belongs to a group. In the Product model I have the relation set up: public function categories() { return $this->belongsToMany(ProductCategory::class, 'product_category_product', 'product_id', 'product_category_id'); } I wanted to get the first category within a

ivanv's avatar
ivanv's avatar ivanvTesting
2

Calling PHPUnit from Artisan command will ignore the XML File

Greetings everyone. I have what I think is an uncommon issue but I'll try to explain as clear as I can. I have created a simple artisan command that does this /** * Execute the console command. */ public function handle() { $this->info("==> Cleaning up reports and docs..."); $command = new Process("rm -f tests/docs/* &

4jZW7jVSdS4U6PC's avatar
4jZW7jVSdS4U6PC's avatar ludo237Testing
5

Eloquent output appears hashed in Tinker console

I have a model called cart, I call a get on it in Tinker and while it returns records, at a certain point the records appear hashed. The application has not issues reading them though. I am using a sqlite database. I have pasted a sample of the output below, begins with proper data objects and then towards the bottom it appears to hash everything. All the data is read accuratel

newSequence's avatar
newSequence's avatar newSequenc...Eloquent
2

How to add new connection to database.php

Hi. I need to use several databases in laravel, and i'm trying to create a form to add a new db connection to connections array in config/database.php. 'connections' => [ 'sqlite' => [ 'driver' => 'sqlite', 'database' => env('DB_DATABASE', database_path('database.sqlite')), 'prefix' => '', ], 'mysql' =

tavares's avatar
tavares's avatar tavaresGeneral
2

[PDOException] SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'-Homestead

I was able to successfully create migrations from Xampp. However when i installed Homestead(vagrant,Virtual Box) and try to associate it with a database and run migrations i am facing [PDOException] SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' I have literally tried many configurations for .env file and config/database file , none seems to be working

arun3x3's avatar
arun3x3's avatar arun3x3Laravel
4

Why laravel 5.3 phpunit so slow when using faker

I am using sqlite for my test and using phpunit. I configure created another .env.testing and defined connection as sqlite. I also configure phpunit.xml and using DB_CONNECTION as sqlite. Also I used faker for my test as shown below. However it took so long (more than 3 minutes) for the test to be completed. I created also a new laravel 5.3 project but with the same testing r

jay_gorio's avatar
jay_gorio's avatar thamer.bel...Laravel
5

Why are .env settings overwriting phpunit.xml settings?

My database.php looks like this: 'default' => env('DB_CONNECTION', 'production'), 'connections' => [ 'tests' => [ 'driver' => 'sqlite', 'database' => env('DB_DATABASE', database_path('database.sqlite')), 'prefix' => '', ], 'production' => [ 'driver' => 'mysql',

Chill's avatar
Chill's avatar ChillTesting
5

Error code 255 on fresh install on TSOhost shared hosting

Hello I am installing a fresh copy of laravel on shared hosting (TSOhost, linux box) by SSH'ing in, installing composer (completed successfully) and then running composer create-project laravel/laravel --prefer-dist As can be seen below the laravel installation fails at php artisan optimise stage. no key is generated and the result is the error: Script php artisan optimize hand

lukio_3's avatar
lukio_3's avatar lukio_3Servers
1

setting right database for test

Hi, I use the model connection attribute in all my models since i'm working with multiple databases/schema's. I'm at a point where I need to write tests and this is where I'm struggling with at the moment. At the moment I set the DB_Connection through the models constructor. I named it "SHARED_CONNECTION" public function __construct() { Parent::__construct

Ronster's avatar
Ronster's avatar RonsterLaravel
0

Passport - Personal Access Token Unit Test

Can someone help me to put up a unit test for personal access tokens? This test should validate, that Passport is setup correct and a new valid token can be created for a new user. /** *@test */ public function Create_an_access_token() { $user = factory(User::class)->create(); $token = $user->createToken('TestToken')->accessToken;

Jacko's avatar
Jacko's avatar rodrigomoj...Testing
8

Charset problem during migration

Hi all, while I'm quite new with Laravel (my first project), I seem to have stumbled upon an issue which I've been looking at for way too long 'default' => env('DB_CONNECTION', 'mysql'), 'connections' => [ 'sqlite' => [ /* shortened as it is not used - default settings were kept */ ], 'mysql' => [ 'driver' => 'mys

supermooshman's avatar
supermooshman's avatar supermoosh...Eloquent
0

Valet Not Loading Site

I am desperately needing some help. I am having trouble with my computer and trying to figure out what is going on with the set up. I'm struggling with testing but getting this side issue fixed might help me get that taken care of. I was told as a test to try and get valet installed so I can try and get the basic test out of the box that Laravel provides to return green however

jrdavidson's avatar
jrdavidson's avatar SnapeyLaravel
6

issue with composer when deploying using Envoyer

Hi I'm having trouble deploying my laravel app using envoyer, the error accuer in installing composer dependencies, here it is: Using global Composer installation. Loading composer repositories with package information Installing dependencies (including require-dev) from lock file - Installing vlucas/phpdotenv (v2.3.0) Loading from cache - Installing symfony/polyfill-m

s2010's avatar
s2010's avatar s2010Envoyer
0

L5.2 - How to use differente DB connection for Queue

Hi all I’d like to use an SQLite DB for Queue, then: I set my SQLite connection in the config/databases.php file I run php artisan migrate --database=sqlite to create Job table in the SQLite DB but now, what I’ve to set in the Listener to use this DataBase? In a Model, for example, I set $connection=sqlite but in the Listener? Thank you.

vlauciani's avatar
vlauciani's avatar vlaucianiLaravel
1

Different database in different tests - is it possible?

I know that it is possible to setup a separate database for testing and local. I have been using an in memory sqlite database to test my models/repositories and seeders but would now like to work with a live database to test my api. Is it possible to have different tests use different databases? Perhaps there is a property that can be overridden on a test by test basis?

smnhunt's avatar
smnhunt's avatar bobbybouwm...Testing
4

Newbie to Laravel, [PDOException] SQLSTATE[HY000]

Hi there, so I'm new to laravel and frameworks in general, I've been following the tutorials on the laracast and everything's been amazing so far, but then when I got to the data migrations video and hit a bump. In the tutorial video, I'm doing a data migration to sqlite, but when i tried to do the migration i kept getting the error [PDOException] could not find driver. Anyways

billy.pc's avatar
billy.pc's avatar billy.pcLaravel
4

Remember me function not working

I have deployed my Laravel application to my server and have come across a problem when checking Remember Me on login, the following error is displayed: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database (SQL: update "users" set "remember_token" = HH0dtQYZ5BgoOpya1hNRUrFvIZF0dcYqdIvAjz0k6CbTKBqah7wWPdQbgzzL, "updated_at" = 2016

cluel3ss's avatar
cluel3ss's avatar cluel3ssLaravel
5

How do I list all tables in Artisan Tinker?

I am using a sqlite database in a Laravel project and I want to list all the tables. How would I do this? I tried using $tables = DBselect('SHOW TABLES'); but that throws this error: Illuminate\Database\QueryException with message 'SQLSTATE[HY000]: General error: 1 near "SHOW": syntax error (SQL: SHOW TABLES)'

trendsideas's avatar
trendsideas's avatar trendsidea...Laravel
6

Checksum between two systems

Hello, In my application, I have to sync large amounts of data between Android devices and my Laravel based Api. I can't tell you what it does exactly (due to copyright etc.) so I'll try my best to explain the situation Once complete, I then get Laravel to queue the unprocessed data to process and cache the end result in Redis. Once the user presses a button on my Android appli

Jamesking56's avatar
Jamesking56's avatar Jamesking5...General
1

Laravel 5.2 - Authentication (only) on different DB connection

Hi All What is the best approach to use different connection (for example a dedicated sqlite) only for Auth DB? I've used the default php artisan make:auth but I do not understand what I need to change to choice different DB connection ONLY for Auth database. Setting: class User extends Authenticatable { protected $connection = 'sqlite'; . . . into User.php Model, It works

vlauciani's avatar
vlauciani's avatar vlaucianiLaravel
1

SQLLite modifying a column width

I'm running tests using an in-memory SQLite DB because, as I understand it, MySQL in-memory testing does not support foreign keys. I created a new migration to widen the user's phone number column but when I run my in-memory SQL tests, they fail when attempting to seed. If I remove the migration that changed the phone number width, everything's fine. class IncreasePhoneColumnSi

ChristopherSFSD's avatar
ChristopherSFSD's avatar Christophe...Laravel
2

Auth - PasswordController uses wrong DB Connection

Hi I've two database connections; one (the default) for my data that is MySQL and another one for Auth that is sqlite. The auth db was created with command: php artisan migrate --database=sqlite To use the sqlite db for Auth, I've changed the validator method into AuthController.php class, adding sqlite.users string: protected function validator(array $data) {

vlauciani's avatar
vlauciani's avatar vlaucianiLaravel
2

Foreign key in mysql error: General error: 1215 Cannot add foreign key constraint

Hey, I am using some polymorphic many to many relationships. I was using sqlite and it worked like a charm. However trying to switch to mysql now gives me trouble. [Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `fragmentables` add constraint `fragmentables_fragment_id_foreign` foreign key (`fragment

lukasoppermann's avatar
lukasoppermann's avatar lukasopper...General
1

Issue with migrations

I seem to have an issue with the DatabaseMigrations trait, and a migration that adds a column to an existing table. I run PHPUnit against an on-disk SQLite database. I have one migration that creates a table (channels), and then a subsequent migration that adds a couple of columns to this table (one called description). But it seems when I run phpunit, Laravel has issue with th

martinbean's avatar
martinbean's avatar martinbeanTesting
2

A week of Laravel (10-17 April 2016)

laravel/framework master d08b708: Synced with stringy 2.3.1 @GrahamCampbell 40ccd57: Correct order @GrahamCampbell b45df80: Added missing debug dependency @GrahamCampbell 913487a: Intersect Method for Illuminate Request (#13167) @AdenFraser 8444190: Remove extra space @TheGIBSON 4dc5626: code tweaking. @taylorotwell 4c370cf: fix cons @taylorotwell 522ab43: fix c

Omranic's avatar
Omranic's avatar mdecoomanLaravel
2

Get rid of text at top of every app page

Hi everybody. I am new to laravel. I get the following output from laravel at the top of each page. I don't know how it got there. How do I get rid of it? Skip to content Personal Open source Business Explore Pricing Blog Support This repository 3,019 22,483 7,384 laravel/laravel Code Pull requests 0 Pulse Graphs laravel/config/database.php eb7743f 11 days ago @dakira dakira a

canadianlover's avatar
canadianlover's avatar canadianlo...Code Review
8

Homestead File Access

Hey Everyone. I have a weird situation. I am using Homestead and VirualBox to run my Laravel installation (version 5.1). In my app I uploaded a file via Laravel, a, SQLite file, and then I tried to set up a PDO to access that file and make SQL queries on it. The upload works fine and the file is there, It is readable by Laravel because I am able to use the File facade to get th

ackerchez's avatar
ackerchez's avatar ackerchezGeneral
2

[PDOException] SQLSTATE[HY000] [2002] Connection refused

Hello, Install Laravel, database: sqlite. config/database.php 'default' => env('DB_CONNECTION', 'sqlite'), 'sqlite' => [ 'driver' => 'sqlite', 'database' => env('DB_DATABASE', database_path('database.sqlite')), 'prefix' => '', ], database-> new file database.sqlite terminal: php artisan migrate Comunicat: [PDOException] SQLSTATE[HY000] [2002] Connection refus

lara-user's avatar
lara-user's avatar nobyLaravel
3

Error when trying to do Migrations

I am currently going through the Laravel From Scratch series here on Laracasts, and in episode 6 (I believe??), it begins talking about using Eloquent. I followed the directions for changing database configuration to use sqlite, and I add the database.sqlite file to the database folder. This is all that is specified to do in the video. However, when I try the 'php artisan mi

jldavis76's avatar
jldavis76's avatar asdaEloquent
6

sqlite3 command doesn't work in git bash & db comes up empty in homestead

I've recently installed homestead and am definitely a beginner at this. With that said, I've installed Homestead as per the 5.2 tutorial, installed Laravel, and have begun to follow the tutorials. Everything has been going well until I get to the part where I am switching the database to sqlite3 and doing a migration. I have been stuck there. I'll explain the circumstances as d

cm3rt's avatar
cm3rt's avatar emineyspri...Servers
1

POSTing from Javascript

Hi! I'm trying to create a two button counter (using Javascript) that counts the clicks and then posts the final tally to my SQLite DB. (It actually pops each click's time onto an array, and then sends the length of the array and the array to the DB after a second of no clicks.) The Javascript logic has been tested and works, besides for the $.post function. But I am receiving

ezrabutler's avatar
ezrabutler's avatar ezrabutlerLaravel
18

Migrations and branches

Hi Had an issue this week when started to try and use phpunit for testing more. It seems to rebuild the db each time running all the migrations, when testing sqlite option. This was an issue as I had swapped to a feature branch but not deleted my db as there was data in it I wanted for views. All was ok for the app. But when the migrations re ran they now had one listed in the

tristanbailey's avatar
tristanbailey's avatar mdecoomanEloquent
3

Cannot connect to db after update

Hello, I updated my Laravel installation using the composer update command and then started a new project I was willing to work on. I decided to use an sqlite database so I changed the driver in database.php and created a database.sqlite file in the appropriate directory as in the Laracasts. I have done this in two other projects prior to the update and it works fine, but in th

DemT89's avatar
DemT89's avatar DemT89Laravel
0

How to avoid database access performed by type-hinted models in controllers while testing?

I have a PostController which contains the following method: public function show(Post $post) { /* Stuff */ } While testing my controllers, is it possible to avoid the database query performed by the Post class? I tried mocking my Post model at no avail. The approach suggested by Jeffrey here didn't work either: https://gist.github.com/JeffreyWay/4968363 This is not a blocker

mostacholoco's avatar
mostacholoco's avatar mostacholo...Testing
0

Seeding in memory tests only once in 5.1

I need to seed my tests only once, unfortunately I cannot get it done with sqlite :memory: feature. To do so my idea was to create a custom bootstrap file to run the migration command once only: passthru('php artisan -q migrate --seed --env="testing"'); require __DIR__.'/autoload.php'; Which is working as expected, but unfortunately my tests don't see anything in th

nicogominet's avatar
nicogominet's avatar nikospkrkTesting
6

“PDOException could not find driver” in laravel migration with postgresql

I have three databases for my project. When I try Laravel migration with PostgreSQL. I am getting some error. But Laravel migration with other mysql databases is okay. I am using XAMPP and Windows 10. Could you please check below code and correct me? Error [PDOException] could not find driver Database return [ 'fetch' => PDO::FETCH_CLASS, 'default' => env('DB_CONNECTION'

sarathiscookie's avatar
sarathiscookie's avatar sarathisco...Laravel
0

Bulk insert on DB

Hi, I'm trying to import 11,000 lines of CSV into a freshly installed SQLite database on Laravel. I feel like there must be a simple way that I am completely missing. Is there a command line/Tinker solution? Thank you.

ezrabutler's avatar
ezrabutler's avatar tykus_ikusLaravel
1

Eloquent relationships with data that is not seeded into database

Hey guys, I've been developing a Laravel 5 application that takes RFID tag reads from a hardware reader and inserts them into an sqlite database through HTTP Post. This will be used in a convention environment to track attendees. I've created a model & migration for my Attendees as well as my Tags with some Eloquent relationships to associate certain db columns like the att

pi.mont's avatar
pi.mont's avatar pi.montEloquent
0

PHP Artisan Migrate Issue

Hello there. I am following along with the following video and hit a roadblock around the 9:33 mark: https://laracasts.com/series/laravel-5-from-scratch/episodes/7 I cannot get homestead to work on my machine through vagrant (that's another issue for another time), so I am SSHing directly into a cloud server on a specific port I'm using for testing/learning. I ran into this err

electrizcity's avatar
electrizcity's avatar electrizci...PHP
4

lastInsertId on non auto incrementing PK

Hi, I have a table containing a non auto incrementing primary key (it is a string). I'm not using Eloquent but am using the Illuminate\Database\DatabaseManager to interact with the database through my repositories. In my FooRepository::create() I have the following: public function create(array $input) { $uuid = Uuid::uuid4()->toString(); $insert = $this->db->

lara1376's avatar
lara1376's avatar lara1376Lumen
0

Laravel whereHas Relationship Query General Error: 25

Okay, so first I'll explain what I'm trying to do here. So picture this: there is a products page and inside this there are multiple products. On the backend, each product has a stock. Think of a stock as in a real store, you go to the back, and that is where you may have multiple sizes of this same product. So since each product has a stock, I'm trying to filter the size to th

bin0's avatar
bin0's avatar bin0Laravel
1

Speed up you laravel development workflow illuminating packages with acacha llum

Form whom it may concern: I create a lot of new Laravel projects every week with my students in classroom. In most of the projects Laravel debugbar and other packages are a must so we repeat a lot of operations when starting new projects. So I created a Laravel package for installing this tools with a single command inspired in Laravel spark tool see too at: https://github.com/

acacha's avatar
acacha's avatar acachaGeneral
0

PhpUnit hanging with DatabaseMigrations trait

Hey, since I wanted to change my tests to use sqlite in-memory with the DatabaseMigrations trait phpunit is hanging with nor output or error. This happens for every test where I use the DatabaseMigrations trait. database.php: 'connections' => [ ... 'testing' => [ 'driver' => 'sqlite', 'database' => env('DB_DATABASE', ':memory:'), '

christophrumpel's avatar
christophrumpel's avatar babeman123Testing
27

Please help me to sort this problem

SQLSTATE[HY000]: General error: 11 database disk image is malformed i got this error help me out to solve it , I try to create another table with same , after that i delete one of them and i got this error . is it possible to reset sqlite ?

khumair's avatar
khumair's avatar jekinneyEloquent
1

Should we avoid using raw statements/functions in Eloquent/DB?

I have a number of Eloquent repositories in my Laravel project. For the most part, I use Eloquent to query my database, but in a few places I use the Query Builder, and when I really need optimization, I use raw queries (through DB::statement()). Of course, this might defeat Eloquent's flexibility, since raw statements can change from MySQL to SQLite, etc. Is it therefore good

leestar's avatar
leestar's avatar ricardovig...Eloquent
8

Dose anyone know the Mysql terminal command for .schema?

I can follow along pretty smoothly with jeffery while I'm using MySQL, I am just having a hard time trying to find the mysql translation for sqlite .schema command. Anyone MySQL'er's out there?

jwavess's avatar
jwavess's avatar jwavessGeneral
2