I have created a website, with many mySQL views for some complex queries and used CActiveRecord for those views.
When I deployed my site to a webhosting, the "show view" privilege is not supported. I cannot figure out any solution to rewrite my code as CActiveDataProvider does not supported DAO.
Does anyone know there is any good web hosting supporting mySQL views for YII? Thanks!!