Comments (9)
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.
Related Issues (20)
- Generating models with_property_constants doesn't work correctly
- error HOT 1
- Please delete this HOT 1
- Feature request for Base File to make this package more Advanced
- Add return types to generated relations HOT 1
- Development for sql server support HOT 1
- Error creating models - Laravel 9.52.6 HOT 1
- Laravel 11 support HOT 13
- Laravel 11 - SQLite Support HOT 4
- "Target class [files] does not exist." when register provider "Reliese\Coders\CodersServiceProvider::class" in config/app.php
- Incorrect type-hints on properties when using base classes
- Don't work realease/laravel HOT 2
- LARAVEL 11 : mkdir(): Invalid path HOT 1
- i need help....! i using laravel 11 HOT 1
- Method Illuminate\Database\PostgresConnection::getDoctrineSchemaManager does not exist HOT 1
- foreach() argument must be of type array|object, null given
- issue \PostgresConnection::getDoctrineSchemaManager does not exist
- Relationships that soft-delete should have nullable property type-hints
- Problem with v11 laravel HOT 1
- Laravel 11 PgSQL and Sqlite Problem HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from laravel.