Error accessing VIEWs on MariaDB using PHP

johndoe

Hi,
I've a problem accessing MariaDB's VIEWs via PHP+mysqli.
I defined a TABLE and a simple VIEW on it. Using Adminer I can see all data of the view. But if I try to query the VIEW using PHP+mysqli I get the error: AH01215: Prepared statement needs to be re-prepared.

sean

johndoe can you provide an example of the code that's throwing this error?

If you prefer not to share that here in the public forum then feel free to email support@opalstack.com with the details.

johndoe

sean I wrote you an e-mail to support@opalstack.com
Thanks

sean

This seems to be a known bug in MariaDB: https://jira.mariadb.org/browse/MDEV-17124

I've done the suggested workaround of setting a higher value for table_definition_cache in the MariaDB configuration which seems to have resolved it in my testing.

johndoe

Now it works, thanks!