Unable to resolve valid table in PhpStorm

In 2017.2 I had to go to

Settings > Languages & Frameworks > SQL Resolution Scopes

and add my project and database link in there to get it right again.


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.

Tags:

Mysql

Phpstorm