Warm tip: This article is reproduced from stackoverflow.com, please click
mysql phpstorm

Unable to resolve valid table in PhpStorm

发布于 2020-04-18 09:35:11

I'm getting unable to resolve table errors appear in php files containing SQL querying valid tables.

enter image description here

If I Ctrl + Enter over the query, then I get expected results in the DB console, and if I expand the database in the DB explorer tab then I can see the tables.

It's not affecting code execution, but it's annoying because it catches my eye when writing code, and it masks real SQL errors.

I've tried refreshing the database connection, and I've verified that the php tab is connecting to the correct database.

Questioner
Parris Varney
Viewed
87
分享
LazyOne 2016-07-13 03:38

Try re-creating DB connection from scratch (delete existing one and create it again).

Thinking of possible reasons ... I can think of this scenario:

  • working with project in current stable version (currently 2016.1.x);
  • trying EAP build for next version (2016.2 at this moment) on this project and make some DB-related changes there (even simple syncing DB);
  • going back to stable version (2016.1.x) .. and because new version uses newer file format/versioning for DB-related data (cached DB structure etc) IDE may start ignoring "unknown/newer" format for such data and instead of throwing appropriate warning it just "silently" throwing "unresolved table" message.

No other ideas.

Steen Schütt 2019-09-04 14:17:16

For me it helped going to the datasource properties and unchecking Current Schema leaving only the correct database checked. Otherwise it would try to resolve everything from the information_schema database.

LazyOne 2019-09-04 20:14:11

@SteenSchütt This suggest me that you may not have selected the DB in Connection settings... At very least that's my thoughts on possible reason for such behaviour.

Steen Schütt 2019-09-04 20:42:33

I had selected both Current Schema and the database I wanted. I suppose information_schema was the current, but I'm just pointing it out as an additional debugging step.

Related issues

1
Create a model with a foreign key to a table not created by SQLAlchemy
2
Update sql database by clicking checkbox without submit button using ajax
3
MYSQL filled some rows, but was't suppost to
4
Directus calculated field / column
5
How to count messages for a user with php and mysql
6
How to get numbers of rows and columns using QtSql?
7
How do I get django "Data too long for column '' at row" errors to print the actual value?
8
LPAD without trimming in mysql
9
MySQL query from JSON datatype column that has backslash character
10
How to include a PHP variable inside a MySQL statement