Unable to show mysql db view in a bootstrap table

Wappler General Need Help
1

Hi,

I’m trying to visualize some views in a table, but so far i’m not succesfull. I’ve used the debug functionality tofind the following server side error:

image
image898×47 3.58 KB

i’ve googled this error and i’m not able to find a solution (for the suggested solution I need server admin rights, which I don’t have).

Now I’m wondering why i can’t visualize the view on my website, since when i run the view in MySQL is takes 1/100th of a second and shows perfectly.

Is there any way to solve this issue, or any workaround available?

Kind regards,
Olaf

2

That’s a known bug in MySQL version prior 5.7 with PHP.
You can fix this by opening the database connection options and set the Prepared Statement menu to True.

1 Like
3

fixed, thanks!