[eluser]SitesByJoe[/eluser]
Everyone,
Thanks for taking a moment to read this: I'm scratching my head in disbelief atm.
Here's the deal: I have a site that's nearing completion. I go to upgrade my CI installation from 1.6.1 to 1.7.0 (1st stupid mistake since I was almost done)
None of my models work!
I rollback - still my models don't work!
I managed to isolate my newly acquired troubles to one particular piece of code:
This works: $this->db->query('SELECT * FROM songs');
This causes a 1051 error: $this->db->select('songs.*');
Here's the controller method I'm using to test:
Code:
function index()
{
$query = $this->db->query('SELECT * FROM songs');
print_r($query);
$this->db->select('songs.*');
$query2 = $this->db->get();
print_r();
}
Here's the result in the browser:
CI_DB_mysql_result Object ( [conn_id] => Resource id #48 [result_id] => Resource id #68 [result_array] => Array ( ) [result_object] => Array ( ) [current_row] => 0 [num_rows] => 13 [row_data] => )
An Error Was Encountered
Error Number: 1051
Unknown table 'songs'
SELECT songs.*
What is going on?!?!? I tried reloading my CI files several times!