Web Hosting support "Show View"

Hi all,

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!!

i use hostagor.com very excellent

baggioowen did you try to contact the hosting support, could be they can enable that privilege for you…