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.
^ this is the updating page for the testing database and it works perfectly, and below is the query for it
However, when I made the exact same one with my working database,
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.
Could anyone help me out with this? Thanks!
Teodor
March 23, 2022, 3:07pm
2
Are you running different mysql versions on both servers?
Do you mean by the Database? Im using MySQL / MariaDB for both of it
Teodor
March 23, 2022, 5:37pm
4
Yes the databases are they different versions on local and remote?
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
Teodor
March 23, 2022, 6:49pm
7
So what database types are both and versions exactly?
Both at MySQL Community on AWS RDS, same versions and certificates.
Teodor
March 23, 2022, 8:34pm
9
So which versions are they - 5 … 8?
The engine version is
Teodor
March 24, 2022, 2:59pm
11
But are you 100% sure it is version 8 on BOTH servers, especially the local/testing one?
yes I’ve checked it through aws rds configuration
George
March 24, 2022, 6:31pm
13
Make sure you have selected MySQL 8 as database type in the database connection settings per target and not just MySQL
I’ve selected MySQL 8 for database type but I still get this same error
