[eluser]Clooner[/eluser]
Code:
$this->db->set('read' , 1);
$this->db->where('id', $id);
$this->db->update($this->table);
Is the code I use to generate my update query. This would come out looking like this.
Code:
UPDATE news SET read = 1 WHERE `id` = '9'
This always worked until this morning. Right now I get a database error saying the query is incorrect.
I can change the code to
Code:
$this->db->set('`read`' , 1);
$this->db->where('id', $id);
$this->db->update($this->table);
This would come out looking like this.
Code:
UPDATE news SET `read` = 1 WHERE `id` = '9'
And this works. What did I do to my mysql to no longer accept the first query? Or is this a CI thing?