Selecting MySQL tables are good, but MySQL views, error comes. See the following error:
SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: SELECT * FROM v_user_models)
My view: CREATE VIEW v_user_models AS select m.id AS model_id, u.id AS user_id, u.firstname AS firstname, u.lastname AS lastname, from ((users u join models m on((u.id = m.user_id)))
In my localhost, it is working but when I uploaded it on the live site, it doesn't work. Please help.. Thanks a lot!