Query not showing all the rows

I would start by breaking down your query to see if you get different results.

PHP Code:

$this->db->query("SELECT * FROM log_event"); // Start here and keep building up to what you want

$this->db->query("SELECT id,date_register FROM log_event");

$this->db->query("SELECT id,date_register FROM log_event ORDER BY id DESC");