<reference> expected, got '${' error

$this->db->query("DELETE FROM " . DB_PREFIX . "customer


Hi Newby here, in my model.php files i get an error :

error.jpg
Can anybody instruct me on how to supress this error. Or at least tell me what the syntax should be. (opencart)

Thanks
Steve

3 comments
Comment actions Permalink

Hi there,

What PhpStorm version do you use exactly?

If v8 -- please try v9 Public Preview build -- there were some improvements in this regard.

Other than that:

Watch these tickets (star/vote/comment) to get notified on progress.

---

Alternatively (considering how these queries are assembled anyway) I may suggest changing SQL Dialect from specific one (most likely MySQL in your case) to "Generic" one where you will have only syntax highlighting for SQL and no error checking.

0
Comment actions Permalink

Thanks Andriy, apprieciated.
In answer to the question about phpstorm version , i had , just the other day, installed the v9 EAP. To see if this was fixed. As its a known issue and i now know whats causing it, im happy. I Look forward to it being fixed.

P.S also i had changed SQL Dialect from mySql back to generic, in settings. A "shot in the dark" action, rather than constructive troubleshooting though.LOL I will revisit to make sure.

Thanks Again,
Steve

0
Comment actions Permalink

Hi,

Getting the same error in 9.0, are there any reported bugs around this? I've got lots of lines of code like this - it's very annoying seing all those error when I try to check in :)

https://devnet.jetbrains.com/servlet/JiveServlet/download/2-22394/phpstorm.png
https://devnet.jetbrains.com/servlet/JiveServlet/download/5548813-22393/phpstorm2.png

 
$sql = "INSERT INTO " . $this->entity . " (" . $fields . ") VALUES (" . $valueStr . ")";


With thanks,
Richard



Attachment(s):
phpstorm2.png
phpstorm.png
0

Please sign in to leave a comment.