Illegal mix of collations with JS sdk

JavaScript
1

Hi there, I have been recently been getting some errors for some of my queries I am performing with the JS backendless sdk. These errors appear at random - sometimes the queries are executed normally, while other times I get the error. This is very bad for our production environment.

These queries have been working for a year, but suddenly I am receiving this error:
Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '<>'

Example Query:
const queryBuilder = Backendless.DataQueryBuilder.create(); queryBuilder.addProperties('objectId', 'name', 'description', 'email', 'phoneNumber', 'website', 'street', 'city', 'zipCode', 'picture', 'logo', 'openingHours', 'mapsIframeLink', 'geolocation', 'url');
queryBuilder.setWhereClause(url=’${url}’);
queryBuilder.setRelated(['openingHours']);
const promise = Backendless.Data.of('Provider').find<Provider>(queryBuilder);

Thanks for your help

3

Hi, @Lukas_Pichler

Welcome to the community and thanks for trying Backendless! Please provide us with a full sample request (including the URL from WhereClause). You may skip sensitive data such as the API Key from the URL.

Regards,
Marina

4

Hi there,
the url does not contain any api key. It is a string.

Full Query:
const queryBuilder = Backendless.DataQueryBuilder.create(); queryBuilder.addProperties('objectId', 'name', 'description', 'email', 'phoneNumber', 'website', 'street', 'city', 'zipCode', 'picture', 'logo', 'openingHours', 'mapsIframeLink', 'geolocation', 'url');
queryBuilder.setWhereClause(url=’Mobile-Tech-Zone’);
queryBuilder.setRelated(['openingHours']);
const promise = Backendless.Data.of('Provider').find<Provider>(queryBuilder);

5

@Lukas_Pichler, please provide us with the cURL of the request. It is safe to send it to the support@backendless.com

Regars,
Marina

6

How would I go about extracting the cURL of the request?

7

@Lukas_Pichler

If you run the code via the console you can see the cURL in the network tab of devtools. If you run the code with the code editor please, add the next line to the end of the query:
console.log(queryBuilder)

P.S. Please provide us with the AppId

Regards,
Marina

8

May I suggest a link with a similar issue here ?

I keep ecountering the same error somewhat randomly.
Very difficult to guess how to replicate the issue, sorry.

9

I am getting the same error regularly today.
We have not made any changes to our code, the issue has just started appearing.

10

Hi, @Tony_Goodchild

We have an internal ticket for this issue - BKNDLSS-28372. I have just raised its priority. We will do our best to fix the issue asap. Sorry for the inconvenience.

Regards,
Marina

11

Hi @Marina.Kan, this seemed to have been resolved yesterday and things were running ok this morning. But now every call we make to the API is giving us this error. Our application is 100% DOWN now.

Is there a resolution plan?

12

Hi,

This seemed to clear up yesterday.

However our application is currently down as every query is giving us this error.

regards
Tony

13

Hello, I’m developing a react app with Backendless and I got same error too. In my case it looks related to a relation retrieval, this produce the error:

const queryBuilder = Backendless.DataQueryBuilder.create();
queryBuilder.setPageSize(100);
queryBuilder.setRelated(["customer"]);
const data = await Backendless.Data.of(meta.table.name).find(queryBuilder);

but if I remove line: queryBuilder.setRelated([“customer”]); it work

14

Hello @Harlock

We are sorry for the inconvenience. Our engineers are already looking into the issue.

Regards

15

@Marina.Kan , @viktor.liablin I have not been able to reproduce the bug during development, both yesterday and today (~6hrs).
Has the problem been resolved on your side?

16

Hi, @Lukas_Pichler

We are working on this issue. Some fixes have already been made and we are currently testing their efficiency. We are glad that the problem is not reproducing for you. That means we are on the right way.

Regards,
Marina