General error: 1615 Prepared statement needs to be re-prepared (selecting mysql view)

Posted 3 years ago by maverickheroes

Hi guys,

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!

Please sign in or create an account to participate in this conversation.

Reply to

Use Markdown with GitHub-flavored code blocks.