Error when running php artisan code:models about laravel HOT 9 CLOSED

Do you have a database which name is 53? Because that seems to be the error.

from laravel.

Yes, double checked my config/database.php and .env files. Nowhere there was a mention of a database called "53" only "rappa53". So it's strange that the database "53" was queried anyway.

Well, it's solved for the moment. All new models (29!) have been created by your nice package. So a great time saver. Thank you very much. Hope others can benefit as well from your nice work. Again, much appreciated!

from laravel.

I'm happy you liked it. Don't hesitate to reach me if you encounter another issue 😄

from laravel.

It might be a configuration mistake in config/database.php or your .env file. If that is not the case, could you please show me the output of "SHOW DATABASES;" from your MySQL client.

from laravel.

Thanks @CristianLlanos. Yes, for another project I had a database called 53. However the database for the project where your nice package is installed is named "rappa53". Temporarily removed the other database 53 and now it seems to work fine. Thanks for your quick reply. Much appreciated!

from laravel.

It seems kind of weird, right? MySQL didn't complain about that name when you created it, but now that we are making a query to get information from that database it squawks.

from laravel.

It think I've got an idea from "access violation". I believe your database user might not have permissions to query the other database (53).

from laravel.

It turned out it was a bug in my query (#5). It has been fixed, now 😄

from laravel.

It is not getting the database name which we have specified in .env file, instead it takes other database name and that DB name if we search in whole project, we can not find anywhere, don't know why this happen?
I need to delete the database from mysql which specified in error

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.8 WHERE Table_type="BASE TABLE"' at line 1 (SQL: SHOW FULL TABLES FROM laravel_blog_5.8 WHERE Table_type="BASE TABLE")

from laravel.