no data source are configured to run this sql and provide advanced assistance

On the Phpstorm IDE I am getting 'no data source are configured to run this sql and provide advanced assistance'

 

 

Is this (the above) preventing / prohibiting me from establishing a database connection? Or is this merely saying I have the ability to connect to my database through the IDE.

 

As currently I am having a problem connecting to mysqli (php admin) and trying to understand if phpstorm is blocking it.

 

 

1 comment

Hi there,

This simply means that you have not configured any Data Source in Database tool window ... so IDE is unable to verify the correctness (existence) of DB tables/fields/etc (in your particular case: "categories" table/view) used in that SQL fragment and therefore cannot offer code completion assistance for such entities.

You may work without any Data Source defined and just disable that particular inspection in IDE Settings/Preferences.

https://confluence.jetbrains.com/display/PhpStorm/Databases+and+SQL+Editor+in+PhpStorm

0

Please sign in to leave a comment.