SQL errors in Pandora

[vic]

Like it

Up

1

Down

Drop it

::

Hi Christophe,

Can you check that your MySQL has been optimised in your /etc/my.cnf file?

On the other hand, you can check if in the /etc/my.cnf file you have the following parameter as follows.

sql_mode=""

Best regards,

Víc.

[Christophe]

Like it

Up

1

Down

Drop it

::

Thanks for your answer,

I compared the /etc/my.cnf files of a server where the error is present and the server where there is no error, which are indeed different.

I changed the file of the server with the error to be the same as the server with no error and restarted the server.

But when I reload the page, the SQL errors are still there.

I put you a capture of the two files, on the left the one of the server displaying the errors and on the right the one of the server which does not display any errors

2023-02-22-17_40_47-C__Users_mdubail.KUBA_Documents_Pandora_KP1.0_my.cnf-Notepad.png 23 KB Image File - Click to view

• Copy Download Link

[vic]

Like it

Up

1

Down

Drop it

::

Hi Christophe,

Can you tell us what version of MySQL all the nodes on which the problem is found have?

In case it is a MySQL compatibility problem.

Best regards,

Víc.

[Christophe]

Like it

Up

1

Down

Drop it

::

I solved the problem by analyzing the code, it was a group with a id_grupo = 0 in the database that was causing the problem.

Thanks for your help !