Laravel is no longer loading in my browser!

So somewhere after this video https://laracasts.com/series/laravel-5-fundamentals/episodes/7 My homestead is no longer loading in safari, it just says "Can't open page". Besides the video I have been takin the Team Treehouse Javascript course and tried applying what I learned to my views in Laravel. I made the following changes in Laravel, could any of the following c

jwavess's avatar
jwavess's avatar gildniyGeneral
12

PHPUnit mysql test database Laravel 5.2

I'm trying to setup a testing environment with the latest Laravel. Is there a way to create a .env.test file and have phpunit use that file? All the examples I have seen, is to use sqlite for your test database. That doesn't feel like a best practice to me, and wanted to know why this was standard.

alexrfan03's avatar
alexrfan03's avatar ifpingramTesting
15

Auth::attempt works only on localhost

Auth::attempt works only on localhost. When I do: php -S localhost:8888 -t public the login method works, but when i do: php -S 192.168.0.1:8888 -t public The page loads but when I try to authenticate it just fails. I can read from the database but it just doesn't seem to work. I am using sqlite on my local machine. Any ideas?

cameronasmith's avatar
cameronasmith's avatar cameronasm...Laravel
0

Whats up guys, the newbies got another question!

So on the migration video Mr. Jeffery said used the "php artisan migrate" command within his project directory, and he made sure that sqlite was installed. So when I tried it I got this message. [PDOException] SQLSTATE[HY000] [2002] No such file or directory I do have Mysql installed, and sqlite via Homebrew. My default DB is MySQL, if that helps. Thanks guys! Can't w

jwavess's avatar
jwavess's avatar PendoGeneral
15

Migration for every test?

I've currently got 44 tests (mostly acceptance-test types), and each test is taking several minutes to run. If what I think I'm seeing is what's really going on, phpunit is migrating, seeding, and then deleting the db for each test. Is this what should be happening? My tests are painfully slow (several minutes each at least), but if it's running the migration, that would be why

llhilton's avatar
llhilton's avatar skelikem@g...Testing
4

Local VM database has incorrect name

I setup VirtualBox and Homestead on my local Windows 7 machine and while going through the Migrate video in the L5 Fundamentals series I found that my database is called "main" instead of "homestead". I don't know how this happened and would appreciate any help in changing it because when I run php artisan migrate, the migration works fine, but I don't know

Venom Rush's avatar
Venom Rush's avatar lindstromGeneral
9

php artisan clear-compiled is trying to read databases before phpunit

I'm starting to work in CI with Semaphoreci ( https://semaphoreci.com ) and the instruction for the process are very simple: In a Ubuntu VM, php 5.6 server, do a pull from Git Run "composer install --prefer-source" Run "phpunit" The problem appear on 2), after installing dependencies from the lock file, Laravel execute the command "php artisan clear-c

punchi's avatar
punchi's avatar punchiTesting
1

Eloquent does not deal with binary information correctly in PostgreSQL.

It's impossible to insert binary data using PostgreSQL with Eloquent Postgres requires that binary data is marked with a special PDO attribute on bindValue, PDO::PARAM_LOB. Not doing this raises the following error: SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte sequence for encoding "UTF8": 0x ... This is despite the fact that the column type i

Jawsh's avatar
Jawsh's avatar JawshEloquent
1

I would like to see more real life examples for different domains of activity

The videos are great, I learnead alot, but Laravel is a worderfoul framework that coud do much more. So if you can make more videos fore real life examples like : multiple sorting with checkboxes,dropdown menus, complex searching dynamic multiple dropdowns on select creating a datagrid sistem for admin area chat with multiple roles ecommerce examples (not just add to cart but

tolby's avatar
tolby's avatar ohffsLaravel
4

Altering foreign key for a table in new migration not working

I have a pivot table named 'author_book' & i'm using sqlite This is the create method of the table Schema::create('author_book', function (Blueprint $table) { $table->integer('author_id')->index(); $table->integer('book_id')->index(); $table->timestamps(); $table->foreign('author_id') ->re

arnabrahman's avatar
arnabrahman's avatar arnabrahma...Laravel
5

php artisan not working

Hi I am beggining with laravel and I was using sqlite database but now I am switching to mysql, so I changed the app/database.php file accordingly and when Im trying to migrate the tables Im getting these errors. [Illuminate\Database\QueryException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'elbeplus.categories' doesn't exist ( SQL: select * from 'categories') [

Gularis's avatar
Gularis's avatar GularisLaravel
0

Artisan Tinker output looks different to video

Hi All, I've quite new to programming and have been following the laracasts tutorial. I've reached a point where the video started using Artisan Tinker and I was wondering why the output in the video looks very different to the one in my console? Is this due to the console emulator I'm using? I'm using ConEmu in PowerShell Admin mode and am using MySQL instead of SQLite. Also,

flimp's avatar
flimp's avatar flimpLaravel
8

MySQL format

Greetings, I have changed my DB from sqlite to MySQL and now dates stopped to be properly represented. I have a code similar to this: $receipt = Receipt::create($request->all()); Should I remove the date from request->all() somehow and then modify it by Carbon and then send to the MySQL database - it seems to me a bit complicated. So far I have thought of something like

0re1's avatar
0re1's avatar 0re1Laravel
3

Starter application (Vue.js, Laravel, Dingo, JWT)

Vue.js Starter Project Hi, For my own projects and for you all to try out, I've created 2 new repo's on Github that should serve as a nice example on what a single page application made in Vue.js could look like when using a backend API. 1. Frontend Vue.js 0.12.15 vue-router vue-resource vueify envify to accomodate builds in different environments Laravel Elixir for Gulp magi

layer7's avatar
layer7's avatar briangreen...Vue
15

sqlite3

i'm running wamp php & laravel on windows. Apparently I have SQLite already installed on my system. What is the path in windows to SQLite3? The tutorial does not explain it for the windows environment.

BazKow's avatar
BazKow's avatar BazKowGeneral
0

Timestamp Nullable throwing error when Null

I have a form with several date inputs, majority of them are nullable fields, receiving this error when the field is left blank Invalid datetime format: 1292 Incorrect datetime value: form looks like this: <div class="form-group"> {!! Form:: label('date_of_visitation','Date:' ) !!} {!! Form:: input('date', 'date_of_visitation', null, ['c

jbowman99's avatar
jbowman99's avatar phildawsonGeneral
5

Eloquent still using old database connection

I have created a very basic laravel app that uses the default Auth controller and table, using this I have registered one user to allow me to login. I started development in my Laravel app using sqlite, however I have decided to change this to mysql, I have made the appropriate changes in my .env and database.php files. Artisan now uses the new db (mysql) for migrations and any

cluel3ss's avatar
cluel3ss's avatar DzemalEloquent
2

Laravel 5: Database Migrations (Help!)

Some useful Information: Im running on OS X (El Capitan Beta) ,Im using XAMPP ,I've successfully installed Laravel 5 and I can confirm it works. Here is my migration file: <?php use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateUsersTable extends Migration { /** * Run the migrations. * * @return void

karth123's avatar
karth123's avatar bugsyshaLaravel
4

artisan config:cache = database.sqlite does not exist

I'm using sqlite db After running: php artisan config:cache I get this on every route: InvalidArgumentException in SQLiteConnector.php line 34: Database (.../storage/database.sqlite) does not exist. ... Then if: php artisan config:clear Everything is back to normal. Why!?! Please help!

oleynikd's avatar
oleynikd's avatar oleynikdLaravel
5

onDelete('cascade')

I have 2 models: Lesson and Module with a manyToMany relationship; There is a coresponding lesson_module pivot table: Schema::create('lesson_module', function (Blueprint $table) { $table->integer('lesson_id')->unsigned(); $table->foreign('lesson_id')->references('id')->on('lessons')->onDelete('cascade'); $table->integer(

Bloomanity's avatar
Bloomanity's avatar BloomanityTesting
4

Nested resources more than 2 deep throwing 404's with MySQL.

So, strange issue I’m having with nested resources in 5.1, I have a route defined as groups.feeds.images with route model binding for groups, feeds and images. Now locally, using sqlite and the built in artisan serve, if I hit {url}/groups/1/feeds/1/images/1 I get the resource I am after, but on our production server running ngix and mysql, we get a resource not found. Now this

JoeMaher's avatar
JoeMaher's avatar helmerdavi...Laravel
6

Unit testing Elasticsearch queries

Right now all of our unit tests talk to MySQL and Elasticsearch. I'm working on moving the tests over to using a mix of DB mocks and SQLIte, but I'm curious how you all work with unit testing Elasticsearch. I know I could just overload the Elastic handlers in our app with mocks, but that wouldn't really test anything, because who knows if the queries in the code actually work o

erunion's avatar
erunion's avatar erunionTesting
2

Access denied for user 'homestead@localhost'

Running into a bit of a problem here... Error I get: http://puu.sh/j6lxt/3558ef310b.png my .env file is as follows: APP_ENV=local APP_DEBUG=true APP_KEY=syqmYS5VelqhTirG1bWv8wV1sEN4s5ge DB_HOST=localhost DB_DATABASE=message_app DB_USERNAME=root DB_PASSWORD= CACHE_DRIVER=file SESSION_DRIVER=file QUEUE_DRIVER=sync MAIL_DRIVER=smtp MAIL_HOST=mailtrap.io MAIL_PORT=2525 MAIL_USER

chern123's avatar
chern123's avatar mdobrenkoLaravel
1

uploading app on bluehost shared server

Hi, I just finished my first project with a sqlite server I have an old website running on a bluehost shared server where i want to upload my app. Now I have read that shared hosting is not recommended and so on, but i do want to give it a try on bluehost before buying some new serverspace. i'm trying to upload my app on a subdomain (project.mywebsite.com) so the current websit

hikups's avatar
hikups's avatar hikupsLaravel
0

uploading app on bluehost shared server

Hi, I just finished my first project with a sqlite server I have an old website running on a bluehost shared server where i want to upload my app. Now I have read that shared hosting is not recommended and so on, but i do want to give it a try on bluehost before buying some new serverspace. i'm trying to upload my app on a subdomain (project.mywebsite.com) so the current websit

hikups's avatar
hikups's avatar hikupsLaravel
0

[5.1.6] Migration can not create column

Hello, I try to add a column to table that is already exists. https://github.com/laravel/framework/issues/9550 This is my issue in github. First of all i think is a bug in migration. If you follow the conversation will find that i'm agree it's not. Here is a picture of my code - http://prntscr.com/7pu2wa and picture of the result http://prntscr.com/7pu3n2 edit 1: I'm using SQL

osaev's avatar
osaev's avatar osaevLaravel
5

Are repositories really the way?

So I've been thinking about repositories recently, and questioning their usefulness when working with Eloquent (or really any ORM). Some thoughts: 1. Repositories allow you to swap out your data source (rely on interfaces) While this is maybe a strong argument for some, in my experience it isn't. I don't ever plan on changing my ORM, at least not without a major rewrite. And El

reinink's avatar
reinink's avatar simensenLaravel
47

Query where created_at ...

Hi, I would like to query a model where the year of the timestamp created_at is equal to the current year or a given year. I'm using SQLITE I found while googling the following solution: ->whereRaw("strftime('%Y', created_at) = strftime('%Y', date('now'))")->get(); Is there a better solution? Something more elegant? (I'm not an expert at all) This query produ

jrean's avatar
jrean's avatar jreanEloquent
2

How to set up and define your database for integration testing

Despite the fact that "Laravel is build with testing in mind" I find this part not as intuitive as all the other great parts of the Laravel landscape. And the changes for the environment handling doens't make things easier. I don't know if other devs see it the same way as I do. So I'am willing to send a pull request to improve the documentation based on the response

pixelpeter's avatar
pixelpeter's avatar christophr...Tips
2

On Delete Cascade

Hi, I have a Venue and Event table. A Venue can have many Event(s). An Event belongs to many Venue(s). ... I have a pivot table venues_events The migration is as follow: $table->increments('id'); $table->integer('venue_id')->unsigned(); $table->integer('event_id')->unsigned(); $table ->foreign('v

jrean's avatar
jrean's avatar polyphemEloquent
5

Bulk DB Inserts Randomly Regressing?

Hey all, first post here so forgive me if I'm breaking any convention. I'm having this weird problem with an Artisan command that inserts huge (several GBs) amounts of data in a SQLite database. Basically, the command appears to run fine for a long time, periodically reporting how far along in terms of completion it is. When the command finishes (apparently successfully) I chec

alixaxel's avatar
alixaxel's avatar alixaxelEloquent
0

PHPUnit can't connect the oracle DB

I have migrated all the MySQL data to SQLite, replace MySQL function (like date_format, concat etc). But the main problem is, I have some data in Oracle DB. On production server everything is good. But when I tried to test the class, PHPUnit can not connect to oracle. I get error like this: Fatal error: Call to undefined function yajra\Pdo\oci_connect() in C:\wamp\www\usfoot\ve

Mego's avatar
Mego's avatar MegoTesting
1

Migrate whole database with Laravel-5-Generator

I want to use this: https://github.com/laracasts/Laravel-5-Generators-Extended I have a large MySQL database with more than 100 tables and thousends of rows. I need to make a migration of it and make a database/migrations file, where will be everything (siže of file is irrelevant). Then I need to migrate whole database with all tables,values,keys,... into SQLite to start testin

Mego's avatar
Mego's avatar mstnorrisTesting
7

Setting up the environment

Hi Laracasts, I will soon be making an API with Lumen and I decided to setup a project on my laptop for some practice before I setup the real project at work. I wanted to get some database interaction so I installed sqlite. I've never used it, but I know mysql and aside that, I just want the drivers to work so that I can interact with it through eloquent. Right now in my .env f

beznez's avatar
beznez's avatar lukeeLumen
19

Laravel 5.1 testing env's always reads local configuration

I'm using sqlite in memory for testing in L5.1. I have 'default'=>'sqlite' in config/testing/database.php. env.testing has APP_ENV to testing. but when I run my tests, the tests hits the Mysql DB which apparently reads configurations from .env file instead of .env.testing. any ideas why this is causing? everything was smooth until upgraded to L5.1.

zals's avatar
zals's avatar craigwebst...Testing
1

Connecting to Mysql on a Vagrant Virtualization

Hi, I know there a looot of topics concerning this problem but I can't figure a way out of this one. I installed vagrant with this video from laracasts: https://laracasts.com/lessons/get-off-mamp-now. But this forums everybody talks about homestead. My configuration files doesn't looks like a homestead release or else but it's working for most of it. I'm following all the basic

dib258's avatar
dib258's avatar bashyServers
13

Setting up MySQL with Laravel 5

Hi, I'm completely new to Laravel (and relatively new to PHP in general) and I've been working through Jeff's Laravel 5 intro series. So far so good, using SQLite as per the videos. However, I have a pre-existing MySQL database that I'd like to use as well (or rather, instead). But I have no idea how to actually set it up in Laravel/Homestead. Ideally I'd like to eventually exp

TimeSocks's avatar
TimeSocks's avatar coderooneyLaravel
7

Foreign Key Constraints on seeding

when I am running a db:seed I disabled foreign key constraints on DatabaseSeeder.php: Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); $this->call('UsersTableSeeder'); ........ DB::statement('SET FOREIGN_KEY_CHECKS=1;'); It works fine with MySQL, but if I change the database configuration to sqlite I got the following error: SQLSTATE[HY000]:

WillyCornelissen's avatar
WillyCornelissen's avatar pgogyEloquent
7

.env Not Reading Variables Sometimes

I've set up a custom variable in my .env file, DISPLAY_TZ, to designate the timezone that the app should display times in. I have the User $tz variable being set to this using getenv('DISPLAY_TZ')?:date_default_timezone_get() and then used by calling setTimezone(Auth::user()->tz) on my Carbon object in the view. Seemingly at random, the times displayed will be in UTC (the da

kaylakaze's avatar
kaylakaze's avatar wazzamouseGeneral
48

Ubuntu 14.04.2 Laravel 4.2.0 PDOException could not find driver MySQL

I want Laravel 4.2.0 working on my Ubuntu 14.04.2 LTS Server. What I have done until now: Installing Ubuntu 14.04.2 sudo apt-get install apache2 sudo apt-get install mysql-server Install Openssl Install libmcrypt Install PHP by ./configure --with-openssl --with-mcrypt --enable-mbstring --with-pdo-mysql --enable-pdo --with-mysql make make install Download Lara

weakprotos's avatar
weakprotos's avatar abaamGeneral
10

Using PHPSpec to test repositories in L5

Hi all, I've a bunch of eloquent repositories I want to test. With Laravel4 and PHPUnit I used to have a database config file for the testing environment with an sqlite in memory database. Then with the aid of testdummy I was able to test my repositories. Now I switched to PHPSpec and L5 and I don't have any idea on how to reproduce that workflow, so I'm here to ask for your he

Fed03's avatar
Fed03's avatar JeffreyWayTesting
3

composer require - PDOException: SQLSTATE[HY000] [2002] No such file or directory

I get the following error when I run composer require from my host machine. I'm running Laravel 5 with Homestead. composer require graham-campbell/markdown Warning: This development build of composer is over 30 days old. It is recommended to update it by running "/usr/local/bin/composer self-update" to get the latest version. Using version ~3.0 for graham-campbell/mar

mstnorris's avatar
mstnorris's avatar MrAlmostWr...General
5

Data sync examples between databases

I would be interested in a topic that demonstrate how to sync database between databases, particularly between sqlite and mysql. While I do realise there are some tools that facilitate that, I would like to see something that can explain that in good detail especially when it comes to ensuring that data is pulled through correctly. Any ideas would be great.

eokorie's avatar
eokorie's avatar hstung11Requests
1

Speed Up Tests? (Codeception)

I've got a L4 app (dev environment on homestead) that has a fairly large test suite (currently 121 functional tests). Having all these tests is great, but running them all can take quite a while. I've explored options for speeding them up, but have yet to find anything that really works for me yet and wanted to see if anyone has any other suggestions. Here's what I've tried / d

austenc's avatar
austenc's avatar austencGeneral
2

Stateless API with HMAC

I'm porting a SlimFramework API to Laravel 5. The app is stateless, uses HMAC for auth and has no UI. It also has no central database but uses a single sqlite db per account. Outside of the no central database scenario this is a pretty common use case in Slim. While I like all the goodies in Laravel for a UI centric app, I'm hoping to slim down the footprint for an API centric

MarkGidman's avatar
MarkGidman's avatar MarkGidmanTips
0

Artisan created model missing properties

Hi, I am new to Laravel. I installed Laravel 5 and then created object model with artisan: php artisan make:model User I had table users (created via migration in sqlite) with ID and timestamp installed before (added some fields to suite my needs). Yet when I try to create object instance in artisan tinker: $user = new App\User; I got an empty object without timestamp or ID h

0re1's avatar
0re1's avatar deadlockgBGeneral
1

Setting up MariaDB with Laravel 5

I have been trying to get my application to connect to MariaDB for some time now without success and it's been driving me crazy ! I have been following the Laravel 5 from scratch tutorial and have been to the end of it, however, upon deciding to go from a Sqlite database connection to MariaDB I have not been able to connect to the database. I am using a Homestead and vagrant se

ferenax's avatar
ferenax's avatar eusapxaiGeneral
7

Gotchas

I hope this takes off. If it does, I'll be checking it daily and adding to it as I discover new ones. What am I talking about? I'm suggesting that we post the GOTCHAS we come across, possibly saving each other tons of time. Here's my first: SQLITE uses RANDOM(), and MySQL uses RAND(). While testing a controller method (using an SQLITE database) instead of the production (MySQ

Richierob62's avatar
Richierob62's avatar Richierob6...General
0

Composer installing problems Laravel 5

Hi. I installed a fresh Laravel 5 on my service server. ( currently my server has some service that is created by Laravel4 on running. ) But after composer installing, it shows me some kind of suggestions to install. symfony/var-dumper suggests installing ext-symfony_debug () symfony/translation suggests installing symfony/config () symfony/security-core suggests installing sym

SEUNGMUN's avatar
SEUNGMUN's avatar SEUNGMUNGeneral
2

Enforcement, Entities, and Eloquent

Enforcement, Entities, and Eloquent I tried to find useful infos about how to do model validation (or business logic validation) in Laravel and at some point, I stumbled upon Jeff's video about model validation, but he calls it Enforcement, Entities, and Eloquent. While the video is a decent start, I found some bugs in the code that I want to share with you, together with a bet

cm's avatar
cm's avatar xrootTips
4