simple_query question

[eluser]John_Betong[/eluser]
[quote author="Derek Allard" date="1200420403"]Yeah, Seppo is correct, but its my fault... I should have told you. Assuming you're using mysql, grab this.[/quote]
 
Hi Derek,

Many thanks to you and your team for the upgrade.

Your supplied file is not backward compatible UNLESS line 45 is changed to this:

Code:

var $_count_string = 'SELECT COUNT(*) AS numrows ';

   // Old line 45
   // var $_count_string = 'SELECT COUNT(*) AS ';

 

The CI 1.54 code that I used was:

Code:

// Pagination stuff
  $config['total_rows']     = $this->db->count_all('quotes'); // id, quote, author

The Error returned was:

Code:

An Error Was Encountered

   Error Number: 1064

   You have an error in your SQL syntax; check the manual that corresponds to your MySQL    server version for the right syntax to use near 'FROM `quotes`' at line 1

   SELECT COUNT(*) AS FROM `quotes`

Cheers,

John_Betong