Postgres does not return last_insert_id

Hello, I have an app which uses postgres. I developed it usign sqlite and when I made the switch to posgress, after trying to create a new user I got this error Syntax error: 7 ERROR: syntax error at or near "returning" at character 107 (SQL: insert into "users" ("name", "email", "password", "updated_at", "create

Terumi's avatar
Terumi's avatar muriloGeneral
9

Two different environment configs (local and testing) for the same machine

Like many, I have one machine that I develop my applications on and also use for testing. I'm using a MySQL database for development (and will be doing for production), but for my tests, I want to use an SQLite database. I know that PHPUnit will switch the environment to 'testing', but how can I tell it which configuration options to use? In config/database.php I have set the d

DMA's avatar
DMA's avatar DMAGeneral
6

Bootstrap laravel 5 in package development

Hi guys, I got stuck during the upgrade to L5 of 1 package. This package run integration tests to a Database (sqlite in memory). With laravel 4 I had successfully bootstrapped the framework and run the tests without problems. Because now Laravel5 use Kernels i don't understand how to bootstrap it only for development purpose. I had a previous question about this without have a

fenos's avatar
fenos's avatar fenosGeneral
0

Laravel 5, Behat 3 and JavaScript

Okay, I've got this problem I just can't find a correct solution for. I've recently been learning Behat and I really like it. At work I really want to have these kinds of tests for our packages, and Behat really seems to fit perfectly. I've got Behat running with Laravel 5 perfectly with the package @JeffreyWay wrote, and it all tests run fast and the testing environment variab

Crinsane's avatar
Crinsane's avatar ghprodTesting
14

Homestead - L4.2 - PGSQL - PDOException - could not find driver

Hi all, hopefully somebody can help. I have a new installation of homestead with a laravel 4.2 application making use of postgresql. The error in the log file when trying to interact with the db is: local.ERROR: exception 'PDOException' with message 'could not find driver' in : I have tested the following: According to a phpinfo(); page php is configured with pdo + pdo_pgsql V

apstyx's avatar
apstyx's avatar safaridenyGeneral
4

[L5] Understanding Package Development

Hi guys, I want to update my Laravel 4 packages to Laravel 5 for all you guys. I would like deliver the updated package with unit and integration tests running on Trevis CI I just need some of your precious suggests. My understanding Laravel 5 has removed the workbench feature (no problem), so for create a new package just create a new folder and init composer installing the

fenos's avatar
fenos's avatar max23General
12

[Guide] How to run Integration tests from a package

Integration testing from a package The Problem When testing models and repositories that follow the active record pattern, such as Eloquent, you will quickly realise that your ORM (persistence layer) is tightly coupled to your entities. Why is this a problem? ... Glad you asked. When testing your models you are unable to test them in isolation because of the afore mentioned is

clemenger's avatar
clemenger's avatar nateritterGuides
5

[L 4.2] PHP Artisan Migrate fails on Homestead 2

I am getting this error when I run php artisan migrate vagrant@homestead:~/Projects/lenda$ php artisan migrate PHP Parse error:  syntax error, unexpected ''DB_HOST'' (T_CONSTANT_ENCAPSED_STRING), expecting ']' in /home/vagrant/Projects/lenda/.env.local.php on line 4 PHP Stack trace: PHP   1. {main}() /home/vagrant/Projects/lenda/artisan:0 PHP   2. require_once() /home/vagrant/

jgravois's avatar
jgravois's avatar jgravoisPHP
0

laravel database and eloquent connection

this question is for the masters of laravel DB and eloquent objects. In a brief I use for tests a sqlite in memory DB, so I create the laravel DB but than the eloquent objects dont use the same connection. This is for my laravel messaging package, you could view the files in my github: https://github.com/tzookb/tbmsg/tree/dev/tests and here is my stackoverflow question with a

tzookb's avatar
tzookb's avatar tzookbEloquent
0

I need some advices about small share files application

I need some advices about small share files application I'm using sqlite to save users info where to save info such as owner of folder / file share a folder / file and emails and any info may appear later ... it would be good if I got an modern open source application thanks

OmarMakled's avatar
OmarMakled's avatar omar.makle...General
2

Testing an API with Guzzle

As the title suggests I want to create some PHPUnit tests that use guzzle to retrieve responses from an API I am building. As part of the setUp method I run the migrate and db:seed command that loads the DB into an SQLite DB in memory Now the issue I'm having, or rather the solution I'm trying to find is when guzzle hits http://tenant.example.com/api/foo I want the app to be

bostinait's avatar
bostinait's avatar alnour alt...Testing
2

DB Error in Migration and Persistance Lesson

Has anyone had this problem before, I'm not new to PHP but relatively new to Laravel, and following this Lesson: https://laracasts.com/series/laravel-5-from-scratch/episodes/7 When following along around 5:26 into the video we go into a generated migration and set a value: $table->text('lyrics')->nullable(); This is throwing the warning Method 'nullable' not found in

Roni's avatar
Roni's avatar RoniGeneral
0

SQL HY000 error when seeding phpunit tests

Hi, I am trying to seed an sqlite in-memory database for use in phpunit tests. in tests/TestCase.php I have a prepareForTests() method with two artisan calls: protected function prepareForTests() { Artisan::call('migrate'); Artisan::call('db:seed'); } The call to db:seed seems to be causing this error: PDOException: SQLSTATE[HY000]: General error: 1 near "SET": synt

DarkRoast's avatar
DarkRoast's avatar ftaGeneral
6

adding test to my package with DB

I have a package for laravel for user-messaging. It creates several tables with migrations, and I want to add tests to my package. In my laravel projects I use sqlite, so it's not a problem. But this package is not in a laravel project, it is only a package, so how can I test it? any ideas?

tzookb's avatar
tzookb's avatar tzookbGeneral
1

How to speed up in memory db tests with fake seeds

Hey, I was wondering. How could I speed up my tests? I have in memory sqlite databse with one table and one small and simple seed file using Faker library. It is generating 10 records in a foreach range loop with 7 calls to faker to get the data. The problem is that when I migrate + seed this databse it took Time: 8.05 seconds, Memory: 22.25Mb which is I believe too long for s

JoeTheCoder's avatar
JoeTheCoder's avatar JoeTheCode...Tips
4

Codeception - Integration testing a package with eloquent

Anyone have any tips for integration testing a package with Eloquent models? I am using codeception with an SQLite database. I'm bootstrapping Eloquent in the codeception _bootstrap file and just pointing it to the same sqlite database I setup in the codeception Db module. Here is the issue: Codeception and Eloquent are using different PDO connections. This causes an issue whe

tyler43636's avatar
tyler43636's avatar paynetyTesting
1

Method only firing once

Hi there, I've follow the 'Incremental APIs' series on the site, and upon the test I have a little problem. I've added a User's model, the model require a unique email, so is set the db. Now in my test, I try using the times() method that is on the ApiTester class. It just sets a protected variable with the value is it passed. Then I try to create N users using that times me

Romain's avatar
Romain's avatar RomainGeneral
0

forge not migrating database

In development my bootstrap /start.php looked like $env = $app->detectEnvironment(array( 'local' => array('homestead'), )); after watching laracast segment on Environment i changed it to $env = $app->detectEnvironment(function() { return getenv('ENV') ? : 'local'; }); On forge i have server installed and uploading from github. During development I used a

vm's avatar
vm's avatar vmForge
3

Codeception + Migration

Hello and first of all I want to say thanks for this wonderful Laracasts website, I love it! I am trying to set up a CodeCeption automated workflow with Gulp and Homestead as my server locally. I have one problem, I want to run migrations everytime I start a test. How can I do that? I've been searching around the web and not found a good solution to this, so I'm starting to

eukaryoter's avatar
eukaryoter's avatar schogettenGeneral
1

In memory database and PHPUnit

I'm playing around with an in-memory sqlite database for automatic unit testing when a file is saved, since it's a lot faster than using an sqlite file - and requires less resources than a full database install. However, it appears PHPUnit runs every test method inside each class within it's own memory allocation, so I need to run my migrations and my seeds before every test. W

Valorin's avatar
Valorin's avatar psmailGeneral
1

installation problem

I did all the steps from the installation video but still at the end I see these error messages: symfony/translation suggests installing symfony/config () symfony/translation suggests installing symfony/yaml () symfony/security-core suggests installing symfony/validator (For using the user password constraint) symfony/security-core suggests installing symfony/expression-langua

roelof's avatar
roelof's avatar bashyGeneral
5

Local dev alternatives for databases

It's been a real annoyance to use SQLite in my local development. Since our production server uses PostgreSQL, there's been multiple instances where the queries just don't line up. Understandably, SQLite is a pared down system, but if I can't rely on my tests and code to execute equally on local and production, it is hindering me, not helping. I'm sure for many, the first inst

coolmatty's avatar
coolmatty's avatar creativityGeneral
3

How to test package that relies on Eloquent. Mock DB?

I am working on a simple package that allows for metadata to be attached to eloquent models. I forked Scubaclick/Meta and added a few features. Everything is working well, but I want to add some simple unit tests. My question is: what is the best practice to test Eloquent models from a package? Every test will write or retrieve something from the database. Some research has po

chrismichaels84's avatar
chrismichaels84's avatar chrismicha...Eloquent
2

Enable Json1 Extension for sqlite3

The docs says, that we need to use the json1 extension for sqlite3 if we are using json where clauses in our application. https://laravel.com/docs/5.8/queries#json-where-clauses I searched a lot and I don't know how to enable them. Is it in the php.ini and there under sqlite3.extension_dir? PHP has a sqlite3 loadExtension method https://secure.php.net/manual/en/sqlite3.loadexte

ChrisSFR's avatar
ChrisSFR's avatar ChrisSFREloquent
10

InvalidArgumentException in SQLiteConnector.php line 34: Database (homestead) does not exist.

I am following the Series Laravel 5 from scratch and I am in specific on the lesson Fetching Data. I created the database.sqlite file, I added some data from the tinker and was able to retrieve them in the console. Then, I try to replicate what the video does. My cards controller: <?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Http\Controllers\C

anon40457's avatar
anon40457's avatar DeftlyGeneral
12

Issue with sqlite3 - Windows 10

Hello All, I am trying to run the following command but I keep receiving the error shown below. I am currently using Windows 10. If this issues is not related with the community, I apologize for this, you can delete it please. C:\AppServ\www\phpvms-master>php artisan database:create Using connection "local" Running "sqlite3 C:\AppServ\www\phpvms-master\databas

servetas's avatar
servetas's avatar servetasLaravel
0

Alter AUTOINCREMENT on SQlite3 database code work on tinker and not on App

For upgrade version of database, I need alter autoincrement for a table. I test my code on tinker and work perfectly, but on app, fail. $firstId = $this->setFirstMyTableId(); // get for example 56789 DB::update("UPDATE SQLITE_SEQUENCE SET seq = $firstId WHERE name = 'MyTable'"); // this code work perfectly on tinker and return 1 Beacuse fail, I need workaround

abkrim's avatar
abkrim's avatar abkrimLaravel
0

Laravel Herd w/ODBC + SAP HANA

Hello, I'm in Mac OS Sequoia 15.0.1 with Laravel Herd. Is it possible to install obdc in the php version of Laravel Herd? Right now the modules installed are: php -m [PHP Modules] bcmath bz2 calendar Core ctype curl date dba dom exif FFI fileinfo filter ftp gd gettext gmp hash herd iconv igbinary imagick imap intl json ldap libxml mbstring mongodb mysqli mysqlnd openssl pcntl p

Lutacon's avatar
Lutacon's avatar Tray2Laravel
4

Hello, anytime i try to spin up a new laravel project within docker + wsl linux 20.04. My build process get terminated or stops here

this is the response from my terminal, i can't seem to get past this process, is there something broken with my setup and how can i fix such issues. Below is the response i get in my terminal and i'm not doing anything entirely different than following the installation guide included in laravel docs ✔ meilisearch Pulled 2.8s ✔ redis Pulled

totoosa's avatar
totoosa's avatar totoosaLaravel
4

Docker laravel sail with php 8.3 mssql running on Mac M1

Ok so here is the goal, use laravel sail with PHP 8.3, but I need to connect to an external mssql server, thus I need mssql drivers. Here are the instructions on how to install the drivers: https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver16#installing-on-ubuntu However, I keep running into errors when trying to build the imag

onecollectiveDev's avatar
onecollectiveDev's avatar onecollect...Laravel
1

Laravel Sail broken?

Everything works fine for my existing projects, but when I try to build a new app using: curl -s "https://laravel.build/example-app" | bash This throws an error: ... #0 29.44 Get:12 http://ports.ubuntu.com/ubuntu-ports jammy-updates/main arm64 Packages [1451 kB] #0 30.83 Get:8 http://ports.ubuntu.com/ubuntu-ports jammy/universe arm64 Packages [17.2 MB] #0 31.22 Ign:8

mathewparet's avatar
mathewparet's avatar mathewpare...Laravel
7

Local nginx setup initial load super slow

Hi All, I've been struggling with my local setup for a while now. And finally took the time to investigate deeper but was not able to find out whats wrong. I have a local nginx setup build with homebrew with PHP running also on homebrew not on a socket but on a port with php-fpm (currently only running [email protected]) Some how the initial load on my local test domains take somewhere b

kayintveen's avatar
kayintveen's avatar kayintveenDevOps
3

Laravel Herd w/MS SQL

I am using Laravel Herd on a M1 MAC running Ventura OS and am running into an issue connoting to a MS SQL Server. I have installed the PHP extensions and loaded them using the following guides below. However, after restarting, I am no able to connect to the MS SQL DB. Anyone have any ideas on how I can resolve this? Error: SQLSTATE[IMSSP]: This extension requires the Microsof

jdc1898's avatar
jdc1898's avatar mintbridgeLaravel
9

Gitlab CI testing

Hi folks, I'm using gitlab CI for testing my laravel application. The issue is before_scripts takes too many time. I'll be sharing my testing script. I want to ask that is there any all-in-one image for running tests. If not, how can I optimize my job? test: image: php:8.2-cli stage: test only: - main before_script: - apt-get update -qq && apt-get instal

aknEvrnky's avatar
aknEvrnky's avatar aknEvrnkyDevOps
5

Laravel installation using Docker 24.0.2

I am using docker for the first time to create my laravel project using: curl -s https://laravel.build/edu | bash I installed Ubuntu (Ubuntu 22.04.3 LTS) using wsl --install in my windows 10. I do have a stable internet connection and I have tried a lot of times and it always stuck here. While creating a new laravel project I am getting this error: Get:145 http://archive.ubunt

ranamoizhaider's avatar
ranamoizhaider's avatar MohamedTam...Laravel
1

Sail Won’t Start

When running ./vendor/bin/sail up, it just won't work. This is after installing a brand new version using: curl -s "https://laravel.build/example-app" | bash cd example-app ./vendor/bin/sail up System MacBook Air Apple M2 Chip macOS: Ventura 13.4.1 (22F82) Docker I've gone to the lengths of completely uninstalling and re-installing it Error that I get #0 196.1 #

dinocajic's avatar
dinocajic's avatar dinocajicLaravel
7

Xdebug 3.2 doesn't work with Laravel Sail 9 and PHP 8.2

Hi all, unfortunately on my local environment seems xdebug doesn't work correctly, i think could not connect to debugging client. I hope someone can help me, thanks a lot. In the diagnostic log on xdebug i received this error [Step Debug] Could not connect to client host discovered through HTTP headers, connecting to configured address/port: host.docker.internal:9003. Here inf

marrano92's avatar
marrano92's avatar marrano92PHP
0

Laravel Sail: SQL Server Connection Issues with SQLSRV and PDO_SQLSRV

Hello, I am currently facing an issue with connecting my Laravel project (deployed using Laravel Sail) to an SQL Server. Although I have successfully installed sqlsrv and pdo_sqlsrv (both extensions appear in phpinfo()), I receive an error whenever I attempt a connection. Error Message: Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => -1 [code] => -

lozadakb's avatar
lozadakb's avatar lozadakbLaravel
1

Error when recreating sail environment

Dear all, I recently cleaned up my docker images on my MacOS system. Today, I started again my sail environment using ./vendor/bin/sail up -d. This downloaded and created again the required docker images however, this time I get the following error: => ERROR [ 4/11] RUN apt-get update && apt-get install -y gnupg gosu curl ca-certificates zip unzip git supervisor

nick95's avatar
nick95's avatar nick95Laravel
0

Laravel sail stuck at building project stage on WSL2

I have a laravel project that I setup using Laravel sail. When I run the sail up -d command, it starts building the project but never finishes. It gets stuck at installing gnpu ... The following are the commandline logs at the point where it gets stuck. Someone help me solve this issue. I have tried researching everywhere but haven't found an answer. => [ 4/13] RUN apt-get

SimonAngatia's avatar
SimonAngatia's avatar frankieleeLaravel
7

Laravel Sail with windows not working

Hello Everyone, I'm using a Windows system with WSL and Ubuntu 20.4, and trying to use Laravel Sail with Docker Desktop. However, I'm encountering errors. Can someone please help me troubleshoot this issue? alok@DESKTOP-D2T227B:/mnt/c/Users/alokp/Music/full-version$ sail up ./.env: line 7: $'\r': command not found ./.env: line 11: $'\r': command not found ./.env: line 18: $'\r'

AlokDev's avatar
AlokDev's avatar AlokDevLaravel
6

Class "DOMDocument" not found

I've read the other posts on laracasts about Class "DOMDocument" not found, but none seem to answer the question. The error occurs on php artisan storage:link php artisan clear-compiled but 'php artisan' runs fine. Class "DOMDocument" not found at vendor/nunomaduro/termwind/src/HtmlRenderer.php:32 28▕ * Parses the given html. 29▕ */

TheDude's avatar
TheDude's avatar DiscipleLaravel
4

Docker on Laravel: I am running ./vendor/bin/sail up -d still not finishing the build it gets stuck in this line for 3 hrs.

=> [ 4/11] RUN apt-get update && apt-get install -y gnupg gosu curl ca-certificates zip unzip git supervisor sqlite3 libcap2-bin libpng-dev python2 && mkdir -p ~/.gnupg && chmod 600 ~/.g 1986.2s => => # Processing triggers for ca-certificates (20211016ubuntu0.22.04.1) ... => => # Updating certificates in /etc/ssl/certs... =>

John_Christian's avatar
John_Christian's avatar John_Chris...Laravel
2

Trying to create a Laravel app on digital ocean gives an error

Hi, What I did: I created a droplet using the docker 19.03.12 on Ubuntu 20.04 image. Then I used ssh to get into the droplet. I simply followed the getting started instructions on the laravel page: curl -s https://laravel.build/example-app | bash. At this point the docker images are being pulled in, and at step 10/19 of building laravel.test I get the following: E: Problem exec

Marijn's avatar
Marijn's avatar mcadioServers
1

Laravel sail returns errors when I do sail up

Hello, I created a fresh Laravel sail project on my remote server (ubuntu20.20) without any issue then I pushed it into my remote repository (gitlab). Now on my local machine -windows 10- I installed docker (wsl, ubuntu 20.20 ...) and the installation seems okay After that I did git pull of that fresh Laravel sail project but when I do sail up it returns me this error: abc@DES

GodziLaravel's avatar
GodziLaravel's avatar EnnioSimoe...General
1

Laravel/Docker Issue

I am trying to dockerize a Laravel app using sail so I can demo how to make an easy REST API with Laravel. I just want to be able to clone a repo onto any machine and not have to install PHP, MySQL, etc. However, I'm having some issues getting this to run. I have Docker desktop installed and fully up to date (fresh install just for kicks and giggles), I have sail in my path (so

Austin1012's avatar
Austin1012's avatar Austin1012Code Review
2

Laravel Sail build failed on M1 mac

Hi everyone, I'm trying to build the 'laravel.test' docker image on my new macbook pro with the M1 Pro chip, but I'm getting this error: => ERROR [ 5/12] RUN apt-get update && apt-get install -y gnupg gosu curl ca-certificates zip unzip git sup 21.5s ------ > [ 5/12] RUN apt-get update && apt-get install -y gnupg gosu curl ca-certificates zip un

Imadev's avatar
Imadev's avatar ImadevLaravel
1

Laravel Sail + Imagick + Security Policy

Hi folks! I am working with Laravel Sail (^1.0.1) and need to install the Imagick Library. Therefore I have published the dockerfiles. Adding Imagick is not the problem I just add the dependency to my docker/8.1/Dockerfile (last line): ... RUN apt-get update \ && apt-get install -y gnupg gosu curl ca-certificates zip unzip git supervisor sqlite3 libcap2-bin libpng-d

sirhxalot's avatar
sirhxalot's avatar sirhxalotLaravel
3

Attempting to run jenssegers/mongodb on Sail

I am having problems with the setup portion of mongodb. Mongo is installing properly, but I can't seem to enable the extension. I have attempted manually using the RUN command to echo the mongodb.so extension into my php.ini file. But I always end up with the same error when I attempt to run ./vendor/bin/sail composer require jenssegers/mongodb. Warning: PHP Startup: Unable to

ldslaracasts's avatar
ldslaracasts's avatar ldslaracas...Code Review
7

sail build fails

hi guys, when i run sail build --no-cache i get the following error, does anyone know what Im doing wrong?keep in my mind that i've built the docker image with sail successfully on this project many times, I tried to do a new build because I wanted to change the host address and port, but even reverting back to the old values, it still wont build #7 115.5 Reading state informat

michalis's avatar
michalis's avatar jaahvickyLaravel
18