DB Where function doesn't resets after running query

[eluser]OwanH[/eluser]
OK this may seem like a crazy suggestion but try replacing but try replacing these two lines:

Code:

$this->db->where('id', $id);
$query = $this->db->get($this->tables['media']);

with this line:

Code:

$query = $this->db->getwhere($this->tables['media'], array('id' => $id));

To be honest I actually don't see anything wrong with your code, and I don't think you should be getting the problem you are getting, especially since you have not enabled CI's query caching, but hey you could give this a try and see if it helps .