Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Dialect is Not Configured (Phpstorm)

I am working on Google oauthorization2 and I encounter problem that

SQL dialect is not configured

That's why my query is not executing and data is going to table.

I have listed below both of queries where I encounter problem.

Tools: PhpStorm 8+ MySQL Localhost

$user_exist = $mysqli->query("SELECT COUNT(google_id) as usercount FROM google_users WHERE google_id=$user_id")->fetch_object()->usercount;

$mysqli->query("INSERT INTO google_users (google_id, google_name, google_email, google_link, google_picture_link)
        VALUES ($user_id, '$user_name','$email','$profile_url','$profile_image_url')");
like image 973
RAZA MUSTAFA Avatar asked May 23 '15 10:05

RAZA MUSTAFA


2 Answers

Head to File > Settings > Languages & Frameworks > SQL Dialects and set it for the whole project.

like image 95
Michael Bolli Avatar answered Oct 18 '22 05:10

Michael Bolli


This is a screenshot of how to do that inside the settings: enter image description here

This is on version 2016.3

like image 81
S.Mason Avatar answered Oct 18 '22 05:10

S.Mason