UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=0μs
[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 '' at line 1


how to solve it,

 public function updateViews( $id ) {
    return $this->dao->query('UPDATE '.$this->getTable_Banner().' SET b_views=coalesce(b_views, 0)+1 WHERE b_id='.$id);
  }

You have incorrect id in where clause

 

Pls check the uploaded screenshot,
That's the real pic of error,

User id?

Check first line you posted

 
thats dummy copy, by mistake copied.

WHERE b_id=0μs

image is real.
all error output represent through pic

Error reference to that line. It must be integer.