Database trouble - Error Number: 1096

[eluser]xwero[/eluser]
[quote author="coldKingdom" date="1204059792"]
Gallery.php - Model

Code:

<?php
class Gallery extends Model {

    function Gallery()
    {
        // Call the Model constructor
        parent::Model();
    }
    
    function get_last_ten_entries()
    {
        $this->db->select("gallery_picture");
        $this->db->from('tbl_gallery');
        
        $total = $this->db->count_all_results(); //Without this it works perfectly
        
        $query = $this->db->get();
        
        return $query->result();
    }
}
?>

An Error Was Encountered
Error Number: 1096

No tables used

SELECT *

I don't know really what more i can do to make it easier. I can test 1.5.4 and 1.6.0 if you wan't me to.[/quote]

Try this

Code:

function get_last_ten_entries()
    {
        $this->db->start_cache(); //added
        $this->db->select("gallery_picture");
        $this->db->from('tbl_gallery');
        $this->db->stop_cache(); // added
        $total = $this->db->count_all_results(); //Without this it works perfectly
        
        $query = $this->db->get();
        $this->db->flush_cache(); // added
        return $query->result();
    }

Those functions are added in 1.6.1 because the count_all_results method resets all the above sql statement building methods.