View providing no results, but table has recent entries

[eluser]wabu[/eluser]
Hello, if it were me I'd want to determine that the query CI is generating actually returns results. You could trace the query in your MySQL log file and then run it in your preferred client.

You could also try commenting out the where functions (clauses) in your model and see if that returns records. For example, 'date_paid' needs to be '0,' so perhaps there's some sort of default/data typing issue. Maybe something changed in the MySQL upgrade.

This all presumes there's no other error, which based on your description there wasn't.