Error with MySQL VIEWs

Wappler General Need Help
1

Has anybody come across this error? I am struggling to find any sensible answer on Google.

message: "SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared"

image
image742×170 9.33 KB

The page and Server action all work fine on local Dev machine. I have uploaded to production server and get this issue. I have ensured that the files have uploaded correctly and are not corrupt.

2

That is a known bug in PHP (not in Wappler) with Mysql versions prior 5.6
That’s why there is a special option about that in the Connection options added some time ago:

Screenshot 2021-03-19 at 17.21.35
Screenshot 2021-03-19 at 17.21.35559×608 21.1 KB

3

Thank you @Teodor, I didn’t realise what that was for.
Fast, helpful and clear response as always :slight_smile:

4

Also, the problem will be solved if you are running mysql 5.7 or newer.

5

I can only see that it is

  • Server version: 10.5.9-MariaDB - MariaDB Server
  • nginx/1.18.0
  • Database client version: libmysql - mysqlnd 5.0.12-dev
  • PHP version: 7.3.26
  • phpMyAdmin Version information: 5.0.3