Level 13
What's a blank rule? Do you mean an empty line in your console or something else?
Try running php artisan migrate -vvv to run it at maximum verbosity.
Also, check your logs in storage\logs, there might be a clue there.
Aug 9, 2018
10
Level 1
PHP Artisan Migrate leaves blank rule
Hello everybody. Laravel newbie here. Since I changed my job, they want me to learn Laravel. I've been following the Laracasts, but with the database migration, I stumble upon a problem.
The line "php artisan migrate", does not do anything. It leaves a blank rule and then it stops. I assume there is an error. Though I cannot find anything to turn error reporting on, so I can know WHAT the error is.
I've also tried "php artisan migrate:refresh", to no avail. With the "mysql" command, it show (logically) no tables. I really been struggling with this.
If more info is needed, I shall provide it.
UPDATE: I tried to go to localhost/phpmyadmin which returned a 404 - not found. It's a valet thing, so I'm going to look into that first.
UPDATE TWO: After a lot, A LOT, trial and error, I managed to get it working. Making the swap to MariaDb allowed me to return error messages. I reinstalled MariaDB, with secure settings. Edited those settings into my .env file and now I'm finally able to migrate. Thanks for the help lads, appriciate it!
Level 1
I've checked the storate\logs folder. There's nothing in it. I update the OP with a screen shot. It is indeed an empty line.
Level 13
hmm no output at all is a bit weird, especially with verbosity set to max.
Were there any issues at all when you ran composer install?
For general debugging purposes, could you try running php artisan clear-compiled and composer dumpautoload and trying again?
Level 1
There were no errors at all with the tips you provided. I even tried "php artisan config:cache", and rerun it afterwards. Still no luck. At this point I'm considering a complete re-installment.
Level 13
It might be worth a shot. Reinstalling laravel shouldn't take you very long at all, and it's not like you'd be losing your work.
Ping back if it doesn't solve anything.
Level 35
It looks like your migration is still 'running'. Are you able to run any other artisan command like php artisan route:list for example?
And are you able to connect to your database at all with your application? If you can run artisan command try running php artisan tinker and than enter DB::select('SELECT DATABASE()');
Level 1
I can run various artisan command, yes. I typed in "PHP Artisan migrate" yesterday and this morning, it was still "running".
Going to uninstall Mysql and install MariaDB. Perhaps that will do the trick.
Another update. With MariaDB, whenever I try to log in into my database, it returns: "Plugin caching_sha2_password could not be loaded:".
Level 13
It's unlikely that swapping mysql for mariadb will solve anything.
Have you tried a fresh laravel install? As in create a new laravel project, run php artisan make:auth, followed by php artisan migrate. If that works, it's likely a problem in your app somewhere. If it doesn't, then look at your infrastructure.
Level 1
It does now return an error message.
"PDOException : SQLSTATE[HY000] [2006] MySQL server has gone away".
Whenever I try to log into my mysql to run it I'll get this error: "Plugin caching_sha2_password could not be loaded".
God, Laravel loves me <3.
Level 8
I had the same issue after upgrading mysql with brew.
To fix it I added this to my /usr/local/etc/my.cnf file:
[mysqld]
default_authentication_plugin=mysql_native_password
Then I restarted mysql with brew services restart mysql.
This blog post helped explain why this fixed the issue: https://laravel-news.com/laravel-and-mysql-8-fixing-mysql-server-has-gone-away-error
1 like
Please or to participate in this conversation.