Database update, pulling data not working

Wappler General How To
#1

Hello, I am trying to use the database “update query” to update the database. However, I wrote nearly the same query as my testing database but it is not working for the actual DB.

image
image1492×1178 53.4 KB

^ this is the updating page for the testing database and it works perfectly, and below is the query for it

image
image1880×1182 223 KB

However, when I made the exact same one with my working database,

image
image1874×1192 248 KB

it is showing me this error, and I’ve checked it out that the same status 500 error occurs when I open the API on the web as well.

image
image1888×780 139 KB

image
image1897×556 120 KB

Could anyone help me out with this? Thanks!

#2

Are you running different mysql versions on both servers?

#3

Do you mean by the Database? Im using MySQL / MariaDB for both of it

#4

Yes the databases are they different versions on local and remote?

#5

I don’t think so

#6

My bad, they are different databases. It is AWS RDS and one is staging the other is production; staging is the one that it works

#7

So what database types are both and versions exactly?

#8

Both at MySQL Community on AWS RDS, same versions and certificates.

#9

So which versions are they - 5 … 8?

#10

The engine version is
8.0.23

#11

But are you 100% sure it is version 8 on BOTH servers, especially the local/testing one?

#12

yes I’ve checked it through aws rds configuration

#13

Make sure you have selected MySQL 8 as database type in the database connection settings per target and not just MySQL

#14

I’ve selected MySQL 8 for database type but I still get this same error

image
image1904×451 119 KB

#15

Maybe check:

#16

And also: