Raw SQL in log file shows wrong query SQL text

[kirkkhua]

I think, in DB class, Init method it would be better to use:

echo $this->ExceptionLog($e->getMessage(),$query);

instead of

echo $this->ExceptionLog($e->getMessage(),$this->sQuery->queryString);

with UPDATE query.

[wickyaswal]

What do you mean with UPDATE query ? When the user provides an update query the class should use this :

 $this->ExceptionLog($e->getMessage(), $query);

[kirkkhua]

The code you provided showed me following:

Time : 00:01:14 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_id = ? LIMIT 1' at line 5 Raw SQL : SELECT * FROM users WHERE phone_number='1' LIMIT 1

Taw SQL above runs without any errors (I removed some quotes to use GitHub markdown), while another query in the same script with "UPDATE ..." contained syntax error. The problem is that code you've provided above shows different query which doesn't contain any errors.

You may also see that log is pointing on line 5 while it is hard to imagine that there is 5 lines in such simple query.

[wickyaswal]

Yes. Instead of using $this->sQuery->queryString, the direct $query variable would be better.
I've replaced that line.

Thanks again smoyzasoboy 👍